Theme Table Overview
The Theme Table is the hub of Cascade which contains all the people and their CliftonStrengths themes. Use it to store the details for everyone, then use the Team Grid to select teams or groups of people for the other reports.
Start with the Import Themes button to pull in the names and themes from a prepared file. This can be from one of the Gallup portals or a previous version of Cascade.
See Entering Themes for more information.
The three sections of the Theme Table have different colour backgrounds for clarity.
Selection Criteria – Blue
The four columns on the left (A – D) are to categorise the clients or staff. You can rename the headings at the top and use these columns however you wish.
Depending on your client base or staff structure, you may want to use the columns for the Organisation, Location, Department, Team, Management Level, Cohort, Workshop, Family or any other factor. In an organisation, you could have one column reserved for Status where you identify people who have left or are away on Maternity leave.
Names & Theme Count – Pink
There are automatic calculations for the Full Name and the Count of themes.
Names in red indicate there is a duplicate, such as Jack Potts in the image above.
Normally there are 5 or 34 themes, so if there are one or two missing, the count of themes goes red. See the example with Olive Branch.
When ‘Duplicate’ appears in the Count column it shows that the same theme is mentioned twice for one person. It doesn’t say which theme is repeated, you will need to scan along the row.
Names and Themes – Green
Here you enter the names for the people and their themes.
The Email and Date columns are optional. Some of the Gallup export files include these columns, which is why they are present.
It is best to import the themes from a file or use the drop-down lists. The reports in Cascade look for an exact match of the theme name in order to display the theme information. A blank space at the end of a word or the hyphen missing in Self-Assurance will affect the reports.
After entering themes to the Theme Table, click on the Reset Formatting button. It tidies up all the formatting of the page for consistency and replaces any formulae which may have got overwritten.
Deleting a Row
To remove someone from the Theme Table, the best way is to highlight their name and themes, then hit the Delete button. It is not possible to delete an entire row, you just need to delete the contents of the row.
To remove the blank row, use the AZ sort buttons.
Sorting and Blank Rows
When entering people into the Theme Table, it is best not to leave any blank rows. Cascade counts the number of people in the Theme Table which sets the size for the Team Grid. When it finds a blank row, it assumes that is the end of the list so some people may not be visible in the Team Grid.
Use the AZ sort buttons to sort the people into a helpful order and push the blank rows to the bottom.
Use the Menu or Team Grid buttons to navigate to those pages. This is better than using the tabs at the bottom as they will pop up reminders if the Refresh Page needs to be run on the Team Grid.
Dominant Theme Count
It is possible to note the number of themes a person considers to be their dominant range. These are the themes which are always present for the person. Normally this is around 10 where it can be a few more or less. When the reports use the number of dominant themes, if there is no number available, they will use 10.
When printing name labels or lanyards in Cascade, it is possible to include a team name on the label. This is helpful in workshops where you want to divide the participants into teams. Alternatively, in an organisation, you may want to show the person’s department.
In the Selection Criteria above, use column D for the team, department or any other aspect. On the Labels page under the Label Format, select Yes for Add Team Name. This will include the name of the team in the footer of the label. The Team page also shows column D on the Team Grid so you can see who is on each team.
This feature is only available with the Bonus Pack.