Forum Discussion

powerJR88's avatar
powerJR88
Frequent Visitor
1 year ago
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...
Need Help
Tips and Tricks
  • powerJR88's avatar
    powerJR88
    1 year ago

    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.

powerJR88's avatar
powerJR88
Frequent Visitor
1 year ago

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.