Skip to main content
Announcements
The way to achieve your own success is the willingness to help somebody else. Go for it!
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)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
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?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)