Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Help: Calculate a Percentage Conditional

Looking for some guidance related to another post.   I do not want to count items that only reside in waiting room. Example, this works because they both progressed somewhere in the case that they ...
Need Help
amitchandak's avatar
amitchandak
Super User
6 years ago

First Create a column

Seen After Waiting = MINX(filter(Sheet1,Sheet1[Unique Record]=EARLIER(Sheet1[Unique Record]) && EARLIER(Sheet1[Activity Type])="Waiting Room" && Sheet1[Activity Type] ="Seen by Doctor"),Sheet1[Unique Record])
Then a measure
Ratio = DIVIDE(COUNT(Sheet1[Seen After Waiting]),COUNTX(filter(Sheet1,Sheet1[Activity Type]="Seen by Doctor"),Sheet1[Unique Record]) )
 
Please find solution at