Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
I need to find the median of the Grade Column, which in this case will be 6+. I also have to apply certain filters, prior to calculate the median. So I am using the expression:
Median
({<[concat] = {"=rank(Count([concat]))=1"},
[Template]= {"=rank(Count(Template))=1"},
[Date] ={">=$(=(date(AddMonths(Updated_Date,-12),'MM-DD-YYYY')))"}
>} Grade) .
The problem with the above expression is that it doesn't work for non-integers. Is there a way wherein instead of taking Median of Grade, I will take Median of ID associated with the grade and than put the result in variable.
Than I can get the corresponding Grade using that variable.
The 2nd approach I think is to generate the RowNo dynamically in the set analysis and then use it to get the median Grade. But I am not sure how to generate the RowNo dynamically in setanalysis.
Need urgent help on this.
Date | Template | Concat | Grade |
2011-11-30 00:00:00 | General Industries | Net Sales | 6 |
2012-01-31 00:00:00 | General Industries | Net Sales | 7 |
2015-03-31 00:00:00 | General Industries | Net Sales | 6+ |
2014-03-31 00:00:00 | General Industries | Net Sales | 6+ |
2015-03-31 00:00:00 | General Industries | Net Sales | 6+ |
2015-03-31 00:00:00 | General Industries | Net Sales | 6+ |
2014-08-31 00:00:00 | Middle Market | EBITDA | 5 |
Thanks a lot.