Unexpected behaviour of 'Median' function --Need help

[#1]

Presently one of my bar chart is showing the Avg of a field named  OFFER_TAT_DIFF and I am using 'Avg' function for this.

The set expression I use is Avg(OFFER_TAT_DIFF)

The chart works perfectly and am displaying it here

Now our customer wants to display the Median value instead of Avg

So, when I changed the set expression to Median(OFFER_TAT_DIFF) the resultant chart is strange and I have no idea why it is behaving strangely. The same chart as above when applied with Median function changes to what has been displayed here

Can someone please help me to sort out this issue ???

[vijay_iitkgp · Accepted solution]

Hi,

As Median is the value of mid number. Can you please check your mid number is not 0.

Regards

Vijay

[#3]

Yes I have a condition like and now it seems fine.

OFFER_TAT_DIFF={'>=0'}

I am validating if the function is working properly.

Thanks for the guidance..I guess so much of 0 values were there ...