- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Median of filtered values
How do I get the median of filtered values.
Year | Phase | study_id | name | category |
2017 | Phase 1 | abc | A | 1 |
2017 | Phase 1 | ab | A | 1 |
2017 | Phase O | bc | B | 1 |
2017 | Phase O | abcd | C | 1 |
2018 | Phase 1 | bcd | A | 1 |
2018 | Phase O | be | A | 2 |
2018 | Phase 1 | ef | B | 1 |
2018 | Phase O | en | C | 1 |
2018 | Phase 1 | zf | B | 1 |
I want to calculate median of count of study_id by Year, Phase on name. Also take into account for the filter being used in the report of Category = 1
Result should be
Year | Phase | Median of count of study_id |
2017 | Phase 1 | 1 |
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I was able to solve it myself.
medianx(values(count(name))), study_id))
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @bharukc ,
I can't understand your scenario exactly, could you share me more details?
1. Like what @BeaBF mentioned, what's the meaning of "count of study_id by Year, Phase on name"? also by name?
2. Based on my understanding, the count for 2017 Phase is 2. Then how does the result "1" get?
Year | Phase | Median of count of study_id |
2017 | Phase 1 | 1 |
Could you explain the calculation logic?
Best Regards,
Icey
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I was able to solve it myself.
medianx(values(count(name))), study_id))
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @bharukc ,
Glad to hear that. Please accept your reply as solution. Your contribution is highly appreciated.
Best Regards,
Icey
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi:
There's a few ways to do this. Here I added a calculated column to the table (I named it Study). This gets the Category 1 piece.
I hope this is what you are looking for..

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
08-19-2024 08:35 PM | |||
04-19-2024 05:55 AM | |||
05-08-2024 02:08 AM | |||
10-14-2024 06:30 AM | |||
07-30-2024 12:36 PM |
User | Count |
---|---|
14 | |
14 | |
11 | |
11 | |
8 |