Hi,
How can I calculate median value of a keyfigure in bex? It should not be calculated as Result but as Single Value.
Example - I have Ticket Number, Ticket Resolution Date as Chars and Resolution Time in terms of days as KF.
I want to calculate median of Resolution Time for each month.
How can this be achieved in bex or otherwise?
Thanks,
Anurag.