Hi all,
how can I compare two timeranges using the commands pivot or stats?
Example:
I wanted to compare last week to the last week a year ago without searching the data between those two ranges, e.g.:
| pivot Mymodel Myobject count(Netatmo_Events) AS anz, avg(temperature) AS temp | eval marker="yesterday" | append [| pivot Mymodel Myobject count(Netatmo_Events) AS anz, avg(temperature) AS temp | eval marker="weekago" ]
Thanks,
Simon
I use the timewrap app for this, compares ranges via time chart. The stats are also available for viewing.
Did you get the solution using pivot? We can't specify time range in pivot command..