Expression as dimesion

[#1]

Hi

i want to sort a table using different expression which is based on some other column.

Now i want to limit the Dimension. But it is not possible in Line Chart.

So i tried to put if(rank(expression)<11, Dimension)

But the problem is expression is always calculated over dimension. So the above thing returning Null value when used as Dimension. If i used the same in Expression as if(rank(expression)<11, Dimension) over the Dimension it is returning the correct top values.

Anything can be done to get the Top dimension using Expression without placing it over a dimension?

I explained my problem as simple as i can.

Any ideas ???

[vgutkovsky]

You need to use the expression within an aggr()--the dimension of the aggr would be the dimensions you want to recreate.

Regards,

[#3]

Hi,

It is possible to limit the Dimension in Line Chart.

In Line Chart-Properties-Presentation-Dimension Limitations(Right Top)-Max Visible Number.

Select this number as 10 or whatever you want (<100).

Sort your data based on Expression in Sort options.

Hope it resolves your problem.

Happy Thoughts

[#4]

nope...aggr() is not working there for me...thats why i raised this question.

[vgutkovsky]

Try this: aggr(if(rank(total expression)<11, Dimension),Dimension). If that doesn't work, please post an example app.

[#6]

But i want Others label which is not possible in Line chart.

[vgutkovsky · Accepted solution]

aggr(if(rank(total expression)<11, Dimension,'Other'),Dimension)

[#8]

Thanks its working great. But placing 'Others' in else part of if, is not working..I want to sum all other dimensions under the label of 'Others'. Any Idea...

[vgutkovsky]

It should work. Please post an example of your application.

[#10]

Hi,

Its working fine now..I added the 'Other' inside the aggr, and also aggr the sorting expression.

Thanks a lot