1 2 Previous Next 15 Replies Latest reply on Sep 21, 2016 1:15 PM by David Li

    Creating a global average

    Stephen Ball

      I am trying to create a calculated field that will return an average at a data source level that is not impacted by filters. Please see following pics:

       

      In the below image, the window average is 51.47. I would like this to remain even if I modify the view by filtering out other districts. Therefore it could serve as a benchmark even if the user wanted to modify the view.

      Tableau help 1.jpg

      Ideally, the calculated field would still return the 51.47 even with additional districts being filtered.

      Tableau help 2.jpg

        1 2 Previous Next