I currently have 4 charts showing stacked data of categories, with the X axis being time, the category is a pivoted dimension.
The 4 charts have the same filters, with 1 dimension filter being different for each chart.
I figured with Trellis charts I could have this as 1 look rather than 4, which could expand to 5 or 6 as new things are added instead of needing additional work.
I went into the explore of the chart, removed the filter and added it as a pivot and changed the visualisation to a Grid Layout By Pivot. The visualisation now says “Max grid size is 12. Reduce Pivots with column limit or change Grid By to “none”.”
I’m guessing I need to add some subtotals or something to the data to get this to work? Or check some other option somewhere?