Compare current hour Vs Yesterday same hour

[AhadLafi]

Hello all,

Please, I need support with this case:

I try to compare current hour of today VS the same hour from yesterday.

I make the Date pivot, and filter it for last to day’s (17 Jun 2021 - 16 Jun 2021).

And filter hour by In the past 1 Hour.

To get the % difference between two date, I write calculation as the below:

Pivot_Index(${Order},1)/Pivot_Index(${Order},2)-1

Also, I want to compare the current day 17 Jun 2021 with the same day from last month 17 May 2021.

[Jimmy_Westman]

Hey @AhadLafi ! 

You should be able to use an advanced filter with the extract_hour()-function. By using this you make sure to only show data from the current hour: extract_hours(${timedimension}) = extract_hours(now())

Combine this with “is in the past 2 days” and you will get all data from the current hour, and the same hour yesterday!

------------

To compare today with the same date last month you can do the same, but use extract_days() instead,

extract_days(${datedimension}) = extract_days(now()) combined with “is in the past 2 months”.

Example: