# Explore Advanced Time-Series Analysis Using DQL

**URL:** <https://community.dynatrace.com/t/explore-advanced-time-series-analysis-using-dql/50390>\
**Category:** DQL\
**Tags:** dql, dynatrace-managed\
**Created:** [February 21, 2025, 11:50am UTC](https://community.dynatrace.com/t/explore-advanced-time-series-analysis-using-dql/50390 "2025-02-21T11:50:54Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![henk\_stobbe](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/henk_stobbe/32/30434_2.png) [@henk\_stobbe](https://community.dynatrace.com/u/henk_stobbe)\
**Post date:** [February 21, 2025, 11:50am UTC](https://community.dynatrace.com/t/explore-advanced-time-series-analysis-using-dql/50390/1 "2025-02-21T11:50:54Z")

</div>

Hello,

(and yes I know you can use -1 as default, but this is more fun)

As an example:

timeseries def1=count(dt.host.cpu.load,default:1),{def2=count(dt.host.cpu.load,default:0)}| fieldsadd Result = def1[] - def2[] | fieldsRemove def1,def2

Show me when I have no timeseries

 ![henk_stobbe_0-1740138384834.png](https://global.discourse-cdn.com/dynatrace/original/3X/8/a/8acdbabe674f1ad46f3333842e0c22cf14260e8b.png)

or:

timeseries def1=count(dt.host.cpu.load,default:1),{def2=count(dt.host.cpu.load,default:0)}| fieldsadd Result = def2[] - def1[] +1 | fieldsRemove def1,def2

Show me when I have timeseries:

 ![henk_stobbe_1-1740138555787.png](https://global.discourse-cdn.com/dynatrace/original/3X/6/e/6e2cc7ef327bc570e98d54502022f244e4e3e03d.png)

Maybe this van inspire someone

KR Henk
