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.
Thank you Sebastiaan. Please keep us posted on this feature release.