I am working on survey data that have multiple entries. Survey data have multiple fields including 'Year' and 'Score'. I have calculated the year-wise average for the Score field that have values either 'Yes' or 'No' .
The requirement is to take an average for two years and labelled as '2014_2015_AVG' in the dimension (X-axis). I have provided a snap shot which may help in ease of understanding.
Also, I wanted it to be shown as a separate bar in the middle of the chart.