Learn how to customize and format a list report.
This article is part of a series and we recommend reading through the articles in the following order:
- Introduction to List Reports
- Creating a Simple List Report
- Creating a Detailed List Report
- Using Dimensions in List Reports
- Formatting a List Report (this article)
Once the list report is saved to a Storyboard, you can make changes through the Tile Settings.
- Start by clicking the pencil icon in the top right corner of the Storyboard to go into modify mode.
- Resizing - Resize a tile by clicking in the bottom right corner and dragging your cursor until the tile displays all columns in the list report or is the height and width you want.
- Positioning - Move or relocate the tile on the Storyboard by holding your cursor down in the tile and dragging to the area of the Storyboard you want it to display. Note that moving a tile could result in other tiles being moved around as well.
- Pagination - The number of rows displayed in a tile defaults to 6, but by updating the Initial Items Per Page, you can choose the default number of rows displayed in the tile on each page.
Note: Increasing the number of items per page (or turning off Pagination altogether) will have impacts to the performance of the list report and storyboard. We highly recommend using the pagination feature.
Storyboard Formatting Options:
The following formatting options will only be displayed in the Storyboard version of the list report. If you export the list report, or view the list in Explore, it will retain its original format.
- Rename Header - The titles of the columns in the list report can be updated in this section. This is only changing the specific list report column title. If you want a permanent change across all your queries, you should use the Table and Column Label Editor.
- Show / Hide Columns - Certain columns in the tile can be hidden by flipping them from ‘On’ to ‘Off’.
Show / Hide Columns is particularly handy if the Time Period and Metric result (for example) are necessary to make the query work but don’t add value to the list report visualization and/or could be explained in the tile title instead.
- Conditional Formatting - By clicking Add a New Rule, you will have the ability to create custom formatting for values in the list report, including changing text or background color, and/or alignment. You are able to use multiple rules in one table. Conditional formatting is not available in the CSV export.
- Deep Linking - Your list report can include hyperlinks to trusted applications or websites outside of One Model, e.g. linking by employee name or ID back to your HRIS / Talent applications that hold a full employee profile or job specification; linking requisition title ID back to your job ad on LinkedIn. Deep link columns are configured within the One Model Table & Column Label Editor screen, not the Storyboard tile settings. More information on Deep Linking can be found here