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.
Thanks . but without modifying script cant we do in front end only?
@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). 🙂
Good to know 🙂 thanks its working fine now.
one small issue im facing .. I want to exclude null values in this set expression.. how can I exclude nulls?
=count({<Level={'1'},user={"=count({<Avgscore={[<60]}>}Level)>2"}>} distinct user)
Hi @soniasweety
Exclude nulls based on which field? , please find the common syntax to exclude nulls in set analysis
{<YourFieldName= {"=Len(Trim(YourFieldName)) > 0"}
or
{<YourFieldName= {"*"}>}
Hi ,
Thank you. I tried this working fine.
Field-={""}