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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.