4 Replies Latest reply on Nov 15, 2018 1:26 PM by Jim Dehner

    Average Number of Records PER DISTRICT

    . Berrett.Rice

      I'm stuck. I want a single bar that shows the average Number of Records per district. So in the attached workbook, I would want the number that resulted from adding all of the numbers on the bar chart together and dividing by the total number of districts. (The answer that I'm looking for is 22.5 -- I calculated it in excel).

       

      But I can't seem to get a bar that shows me that number! Ideally, I would like just a single bar with that number - and nothing else.. no district list - just a bar with that number (I'm using it as a chart in a tooltip).

       

      How can I make this happen?