Forum Discussion

briodan's avatar
briodan
Frequent Visitor
8 years ago
Solved

Percent complete by category

I need to calculate the percent complete of tasks assigned to users Here is what my data looks like: User Task Status a 1 start a 2 progress a 3 progress a 4 complete b ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Here is a solution.

 

It gets more complex if you want to apply FILTER() to the formula so that person b will show up and you do not need to show all categories.  If filtering for Complete, person b will not show up.  In the FILTER() case, the Measure is hard coded for Complete.

 

Here is the measure and a snippet below showing my results using your provided data:

 

% of Status =
COUNT ( data[Status] ) / CALCULATE (
COUNT ( data[Status] ),
ALLEXCEPT ( data, data[User] )
)

 

 

 

  • briodan's avatar
    briodan
    Frequent Visitor
    8 years ago

    Thanks that is really close to what I need.

     

    I need to only display the Complete status with its value, its ok if users with 0%or blank% show up in the list.

    So i guess i need the more complex option.