Plant wise Top 3 Products or can we show threshold to show N number of products

[rupaliqlik]

Hi Folks,

Below I am showing Plant wise Top 3 products .My user asked me to make this chart attractive.

Can I user other chart or to show different visualization for below requirement.Also is there any wany to give them choosing option like top 5 ,top 10

I am very poor in visualization.

Stack Dimension:  Plant

Bars : Material Name

Measure:  Sum([FF&P_QTY])

Best Regards,

Rupali

@sunny_talwar @jagan  @abhijitnalekar @ kaushik.solanki ,@sunny t, 

[abhijitnalekar]

Hi @rupaliqlik,

We can give able to give them the option to choose the top n. 

Can you please share the sample data?

[rupaliqlik]

Hi Abhijeet,

Please find attached dump.

Best Regards,

Rupali Ethape

[abhijitnalekar]

Hi @rupaliqlik ,

Please find attached QVF.

Personally, I feel Stack bar would be the best solution in your scenario. 

The attached QVF has a way to change the TOP N value in the chart. 

Hope this helps you.

[rupaliqlik]

It is not allowing to import.

Can you share image here of your visualization

[abhijitnalekar]

[rupaliqlik]

how did you added that mechanism to enter number and according to that user can see Top product and also how you adde that title,where to change for that title?In my case title is coming in big font

[abhijitnalekar]

=if(aggr(rank(Sum([FF&P QTY])), [MATERIAL NAME]) <= $(vTop), [MATERIAL NAME])

use above dimension expression  in the chart