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.
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.
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.