I'm using this measure =COUNTROWS(DISTINCT(COLUMN)) to tell me the number of unique items completed per person in a pivot table. I've done some searching, but I can't figure out how, in the table, to get an average of those unique items over time (weeks, months). The table data does include the date the item was completed.
(How) can I average a measure? And, can I do it over time?
TIA
(How) can I average a measure? And, can I do it over time?
TIA