How to calculate the average grade of student when records for STDT_ID 4 are duplicated in qliksense measure?
I know it can calculate by average the min record by ID. But don't know how to implement in QS measuer.
Perhaps this
Avg({<[STDT ID]={"=Count([STDT ID])>1"}>} [STDT ID])
I want to get the average grade??
what if I also want the year equal to some specific year?
Perhaps this
Avg({<[STDT ID]={"=Count([STDT ID])>1"}, Year={2019}>} Grade)
It only work for there are multiple records with same id, cannot include the single record
From Given Snapshot, What is the outcome you are looking?