1 Reply Latest reply on Sep 27, 2016 11:12 AM by Matt Hong

    Standard Deviation toggle

    Charlotte Ho

      Anyone know how to create a std dev toggle to the dashboard?  Tableau doesn’t seem to give you an option to choose your own calculation (Graph 1).

      I want users to be able to view the five ED time events with either one or two standard deviation reference lines (Graph 2). 


      Graph 1

      Graph 2

        • 1. Re: Standard Deviation toggle
          Matt Hong

          You can create a parameter that can take on the integer values 1 and 2. Let's call it [St. dev. toggle].


          Then, create a calculation that is something like this:

               AVG([Measure]) + [St. dev. toggle] * STDEV([Measure])


          Create a reference line, and select this calculation under 'Value'.