function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
KCarmenKCarmen 

Best way to create a time-based actual vs. goal

Hi devs,

I'm working on how best to create a report that shows the hourly goal of Demos Set to what was actually set.
This report is looked at throughout the day so the goal would need to change per hour.
I created a formula field to indicate time of day and it keeps building as the day goes on, then I created a formula field to capture the static goal.
The report below is based on today and looks like this:
User-added image
Is there a better way for management to look at this and track it when the hour's end gets close?
Should I be creating a custom object or looking for an outside app?