Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i want to show the percentage of pass and fail .
for example : L1 users 10 members in that 4 pass and 6 fail.. so i want that pass percentage and fail %
Hi @soniasweety
Try like below
Dim: Level
Pass: Count({<Status={'Pass'}>}DISTINCT user) / Count(DISTINCT user)
Fail: Count({<Status={'Fail'}>}DISTINCT user) / Count(DISTINCT user)
Hi
Use an expression like this:
Num(Count({<Status={'Fail'}>}Status)/count(Status), '0%') //Fail precentage
or this
Num(Count({<Status={'Pass'}>}Status)/count(Status), '0%') //Pass precentage
Thanks Mayil. but distinct gave me wrong result.
Thanks @Vegar it worked.