Limit Dimension

[karin_nevo]

Hi,

I have a scatter chart with 3 expressions.

I want to limit the chart to show only the top 100 values of the first expression.

I am using DImension Limits tab the restrict only largest 100 values, but it is showing the largest 100 based on the third expression and not the first.

If I only use 2 expressions it works.

Any help is appriciated.

Thanks,

Karin

[Arthur_Fong · Accepted solution]

Remove the dimension limits and try this in calculated dimension:

=if(aggr(rank(aggr(<Exp 1>,[Dimension in Chart])),[Dimension in Chart])<100,[Dimension in Chart],null())

Under settings on selected dimension,

Check(Tick) suppress when value is null.

[Brett_Bleess]

Karin, did Arthur's suggestion work for you?  If so, please be sure to come back to the thread and use the Accept as Solution button on his post to give him credit and let others know his solution did work.  If you are still working on things, leave an update.

Regards,
Brett

[karin_nevo]

Thanks Arthur, it works!