This is my second article in a series of three that walks through different ways to customize your SAS Visual Analytics report. Check out the first entry on creating a custom graph.
As I mentioned in my last post, creating reports in SAS Visual Analytics is a very iterative process. You start by building a graph and you may soon realize you need additional data. This post will walk you through how easy it is to augment your data with a custom category.
We pick up this article where we left off in part 1: a custom scatter/vector plot graph element that shows the age of each president at first inauguration. We have dragged this custom graph into the center workspace, added measures, categories and a label which produced the report below. We are now ready to continue building out our report.
To give this graph more visual information, we could add the party affiliation of each president. What are our options?
Base the custom category on the category “President.” Click Next.
Drag the new custom category to the “Color” role for the report.
Each party is now represented by color, as noted by the legend at the bottom. However it is quite possible that you will want to change the colors of each party, as well as change the order in how they are displayed in the legend. We will do those steps next.
So now we have a chart that not only shows the length of the presidential term over the course of years, but the color of each line represents the party affiliation of each president. The political party was not in the original data source, so we created it not by adding new data and joining it to the original data source, but by creating and applying a new custom category. We also created a custom sort order and specified the color of each political party.
Quickly adding some additional options like custom sort and custom categories allows you to fine-tune your reports and dashboards to make an even bigger impact.