Dashboard top 5 help

[xencema]

Hi!

I'm trying to generate a dashboard that represents the Top 5 best-selling products in terms of quantity per year.

The data is already selected for the top 5 by year, I would just like to make a vizualisation out of it.

I would like to create a grouped barplot with on the Y axis: 5 bars for each year side by side (so 5*4 bars), each bar will represent the Productid and the height of that bar will represent the somme column. The X axis will be for the Year.

The data

Year PRODUCTID Somme

2011	352	1100
2011	508	1100
2011	507	1100
2011	351	1100
2011	530	550
2012	935	3850
2012	936	3850
2012	524	3850
2012	319	3850
2012	326	3750
2013	319	24200
2013	325	20000
2013	326	20000
2013	523	18700
2013	513	18150
2014	319	42900
2014	325	38750
2014	326	38750
2014	936	34100
2014	935	34100

What I've come up with so far, the visualizations make a sum of 'productid' and also a sum of 'somme' but I don't want it to do that

[v-xiaotang]

Hi @xencema 

Thanks for reaching out to us.

>> the visualizations make a sum of 'productid' and also a sum of 'somme' but I don't want it to do that

What's your expected output? Do you mean you want to add the name of product to the chart?

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.