Period over Period - Hourly comparison

Reply
Highlighted
Yellow Belt

Period over Period - Hourly comparison

Hello,

I want to do a period over period comparison on an hourly view.  I would like to compare against 48 hours ago but the hour comparison is greyed out.  If I changed the "graph by" to days then it shows up but greys out once I change it back to hours. Any idea on how I can do a comparison of hours?

Screenshot attached.

Thanks

Highlighted
Blue Belt

Re: Period over Period - Hourly comparison

@user06209 

 

I'm not certain why you can't do a period over period graph based on hours, seems like you should be able to. One way you can get around it is if you create a MySQL ETL to join the table to itself based on the time being 48 hours before and labeling those oclumns with a suffix ('_48ago' for example). This is assuming you're at an hour level granularity - otherwise you'll need to group based on the hour and then join the two tables together.



**Was this post helpful? Click the heart icon**

**Did this solve your problem? Accept it as a solution!**
Tags (1)
Announcements
Want to join our weekly online meet up? Please visit this board here and let me know. Click here for more details!