node-red-contrib-tibber-api 7.0.1
Node Red module for integrating with Tibber api
node-red-contrib-tibber-api
Node Red module for integrating with Tibber Pulse through Tibber api.
| Status | NPM | DeepScan |
|---|---|---|
  |
 |
 |
General
This Node-Red module is used for communication with Tibber API through GraphQL queries and for retrieving data from Tibber Pulse via websocket. Tibber is a norwegian technology focused power company which is providing tools to get more insight and controll over your home and its power consumption.
Note!
Breaking changes in version 7.0.0, which is built on tibber-api 6:
- The nodes report an error when a call to Tibber fails, for example with an invalid access token. Use a Catch node to handle it. Earlier versions sent an empty result or the error object as
msg.payload.tibber-feedreconnects by itself with an increasing delay, as Tibber requires. The Reconnect delay setting is removed. If Tibber rejects the access token, the feed stops and the status shows invalid token.getConsumptionwithout a home ID returns one flat list withhomeIdon each record, instead of one list per home.
Note!
From version 5.0.0 the URL for the
tibber-feedhas been removed fromtibber-api-endpointconfiguration node. The only URL needed now is the Query URL. The feed will automatically fetch the websocket url from Tibber.The version has also been bumped to reflect the version of the underlying tibber-api component.
Prerequisites
Click the link below to sign up, and receive 400 NOK to shop smart home gadgets from Tibber Store:
You will also need an OAuth client or an access token from Tibber. See the configuration node for how to get them.
The nodes require Node-RED 2.0 or newer and Node.js 18 or newer. They are tested with Node-RED 2.2, 3.1, 4.1 and 5.0.
Note! In order to use the included Grafana dashboard example, you will need Grafana 6.x or higher.
Installation
NPM package
Node-Red
To install module in Node-Red GUI
- Go to main menu.
- Select Manage palette.
- Select Install tab.
- Search for node-red-contrib-tibber-api
- Click Install button to perform the installation.
Manual installation
$ npm install node-red-contrib-tibber-api
Nodes
Tibber Feed node (tibber-feed)
Realtime power consuption data from Tibber Pulse. Select an API endpoint, provide Home ID and select what kind of information you want to retrieve, including reactive power.
The access token and home ID can also be injected through an incoming message (msg.payload.accessToken and msg.payload.homeId). The feed reconnects by itself when the connection is lost.
Note! There should be only one instance running of tibber-feed per API key. Doing otherwise may return unpredictable result, or even error responses from the API.
Tibber API call node (tibber-query)
Do basic calls to Tibber API using GraphQL queries. To query the Tibber API, simply provide raw GraphQL queries in the payload of the incoming message. See Tibber API documentation and API Explorer for more informations. If the query fails, the node reports an error that can be handled with a Catch node.
Tibber push notification (tibber-notify)
Send push notifications to connected Tibber apps via Tibber API. Fill in Title, Message and which screen to open in the app directly in the node, or provide them in the payload of the incoming message as title, message and screen.
Tibber data (tibber-data)
Select from a set of predefined queries to retrieve data from Tibber API. The additional parameters can be provided either by the message payload or by configuring the node itself. By using the message payload you will be able to select query and parameters provided by other nodes in the flow.
Payload example:
{
"queryName": "getTomorrowsEnergyPrices",
"homeId": "96a14971-525a-4420-aae9-e5aedaa129ff",
"energyResolution": "DAILY",
"lastCount": 14
}
The queries getEnergyPriceRange, getConsumptionPage and getProductionPage return an object with nodes and pageInfo, and accept paging in the payload:
| Property | Description |
|---|---|
first / last |
Return the first or the last number of records. lastCount is used if neither is set. |
before / after |
Return records before or from a point in time: an ISO 8601 date, a timestamp in milliseconds, or a cursor from pageInfo. before does not include the record at that point, after does. |
filterEmptyNodes |
Leave out empty records (consumption and production). |
Payload example, the quarter-hourly prices for one day:
{
"queryName": "getEnergyPriceRange",
"homeId": "96a14971-525a-4420-aae9-e5aedaa129ff",
"energyResolution": "QUARTER_HOURLY",
"first": 96,
"after": "2026-10-10T00:00:00+02:00"
}
Tibber limits the number of records per request: 744 hourly, 31 daily, 52 weekly, 12 monthly and 1 annual, and 672 quarter-hourly prices. With
QUARTER_HOURLY,getEnergyPriceRangeworks in whole hours, so use a multiple of 4.
Available queries:
/**
* Get selected home with some selected properties, including address and owner.
* @param homeId Tibber home ID
* @return IHome object
*/
getHome(homeId: string): IHome;
/**
* Get homes with all properties, including energy price, consumption and production.
* @param homeId Tibber home ID
* @return IHome object
*/
getHomeComplete(homeId: string): IHome;
/**
* Get homes with some selected properties, including address and owner.
* @return Array of IHome.
*/
getHomes(): IHome[];
/**
* Get homes with all properties, including energy price, consumption and production.
* @return Array of IHome
*/
getHomesComplete(): IHome[];
/**
* Get current energy price for selected home.
* @param homeId Tibber home ID
* @return IPrice object
*/
getCurrentEnergyPrice(homeId: string): IPrice;
/**
* Get current energy prices from all homes registered to current user
* @return Array of IPrice
*/
getCurrentEnergyPrices(): IPrice[];
/**
* Get energy prices for today.
* @param homeId Tibber home ID
* @return Array of IPrice
*/
getTodaysEnergyPrices(homeId: string): IPrice[];
/**
* Get energy prices for tomorrow. These will only be available between 12:00 and 23:59
* @param homeId Tibber home ID
* @return Array of IPrice
*/
getTomorrowsEnergyPrices(homeId: string): IPrice[];
/**
* Get energy consumption for one or more homes.
* Returns an array of IConsumption
* @param energyResolution EnergyResolution. Valid values: HOURLY, DAILY, WEEKLY, MONTHLY, ANNUAL
* @param lastCount Return the last number of records
* @param homeId Tibber home ID. Optional parameter. Empty parameter will return all registered homes.
* @return Array of IConsumption
*/
getConsumption(energyResolution: EnergyResolution, lastCount: number, homeId?: string): IConsumption[];
/**
* Get energy production for one or more homes.
* Returns an array of IProduction
* @param energyResolution EnergyResolution. Valid values: HOURLY, DAILY, WEEKLY, MONTHLY, ANNUAL
* @param lastCount Return the last number of records
* @param homeId Tibber home ID. Optional parameter. Empty parameter will return all registered homes.
* @return Array of IProduction
*/
getProduction(energyResolution: EnergyResolution, lastCount: number, homeId?: string): IProduction[];
/**
* Get a page of energy consumption or production for selected home, including page info with totals and cursors.
* @param homeId Tibber home ID
* @param energyResolution EnergyResolution. Valid values: HOURLY, DAILY, WEEKLY, MONTHLY, ANNUAL
* @param paging first or last, before or after, and filterEmptyNodes
*/
getConsumptionPage(homeId: string, energyResolution: EnergyResolution, paging): IHomeConsumptionConnection;
getProductionPage(homeId: string, energyResolution: EnergyResolution, paging): IHomeProductionConnection;
/**
* Get historical energy prices for selected home, including page info with min/max and cursors.
* @param homeId Tibber home ID
* @param energyResolution Valid values: DAILY, HOURLY, QUARTER_HOURLY
* @param paging first or last, and before or after
*/
getEnergyPriceRange(homeId: string, energyResolution: PriceRangeResolution, paging): ISubscriptionPriceConnection;
Tibber Data API nodes
The Tibber Data API gives access to devices paired to Tibber, such as electric vehicles, chargers, thermostats, heat pumps, inverters and batteries, and to live measurements from Tibber Pulse and Watty. It is a separate API from the one used by the nodes above, and it does not serve prices.
The Tibber Data API nodes need a configuration node that logs in with client ID and secret. An access token is not accepted by the Tibber Data API.
Tibber Data API query (tibber-data-api)
Select a query on the node, or provide it in the payload of the incoming message.
| Query | Parameters | Result |
|---|---|---|
getHomes |
The homes of the user. | |
getDevices |
homeId |
The devices in a home. |
getDevice |
homeId, deviceId |
A device with its attributes and its capabilities, which hold the current state. |
getDeviceHistory |
homeId, deviceId, resolution, since or until, or link |
A page of history with items, and a next or prev link to another page. |
getLiveEventDevices |
homeId |
The devices that can stream live measurements right now. |
Payload example:
{
"queryName": "getDeviceHistory",
"homeId": "b5d69cab-...",
"deviceId": "dGVzb...",
"resolution": "hour",
"since": "2026-10-01T00:00:00+02:00"
}
resolution is quarterHour, hour, day or month. A device only has history if its supportedHistory.resolutions lists a resolution. To get another page, send the next or prev link from the previous result as link.
Tibber Data API feed (tibber-data-api-feed)
Live measurements from Tibber Pulse and Watty. msg.payload is the measurement and msg.topic is the ID of the device. The scope data-api-meters-read must be selected when logging in.
Note! Tibber allows one live feed per home. Starting a second one closes the first, which then shows the status evicted and does not reconnect. Use one tibber-data-api-feed node per home.
Configuration node (tibber-api-endpoint)
When configuring regular tibber nodes, you will have to create or select the configuration from the property API Endpoint. The configuration can be used by any Tibber node, so a change happens on all nodes using it. There are two ways to authenticate:
| Authentication | Works with | How to get it |
|---|---|---|
| Log in with client ID and secret (default for new configurations) | All nodes | Create an OAuth client at data-api.tibber.com |
| Access token | All nodes except tibber-data-api and tibber-data-api-feed | Create a personal access token at developer.tibber.com |
Configurations created before the login was added keep using their access token. Nothing has to be changed when upgrading.
Log in with client ID and secret
- Create an OAuth client at data-api.tibber.com and select the scopes you need.
- Open the configuration node in Node-RED. Add the Redirect URI it shows to the client at Tibber. See below if Tibber does not accept it.
- Enter the Client ID and Client Secret, click Log in to Tibber and log in in the window that opens. The status changes to Logged in.
- Click Update (or Add) and then Deploy.
The Tibber nodes work as soon as you have logged in. The deploy saves the Client ID and Client Secret, so the login survives a restart of Node-RED. If you log in and do not deploy, the editor enables Deploy and reminds you, also after the page has been reloaded.
The login gives Node-RED tokens that are renewed automatically. They are stored in the file tibber-api-tokens.json in the Node-RED user directory, readable only by the user running Node-RED. They are not part of the flow and are not included when flows are exported. The access token and the client secret are stored with the Node-RED credentials.
The Redirect URI
How the login works
- You click Log in to Tibber. Node-RED opens Tibber's login page in a new browser window.
- You log in at Tibber and approve the access.
- Tibber tells your browser to go to the Redirect URI, and adds a one-time code to the address.
- Node-RED reads the code from that address and exchanges it for tokens, in a call from Node-RED to Tibber.
The Redirect URI is therefore an address your browser opens. Tibber's servers never connect to Node-RED, so Node-RED does not have to be reachable from the internet. It only has to be reachable from the browser you log in with, and it needs outgoing access to Tibber.
Two rules decide which Redirect URI you can use:
- It must be the same, character for character, in the configuration node and on the client at Tibber. That includes
httporhttps, the port and any trailing/. - Tibber only accepts addresses that start with
https://, or withhttp://localhost.
Which Redirect URI to use
| How you open the Node-RED editor | Redirect URI | What to do |
|---|---|---|
http://localhost:1880 or http://127.0.0.1:1880, on the computer running Node-RED |
http://localhost:1880/tibber-api/callback |
Use Log in to Tibber. If the configuration node suggests 127.0.0.1, change it to localhost, and open the editor through localhost as well. |
An https address, for example https://nodered.example.com |
The address the configuration node suggests | Use Log in to Tibber. |
An http address on your network, for example http://192.168.1.10:1880 or http://raspberrypi:1880 |
http://localhost:1880/tibber-api/callback |
Tibber does not accept your address. Use the paste method below. |
| Through Home Assistant or another proxy that gives the editor a long or changing address | http://localhost:1880/tibber-api/callback |
Use the paste method below. |
The editor is private, but your HTTP In nodes are reachable through a public https address |
https://your-public-address/tibber-api/callback |
Use Log in to Tibber. See Public address below. |
The configuration node suggests a Redirect URI from the address you opened the editor with, including the path prefix if you have set httpAdminRoot in the Node-RED settings. You can change it, and it is saved with the configuration.
The paste method
Use this when Tibber does not accept the address of your Node-RED editor.
- Set the Redirect URI to
http://localhost:1880/tibber-api/callback, both in the configuration node and on the client at Tibber. - Click Log in to Tibber and log in.
- The browser now shows an error such as This site can't be reached. That is expected: Tibber sent the browser to
localhost, which is your own computer, and Node-RED is running somewhere else. - Copy the whole address from the address bar of that page. It starts with
http://localhost:1880/tibber-api/callback?code=. Some embedded browsers show an empty page and keep Tibber's address in the address bar. If the address does not start withhttp://localhost, log in from a regular browser such as Chrome, Firefox or Safari instead. - Paste it into Or paste in the configuration node and click Finish login. The status changes to Logged in.
The address can only be used once, and within 10 minutes of clicking Log in to Tibber. If it has expired, click Log in to Tibber again.
Public address
Node-RED answers on /tibber-api/callback in two places: next to the editor, and next to the HTTP In nodes. If only your HTTP In nodes are published on a public https address, set the Redirect URI to that address followed by /tibber-api/callback. Add the path prefix if you have set httpNodeRoot in the Node-RED settings, for example https://example.com/api/tibber-api/callback.
This address does not need the editor's login, because the browser arrives there from Tibber. It only accepts a login that was started from the editor in the last 10 minutes, and each login can only be finished once. If you protect the HTTP In nodes with httpNodeAuth, the browser asks for that user name and password when Tibber sends it back.
If the login fails
| What you see | Cause |
|---|---|
| Tibber shows Something went wrong: invalid_request instead of the login page | The Redirect URI in the configuration node is not registered on the client at Tibber, differs by a character, or is an http address other than localhost. Add it to the client, exactly as shown in the configuration node, and click Log in to Tibber again. |
| An error that mentions the scope, at Tibber or as Login failed in Node-RED | Scopes in the configuration node contains a scope that is not selected on the client. Remove it there, or select it on the client. |
| Login failed: unknown or expired login | More than 10 minutes passed, the address was already used, or Node-RED was restarted after you clicked Log in to Tibber. Start again. |
| Login failed: Tibber did not accept the Client ID and Client Secret (invalid_client) | The Client Secret does not belong to the Client ID. This happens if you change the Client ID without entering the secret of the new client. Enter both again and log in again. |
| Login failed: Token request failed | Tibber did not accept the code or the Redirect URI. Start again. |
| The status stays Not logged in after the paste method | The pasted address was not complete. It must include everything after the ?. |
The configuration node also holds the GraphQL Endpoint and the timeouts for the feed and for queries.
Examples
To easily test out the examples, you should use a server stack containing Node-Red, InfluxDB, and Grafana. Such stack can easily be installed by using the following docker based IoTServer: https://github.com/bisand/iotserver
Installation instructions:
git clone https://github.com/bisand/IoTServer.git iotserver
cd iotserver
sudo ./init.sh
Read the included readme for more info.
Node-Red examples
The example flows are included in the package. In the Node-RED editor, open the menu, select Import, then Examples, and look under node-red-contrib-tibber-api.
| Example | Shows |
|---|---|
node-red-tibber-test-flow |
The feed, GraphQL queries, pre-defined queries and push notifications. |
node-red-home-power |
Storing live measurements from Tibber Pulse in InfluxDB. |
node-red-tibber-data-api |
The Tibber Data API: homes, devices with their current state, and live measurements. Needs a configuration that logs in with client ID and secret. |
node-red-tibber-update-home |
Reading your homes and updating the information about one. |
The Grafana dashboard further down is also available as docs/grafana/home-power-dashboard.json.
Tibber Pulse - Example flow
tibber-test-flow.json
[
{
"id": "4e0718b1.2af2a8",
"type": "tab",
"label": "Tibber Test Flow",
"disabled": false,
"info": ""
},
{
"id": "8099995f.515738",
"type": "inject",
"z": "4e0718b1.2af2a8",
"name": "",
"topic": "",
"payload": "{viewer{homes{id size appNickname appAvatar address{address1 address2 address3 postalCode city country latitude longitude}}}}",
"payloadType": "str",
"repeat": "",
"crontab": "",
"once": false,
"onceDelay": 0.1,
"x": 130,
"y": 80,
"wires": [
[
"28454c92.811574"
]
]
},
{
"id": "944c04ef.7b6638",
"type": "debug",
"z": "4e0718b1.2af2a8",
"name": "",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "false",
"x": 570,
"y": 80,
"wires": []
},
{
"id": "c80cad4f.7a806",
"type": "tibber-feed",
"z": "4e0718b1.2af2a8",
"name": "",
"active": true,
"apiUrl": "wss://api.tibber.com/v1-beta/gql/subscriptions",
"apiToken": "d1007ead2dc84a2b82f0de19451c5fb22112f7ae11d19bf2bedb224a003ff74a",
"homeId": "96a14971-525a-4420-aae9-e5aedaa129ff",
"timestamp": "1",
"power": "1",
"lastMeterConsumption": "1",
"accumulatedConsumption": "1",
"accumulatedProduction": "1",
"accumulatedCost": "1",
"accumulatedReward": "1",
"currency": "1",
"minPower": "1",
"averagePower": "1",
"maxPower": "1",
"powerProduction": "1",
"minPowerProduction": "1",
"maxPowerProduction": "1",
"lastMeterProduction": "1",
"powerFactor": "1",
"voltagePhase1": "1",
"voltagePhase2": "1",
"voltagePhase3": "1",
"currentL1": "1",
"currentL2": "1",
"currentL3": "1",
"x": 120,
"y": 180,
"wires": [
[
"781f5eed.ea2a3"
]
]
},
{
"id": "781f5eed.ea2a3",
"type": "debug",
"z": "4e0718b1.2af2a8",
"name": "",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "false",
"x": 350,
"y": 180,
"wires": []
},
{
"id": "28454c92.811574",
"type": "tibber-query",
"z": "4e0718b1.2af2a8",
"name": "",
"active": true,
"apiUrl": "https://api.tibber.com/v1-beta/gql",
"apiToken": "d1007ead2dc84a2b82f0de19451c5fb22112f7ae11d19bf2bedb224a003ff74a",
"x": 350,
"y": 80,
"wires": [
[
"944c04ef.7b6638"
]
]
},
{
"id": "f3a4184a.047968",
"type": "tibber-notify",
"z": "4e0718b1.2af2a8",
"name": "",
"active": true,
"apiUrl": "https://api.tibber.com/v1-beta/gql",
"apiToken": "d1007ead2dc84a2b82f0de19451c5fb22112f7ae11d19bf2bedb224a003ff74a",
"notifyTitle": "",
"notifyMessage": "",
"notifyScreen": "",
"x": 330,
"y": 300,
"wires": []
},
{
"id": "b0e33b71.865f18",
"type": "inject",
"z": "4e0718b1.2af2a8",
"name": "",
"topic": "",
"payload": "{\"title\":\"Test\",\"message\":\"This is a simple test\",\"screen\":\"HOME\"}",
"payloadType": "json",
"repeat": "",
"crontab": "",
"once": false,
"onceDelay": 0.1,
"x": 120,
"y": 300,
"wires": [
[
"f3a4184a.047968"
]
]
}
]
Tibber Pulse - Home power consumption example
home-power.json
[
{
"id": "683fd7.e63da028",
"type": "tab",
"label": "Home Energy",
"disabled": false,
"info": ""
},
{
"id": "b970f3b0.3ff74",
"type": "tibber-feed",
"z": "683fd7.e63da028",
"name": "",
"active": true,
"apiEndpointRef": "8a80f84f.0cbd98",
"homeId": "96a14971-525a-4420-aae9-e5aedaa129ff",
"timestamp": "1",
"power": "1",
"lastMeterConsumption": "1",
"accumulatedConsumption": "1",
"accumulatedProduction": "1",
"accumulatedCost": "1",
"accumulatedReward": "1",
"currency": "1",
"minPower": "1",
"averagePower": "1",
"maxPower": "1",
"powerProduction": "1",
"minPowerProduction": "1",
"maxPowerProduction": "1",
"lastMeterProduction": "1",
"powerFactor": "1",
"voltagePhase1": "1",
"voltagePhase2": "1",
"voltagePhase3": "1",
"currentL1": "1",
"currentL2": "1",
"currentL3": "1",
"x": 140,
"y": 300,
"wires": [["1491f46.f317b0c"]]
},
{
"id": "4d0b020a.94fbac",
"type": "debug",
"z": "683fd7.e63da028",
"name": "",
"active": false,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "false",
"x": 590,
"y": 360,
"wires": []
},
{
"id": "2773a5f1.d99aca",
"type": "tibber-query",
"z": "683fd7.e63da028",
"name": "",
"active": true,
"apiEndpointRef": "8a80f84f.0cbd98",
"x": 370,
"y": 100,
"wires": [["4a25248d.5e506c"]]
},
{
"id": "983cd36.d80383",
"type": "inject",
"z": "683fd7.e63da028",
"name": "Get Home Id",
"topic": "",
"payload": "{ viewer { homes { id address { address1 address2 address3 postalCode city country latitude longitude } } } }",
"payloadType": "str",
"repeat": "",
"crontab": "",
"once": false,
"onceDelay": 0.1,
"x": 150,
"y": 100,
"wires": [["2773a5f1.d99aca"]]
},
{
"id": "4a25248d.5e506c",
"type": "debug",
"z": "683fd7.e63da028",
"name": "",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "false",
"x": 550,
"y": 100,
"wires": []
},
{
"id": "e0404127.1a2f8",
"type": "http request",
"z": "683fd7.e63da028",
"name": "",
"method": "POST",
"ret": "txt",
"paytoqs": false,
"url": "http://influxdb:8086/write?precision=s&consistency=any&db=test",
"tls": "",
"proxy": "",
"authType": "",
"x": 590,
"y": 300,
"wires": [["4d0b020a.94fbac"]]
},
{
"id": "1491f46.f317b0c",
"type": "function",
"z": "683fd7.e63da028",
"name": "Transform payload",
"func": "let p = msg.payload;\n\nif (!p.voltagePhase1)\n return null;\n\nfor (var prop in p) {\n if (!p[prop])\n p[prop] = 0;\n}\n\n// Meassurement\nlet data = \"power\";\n\n// Tag set\ndata += \",location=test\";\ndata += \",currency=\" + p.currency;\n\n// Field set\ndata += \" power=\" + p.power;\ndata += \",lastMeterConsumption=\" + p.lastMeterConsumption;\ndata += \",accumulatedConsumption=\" + p.accumulatedConsumption;\ndata += \",accumulatedProduction=\" + p.accumulatedProduction;\ndata += \",accumulatedCost=\" + p.accumulatedCost;\ndata += \",accumulatedReward=\" + p.accumulatedReward;\ndata += \",minPower=\" + p.minPower;\ndata += \",averagePower=\" + p.averagePower;\ndata += \",maxPower=\" + p.maxPower;\ndata += \",powerProduction=\" + p.powerProduction;\ndata += \",minPowerProduction=\" + p.minPowerProduction;\ndata += \",maxPowerProduction=\" + p.maxPowerProduction;\ndata += \",lastMeterProduction=\" + p.lastMeterProduction;\ndata += \",powerFactor=\" + p.powerFactor;\ndata += \",voltagePhase1=\" + p.voltagePhase1;\ndata += \",voltagePhase2=\" + p.voltagePhase2;\ndata += \",voltagePhase3=\" + p.voltagePhase3;\ndata += \",currentL1=\" + p.currentL1;\ndata += \",currentL2=\" + p.currentL2;\ndata += \",currentL3=\" + p.currentL3;\n\nmsg.payload = data;\n\nreturn msg;\n",
"outputs": 1,
"noerr": 0,
"x": 390,
"y": 300,
"wires": [["e0404127.1a2f8"]]
},
{
"id": "4286466c.a02e08",
"type": "http request",
"z": "683fd7.e63da028",
"name": "",
"method": "POST",
"ret": "txt",
"paytoqs": false,
"url": "http://influxdb:8086/query?q=CREATE%20DATABASE%20%22test%22",
"tls": "",
"proxy": "",
"authType": "",
"x": 370,
"y": 40,
"wires": [["d102d972.8fb0c8"]]
},
{
"id": "b24ffef4.c3ca",
"type": "inject",
"z": "683fd7.e63da028",
"name": "Create test database",
"topic": "",
"payload": "",
"payloadType": "str",
"repeat": "",
"crontab": "",
"once": false,
"onceDelay": 0.1,
"x": 170,
"y": 40,
"wires": [["4286466c.a02e08"]]
},
{
"id": "d102d972.8fb0c8",
"type": "debug",
"z": "683fd7.e63da028",
"name": "",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "false",
"x": 550,
"y": 40,
"wires": []
},
{
"id": "165b29ab.c7bef6",
"type": "tibber-query",
"z": "683fd7.e63da028",
"name": "",
"active": true,
"apiEndpointRef": "8a80f84f.0cbd98",
"x": 370,
"y": 180,
"wires": [["9f49c320.526db"]]
},
{
"id": "425b3d0d.8f10d4",
"type": "inject",
"z": "683fd7.e63da028",
"name": "Daily energy prices",
"topic": "",
"payload": "{ viewer { homes { currentSubscription { priceInfo { today { total energy tax startsAt currency level } } } } } }",
"payloadType": "str",
"repeat": "",
"crontab": "30 00 * * *",
"once": false,
"onceDelay": 0.1,
"x": 180,
"y": 180,
"wires": [["165b29ab.c7bef6"]]
},
{
"id": "810b8faa.9656a",
"type": "debug",
"z": "683fd7.e63da028",
"name": "",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "payload",
"targetType": "msg",
"x": 550,
"y": 240,
"wires": []
},
{
"id": "9f49c320.526db",
"type": "function",
"z": "683fd7.e63da028",
"name": "Transform energy price",
"func": "let pl = msg.payload;\n\nlet prices = pl.viewer.homes[0].currentSubscription.priceInfo.today;\n\n// Meassurement\nlet data = \"\";\n\nfor(let i = 0; i < prices.length; i++)\n{\n let p = prices[i];\n data += \"energy\";\n\n // Tag set\n data += \",location=test\";\n data += \",currency=\" + p.currency;\n \n // Field set\n data += \" total=\" + p.total;\n data += \",energy=\" + p.energy;\n data += \",tax=\" + p.tax;\n data += \",level=\\\"\" + p.level + \"\\\"\";\n data += \" \" + new Date(p.startsAt).getTime() / 1000 + \"\";\n data += \"\\n\";\n}\n\nmsg.payload = data;\n\nreturn msg;",
"outputs": 1,
"noerr": 0,
"x": 590,
"y": 180,
"wires": [["c478abbd.5715e8"]]
},
{
"id": "c478abbd.5715e8",
"type": "http request",
"z": "683fd7.e63da028",
"name": "",
"method": "POST",
"ret": "txt",
"paytoqs": false,
"url": "http://influxdb:8086/write?precision=s&consistency=any&db=test",
"tls": "",
"proxy": "",
"authType": "",
"x": 370,
"y": 240,
"wires": [["810b8faa.9656a"]]
},
{
"id": "8a80f84f.0cbd98",
"type": "tibber-api-endpoint",
"z": "",
"queryUrl": "https://api.tibber.com/v1-beta/gql",
"apiKey": "d1007ead2dc84a2b82f0de19451c5fb22112f7ae11d19bf2bedb224a003ff74a",
"name": "Demo"
}
]
Grafana example dashboard
Grafana - Home power consumption dashboard example
home-power-dashboard.json
{
"annotations": {
"list": [
{
"builtIn": 1,
"datasource": "-- Grafana --",
"enable": true,
"hide": true,
"iconColor": "rgba(0, 211, 255, 1)",
"name": "Annotations & Alerts",
"type": "dashboard"
}
]
},
"editable": true,
"gnetId": null,
"graphTooltip": 0,
"id": 1,
"links": [],
"panels": [
{
"gridPos": {
"h": 5,
"w": 4,
"x": 0,
"y": 0
},
"id": 6,
"options": {
"fieldOptions": {
"calcs": [
"lastNotNull"
],
"defaults": {
"mappings": [],
"max": 260,
"min": 200,
"thresholds": [
{
"color": "red",
"value": null
},
{
"color": "dark-red",
"value": 200
},
{
"color": "yellow",
"value": 210
},
{
"color": "green",
"value": 220
},
{
"color": "green",
"value": 230
},
{
"color": "#EAB839",
"value": 240
},
{
"color": "dark-red",
"value": 250
}
],
"unit": "volt"
},
"override": {},
"values": false
},
"orientation": "auto",
"showThresholdLabels": true,
"showThresholdMarkers": true
},
"pluginVersion": "6.3.5",
"targets": [
{
"groupBy": [
{
"params": [
"$interval"
],
"type": "time"
},
{
"params": [
"previous"
],
"type": "fill"
}
],
"measurement": "power",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT last(\"voltagePhase1\") FROM \"power\" WHERE $timeFilter",
"rawQuery": false,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"voltagePhase1"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": []
}
],
"timeFrom": null,
"timeShift": null,
"title": "Voltage - Phase 1",
"type": "gauge"
},
{
"gridPos": {
"h": 5,
"w": 4,
"x": 4,
"y": 0
},
"id": 7,
"options": {
"fieldOptions": {
"calcs": [
"lastNotNull"
],
"defaults": {
"mappings": [],
"max": 260,
"min": 200,
"thresholds": [
{
"color": "red",
"value": null
},
{
"color": "dark-red",
"value": 200
},
{
"color": "yellow",
"value": 210
},
{
"color": "green",
"value": 220
},
{
"color": "green",
"value": 230
},
{
"color": "#EAB839",
"value": 240
},
{
"color": "dark-red",
"value": 250
}
],
"unit": "volt"
},
"override": {},
"values": false
},
"orientation": "auto",
"showThresholdLabels": true,
"showThresholdMarkers": true
},
"pluginVersion": "6.3.5",
"targets": [
{
"groupBy": [
{
"params": [
"$interval"
],
"type": "time"
},
{
"params": [
"previous"
],
"type": "fill"
}
],
"measurement": "power",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"voltagePhase2"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": []
}
],
"timeFrom": null,
"timeShift": null,
"title": "Voltage - Phase 2",
"type": "gauge"
},
{
"gridPos": {
"h": 5,
"w": 4,
"x": 8,
"y": 0
},
"id": 8,
"options": {
"fieldOptions": {
"calcs": [
"lastNotNull"
],
"defaults": {
"mappings": [],
"max": 260,
"min": 200,
"thresholds": [
{
"color": "red",
"value": null
},
{
"color": "dark-red",
"value": 200
},
{
"color": "yellow",
"value": 210
},
{
"color": "green",
"value": 220
},
{
"color": "green",
"value": 230
},
{
"color": "#EAB839",
"value": 240
},
{
"color": "dark-red",
"value": 250
}
],
"unit": "volt"
},
"override": {},
"values": false
},
"orientation": "auto",
"showThresholdLabels": true,
"showThresholdMarkers": true
},
"pluginVersion": "6.3.5",
"targets": [
{
"groupBy": [
{
"params": [
"$interval"
],
"type": "time"
},
{
"params": [
"previous"
],
"type": "fill"
}
],
"measurement": "power",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"voltagePhase3"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": []
}
],
"timeFrom": null,
"timeShift": null,
"title": "Voltage - Phase 3",
"type": "gauge"
},
{
"gridPos": {
"h": 13,
"w": 4,
"x": 12,
"y": 0
},
"id": 4,
"interval": "",
"options": {
"displayMode": "lcd",
"fieldOptions": {
"calcs": [
"lastNotNull"
],
"defaults": {
"decimals": 2,
"mappings": [],
"max": 50,
"min": 0,
"thresholds": [
{
"color": "green",
"value": null
},
{
"color": "yellow",
"value": 25
},
{
"color": "red",
"value": 40
}
],
"title": "",
"unit": "amp"
},
"override": {},
"values": false
},
"orientation": "vertical"
},
"pluginVersion": "6.3.5",
"targets": [
{
"alias": "Phase 1",
"groupBy": [],
"measurement": "power",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"currentL1"
],
"type": "field"
}
]
],
"tags": []
},
{
"alias": "Phase 2",
"groupBy": [],
"measurement": "power",
"orderByTime": "ASC",
"policy": "default",
"refId": "B",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"currentL2"
],
"type": "field"
}
]
],
"tags": []
},
{
"alias": "Phase 3",
"groupBy": [],
"measurement": "power",
"orderByTime": "ASC",
"policy": "default",
"refId": "C",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"currentL3"
],
"type": "field"
}
]
],
"tags": []
}
],
"timeFrom": null,
"timeShift": null,
"title": "Phase current",
"type": "bargauge"
},
{
"cacheTimeout": null,
"colorBackground": false,
"colorPostfix": false,
"colorPrefix": false,
"colorValue": true,
"colors": [
"#299c46",
"rgba(237, 129, 40, 0.89)",
"#d44a3a"
],
"format": "watt",
"gauge": {
"maxValue": 100,
"minValue": 0,
"show": false,
"thresholdLabels": false,
"thresholdMarkers": true
},
"gridPos": {
"h": 4,
"w": 4,
"x": 16,
"y": 0
},
"id": 10,
"interval": null,
"links": [],
"mappingType": 1,
"mappingTypes": [
{
"name": "value to text",
"value": 1
},
{
"name": "range to text",
"value": 2
}
],
"maxDataPoints": 100,
"nullPointMode": "connected",
"nullText": null,
"options": {},
"pluginVersion": "6.3.5",
"postfix": "",
"postfixFontSize": "50%",
"prefix": "",
"prefixFontSize": "50%",
"rangeMaps": [
{
"from": "null",
"text": "N/A",
"to": "null"
}
],
"sparkline": {
"fillColor": "rgb(3, 94, 107)",
"full": false,
"lineColor": "rgb(31, 120, 193)",
"show": false,
"ymax": null,
"ymin": null
},
"tableColumn": "",
"targets": [
{
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "power",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"power"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": []
}
],
"thresholds": "5000,10000",
"timeFrom": null,
"timeShift": null,
"title": "Current power",
"type": "singlestat",
"valueFontSize": "100%",
"valueMaps": [
{
"op": "=",
"text": "N/A",
"value": "null"
}
],
"valueName": "current"
},
{
"cacheTimeout": null,
"colorBackground": false,
"colorValue": false,
"colors": [
"#299c46",
"rgba(237, 129, 40, 0.89)",
"#d44a3a"
],
"decimals": 2,
"format": "kwatth",
"gauge": {
"maxValue": 100,
"minValue": 0,
"show": false,
"thresholdLabels": false,
"thresholdMarkers": true
},
"gridPos": {
"h": 4,
"w": 4,
"x": 20,
"y": 0
},
"id": 17,
"interval": null,
"links": [],
"mappingType": 1,
"mappingTypes": [
{
"name": "value to text",
"value": 1
},
{
"name": "range to text",
"value": 2
}
],
"maxDataPoints": 100,
"nullPointMode": "connected",
"nullText": null,
"options": {},
"postfix": "",
"postfixFontSize": "50%",
"prefix": "",
"prefixFontSize": "50%",
"rangeMaps": [
{
"from": "null",
"text": "N/A",
"to": "null"
}
],
"sparkline": {
"fillColor": "rgba(31, 118, 189, 0.18)",
"full": false,
"lineColor": "rgb(31, 120, 193)",
"show": false,
"ymax": null,
"ymin": null
},
"tableColumn": "",
"targets": [
{
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "power",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"accumulatedConsumption"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": []
}
],
"thresholds": "",
"timeFrom": null,
"timeShift": null,
"title": "Consumption today",
"type": "singlestat",
"valueFontSize": "80%",
"valueMaps": [
{
"op": "=",
"text": "N/A",
"value": "null"
}
],
"valueName": "current"
},
{
"cacheTimeout": null,
"colorBackground": false,
"colorPostfix": false,
"colorPrefix": false,
"colorValue": true,
"colors": [
"#299c46",
"rgba(237, 129, 40, 0.89)",
"#d44a3a"
],
"format": "watt",
"gauge": {
"maxValue": 100,
"minValue": 0,
"show": false,
"thresholdLabels": false,
"thresholdMarkers": true
},
"gridPos": {
"h": 3,
"w": 4,
"x": 16,
"y": 4
},
"id": 11,
"interval": null,
"links": [],
"mappingType": 1,
"mappingTypes": [
{
"name": "value to text",
"value": 1
},
{
"name": "range to text",
"value": 2
}
],
"maxDataPoints": 100,
"nullPointMode": "connected",
"nullText": null,
"options": {},
"pluginVersion": "6.3.5",
"postfix": "",
"postfixFontSize": "50%",
"prefix": "",
"prefixFontSize": "50%",
"rangeMaps": [
{
"from": "null",
"text": "N/A",
"to": "null"
}
],
"sparkline": {
"fillColor": "rgb(3, 94, 107)",
"full": false,
"lineColor": "rgb(31, 120, 193)",
"show": false,
"ymax": null,
"ymin": null
},
"tableColumn": "",
"targets": [
{
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "power",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"averagePower"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": []
}
],
"thresholds": "5000,10000",
"timeFrom": null,
"timeShift": null,
"title": "Average power",
"type": "singlestat",
"valueFontSize": "80%",
"valueMaps": [
{
"op": "=",
"text": "N/A",
"value": "null"
}
],
"valueName": "current"
},
{
"cacheTimeout": null,
"colorBackground": false,
"colorValue": false,
"colors": [
"#299c46",
"rgba(237, 129, 40, 0.89)",
"#d44a3a"
],
"decimals": 2,
"format": "currencyNOK",
"gauge": {
"maxValue": 100,
"minValue": 0,
"show": false,
"thresholdLabels": false,
"thresholdMarkers": true
},
"gridPos": {
"h": 3,
"w": 4,
"x": 20,
"y": 4
},
"id": 20,
"interval": null,
"links": [],
"mappingType": 1,
"mappingTypes": [
{
"name": "value to text",
"value": 1
},
{
"name": "range to text",
"value": 2
}
],
"maxDataPoints": 100,
"nullPointMode": "connected",
"nullText": null,
"options": {},
"postfix": "",
"postfixFontSize": "50%",
"prefix": "",
"prefixFontSize": "50%",
"rangeMaps": [
{
"from": "null",
"text": "N/A",
"to": "null"
}
],
"sparkline": {
"fillColor": "rgba(31, 118, 189, 0.18)",
"full": false,
"lineColor": "rgb(31, 120, 193)",
"show": false,
"ymax": null,
"ymin": null
},
"tableColumn": "",
"targets": [
{
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"previous"
],
"type": "fill"
}
],
"measurement": "energy",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT last(\"total\") + (41.91 / 100) + ((287.5 / 30.5) / 24) FROM \"energy\" WHERE $timeFilter GROUP BY time($__interval) fill(previous)\n-- Nettleie: 41.91 øre/KWh\n-- Månedlig fastpris: 287,50",
"rawQuery": true,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"total"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
}
],
"thresholds": "",
"timeFrom": null,
"timeShift": null,
"title": "Current price / KWh",
"type": "singlestat",
"valueFontSize": "80%",
"valueMaps": [
{
"op": "=",
"text": "N/A",
"value": "null"
}
],
"valueName": "current"
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"decimals": 2,
"description": "",
"fill": 1,
"fillGradient": 4,
"gridPos": {
"h": 8,
"w": 12,
"x": 0,
"y": 5
},
"id": 2,
"interval": "",
"legend": {
"alignAsTable": false,
"avg": false,
"current": true,
"hideEmpty": false,
"hideZero": false,
"max": false,
"min": false,
"rightSide": false,
"show": true,
"total": false,
"values": true
},
"lines": true,
"linewidth": 1,
"nullPointMode": "connected",
"options": {
"dataLinks": []
},
"percentage": false,
"pointradius": 2,
"points": false,
"renderer": "flot",
"seriesOverrides": [
{
"alias": "Power",
"yaxis": 2
},
{
"alias": "Price",
"yaxis": 1
}
],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"alias": "Power",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"linear"
],
"type": "fill"
}
],
"hide": false,
"measurement": "power",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"power"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": []
},
{
"alias": "Price",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"previous"
],
"type": "fill"
}
],
"measurement": "energy",
"orderByTime": "ASC",
"policy": "default",
"refId": "B",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"total"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
}
],
"thresholds": [],
"timeFrom": null,
"timeRegions": [],
"timeShift": null,
"title": "Power consumprion",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"buckets": null,
"mode": "time",
"name": null,
"show": true,
"values": []
},
"yaxes": [
{
"format": "currencyNOK",
"label": "Price",
"logBase": 1,
"max": null,
"min": null,
"show": true
},
{
"decimals": null,
"format": "watt",
"label": "Energy",
"logBase": 1,
"max": null,
"min": null,
"show": true
}
],
"yaxis": {
"align": false,
"alignLevel": null
}
},
{
"cacheTimeout": null,
"colorBackground": false,
"colorPostfix": false,
"colorPrefix": false,
"colorValue": true,
"colors": [
"#299c46",
"rgba(237, 129, 40, 0.89)",
"#d44a3a"
],
"format": "watt",
"gauge": {
"maxValue": 100,
"minValue": 0,
"show": false,
"thresholdLabels": false,
"thresholdMarkers": true
},
"gridPos": {
"h": 3,
"w": 4,
"x": 16,
"y": 7
},
"id": 12,
"interval": null,
"links": [],
"mappingType": 1,
"mappingTypes": [
{
"name": "value to text",
"value": 1
},
{
"name": "range to text",
"value": 2
}
],
"maxDataPoints": 100,
"nullPointMode": "connected",
"nullText": null,
"options": {},
"pluginVersion": "6.3.5",
"postfix": "",
"postfixFontSize": "50%",
"prefix": "",
"prefixFontSize": "50%",
"rangeMaps": [
{
"from": "null",
"text": "N/A",
"to": "null"
}
],
"sparkline": {
"fillColor": "rgb(3, 94, 107)",
"full": false,
"lineColor": "rgb(31, 120, 193)",
"show": false,
"ymax": null,
"ymin": null
},
"tableColumn": "",
"targets": [
{
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "power",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"minPower"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": []
}
],
"thresholds": "5000,10000",
"timeFrom": null,
"timeShift": null,
"title": "Minimum power",
"type": "singlestat",
"valueFontSize": "80%",
"valueMaps": [
{
"op": "=",
"text": "N/A",
"value": "null"
}
],
"valueName": "current"
},
{
"cacheTimeout": null,
"colorBackground": false,
"colorPostfix": false,
"colorPrefix": true,
"colorValue": false,
"colors": [
"#299c46",
"rgba(237, 129, 40, 0.89)",
"#d44a3a"
],
"decimals": 2,
"format": "currencyNOK",
"gauge": {
"maxValue": 100,
"minValue": 0,
"show": false,
"thresholdLabels": false,
"thresholdMarkers": true
},
"gridPos": {
"h": 3,
"w": 4,
"x": 20,
"y": 7
},
"id": 15,
"interval": null,
"links": [],
"mappingType": 1,
"mappingTypes": [
{
"name": "value to text",
"value": 1
},
{
"name": "range to text",
"value": 2
}
],
"maxDataPoints": 100,
"nullPointMode": "connected",
"nullText": null,
"options": {},
"pluginVersion": "6.3.5",
"postfix": "",
"postfixFontSize": "50%",
"prefix": "",
"prefixFontSize": "50%",
"rangeMaps": [
{
"from": "null",
"text": "N/A",
"to": "null"
}
],
"sparkline": {
"fillColor": "rgba(31, 118, 189, 0.18)",
"full": false,
"lineColor": "rgb(31, 120, 193)",
"show": false,
"ymax": null,
"ymin": null
},
"tableColumn": "",
"targets": [
{
"groupBy": [
{
"params": [
"$interval"
],
"type": "time"
}
],
"measurement": "power",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"accumulatedCost"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": []
}
],
"thresholds": "",
"timeFrom": null,
"timeShift": null,
"title": "Net cost today",
"type": "singlestat",
"valueFontSize": "80%",
"valueMaps": [
{
"op": "=",
"text": "N/A",
"value": "null"
}
],
"valueName": "current"
},
{
"cacheTimeout": null,
"colorBackground": false,
"colorPostfix": false,
"colorPrefix": false,
"colorValue": true,
"colors": [
"#299c46",
"rgba(237, 129, 40, 0.89)",
"#d44a3a"
],
"format": "watt",
"gauge": {
"maxValue": 100,
"minValue": 0,
"show": false,
"thresholdLabels": false,
"thresholdMarkers": true
},
"gridPos": {
"h": 3,
"w": 4,
"x": 16,
"y": 10
},
"id": 13,
"interval": null,
"links": [],
"mappingType": 1,
"mappingTypes": [
{
"name": "value to text",
"value": 1
},
{
"name": "range to text",
"value": 2
}
],
"maxDataPoints": 100,
"nullPointMode": "connected",
"nullText": null,
"options": {},
"pluginVersion": "6.3.5",
"postfix": "",
"postfixFontSize": "50%",
"prefix": "",
"prefixFontSize": "50%",
"rangeMaps": [
{
"from": "null",
"text": "N/A",
"to": "null"
}
],
"sparkline": {
"fillColor": "rgb(3, 94, 107)",
"full": false,
"lineColor": "rgb(31, 120, 193)",
"show": false,
"ymax": null,
"ymin": null
},
"tableColumn": "",
"targets": [
{
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "power",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"maxPower"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": []
}
],
"thresholds": "5000,10000",
"timeFrom": null,
"timeShift": null,
"title": "Maximum power",
"type": "singlestat",
"valueFontSize": "80%",
"valueMaps": [
{
"op": "=",
"text": "N/A",
"value": "null"
}
],
"valueName": "current"
},
{
"cacheTimeout": null,
"colorBackground": false,
"colorPostfix": false,
"colorPrefix": false,
"colorValue": false,
"colors": [
"#299c46",
"rgba(237, 129, 40, 0.89)",
"#d44a3a"
],
"decimals": 2,
"format": "currencyNOK",
"gauge": {
"maxValue": 100,
"minValue": 0,
"show": false,
"thresholdLabels": false,
"thresholdMarkers": true
},
"gridPos": {
"h": 3,
"w": 4,
"x": 20,
"y": 10
},
"id": 18,
"interval": null,
"links": [],
"mappingType": 1,
"mappingTypes": [
{
"name": "value to text",
"value": 1
},
{
"name": "range to text",
"value": 2
}
],
"maxDataPoints": 100,
"nullPointMode": "connected",
"nullText": null,
"options": {},
"pluginVersion": "6.3.5",
"postfix": "",
"postfixFontSize": "50%",
"prefix": "",
"prefixFontSize": "50%",
"rangeMaps": [
{
"from": "null",
"text": "N/A",
"to": "null"
}
],
"sparkline": {
"fillColor": "rgba(31, 118, 189, 0.18)",
