Forum Discussion

Belvicus's avatar
Belvicus
New Member
4 years ago

Split X-Axis with stacked columns

Hello,

I need to split in two different columns this chart:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

I need to have two columns for each month:

  1. Azure + Blue values column
  2. Pink + Red values column

so, for example I need to display this one,  when I decide to drill over a month this graph:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Actually I have in the axis:

  • X-Axis: Month
  • Y-Axis: Force and Force KO (Azure and Blue) and Training and Training KO (Pink and Red)

 

Please, can you help me?

Thanks in advance!

Need Help

2 Replies

  • v-zhangti's avatar
    v-zhangti
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi, Belvicus 

     

    You can try the following methods.

    Index = IF([Category]="Force"||[Category]="Force KO",1,2)

    Does this meet your desired outcome?

     

    Best Regards,

    Community Support Team _Charlotte

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

    • Belvicus's avatar
      Belvicus
      New Member
      4 years ago

      Hi v-zhangti 

       

      on first thanks for the answer.

      I'm not able to apply your solution, because all the four columns are new calculated columns.

      This is a part of the table

       

       

       

       

       

       

       

      So how can I split the whole?
      Thanks again for the support.


      Regards