topic Timeseries - Distinct count regardless of the time interval value in DQL

Timeseries - Distinct count regardless of the time interval value

jegron — Wed, 23 Oct 2024 15:57:51 GMT

Hi,

I'd like to graph a metric that counts distinct values of a dimension over time, regardless of the time interval value.

Example :

timeseries { sum = sum(mymetrics, default: 0)}, by:{dimension1, dimension2}, interval:1m => OK
timeseries { sum = sum(mymetrics, default: 0)}, by:{dimension1, dimension2}, interval:10m => KO

Do you have a tip?

Re: Timeseries - Distinct count regardless of the time interval value

krzysztof_hoja — Thu, 24 Oct 2024 20:47:02 GMT

Here is example query which calculates distinct count of values of "k8s.workload.name" dimension over time:

timeseries {containersCnt = sum(dt.kubernetes.containers), timestamp=start()}, by: { k8s.workload.name } | fieldsAdd d=record(containersCnt=containersCnt[], timestamp=timestamp[]) | expand d | filterOut isNull(d[containersCnt]) | makeTimeseries countDistinct(k8s.workload.name), time:d[timestamp]

Re: Timeseries - Distinct count regardless of the time interval value

jegron — Fri, 25 Oct 2024 09:32:16 GMT

Perfect! Thanks a lot.

Are you planning to simplify makeTimeseries use for timeseries? It is not easy right now ...