I have data with all measures like below, how can I create a simple bar chart with column1, column2, column3 is X-axis and the sum of the values in Y-axis
Another chart needed is stacked bar chart (X-axis of Sold and Remaining Capacity reflecting Total Capacity.
|Resource Pool Manager||Total Capacity current calendar month||Sold current calendar month||Remaining current calendar month||Total Capacity current calendar month +1||Sold current calendar month + 1||Remaining Capacity current calendar month + 1|
Thank you @Anonymous. I will not be able to share the actual data, but it basically Products solds every month. The expected report is a bar chart showing Months in X-axis and sum of values in Y-axis. Products are not required to be shown in the chart.
@SillyJam123 I understand. My solution depends on how the data is stored. Could you provide an example of it then?
If the data is stored like this, with these columns: [Date], [Product], [Value], you can just plot it into a bar chart, where you have date on the x-axis, value on y-axis and product in the legend.
If your data is stored differently, please let me know. The goal would then be to make sure it's stored this way. Or go in a different direction.
That's correct. Data is stored the way I have mentioned. But when I use Column chart, I dont get separate bars. May I have your email address I can send you the chart I am getting v/s what is expected
Hi @Anonymous, please see the updated table. Hope this helps.
May June July Product A Sold 1 1 7 Product B Sold 2 2 8 Product C Sold 3 3 9 Product D Sold 4 4 4 Product E Sold 5 0 5
You may unpivot the data at first.
Then get a table as below
After that it would be easy to create a visual as below.
@SillyJam123 and I have corresponded by e-mail. though a good solution, this is not exactly the end goal. I'm not sure if I'm allowed to share a pitcure of the end goal. But basically it is to have one bar for sold current month and one for sold current month +1. Then also have a stacked bar chart, with one color for sold and different color for remaining. It isn't clear from the post itself, and you would probably need the data to realize this as well. I'm writing with @SillyJam123 by e-mail at the moment to figure out what the we have to do to accommodate the end goal.