1 of 1 people found this helpful
Essentially, a discrete measure is like a dimension and so grand totals cannot be added. However, it looks like the reason that the discrete measure is being used is for formatting purposes. Instead, place Totals Calls Completed on the text shelf. Then, to add a title to this single column, create a string calculation that looks like the following:
"Total Calls Completed"
Place the above calculation on the Columns shelf next to CaseLabel.
Hope this helps!
I put the Total Calls Completed on the text shelf. I didn't understand the second part, where you say create a string calculation that looks like the Total Calls Completed. Do I need to make a calculated field with just a string like "Total Calls Completed" or do I need to use the formula which I am currently using which is Counting Distinct of a Date field.
What I had was Total Calls Completed = COUNTD(DateField)
Sum of Total Calls Completed = TOTAL(COUTD(DateField))
Hi Tracy, I had attached my original workbook in my first post, can you make the changes as you mentioned and post that workbook again, I tried to implement your solution but it's coming right.