Expand my Community achievements bar.

Join us for the next Community Q&A Coffee Break on Tuesday April 23, 2024 with Eric Matisoff, Principal Evangelist, Analytics & Data Science, who will join us to discuss all the big news and announcements from Summit 2024!

Compare current day in Workspace

Avatar

Level 9

11/14/16

Love the new compare time periods feature!!  Can you please add the following?

Comparison vs. Current Day

     It is difficult to compare against current day because the current day has not ended yet.  If I wanted to compare against current day is it possible to cut off the comparison date at the same time of day of the current day?

9 Comments

Avatar

Level 2

11/30/16

Good suggestion, 
Could it be possible to also have the comparison dynamic. 

I tried to built a report to have dynamic comparison for "yesterday" (select in the date - so full day data) vs the day before. 
It seems that the comparison date is stuck even when the date change. 

ie : the 22nd, I run a report on 21st vs 20th. 
I come back on the report the 23, the yesterday date is rightly chose dynamicly( the 22nd) but the comparison remains the 20th. I would like the comparison to move from the 20th to 21st. 

Avatar

Employee

12/1/16

@michael-jet Great points. Our date ranges that we use in the segments that allow us to do date comparisons only have daily granularity, so we'd need to add hourly. Great request.

Avatar

Level 2

12/1/16

Hey Ben,

I was thinking of this. 
A solution could be that, every time the time selection is dynamic in the report (yesterday, last 7 days, last week, etc...) 
The comparison is dynamic. 

Avatar

Level 2

12/2/16

@pitchkrak I think that IS how it works...if you hitch your compare wagon to a dynamic preset range, the comparison will move along naturally changing each day, or week, etc.

Avatar

Level 2

1/3/17

I re-test it and it still doesn't work. 
It work whem you select pre-defined rolling date (yesterday & today) but as explain by the first post, you can never really compare today & yesterday, except at 11:59 pm. 

So I repeat the idea : be able to compare yesterday with the day before yesterday and making it rolling.