function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Siva__kSiva__k 

How to create reports for an hour with 5 mins interval?

I want to create an hour report with 5 mins interval on case object. How can I acheive this using custom formula. Whenever I refresh my refresh my dashbord it has to bring past one hour data with 5 mins interval. It would be really great if I get some help on this. 
Fahad-AkhtarFahad-Akhtar

Hi,
If you are trying to create a snapshot of your data and report on it, By default in salesforce you can only schedule analytical snapshot on hourly basis, even if you write you custom code to run every five min and create snapshot of your data salesforce doesn’t provide SLA on batches at min level it won’t be accurate per sec but Apex batches would be the way to go.

Please explain your problem in more detail.

Thanks,
​Fahad Akhtar
 
 
Siva__kSiva__k
Thanks for your response Fahad Akhtar. 

1) I want to create hourly reports and dashboard with 5 mins intervals. Suppose if I refresh my dashboard at 10:30AM (EST) it should bring all the data from 9:30AM. 
2) The report X-axis will start from 9:30, 9:35, 9:40, 9:45, .....to 10:30. It has to bring only past one hour report. 
3) I would like to do with custom formula, because in the future I may need to change my reports. 

Thanks in advance.