cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

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

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

 

2 REPLIES 2

PacoPorro
Dynatrace Leader
Dynatrace Leader

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)

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

Featured Posts