Question:
How can I have CRMA report that there was no tasks created within a certain period of time so that averages are calculated correctly and account for no data during certain periods but those periods can still be used during the average calculation.
Further Context:
I am working on a request for analytics on the average number of tasks created per day of the week over variable time periods (for example, a leader may want to see if the average number of tasks created on Mondays in March increased from the average number of tasks created on Mondays in Q4 of 2024. What I am having trouble with is generating the correct average when there are no tasks created on a day that should be included in the average. So for example, if on Mondays in January: 5 tasks were created the 1st Monday, 0 tasks the 2nd Monday, 0 tasks the 3rd Monday, and 5 tasks the 4th Monday - My CRMA Lense generates an average of 5 tasks because it does not register there were two Mondays with no tasks. Any thoughts on this? Here is a snapshot of the lense thus far looking at a small segment of data from one user in March 2025.
#CRM Analytics
I would most probably go with two datasets:
- one datasets to count the amount of tasks created, doing all the filter work accordingly.
- another dataset which simply holds every date for a given period of time (like 2020 to 2030) to calculate the number of days (or Mondays) within the relevant period.
- use data blending/co-group to bring both values together and calculate the avg.
Sample for a csv file with all dates to upload into a CRM Analytics dataset attached.
