How to show '50+' on the continuous dimension axis in a bar chart?

[gaddeonline]

Hi Experts,

I have a bar chart with a continuous dimension axis. Please refer the attachment for your convenience.

The no of episodes shown at days 50 are not only the value at 50. it is also the sum of all the episodes beyond the 50(includes 50).

So I want to show '50+' instead of 50 on x-axis. I am having difficulties in using dimension limits as this graph have continuous axis.

All I want in the graph is, instead of '50' in the x-axis(Days), I want to display '50+'.

Can any one help with this?

Thanks and Regards

Mahesh Gadde

[Gysbert_Wassenaar]

You can't. '50+' is a text value, not a number. So it can't be part of a continuous axis. What you can do is add a text in chart object with the text '+' and position that object next to the 50 label of the x-axis.

[Anonymous]

Hi

Try this in expresso..

if(Days>=50,(aggr(sum(Sales),Days)),0)