Hi Guys
These are a couple of Visuals I have in an Availability Dashboard (refer to attached image)
Description of visuals referenced by numbers
1 – DQL query – Host availability per Application and Host - Visual = Table
2 – Same DQL query as in (1) with the addition of a summarize/ avg calculation (by Application)
| summarize {avg(Availability_BH),avg(Availability_NBH)}, by:{$Application}
3 – Hosts - Same DQL query as in (1) with the addition of a summarize / count (by Host)
| summarize Hosts = countDistinct(host.entity.name)
3 – Applications - Same DQL query as in (1) with the addition of a summarize / count (by Applications)
| summarize Applications = countDistinct(Application)
This scenario works fine but it is not efficient from a DQL query perspective as it needs to be run 5 times, once for the Detail (1) and then again for the remaining visuals(2,3) based on what summarization needs to take place depending on the Visual used
What I want to be able to do is perform the DQL query only once and then reference it in the other visual and then perform the required summarization
This could be possible by defining a hidden Variable called “HostDetail” and running the detail DQL query here which will contain the output in Table format as per (1) – I could then reference it and do the summarization
If the $HostDetail was JSON referencing it will be quite straightforward as it would be done as follows:
data json:$HostDetail
However because it is a Table I am not sure how to reference $HostDetail, I have referred to the DQL reference and tried a number of DQL functions but have been unsuccessful as I am not sure which function to use
Basically i am looking for this kind of syntax
data ???($HostDetail)
Is it possible? Looking for help with DQL syntax to use in this scenario
Why I want to get this working:
- A single DQL query to maintain
- Cost saving as the DQL query only needs to run once and then referenced in a $Variable based on summarization preference
- More efficient
Appreciate the assistance
Thanks
Alan
