Hi All,
Has anyone found it possible to overlay or join queries in a visualization? As an example, if we were looking to create a line graph containing data results from multiple queries for a timeframe.
1 Like
hello. not sure if this is what your looking for but your “groupby” after your query you can have multiple items separated with a comma. like where(username_name=XZY) groupby(destination_asset,username)
hope this helps, its a really cool feature that extends to the dashboards.
1 Like
@rford ,
You can do that pretty easily. In your example you wanted to use a line graph, when you build your dashboard card, ensure the final portion of your query is a calculate(count) function, then when you add a second query, put calculate(count) at the end of that one. When you have 2 or more queries your visualization options should include the “Stacked Area” option in the bottom left which I’m assuming is what you’re looking for.
1 Like
These were very helpful thank you guys, we found what we needed here.
1 Like