topic Re: Total time for a dimension regarding the timeseries in DQL

Total time for a dimension regarding the timeseries

Sullivan — Wed, 02 Apr 2025 09:21:07 GMT

Hello everyone,

I want to retrieve the total time of a time series for each service in order to produce a monthly report on the total degradation time per service.

Basic DQL query:

timeseries interval : 1h, health = avg(office365.tenant.service.health, filter : { status == ‘ serviceDegradation ’ }), by : { service }

Do you have any ideas on how to do this please?

Regards,

Re: Total time for a dimension regarding the timeseries

yanezza — Sat, 05 Apr 2025 20:32:49 GMT

Are you meaning like this?

timeseries by:{service}, filter:status == "serviceDegradation", interval:1h, timeframe:timeframe(from:now() - 30d, to:now()), health = avg(office365.tenant.service.health) | fieldsAdd total_degradation_time = arraySum(health)

you can remove the timeframe if you will set it in the notebook section.

Re: Total time for a dimension regarding the timeseries

Sullivan — Mon, 07 Apr 2025 08:14:27 GMT

Hi Yanezza, thanks for your suggestion, I made the DQL query after my post finally, I forgot to close, thanks for your suggestion I created this query :

timeseries by:{service}, filter:status == $Statut, health = avg(office365.tenant.service.health)
| fieldsAdd health = arrayRemoveNulls(health)
| fieldsAdd total_time = toDuration(timeframe)
| filter isNotNull(total_time)
| fieldsAdd arraySize(health)
| fieldsAdd TempsduStatut=(`arraySize(health)`*interval)