Please Note This forum exists for community support for the Mango product family and the Radix IoT Platform. Although Radix IoT employees participate in this forum from time to time, there is no guarantee of a response to anything posted here, nor can Radix IoT, LLC guarantee the accuracy of any information expressed or conveyed. Specific project questions from customers with active support contracts are asked to send requests to support@radixiot.com.
Charting number of events over time
-
Hi all,
I looked through the forum, but I cannot find anything related. How can you chart the number of events over time? For example a bar chart of number of urgent events of data points per day for a 1 week?
BR,
Ricardo -
Any ideas?
-
Hi Ricardo,
maybe:
create a SQL-Data-Source and connect to the h2-db,
Select statement: SELECT COUNT(ID) FROM events WHERE ISNULL(ackTs)
create one numeric datapoint, run the query and log the history.Or:
Check the alarm-icon with the counter inside the header.
There is something like<span ng-bind="$ctrl.renderCount($ctrl.events.totalCount)">16</span> -
Just a thought, but is there not an internal mango datapoint you can take a snapshot of with a meta datapoint? Either that or make api calls and store the result.
At least then you could graph that however you like.
Nice idea with the SQL query RalfFox
