Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I need to get median between two columns and end result should be combined median of two columns A & B as shown below:
A | B |
34 | 567 |
55 | 67 |
45 | 68 |
75 | 43 |
7 | 76 |
End result should be 61.0. Please help.
I am facing almost the same scenario but the difference is I need to create those columns (as measures) and then do the median?
Add Aggr() with your dimensions within Concat
Concat(Aggr(YourExpression, YourChartDimensions), ',')
Can you explain how are you arriving at 61 based on the data provided above? Median of A = 45 and Median of B = 68... right? How do you get to 61 from here?
Hi Sunny,
Sorry for late response,
I need a calculation so that it can calculate both the columns as combined one like below
A | 34 |
A | 55 |
A | 45 |
A | 75 |
A | 7 |
B | 567 |
B | 67 |
B | 68 |
B | 43 |
B | 76 |
Median | 61 |
And you need this output in a KPI object?
Correct.
Try this in a KPI object
=RangeFractile(0.5, $(=Concat(A, ',') & ',' & Concat(B, ',')))
Thanks 🙂
Scenario here is ; I have calculated columns based on multiple conditions and if i store them as variable then what should be the calc.
Regards,
Arvind
Not sure I follow.
Hi Sunny,
See above columns (basically measures) are based on certain calculation ( includes functions; getfieldselection,getselectedcount&median). And if I am using your calculation to 'concat' then need to entertain that measure in place of columns A & B which shows me an error. So i created a variables for both measures, need to know if we can concat variables as per your calculation.
Regards,
Arvind
Add Aggr() with your dimensions within Concat
Concat(Aggr(YourExpression, YourChartDimensions), ',')