Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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.

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous ,

Try a measure

divide(sum(Table[Time]), distinctcount(Table[Task]))

 

or

 

Averagex(summarize(Table, Table[Month] , Table[Category],"_1",divide(sum(Table[Time]), distinctcount(Table[Task]))),[_1])

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Unfortunately neither of those works.

The first one sums up all the averages across the table and then divide it by distinct count per month and the other results in some strange results I even can't interpret.

 

Thanks

E