Grouping Lists

Sometimes, you need to group lists together. Let's use the Trello Public Roadmap board and Cumulative Flow chart as examples.

As you can see, there are Live lists created for every quarter. We need to unite them into a single group, because we're interested in total feature progress, rather than tracking separate cards.

This can be done using the CASE WHEN statement. So, we need to select 'List' in the Color panel, and change the calculation to the following:

CASE WHEN CONTAINS([List], 'Live') THEN 'Live' ELSE [List]

We then need to rename the Axis Label to 'List', since it is currently auto-named.