Dear Dojo Community,
If we are getting time series data, let's take an example, we are getting data in every 1 second.
We build a dashboard with timestamp filter. We build a query using GQI and it's fetching total counts or number of request records for the particular selected time range. It's working fine.
Now on top of that we want to give a functionality to select aggregate function (sum/min/max/avg/count) and period. how we can do that?
for example :- if user selected MAX and period 5 minutes and date range 24 hours, so query should fetch all 24 hours data for 5-5 mins interval. And 5 minutes interval will have max value during 5 mins.
Thanks
Hi Vikas,
As Sebastiaan mentioned, this option is currently not available. A possible workaround at this moment is to either the change the polling time of the parameter in the driver or update the timer base to reduce the polling frequency (Changing the polling speed of an element).
Hope it helps.
Thank you Miguel for the workaround but it’ll work if we have single user or sliding window configured from backend. Here we want to give option to user to aggregate data for particular sliding window and Dashboard/app can be accessible by multiple users. Everyone can filter base on their need. Few of them can see 5 mins sliding window data others can see 10 mins and so on. but minimum sliding window will be 1 mins as we are getting from hardware for every 1 mins.
Thank you