topic Re: Dashboard DQL - combine tiles values (can variables be used?) in Dashboarding

Combine tiles values in Dashboard DQL?

paolo_fumanelli — Fri, 05 Dec 2025 11:26:45 GMT

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

Re: Dashboard DQL - combine tiles values (can variables be used?)

PacoPorro — Fri, 24 Jan 2025 13:04:45 GMT

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)

Re: Dashboard DQL - combine tiles values (can variables be used?)

paolo_fumanelli — Fri, 24 Jan 2025 13:42:45 GMT

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).