Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
vvvvvvvvvv
Creator
Creator

How to get the average of min record by id

vvvvvvvvvv_0-1597218184464.png

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.

 

Labels (4)
6 Replies
rockabs
Contributor III
Contributor III

Perhaps this

Avg({<[STDT ID]={"=Count([STDT ID])>1"}>} [STDT ID])

vvvvvvvvvv
Creator
Creator
Author

I want to get the average grade??

vvvvvvvvvv
Creator
Creator
Author

what if I also want the year equal to some specific year?

Anil_Babu_Samineni

Perhaps this

Avg({<[STDT ID]={"=Count([STDT ID])>1"}, Year={2019}>} Grade)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
vvvvvvvvvv
Creator
Creator
Author

It only work for there are multiple records with same id, cannot include the single record

Anil_Babu_Samineni

From Given Snapshot, What is the outcome you are looking?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful