Need percenatge

[soniasweety]

Hi @MayilVahanan 

@Vegar 

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 %

[MayilVahanan]

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)

[Vegar]

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

[Vegar · Accepted solution]

Added an adjusted QVW below.

[soniasweety]

Thanks Mayil. but distinct gave me wrong result.

[soniasweety]

Thanks @Vegar  it worked.