Missing data values in bar chart

[#1]

Hi All,

I'm facing a problem showing only top 5 values on a bar chart with 2 dimensions displayed. In the print screen you will see that I get the same dimension values even if under one is not a part of the top..

The dimension includes the following:

1- Is Recommended

2- Aspect Name

3- =1 a dummy dimension to support the 2 dimensions above to be one on top of the other and not side by side

Thanks for your help!

Hila.

[#2]

Hi,

In the Bar chart properties---> style---> Stacked plz check that you will get as per your requirement

[#3]

Hi Rakesh!

Thanks for your reply!

Since my chart is is oriented on the side the stacked option is grey and I can't select it.

Hila.

[jpenuliar]

Hi,

Have you tried, a Calculated Dimension for your Aspect Name something like

=Aggr(if(rank(count(COUNTER))<=5,[Aspect Name],[Aspect Name])

[#5]

Hi Jonathan!

It's progressing.. Now I don''t get the missing values but I don't get the correct top values..

Thanks for you help!

Hila.