# Combine tiles values in Dashboard DQL?

**URL:** <https://community.dynatrace.com/t/combine-tiles-values-in-dashboard-dql/49906>\
**Category:** Dashboarding\
**Tags:** dql, dashboards\
**Created:** [January 24, 2025, 11:57am UTC](https://community.dynatrace.com/t/combine-tiles-values-in-dashboard-dql/49906 "2025-01-24T11:57:06Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![paolo\_fumanelli](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/paolo_fumanelli/32/1037_2.png) [@paolo\_fumanelli](https://community.dynatrace.com/u/paolo_fumanelli)\
**Post date:** [January 24, 2025, 11:57am UTC](https://community.dynatrace.com/t/combine-tiles-values-in-dashboard-dql/49906/1 "2025-01-24T11:57:06Z")

</div>

Hi folks,

I have a dashboard in which I want to show some different values (DQL timeseries output) in different tiles.

Then, I want to combine (sum or other aggregations) all these values in a single, final tile.

Of course I could write a DQL statement that extracts them again and combines them up. But it has 2 limitations:

1) the final DQL query would become huge to be managed

2) if I change one of the initial tiles, then I have to modify also the huge DQL one

I thought I could use variables for this. I mean create a variable (not displayed as filter) for each tile, then show in each tile just the variable itself, and in the final tile combine them. This would solve points 1 and 2 above.

The problem is that, to make it very simple, if I create a variable named “fake” like this example:

timeseries sum(dt.service.request.count)  
| fields total = arraySum(`sum(dt.service.request.count)`)  
| summarize sum(total)

and then reference it in a tile like this:

data record(a=$fake)

At the first execution the second tile shows the correct value, but if then the variable is refreshed, the referencing tile is not.

How can achieve what I’m trying to do?

Thanks  
Paolo

---

<div class="post-metadata">

**Author:** ![PacoPorro](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/pacoporro/32/36087_2.png) [@PacoPorro](https://community.dynatrace.com/u/PacoPorro)\
**Post date:** [January 24, 2025, 1:04pm UTC](https://community.dynatrace.com/t/combine-tiles-values-in-dashboard-dql/49906/2 "2025-01-24T13:04:45Z")

</div>

What if you use the same dql query for the variable and the tile?  
Variable  
timeseries sum(dt.service.request.count)  
| fields total = arraySum(`sum(dt.service.request.count)`)  
| summarize sum(total)

Tile:  
timeseries sum(dt.service.request.count)  
| fields total = arraySum(`sum(dt.service.request.count)`)  
| summarize sum(total)

---

<div class="post-metadata">

**Author:** ![paolo\_fumanelli](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/paolo_fumanelli/32/1037_2.png) [@paolo\_fumanelli](https://community.dynatrace.com/u/paolo_fumanelli)\
**Post date:** [January 24, 2025, 1:42pm UTC](https://community.dynatrace.com/t/combine-tiles-values-in-dashboard-dql/49906/3 "2025-01-24T13:42:45Z")

</div>

Sure that’s a possibility. But when I have tens of tiles (and with much more complex DQL) then the final tile will become huge and difficult to maintain (see points 1 and 2 above).
