Creating visualizations that compare similar metrics across a categorical variable can be tricky. The report designer needs to show how the values of the two metrics compare, while also allowing the report consumer view those comparisons within an overall group. Using the builder I was able to create the following visualization which compares City and Highway MPG by car manufacturer:
Get the details on the graph's source data and how to re-create this chart in this SAS Communities Library article.
This directory contains the needed resources to recreate this custom graph including:
- The code to create the report-ready data - Compare_Similar_Metrics.sas
- A JSON file containing the custom graph and Report- Compare_Similar_Metrics.json