Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
@soniasweety May be this :
=count({<Level={'1'},user={"=count({<Avgscore={'<60'}>}Level)>2"}>} distinct user)
output:
@soniasweety , @Taoufiq_Zarra Try:
=count({<Level={'1'},user={"=count({<Avgscore={[<60]}>}Level)>2"}>} distinct user)
Note: quotation has got modified meaning in latest versions of qv. And with this expression both of you would see the same result, unlike in the other case (expression with single quotes). 🙂
@soniasweety can you share a sample data ? and the expected also from this sample ?
@Taoufiq_Zarra attached sample. Need result in setanalysis.
@soniasweety May be this :
=count({<Level={'1'},user={"=count({<Avgscore={'<60'}>}Level)>2"}>} distinct user)
output:
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)
@Taoufiq_Zarra same expression I tried its showing 0 as result .. can you attach your sample.
@soniasweety attached
Still strange … its showing zero to me im my qvw 😞 attached my sample . am I missing something
@soniasweety for me its 4 (your sample )
Im not sure.. any other alternate solution ? for me its showing zero 😞