API tools faq
paste
josefkyrian

grafana dashboard - PV Power Plant - Summary

josefkyrian
Oct 9th, 2023 (edited)
82
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 23.26 KB | None | 0 0
raw download clone embed print report
  1. {
  2. "annotations": {
  3. "list": [
  4. {
  5. "builtIn": 1,
  6. "datasource": {
  7. "type": "datasource",
  8. "uid": "grafana"
  9. },
  10. "enable": true,
  11. "hide": true,
  12. "iconColor": "rgba(0, 211, 255, 1)",
  13. "name": "Annotations & Alerts",
  14. "target": {
  15. "limit": 100,
  16. "matchAny": false,
  17. "tags": [],
  18. "type": "dashboard"
  19. },
  20. "type": "dashboard"
  21. }
  22. ]
  23. },
  24. "editable": true,
  25. "fiscalYearStartMonth": 0,
  26. "graphTooltip": 0,
  27. "id": 14,
  28. "links": [],
  29. "liveNow": true,
  30. "panels": [
  31. {
  32. "collapsed": false,
  33. "datasource": {
  34. "type": "mysql",
  35. "uid": "BjbJE3u7z"
  36. },
  37. "gridPos": {
  38. "h": 1,
  39. "w": 24,
  40. "x": 0,
  41. "y": 0
  42. },
  43. "id": 123223,
  44. "panels": [],
  45. "targets": [
  46. {
  47. "datasource": {
  48. "type": "mysql",
  49. "uid": "BjbJE3u7z"
  50. },
  51. "refId": "A"
  52. }
  53. ],
  54. "title": "PV Summary Stats",
  55. "type": "row"
  56. },
  57. {
  58. "datasource": {
  59. "type": "mysql",
  60. "uid": "BjbJE3u7z"
  61. },
  62. "fieldConfig": {
  63. "defaults": {
  64. "color": {
  65. "mode": "palette-classic"
  66. },
  67. "custom": {
  68. "axisBorderShow": false,
  69. "axisCenteredZero": false,
  70. "axisColorMode": "text",
  71. "axisLabel": "",
  72. "axisPlacement": "auto",
  73. "barAlignment": 0,
  74. "drawStyle": "bars",
  75. "fillOpacity": 15,
  76. "gradientMode": "none",
  77. "hideFrom": {
  78. "legend": false,
  79. "tooltip": false,
  80. "viz": false
  81. },
  82. "insertNulls": false,
  83. "lineInterpolation": "linear",
  84. "lineWidth": 1,
  85. "pointSize": 5,
  86. "scaleDistribution": {
  87. "type": "linear"
  88. },
  89. "showPoints": "auto",
  90. "spanNulls": false,
  91. "stacking": {
  92. "group": "A",
  93. "mode": "none"
  94. },
  95. "thresholdsStyle": {
  96. "mode": "off"
  97. }
  98. },
  99. "mappings": [],
  100. "thresholds": {
  101. "mode": "absolute",
  102. "steps": [
  103. {
  104. "color": "green",
  105. "value": null
  106. },
  107. {
  108. "color": "red",
  109. "value": 80
  110. }
  111. ]
  112. },
  113. "unit": "kwatth"
  114. },
  115. "overrides": []
  116. },
  117. "gridPos": {
  118. "h": 11,
  119. "w": 12,
  120. "x": 0,
  121. "y": 1
  122. },
  123. "id": 123225,
  124. "options": {
  125. "legend": {
  126. "calcs": [
  127. "mean"
  128. ],
  129. "displayMode": "table",
  130. "placement": "bottom",
  131. "showLegend": true
  132. },
  133. "tooltip": {
  134. "mode": "single",
  135. "sort": "none"
  136. }
  137. },
  138. "targets": [
  139. {
  140. "datasource": {
  141. "type": "mysql",
  142. "uid": "BjbJE3u7z"
  143. },
  144. "editorMode": "code",
  145. "format": "time_series",
  146. "group": [],
  147. "metricColumn": "none",
  148. "rawQuery": true,
  149. "rawSql": "SELECT\n UNIX_TIMESTAMP(log_date) AS \"time\",\n grid_import, grid_export, pv, consumption\nFROM pv_daily_stats\nWHERE\n $__timeFilter(log_date)\nORDER BY log_date",
  150. "refId": "A",
  151. "select": [
  152. [
  153. {
  154. "params": [
  155. "id"
  156. ],
  157. "type": "column"
  158. }
  159. ]
  160. ],
  161. "sql": {
  162. "columns": [
  163. {
  164. "parameters": [],
  165. "type": "function"
  166. }
  167. ],
  168. "groupBy": [
  169. {
  170. "property": {
  171. "type": "string"
  172. },
  173. "type": "groupBy"
  174. }
  175. ],
  176. "limit": 50
  177. },
  178. "table": "_is_generic_admin_media_objects",
  179. "timeColumn": "date_of_creation",
  180. "timeColumnType": "timestamp",
  181. "where": [
  182. {
  183. "name": "$__timeFilter",
  184. "params": [],
  185. "type": "macro"
  186. }
  187. ]
  188. }
  189. ],
  190. "title": "Stats - Daily",
  191. "type": "timeseries"
  192. },
  193. {
  194. "datasource": {
  195. "type": "mysql",
  196. "uid": "BjbJE3u7z"
  197. },
  198. "description": "",
  199. "fieldConfig": {
  200. "defaults": {
  201. "color": {
  202. "mode": "palette-classic"
  203. },
  204. "custom": {
  205. "axisBorderShow": false,
  206. "axisCenteredZero": false,
  207. "axisColorMode": "text",
  208. "axisLabel": "",
  209. "axisPlacement": "auto",
  210. "barAlignment": 0,
  211. "drawStyle": "bars",
  212. "fillOpacity": 16,
  213. "gradientMode": "none",
  214. "hideFrom": {
  215. "legend": false,
  216. "tooltip": false,
  217. "viz": false
  218. },
  219. "insertNulls": false,
  220. "lineInterpolation": "linear",
  221. "lineWidth": 1,
  222. "pointSize": 5,
  223. "scaleDistribution": {
  224. "type": "linear"
  225. },
  226. "showPoints": "auto",
  227. "spanNulls": false,
  228. "stacking": {
  229. "group": "A",
  230. "mode": "none"
  231. },
  232. "thresholdsStyle": {
  233. "mode": "off"
  234. }
  235. },
  236. "mappings": [],
  237. "thresholds": {
  238. "mode": "absolute",
  239. "steps": [
  240. {
  241. "color": "green",
  242. "value": null
  243. },
  244. {
  245. "color": "red",
  246. "value": 80
  247. }
  248. ]
  249. },
  250. "unit": "kwatth"
  251. },
  252. "overrides": []
  253. },
  254. "gridPos": {
  255. "h": 11,
  256. "w": 12,
  257. "x": 12,
  258. "y": 1
  259. },
  260. "id": 123228,
  261. "options": {
  262. "legend": {
  263. "calcs": [
  264. "mean"
  265. ],
  266. "displayMode": "table",
  267. "placement": "bottom",
  268. "showLegend": true
  269. },
  270. "tooltip": {
  271. "mode": "single",
  272. "sort": "none"
  273. }
  274. },
  275. "targets": [
  276. {
  277. "datasource": {
  278. "type": "mysql",
  279. "uid": "BjbJE3u7z"
  280. },
  281. "editorMode": "code",
  282. "format": "time_series",
  283. "group": [],
  284. "metricColumn": "none",
  285. "rawQuery": true,
  286. "rawSql": "SELECT\n UNIX_TIMESTAMP(DATE_FORMAT(log_date, \"%Y-%m-01\")) AS \"time\",\n SUM(grid_import) AS grid_import,\n SUM(grid_export) AS grid_export,\n SUM(pv) AS pv,\n SUM(consumption) AS consumption\nFROM pv_daily_stats\nWHERE\n $__timeFilter(log_date)\nGROUP BY time\nORDER BY time",
  287. "refId": "A",
  288. "select": [
  289. [
  290. {
  291. "params": [
  292. "id"
  293. ],
  294. "type": "column"
  295. }
  296. ]
  297. ],
  298. "sql": {
  299. "columns": [
  300. {
  301. "parameters": [],
  302. "type": "function"
  303. }
  304. ],
  305. "groupBy": [
  306. {
  307. "property": {
  308. "type": "string"
  309. },
  310. "type": "groupBy"
  311. }
  312. ],
  313. "limit": 50
  314. },
  315. "table": "_is_generic_admin_media_objects",
  316. "timeColumn": "date_of_creation",
  317. "timeColumnType": "timestamp",
  318. "where": [
  319. {
  320. "name": "$__timeFilter",
  321. "params": [],
  322. "type": "macro"
  323. }
  324. ]
  325. }
  326. ],
  327. "title": "Stats - Monthly",
  328. "type": "timeseries"
  329. },
  330. {
  331. "datasource": {
  332. "type": "mysql",
  333. "uid": "BjbJE3u7z"
  334. },
  335. "fieldConfig": {
  336. "defaults": {
  337. "color": {
  338. "mode": "palette-classic"
  339. },
  340. "custom": {
  341. "axisBorderShow": false,
  342. "axisCenteredZero": false,
  343. "axisColorMode": "text",
  344. "axisLabel": "",
  345. "axisPlacement": "auto",
  346. "barAlignment": 0,
  347. "drawStyle": "bars",
  348. "fillOpacity": 15,
  349. "gradientMode": "none",
  350. "hideFrom": {
  351. "legend": false,
  352. "tooltip": false,
  353. "viz": false
  354. },
  355. "insertNulls": false,
  356. "lineInterpolation": "linear",
  357. "lineWidth": 1,
  358. "pointSize": 5,
  359. "scaleDistribution": {
  360. "type": "linear"
  361. },
  362. "showPoints": "auto",
  363. "spanNulls": false,
  364. "stacking": {
  365. "group": "A",
  366. "mode": "none"
  367. },
  368. "thresholdsStyle": {
  369. "mode": "off"
  370. }
  371. },
  372. "mappings": [],
  373. "thresholds": {
  374. "mode": "absolute",
  375. "steps": [
  376. {
  377. "color": "green",
  378. "value": null
  379. },
  380. {
  381. "color": "red",
  382. "value": 80
  383. }
  384. ]
  385. },
  386. "unit": "kwatth"
  387. },
  388. "overrides": [
  389. {
  390. "__systemRef": "hideSeriesFrom",
  391. "matcher": {
  392. "id": "byNames",
  393. "options": {
  394. "mode": "exclude",
  395. "names": [
  396. "pv",
  397. "last_year_pv"
  398. ],
  399. "prefix": "All except:",
  400. "readOnly": true
  401. }
  402. },
  403. "properties": [
  404. {
  405. "id": "custom.hideFrom",
  406. "value": {
  407. "legend": false,
  408. "tooltip": false,
  409. "viz": true
  410. }
  411. }
  412. ]
  413. }
  414. ]
  415. },
  416. "gridPos": {
  417. "h": 19,
  418. "w": 12,
  419. "x": 0,
  420. "y": 12
  421. },
  422. "id": 123227,
  423. "options": {
  424. "legend": {
  425. "calcs": [
  426. "mean",
  427. "sum"
  428. ],
  429. "displayMode": "table",
  430. "placement": "bottom",
  431. "showLegend": true
  432. },
  433. "tooltip": {
  434. "mode": "single",
  435. "sort": "none"
  436. }
  437. },
  438. "targets": [
  439. {
  440. "datasource": {
  441. "type": "mysql",
  442. "uid": "BjbJE3u7z"
  443. },
  444. "editorMode": "code",
  445. "format": "time_series",
  446. "group": [],
  447. "hide": false,
  448. "metricColumn": "none",
  449. "rawQuery": true,
  450. "rawSql": "SELECT\n UNIX_TIMESTAMP(log_date) AS \"time\",\n grid_import, grid_export, pv, consumption\nFROM pv_daily_stats\nWHERE\n $__timeFilter(log_date)\nORDER BY log_date",
  451. "refId": "A",
  452. "select": [
  453. [
  454. {
  455. "params": [
  456. "id"
  457. ],
  458. "type": "column"
  459. }
  460. ]
  461. ],
  462. "sql": {
  463. "columns": [
  464. {
  465. "parameters": [],
  466. "type": "function"
  467. }
  468. ],
  469. "groupBy": [
  470. {
  471. "property": {
  472. "type": "string"
  473. },
  474. "type": "groupBy"
  475. }
  476. ],
  477. "limit": 50
  478. },
  479. "table": "_is_generic_admin_media_objects",
  480. "timeColumn": "date_of_creation",
  481. "timeColumnType": "timestamp",
  482. "where": [
  483. {
  484. "name": "$__timeFilter",
  485. "params": [],
  486. "type": "macro"
  487. }
  488. ]
  489. },
  490. {
  491. "datasource": {
  492. "type": "mysql",
  493. "uid": "BjbJE3u7z"
  494. },
  495. "editorMode": "code",
  496. "format": "time_series",
  497. "group": [],
  498. "hide": false,
  499. "metricColumn": "none",
  500. "rawQuery": true,
  501. "rawSql": "SELECT\n UNIX_TIMESTAMP(log_date + INTERVAL 1 YEAR) AS \"time\",\n grid_import AS last_year_grid_import, grid_export AS last_year_grid_export, pv AS last_year_pv, consumption AS last_year_consumption\nFROM pv_daily_stats\nWHERE\n $__timeFilter(log_date + INTERVAL 1 YEAR)\nORDER BY log_date",
  502. "refId": "B",
  503. "select": [
  504. [
  505. {
  506. "params": [
  507. "id"
  508. ],
  509. "type": "column"
  510. }
  511. ]
  512. ],
  513. "sql": {
  514. "columns": [
  515. {
  516. "parameters": [],
  517. "type": "function"
  518. }
  519. ],
  520. "groupBy": [
  521. {
  522. "property": {
  523. "type": "string"
  524. },
  525. "type": "groupBy"
  526. }
  527. ],
  528. "limit": 50
  529. },
  530. "table": "_is_generic_admin_media_objects",
  531. "timeColumn": "date_of_creation",
  532. "timeColumnType": "timestamp",
  533. "where": [
  534. {
  535. "name": "$__timeFilter",
  536. "params": [],
  537. "type": "macro"
  538. }
  539. ]
  540. }
  541. ],
  542. "title": "This vs Last Year - Daily",
  543. "type": "timeseries"
  544. },
  545. {
  546. "datasource": {
  547. "type": "mysql",
  548. "uid": "BjbJE3u7z"
  549. },
  550. "description": "",
  551. "fieldConfig": {
  552. "defaults": {
  553. "color": {
  554. "mode": "palette-classic"
  555. },
  556. "custom": {
  557. "axisBorderShow": false,
  558. "axisCenteredZero": false,
  559. "axisColorMode": "text",
  560. "axisLabel": "",
  561. "axisPlacement": "auto",
  562. "barAlignment": 0,
  563. "drawStyle": "bars",
  564. "fillOpacity": 15,
  565. "gradientMode": "none",
  566. "hideFrom": {
  567. "legend": false,
  568. "tooltip": false,
  569. "viz": false
  570. },
  571. "insertNulls": false,
  572. "lineInterpolation": "linear",
  573. "lineWidth": 1,
  574. "pointSize": 5,
  575. "scaleDistribution": {
  576. "type": "linear"
  577. },
  578. "showPoints": "auto",
  579. "spanNulls": false,
  580. "stacking": {
  581. "group": "A",
  582. "mode": "none"
  583. },
  584. "thresholdsStyle": {
  585. "mode": "off"
  586. }
  587. },
  588. "mappings": [],
  589. "thresholds": {
  590. "mode": "absolute",
  591. "steps": [
  592. {
  593. "color": "green",
  594. "value": null
  595. },
  596. {
  597. "color": "red",
  598. "value": 80
  599. }
  600. ]
  601. },
  602. "unit": "kwatth"
  603. },
  604. "overrides": []
  605. },
  606. "gridPos": {
  607. "h": 19,
  608. "w": 12,
  609. "x": 12,
  610. "y": 12
  611. },
  612. "id": 123229,
  613. "options": {
  614. "legend": {
  615. "calcs": [
  616. "mean",
  617. "sum"
  618. ],
  619. "displayMode": "table",
  620. "placement": "bottom",
  621. "showLegend": true
  622. },
  623. "tooltip": {
  624. "mode": "single",
  625. "sort": "none"
  626. }
  627. },
  628. "targets": [
  629. {
  630. "datasource": {
  631. "type": "mysql",
  632. "uid": "BjbJE3u7z"
  633. },
  634. "editorMode": "code",
  635. "format": "time_series",
  636. "group": [],
  637. "hide": false,
  638. "metricColumn": "none",
  639. "rawQuery": true,
  640. "rawSql": "SELECT\n UNIX_TIMESTAMP(DATE_FORMAT(log_date, \"%Y-%m-01\")) AS \"time\",\n SUM(grid_import) AS grid_import,\n SUM(grid_export) AS grid_export,\n SUM(pv) AS pv,\n SUM(consumption) AS consumption\nFROM pv_daily_stats\nWHERE\n $__timeFilter(log_date)\nGROUP BY time\nORDER BY time",
  641. "refId": "A",
  642. "select": [
  643. [
  644. {
  645. "params": [
  646. "id"
  647. ],
  648. "type": "column"
  649. }
  650. ]
  651. ],
  652. "sql": {
  653. "columns": [
  654. {
  655. "parameters": [],
  656. "type": "function"
  657. }
  658. ],
  659. "groupBy": [
  660. {
  661. "property": {
  662. "type": "string"
  663. },
  664. "type": "groupBy"
  665. }
  666. ],
  667. "limit": 50
  668. },
  669. "table": "_is_generic_admin_media_objects",
  670. "timeColumn": "date_of_creation",
  671. "timeColumnType": "timestamp",
  672. "where": [
  673. {
  674. "name": "$__timeFilter",
  675. "params": [],
  676. "type": "macro"
  677. }
  678. ]
  679. },
  680. {
  681. "datasource": {
  682. "type": "mysql",
  683. "uid": "BjbJE3u7z"
  684. },
  685. "editorMode": "code",
  686. "format": "time_series",
  687. "group": [],
  688. "hide": false,
  689. "metricColumn": "none",
  690. "rawQuery": true,
  691. "rawSql": "SELECT\n UNIX_TIMESTAMP(DATE_FORMAT(log_date, \"%Y-%m-01\") + INTERVAL 1 YEAR) AS \"time\",\n SUM(grid_import) AS last_year_grid_import,\n SUM(grid_export) AS last_year_grid_export,\n SUM(pv) AS last_year_pv,\n SUM(consumption) AS last_year_consumption\nFROM pv_daily_stats\nWHERE\n $__timeFilter(log_date + INTERVAL 1 YEAR)\nGROUP BY time\nORDER BY time",
  692. "refId": "B",
  693. "select": [
  694. [
  695. {
  696. "params": [
  697. "id"
  698. ],
  699. "type": "column"
  700. }
  701. ]
  702. ],
  703. "sql": {
  704. "columns": [
  705. {
  706. "parameters": [],
  707. "type": "function"
  708. }
  709. ],
  710. "groupBy": [
  711. {
  712. "property": {
  713. "type": "string"
  714. },
  715. "type": "groupBy"
  716. }
  717. ],
  718. "limit": 50
  719. },
  720. "table": "_is_generic_admin_media_objects",
  721. "timeColumn": "date_of_creation",
  722. "timeColumnType": "timestamp",
  723. "where": [
  724. {
  725. "name": "$__timeFilter",
  726. "params": [],
  727. "type": "macro"
  728. }
  729. ]
  730. }
  731. ],
  732. "title": "This vs Last Year - Monthly",
  733. "type": "timeseries"
  734. },
  735. {
  736. "datasource": {
  737. "type": "mysql",
  738. "uid": "BjbJE3u7z"
  739. },
  740. "fieldConfig": {
  741. "defaults": {
  742. "color": {
  743. "mode": "palette-classic"
  744. },
  745. "custom": {
  746. "axisBorderShow": false,
  747. "axisCenteredZero": false,
  748. "axisColorMode": "text",
  749. "axisLabel": "",
  750. "axisPlacement": "auto",
  751. "axisSoftMin": 0,
  752. "fillOpacity": 80,
  753. "gradientMode": "none",
  754. "hideFrom": {
  755. "legend": false,
  756. "tooltip": false,
  757. "viz": false
  758. },
  759. "lineWidth": 1,
  760. "scaleDistribution": {
  761. "type": "linear"
  762. },
  763. "thresholdsStyle": {
  764. "mode": "off"
  765. }
  766. },
  767. "decimals": 3,
  768. "mappings": [],
  769. "thresholds": {
  770. "mode": "absolute",
  771. "steps": [
  772. {
  773. "color": "green",
  774. "value": null
  775. },
  776. {
  777. "color": "red",
  778. "value": 80
  779. }
  780. ]
  781. },
  782. "unit": "kwatth"
  783. },
  784. "overrides": []
  785. },
  786. "gridPos": {
  787. "h": 11,
  788. "w": 12,
  789. "x": 7,
  790. "y": 31
  791. },
  792. "id": 123226,
  793. "options": {
  794. "barRadius": 0,
  795. "barWidth": 0.97,
  796. "fullHighlight": false,
  797. "groupWidth": 1,
  798. "legend": {
  799. "calcs": [
  800. "last"
  801. ],
  802. "displayMode": "table",
  803. "placement": "bottom",
  804. "showLegend": true
  805. },
  806. "orientation": "auto",
  807. "showValue": "auto",
  808. "stacking": "none",
  809. "tooltip": {
  810. "mode": "single",
  811. "sort": "none"
  812. },
  813. "xTickLabelRotation": 0,
  814. "xTickLabelSpacing": 0
  815. },
  816. "targets": [
  817. {
  818. "datasource": {
  819. "type": "mysql",
  820. "uid": "BjbJE3u7z"
  821. },
  822. "editorMode": "code",
  823. "format": "time_series",
  824. "group": [],
  825. "metricColumn": "none",
  826. "rawQuery": true,
  827. "rawSql": "SELECT\n UNIX_TIMESTAMP(MIN(log_date)) AS \"time\",\n SUM(grid_import) AS grid_import, SUM(grid_export) AS grid_export, SUM(pv) AS pv, SUM(consumption) AS consumption\nFROM pv_daily_stats\nWHERE\n $__timeFilter(log_date)",
  828. "refId": "A",
  829. "select": [
  830. [
  831. {
  832. "params": [
  833. "id"
  834. ],
  835. "type": "column"
  836. }
  837. ]
  838. ],
  839. "sql": {
  840. "columns": [
  841. {
  842. "parameters": [],
  843. "type": "function"
  844. }
  845. ],
  846. "groupBy": [
  847. {
  848. "property": {
  849. "type": "string"
  850. },
  851. "type": "groupBy"
  852. }
  853. ],
  854. "limit": 50
  855. },
  856. "table": "_is_generic_admin_media_objects",
  857. "timeColumn": "date_of_creation",
  858. "timeColumnType": "timestamp",
  859. "where": [
  860. {
  861. "name": "$__timeFilter",
  862. "params": [],
  863. "type": "macro"
  864. }
  865. ]
  866. }
  867. ],
  868. "title": "Sums",
  869. "type": "barchart"
  870. }
  871. ],
  872. "refresh": "",
  873. "schemaVersion": 38,
  874. "tags": [],
  875. "templating": {
  876. "list": []
  877. },
  878. "time": {
  879. "from": "now/y",
  880. "to": "now/y"
  881. },
  882. "timepicker": {
  883. "hidden": false,
  884. "refresh_intervals": [
  885. "5s",
  886. "10s",
  887. "30s",
  888. "1m",
  889. "5m",
  890. "15m",
  891. "30m",
  892. "1h",
  893. "2h",
  894. "1d"
  895. ],
  896. "time_options": [
  897. "5m",
  898. "15m",
  899. "1h",
  900. "6h",
  901. "12h",
  902. "24h",
  903. "2d",
  904. "7d",
  905. "30d"
  906. ],
  907. "type": "timepicker"
  908. },
  909. "timezone": "browser",
  910. "title": "PV Power Plant - Summary",
  911. "uid": "uvkQKVwnz",
  912. "version": 16,
  913. "weekStart": ""
  914. }
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!