Report display rolling hour of day

[Stevie-Kv]

Context

• We have a verticle bar report which shows activity over the last day. For example, 22 deal records were modified 10-11am.
  • A date/time property is one of the datapoints (x-axis). It is set set to display 'Hour of day'.
  • There is a filter set for this date/time property 'is less than 1 day ago'

What we want to do

• We want the filter to be 'less than 24 hours (rolling)' instead of 'less than 1 day'.
• We want the display order to show the current time on the right, and previous hours going left. e.g. left->right 24h ago, 23h ago...2h ago, last hour, current hour.

Why can't do it today

The reporting display options and filter does not offer these options

Idea

Add these options 😉 

[CBN]

This is just so typically HubSpot.

Why can't I see today's data in my rolling filters?

I want to see today's deals today ... just as I can see them in my Deal's Pipeline.

[CBN]

This is the setting that makes no sense. And I cannot change it.

[Anonymous]

Hi @Stevie-Kv @CBN 
I tried to do it using custom code on a workflow and creating a contactproperty "hours_since_last_update". I hope it helps 🙂 

[Anonymous]

Hi @Stevie-Kv @CBN 

I tried to create a report like that using custom code on a workflow and creating a contact property. I hope it helps 🙂 

[CBN]

Thanks @Anonymous 
I can see it works, but it a rather long way to cross the stream to get water.

Why not just give me the data including "now"? I am not asking for realtime data, but sort of anything upto 5-10 minutes before now would really help. 

Once or twice per month I have to explain this to our users. And they simply share their head.

This reminds me of why I have to wait minutes to see the result of a dynamic list???? Another discussion, but the same.

And why - just to continue - is it that I can only use the Search API 10 times per second? The way data is structured in CRM you often need to first search for a deal, then an email and then an alternative email. If you have 2 or 3 operations in progress you hit that Rate Limit often. And loose business or relevant updates.