Forum Discussion
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 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
9 Replies
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
Super User
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
