Trellis charts are a version of a small multiples chart that organizes the dimensions in the view across a grid. In this tip, I show you how to create a trellis chart that will work even when you are missing data.

Download the workbook here - [ Ссылка ]

Trellis / Panel Chart Calculations
//Columns
(index()-1)%(round(sqrt(size())))

//Rows
int( (index()-1)/(round(sqrt(size()))))

Steps
1. Create the column and row calcs
2. Create a custom date
3. Place custom date on columns, measure on rows and dimension on detail
4. Place column on columns, row on rows, and custom date on detail
5. Ensure dimension is above date on detail shelf
6. Change custom date on columns to ATTR
7. Configure table calcs
1. Check both the Dimension and the date field date in order
2. Ensure the dimension is above the date field in the Specific Dimensions section
3. Set "At the level" to the dimension

свернуть