Most have heard the idioms "never judge a book by it’s cover" and "there’s more than meets the eye". Keeping these statements in mind, I’d like to introduce you to the List Table in SAS Visual Analytics.
The List Table can be more than just a black and white ledger style visual. Here is one example where I’ve highlighted some of the enhancements you can apply to the List Table.
You can also control the styling of the List Table by changing the header and total cell background colors as well as an alternating row color.
Some of these features have already been covered and are linked to in the above list. I’ll cover the remaining features in the following sections.
The List Table is one of the objects that can have all three types of Display Rules applied, depending on the List Table’s Role assignments. One of the advantages of using a display rule is to be able to quickly apply business rules to flag certain rows.
The types of display rules include:
You are even able to apply a rule to a data item not assigned a role in the List Table! In this example, I am applying a Display Rule for the Expenses measure and that data item is not assigned a role in the List Table. Not show here, but you can even compare columns to calculated data items in the same data source.
Use the Options pane to individually select which measure data items you would like to use an Abbreviated numerical value.
Or you can right click on the target column and use the menu to select Abbreviated numerical value.
A sparkline is intended to display a trend line for high density data in a small space. The idea with any line visualization is to represent the trend of data over a time period. That said, your data source must contain a date or datetime data item and a measure.
To add a sparkline to the List Table you will need to make use of the right click menu. To demonstrate that you can add a sparkline representing the trend of any data item in your data source, this current List Table only has one column Facility Region assigned.
The list of available Time Axis and Measure data items are driven by the report’s data source.
In this example, I’ve selected 2011 as my year and used Date by Month as the sparkline’s Time Axis. I selected Profit as the measure to trend. See the different styles available for the sparkline below.
Use the Options pane to easily customize which Totals you would like to add to the List Table. You can see the other formatting options available: showing labels, background cell color, font style and size, and placement. You can choose to have the totals of the List Table placed after the rows of data or before.
Use the right-click menu to select the column you wish to freeze on and select Freeze all columns to the left.
The recording below shows that any user can use the freeze column feature even when in View mode.
Here is a list of the List Table enhancements covered either in this article or previous articles:
If you want to style your List Table for all users to have the same color scheme and other style enhancements, consider using either a Report Theme or Object Templates for consistency across report developers.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
Data Literacy is for all, even absolute beginners. Jump on board with this free e-learning and boost your career prospects.