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.