How can i remove the highest value in the chart?
Hi Marius, for just that bar you can try with:
If you want remove the dimension maybe using a calculated dimension:
Aggr(If(Rank(YourActualExpression)>1, DimensionField), DimensionField)
One more option you have in Dimension limit, where you can limit the amount as shown below;
I hope it will help you
will give u o/p hopw it will help to complete the task.
Its quite simple just use the below syntax removing any value greater than the specific number as shown below based on your requirement
Here you can option to maintain certain limit
Path --> Chart Properties--> Dimension Limits
Simple way, U can work on Properties of Object u can choose Dimension Limits tab then u will have option to restrict the highest value.
Retrieving data ...