Matrix Chart - Align subscription counts from different years

[Anonymous]

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 same basic question applies ...  what is the best way to align the yearly graphs to the left? See 2nd Picture.

Thanks for the help,

Mark

[Anonymous]

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 same basic question applies ...  what is the best way to align the yearly graphs to the left? See 2nd Picture.

Thanks for the help,

Mark

[TomMartens]

Hey,

the simplest and only solution it this, just jemove the year column from the row headers.

As you use the column year 2 times

• as row header and
• column header

this will always be way the data is visualized inside the matrix visual, as the headers (row and column) are contributing to the filter context. As the data points do not exist for the the years 2017/2018 in parallel the data will be shown as a diagonal if the same columns are used on row and column headers.

Regards,

Tom 

[Anonymous]

Hi All -  any suggestions on this question?  

I will be gald to add clarification if required.

Thanks,

Mark

[Anonymous]

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]

we can do that

[Anonymous]

Hi All, @Anonymous 

Here is a link to sample data: https://mega.nz/#!bzYhQACR!htR2NHK_xiK-XvnNkAjJ9zFw0HVbN1jq79jRYyK6mso

[tarunsingla]

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

[Anonymous]

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 

[Anonymous]

Hi All - any other suggestions out there?

Thanks, Mark