https://community.dynatrace.com/t5/DQL/Get-percentage-of-time-with-ACTIVE-problems-and-not/m-p/293923#M3110 <P>Hi!</P><P>We would like to create a query which checks a timeperiod for all "timebuckets" where a problem was open.</P><PRE><SPAN>fetch events<BR />| filter event.kind == "DAVIS_PROBLEM"<BR />| filter event.category == "AVAILABILITY" <BR />| filter event.status == "ACTIVE"<BR />| filter contains(event.name,"BSN0001632")<BR />| makeTimeseries interval:1m, count = count(default:0)</SPAN>&nbsp;</PRE><P>This is the closest I have&nbsp; come, but it is not quite what I am after.</P><P>One of the questions is if an open event will show as ACTIVE in all timeperiods between event.start and event.end</P> Fri, 30 Jan 2026 11:42:32 GMT tarjei 2026-01-30T11:42:32Z https://community.dynatrace.com/t5/DQL/Get-percentage-of-time-with-ACTIVE-problems-and-not/m-p/293923#M3110 <P>Hi!</P><P>We would like to create a query which checks a timeperiod for all "timebuckets" where a problem was open.</P><PRE><SPAN>fetch events<BR />| filter event.kind == "DAVIS_PROBLEM"<BR />| filter event.category == "AVAILABILITY" <BR />| filter event.status == "ACTIVE"<BR />| filter contains(event.name,"BSN0001632")<BR />| makeTimeseries interval:1m, count = count(default:0)</SPAN>&nbsp;</PRE><P>This is the closest I have&nbsp; come, but it is not quite what I am after.</P><P>One of the questions is if an open event will show as ACTIVE in all timeperiods between event.start and event.end</P> Fri, 30 Jan 2026 11:42:32 GMT https://community.dynatrace.com/t5/DQL/Get-percentage-of-time-with-ACTIVE-problems-and-not/m-p/293923#M3110 tarjei 2026-01-30T11:42:32Z