Forum Discussion
Measure - Average time per category per task
Hello all, I'd like to build stacked chart with Average resolution time for category per month per Task distinct count. Here is my data in Table ForAnalysis: ForAnalysis Task Month Cate...
Anonymous
I think the easiest way would be to, simply, add a quick measure "Weighted Average per Category" . I tested with your sample data, and confirmed that it genrates the expected results. Hope it helps.
OR
Then, select "Weighted Average per category" from the dropdown, and fill out the rest as follows:
Here are the results I got:
p.s. By default, the results are given in whole numbers. If you want to include decimals, make sure to update the visual to include decimals.
I hope this resolves the issue you're facing.
Thanks.
Break this up into indivual measures, makes it much eaiser...
SUM_Time = SUM('Table'[Time])
DIST_Count_Tasks = DISTINCTCOUNT('Table'[Task])
Measure = [SUM_Time] / [DIST_Count_Tasks]