Creating a dynamic column/row trellis chart
In this recipe, we will create a parameter that will help us adjust the number of columns—and indirectly rows—for our trellis chart.
Getting ready
To follow this recipe, open B05527_03 – STARTER.twbx. Use the worksheet called Trellis, and connect to the Population (WDI 1966-2016) data source.
How to do it…
The following are the steps to create a dynamic column/row chart:
From Dimensions, drag Year to the Columns shelf.
Right-click on the Year pill in the Columns shelf, and select Continuous.
From Measures, drag Population to the Rows shelf.
Right-click on the SUM(Population) pill in the Rows shelf, and under Quick Table Calculation, select Percent Difference.
Control drag the SUM(Population) pill in your Rows shelf to the Color shelf.
Right-click on the color legend and choose Edit Colors. Check Stepped Color, and enter 4 as the value for Steps.
Right-click on the color legend and choose Edit Title. Change the color legend title to % Difference.
From Dimensions...
