Thanks for responding,
Basically I want to compare metric for different timeframe.
I am fetching data from bizevent(fetch bizevent),currently I am able to
get data for specific single timeframe .
Now I need a tabular output where same metric can be monitored for two release(timeframe).
I also tried creating two seperate DQL for each timeframe, but didnt find way to merge those two column in single table
Here is some highlevel Expected output
|Application_metric_name||Release1(2nd may)||Release2(6th June)|
@amita thanks for the details.
One way you likely already figured out is putting two separate queries next to each on a dashboard, for example, via a single-value tile.
If you need to merge the result, you could leverage the lookup command as a workaround.
fetch bizevents, from:now()-7d | summarize this_week = avg(toDouble(amount)) | fieldsAdd helper="test" | lookup [ fetch bizevents, from:now()-14d, to:-7d | summarize previous_week = avg(toDouble(amount)) | fieldsAdd helper="test"] , sourceField:helper, lookupField:helper | fieldsRemove helper, lookup.helper | fieldsRename lookup.previous_week, alias:previous_week
Kind regards, Philipp