# DQL future placeholder dates

**URL:** <https://community.dynatrace.com/t/dql-future-placeholder-dates/53433>\
**Category:** DQL\
**Tags:** dql, reports, notebooks, dashboards\
**Created:** [September 22, 2025, 6:30am UTC](https://community.dynatrace.com/t/dql-future-placeholder-dates/53433 "2025-09-22T06:30:30Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![loopy](https://avatars.discourse-cdn.com/v4/letter/l/278dde/32.png) [@loopy](https://community.dynatrace.com/u/loopy)\
**Post date:** [September 22, 2025, 6:30am UTC](https://community.dynatrace.com/t/dql-future-placeholder-dates/53433/1 "2025-09-22T06:30:30Z")

</div>

Is there a way in DQL or dashboards to show the data for today and the next 7 days as 0 until we go past those days? Idea being showing each day from the Monday how many records are returned until the Sunday then the graph resets.

Eg in DQL return this table as there is only data for todays date, show 0 for the rest of the week.

| Date | Count |
| --- | --- |
| 2025-09-22 | 254 |
| 2025-09-23 | 0 |
| 2025-09-24 | 0 |
| 2025-09-25 | 0 |
| 2025-09-26 | 0 |
| 2025-09-27 | 0 |
| 2025-09-28 | 0 |

---

<div class="post-metadata">

**Author:** ![krzysztof\_hoja](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/krzysztof_hoja/32/34625_2.png) [@krzysztof\_hoja](https://community.dynatrace.com/u/krzysztof_hoja)\
**Post date:** [September 22, 2025, 4:28pm UTC](https://community.dynatrace.com/t/dql-future-placeholder-dates/53433/2 "2025-09-22T16:28:35Z")

</div>

Yes, you can just add the placeholders into your data, like this:

```markup
fetch bizevents, from: @w1
| summarize cnt=count(), by: { timestamp=timestamp@d }
| append [
  data record(timestamp=array(
    @w1,
    @w1+1d,
    @w1+2d,
    @w1+3d,
    @w1+4d,
    @w1+5d,
    @w1+6d
  ))
  | expand timestamp
  | fieldsAdd cnt=0
]
| summarize cnt=sum(cnt), by: {timestamp}
| sort timestamp asc

```

I am counting bizevents since beginning of week set on beginning od Monday (_ **@w1** _) .  
After adding placeholders I _ **summarize** _ again using _**sum()**_, so placeholder are deduplicates and do nothing to existing data as 0 is neutral.

 ![krzysztof_hoja_0-1758558450577.png](https://global.discourse-cdn.com/dynatrace/original/3X/0/3/03cce10376427fc91c264de3a4b72c861d9a3fcf.png)
