Expression to calculate Rows Median in straight chart

[nayanpatel]

Hi Friends,

I wanted to calculate Median of Rows in Straight chart. below given is the expression I am using. However, this expression giving me expression total. Also there is no selection available in Straight chart to calculate "Median of Rows". Please help how to calculate Median.

Exp=Median(Aggr(Only({<FlagDate = {1}>} [E2EDays]),id))

Thank you.

Nayan

[gerry_hdm]

Hello

you can  the Median setting in the diagram

[Anonymous]

try something like

Median({<FlagDate = {1}>}Aggr(Only({<FlagDate = {1}>} [E2EDays]),id))

[nayanpatel]

Hi Shiva, Thanks for reply.

Both expressions results same output

[Anonymous]

if possible can you share a sample .qvw?