Thingsboard Dashboard creation
Budget: £3,000 – £5,000 GBP
Please have a look at the attached. I have also provided a summary of the requirements below:
Example Thingsboard customer structure
Customer 1 (customer)
- Division 1 (division - customer Group)
- School (customer group)
- Site (customer group)
- floor 1 (asset)
- floor 2 (asset)
- Energy Meter - Lighting (device - Energy Meter)
- Energy Meter - Kitchen (device - Energy Meter)
- Motion Sensor rm 102 (device - Motion Sensor)
- Smart Plug rm 102 (device - Smart Plug)
Energy readings
Co2 usage = is sum Kwh energy x current conversion Rate (both telemetry values). Rule chain take current attribute value and enrich telemetry with this before saving entries
Energy Cost = sum Kwh energy x current cost rate + fixed rate (all telemetry).Rule chain take current attribute values and enrich telemetry with this before saving entries
Cost per Pupil = Energy Cost / number of pupils (site attribute)
Cost per Meter = Energy Cost / Square metre space (site attribute)
Cost per Staff = Energy Cost / Staff number (site attribute)
Energy Cost vs Budget = Take (energy Cost for period / (Yearly Budget/365*number of days in period )) * 100 (ie a percentage of budget) - Budget will change yearly and so attribute will be enriched to telemetry.
Example Hierarchies
## Admin Dashboard
Same as SuperMarket Administration example on Thingsboard but for any hierarchy level showing all companies in a customer Groups with mange device, users, assets options on right of each entry
same Add, search column capability as with example widget
### Manage Devices (top level)
Same as supermarket example on Thingsboard based on Company selected. Same fields.
Same +, search etc capabilities
### Manage Users
Same as supermarket example on Thingsboard based on Company selected. Same fields.
Same +, search etc capabilities
### Manage Sites
Same as smart supermarket manage supermarkets dashboard on Thingsboard with map on left and list on right with alarms based on Company selected. Same fields.
Same +, search etc capabilities
## Group Dashboard
Dashboard
Dashboard showing overall usage, cost and co2 for all sites of the customer. For lower level users dashboard just shows that level and below. Customer Groups would see figures for all sites and division owners would just see their level etc.
See comments on screenshot attached
**Important! School years run from September-August and so comparisons with the year before need to be able to cover a Sept-Aug year. All dashboards need to work on a September-August year basis.**
### View sites
This is a leaderboard showing all sites under the customer
See notes on screenshot attached
School breakdown
this dashboard shows the sites and floors for a particular schools with usage for each
see screenshot attached
Floor breakdown
This is very much like a simplified version of the supermarket example.
- Floor plan should be updateable with new floorplan
- Devices can either be zones (multi-point area) or location (as in the example below)
- Same capabilities as supermarket example move devices, add on plan, remove device and edit device details
- Same +, search etc capabilities
see screenshot attached
Example Thingsboard customer structure
Customer 1 (customer)
- Division 1 (division - customer Group)
- School (customer group)
- Site (customer group)
- floor 1 (asset)
- floor 2 (asset)
- Energy Meter - Lighting (device - Energy Meter)
- Energy Meter - Kitchen (device - Energy Meter)
- Motion Sensor rm 102 (device - Motion Sensor)
- Smart Plug rm 102 (device - Smart Plug)
Energy readings
Co2 usage = is sum Kwh energy x current conversion Rate (both telemetry values). Rule chain take current attribute value and enrich telemetry with this before saving entries
Energy Cost = sum Kwh energy x current cost rate + fixed rate (all telemetry).Rule chain take current attribute values and enrich telemetry with this before saving entries
Cost per Pupil = Energy Cost / number of pupils (site attribute)
Cost per Meter = Energy Cost / Square metre space (site attribute)
Cost per Staff = Energy Cost / Staff number (site attribute)
Energy Cost vs Budget = Take (energy Cost for period / (Yearly Budget/365*number of days in period )) * 100 (ie a percentage of budget) - Budget will change yearly and so attribute will be enriched to telemetry.
Example Hierarchies
## Admin Dashboard
Same as SuperMarket Administration example on Thingsboard but for any hierarchy level showing all companies in a customer Groups with mange device, users, assets options on right of each entry
same Add, search column capability as with example widget
### Manage Devices (top level)
Same as supermarket example on Thingsboard based on Company selected. Same fields.
Same +, search etc capabilities
### Manage Users
Same as supermarket example on Thingsboard based on Company selected. Same fields.
Same +, search etc capabilities
### Manage Sites
Same as smart supermarket manage supermarkets dashboard on Thingsboard with map on left and list on right with alarms based on Company selected. Same fields.
Same +, search etc capabilities
## Group Dashboard
Dashboard
Dashboard showing overall usage, cost and co2 for all sites of the customer. For lower level users dashboard just shows that level and below. Customer Groups would see figures for all sites and division owners would just see their level etc.
See comments on screenshot attached
**Important! School years run from September-August and so comparisons with the year before need to be able to cover a Sept-Aug year. All dashboards need to work on a September-August year basis.**
### View sites
This is a leaderboard showing all sites under the customer
See notes on screenshot attached
School breakdown
this dashboard shows the sites and floors for a particular schools with usage for each
see screenshot attached
Floor breakdown
This is very much like a simplified version of the supermarket example.
- Floor plan should be updateable with new floorplan
- Devices can either be zones (multi-point area) or location (as in the example below)
- Same capabilities as supermarket example move devices, add on plan, remove device and edit device details
- Same +, search etc capabilities
see screenshot attached