I'm trying to do a summary-level formula to work out an the average individual call rate per day, but the grand total row defaults to a sum
not an average, and I'm encountering validation errors whenever I try to do something.
Screenshot 1 shows the basic call rate formula - number of rows/entries divided by the number of unique dates - fine. But in screenshot 3 you can see this
sumsin the grand total, whereas I want the average across the 7 users.
Screenshot 2 I've tried to divide this by the number of Call Owners Unique - which gives the same numbers on an individual row level (dividing by 1), but dividing by 7 is giving the incorrect answer of 4.13 (the average of those numbers should be 8.47). I suspect the issue is to do with the "UNIQUE" criteria attached to the Call Date field - but if I remove this I get a validation error.
ChatGPT suggests that creating a "Call Count" field within the Call object (where every entry just equals 1) will fix this issue as I can use for summing up the rows, but I don't understand how a SUM of this custom call count field would behave differently to "RowCount".
Any advice greatly appreciated!
Hey @Alexander Chantrell, did you ever figure this out? I'm trying to build something similar and hitting a wall. My hangup is trying to get the dynamic group count. Here is my question: Average Event Hours per Calendar | Salesforce Trailblazer Community
Let me know if this helps and if you have any tips!
