Compare two time ranges with pivot or tstats

[Simon]

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

[thomrs]

I use the timewrap app for this, compares ranges via time chart. The stats are also available for viewing.

https://apps.splunk.com/app/1645/

[jayannah]

Did you get the solution using pivot? We can't specify time range in pivot command..