Forum Discussion
Solved
Add country as a stack in clustered column chart
Hi, I have two clustered column charts with metrics from FY21, FY22 and Projected Year. I need to add a country column to the chart where it shows which portion of a particular month is US and t...
With the help of a colleague, I realized I just needed to create a couple of appends with FY21, FY22 and Projected Results. I merged the Total Hours (FY21 and FY22) and Hours (Projected Results) into one column, Total Cost (FY21/FY22) and Cost (Projected Results) into another column, and the Ranks into another column. I created a new column called Fiscal Year which differentiated between the year. Then I was able to combine the visuals together.
I'm good for now.
