0 Replies Latest reply: Sep 18, 2017 8:54 AM by Karim Sattar RSS

    Creating Bar for Average of Two Fields

    Karim Sattar

      Hi

      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.


      Thank you