Acummulate range of values in a graphic

[#1]

Hello fellows,

I would like to limit the maximum value of a certain dimension in a bar graphic, but I would also like to have the possibility of accumulating the values beyond that limit on the last one.

To be more precise, as an example:

If I have the values 1 2 3 4 5 6 7 8 9 10, and limit the dimension to show only until 5, I would like the graphic to represent

1 2 3 4 (5 or more)

Is there any way to specify this in the options?

Regards,

Ygor

[#2 · Accepted solution]

Hi,

in the chart, you can create a calculated dimension.

For your example the dimension become : if( yourDIM <= 5 , yourDIM , 'Other' )

JJJ