vvvvvvvvvv
Creator
2020-08-12
03:45 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How to get the average of min record by id
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.
1,363 Views
6 Replies
rockabs
Contributor III
2020-08-12
04:21 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Perhaps this
Avg({<[STDT ID]={"=Count([STDT ID])>1"}>} [STDT ID])
1,358 Views
vvvvvvvvvv
Creator
2020-08-12
04:41 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I want to get the average grade??
1,340 Views
vvvvvvvvvv
Creator
2020-08-12
04:42 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
what if I also want the year equal to some specific year?
1,339 Views
2020-08-12
04:53 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
2020-08-12
09:51 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
It only work for there are multiple records with same id, cannot include the single record
1,292 Views
2020-08-13
02:18 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
1,277 Views