Bottom 5 values using dimension limits

[#1]

Hi Members,

Can we show bottom 5 values using dimension limits ?

I don not want to use aggr function in dimensions and metrics.

Thanks

Khushboo

[lironbaram]

hi

yes you just need to use the dimension limit , and make sure the first expression is the one you want to filter by

then just select to display the smallest 5  values

as displayed in the picture

[#3]

When i try to do that i get no data to display error in my chart.

Is the reason because my lowest values is 1 and I have more than 5 products with volume 1?

[lironbaram]

hi

no this shouldn't be the reason it will randomly select 5 values from the list

[#5]

Hi ,

My dimension is a cyclic group , for other dimension it is coming, but for product it is coming as no data to display.

Is it because few products have 0 value in fact table?

[#6]

Hi Liron,

Checked this is the reason. Presence of 0 values in fact tables .

Hence bottom 5 values are 0.

If i remove suppress 0 values from the presentation tab, we get the results.

[lironbaram]

hi ok

so no problem

go to the presentation tab in the chart properties , and un-check the "suppress zero values"