2 Replies Latest reply on Feb 10, 2013 2:11 PM by Andrew Watson

    How do I create a graph that can filter to a specific item and still show the average for the aggregate?

    Stephanie Boudeman

      I am trying to create a line graph that shows total $ for an individual building but that also shows a line that represents the average $ for all buildings.  I tried to do this by creating a calculated field that calculates the average.  Unfiltered, this works fine.  However, once I filter to a specific building, the average no longer calculates correctly.