Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Matrix Chart - Align subscription counts from different years

Hi All - What is the best way to align the subsrciption counts from different years on the same line?  See 1st picture.   Of course, I will eventually want to place the data in a graphic, and the s...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

It would be helpful to see a sample of your data, especially with how it's structured. Do you have different measures for your 2017, 2018, 2019 totals? What do your date fields look like?

 

Thanks,

Ben

Anonymous's avatar
Anonymous
Not applicable
7 years ago

we can do that

 

    • tarunsingla's avatar
      tarunsingla
      Icon for Solution Sage rankSolution Sage
      7 years ago

      Since you already have subscription year in the columns, you do not need it in the rows.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hi tarunsingla - 

         

        Thanks for the comments. 

         

        Unfortunately, the ITD numbers are too high for 2017 and 2018.  If you see the pics in the original post you will see that ITD numbers need to equal the inital month's numbers and increase from there.

         

        The Year in the rows is not Subsription Year but rather the Calendar Date (Year) in which the subscription was logged into the system. 

         

        Mark