I'm trying to create a widget that shows the open requests for the day and below shows the average requests opened per day.
The widget I created uses:
Select Columns
Data Column - RequestID (Count)
Group By: Created Time (Full Date)
Show Value As
Primary Value: Latest
Secondary Values: Average
Filters
Created Time: Relative - Today
I am getting totals for both the Latest and Average. My main question is what makes up that average number? Am I seeing the average number of requests created for just today or an average of requests created a day calculated from all requestid's (which is what I am looking for). If there is a better way to do this please let me know.
Thank you.