This is how my Bar chart looks I have values for each year for the size but I still need to display the cut-off value on this bar chart in a line or something for each year can this be done in VA?
Hey @GeorgevdW! You might want to look into a Targeted Bar Chart. You can add a target for each value that you need. To do this, you'll have to build the target into the dataset. You also won't be able to use a Group, but as an alternative, you can use lattice columns.
Product | Year | Size | Target |
A | 2017 | 10 | 12 |
A | 2018 | 20 | 15 |
A | 2019 | 30 | 34 |
B | 2017 | 40 | 45 |
B | 2018 | 50 | 48 |
B | 2019 | 60 | 55 |
C | 2017 | 70 | 80 |
C | 2018 | 80 | 75 |
C | 2019 | 90 | 89 |
If you have multiple values that you're aggregating, simply repeat the target value for each row in the data and then set its aggregation to Average. Since Visual Analytics aggregates automatically, this will ensure that the target value is not summed and remains the value you expect.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.