To perform math operation on two queries (both running in different timeranges - eg. Query A - today, Query B - last week same day).
Use case: To calculate the percentage change between today and last week same day.
I’m using Elasticsearch data source.
I tried using Singlestat math but cannot control the time range for each of the queries running in the panel. Metaqueries seems to plot the graph for this use case but I’m looking for a panel like singlestat.
Any help will be much appreciated!
Thanks