Dynamic time period in datatable visulisation

[anjilinga (Anji)]

Hi,

How can the Datehistogram period can be configured dynamically. curently the histogram is configured as 1d.
to see the data for 1 week, the data is displaying in multiple rows. is there any way to display the data as per period selected in a single row for each group.
to see the summary data for 1 day, 1 week, 1 month and 1 year as a summary instead of multiple rows for the same group by

Regards,

[markov00 (Marco Vettorello)]

Hi, something similart to this can be achieved with a filter aggregation instead: this can allow you to specify a subset of time windows (of the current selected time range) and apply an aggregation of each specific subset of documents.
I've attached here an example where I've filtered out documents based on KQL filters on the time field.