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,
Great question!
In GQI, the standard grouping process involves utilizing the distinct values within a column to establish groups. Records sharing the same value in a particular column are grouped together, enabling subsequent aggregation of specific data for each group.
However, in your specific scenario, we aim to redefine the concept of grouping. Rather than creating groups based on unique values, we intend to form time-based buckets, each spanning 5 minutes. Any record with a value falling within the time frame of a 5-minute bucket will be allocated to that group. After these time-based groups are established, aggregation can proceed in a manner consistent with current practices.
It's worth noting that this specific grouping behavior is not currently available, although it's a concept we've already considered and added to our development backlog. I'll keep you informed through this post whenever there's an update on its implementation.
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
Thank you Sebastiaan. Please keep us posted on this feature release.