continues in set analysis

[soniasweety]

Hi All,

@tresesco @MayilVahanan  @Taoufiq_Zarra 

i wan to count the user id where   L1  exams continues 3times failed only ..

 here is my expression 

count({<level={1}},avgscore ={"<60"}>}User_id)      here failed criteria is  ( <60% is failed )    I have field  Avg_score.

I wan to include  3times continues failed Leval1 failed candidates only.

[Taoufiq_Zarra]

@soniasweety  can you share a sample data ? and the expected also from this sample ?

[soniasweety]

@Taoufiq_Zarra  attached sample.  Need result in setanalysis.

[Taoufiq_Zarra · Accepted solution]

@soniasweety  May be this :

=count({<Level={'1'},user={"=count({<Avgscore={'<60'}>}Level)>2"}>} distinct user)

output:

[MayilVahanan]

Hi @soniasweety 

Try like below. Might be, you can include additional condition in if statement.

LOAD user,
Level,
Status,
Avgscore,
If(Status = 'Fail' and Status = Peek('Status') and user = Peek(user), 1+Peek('Cont'), 1) as Cont
FROM
[score.xlsx]
(ooxml, embedded labels, table is Sheet1);

Exp: count({<level={1},avgscore ={"<60"}, Cont={">=3"}>}user)

[soniasweety]

@Taoufiq_Zarra  same expression I tried its  showing  0 as result .. can you attach your sample.

[Taoufiq_Zarra]

@soniasweety  attached

[soniasweety]

@Taoufiq_Zarra 

Still strange   …    its showing zero to me im my qvw  😞    attached my sample .  am I missing something

[Taoufiq_Zarra]

@soniasweety  for me its 4 (your sample )

[soniasweety]

Im not sure.. any other alternate solution  ?   for me its showing zero 😞