Report display rolling hour of day

Search HubSpot Ideas or Create Idea
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Status: Idea Submitted
Stevie-Kv
Submitted by on ‎Jun 12, 2024 5:02 AM

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'

HawkSteve_0-1718182655898.png

 

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 😉 

See more ideas labeled with:
5 Replies
CBN
Top Contributor
‎May 20, 2025 9:00 AM

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
Top Contributor
‎May 20, 2025 9:03 AM

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

 

CBN_0-1747746205410.png

 

Anonymous
Not applicable
‎Jun 2, 2025 8:28 AM

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 🙂 

 

Capture d’écran 2025-06-02 142115.jpg

 

Capture d’écran 2025-05-23 195056.jpg

Anonymous
Not applicable
‎Jun 2, 2025 8:31 AM

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 🙂 

Capture d’écran 2025-06-02 142115.jpgCapture d’écran 2025-05-23 195056.jpg

CBN
Top Contributor
‎Jun 6, 2025 11:15 AM

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.