4 Replies Latest reply on Nov 24, 2014 3:22 AM by Alex Money

    Toggle between min, max and average

    Alex Money

      Hello, I am trying to create a filter which allows me to toggle the view between minimum, maximum and average of the Measure Values in my worksheet. Is this possible? Thanks, Alex

        • 1. Re: Toggle between min, max and average
          Mark Fraser

          Hi Alex

           

          If you create a separate measure and then use a parameter to dynamically choose between the 3.

           

          here is an example of how i have done it, i have a parameter called Activity Type which has a drop down selection of admissions or box office. (in your case it would be min, max, avg)

           

          2014-11-21_16h10_07.jpg

           

          next create a calculated field called Activity which is the following -

           

          CASE [Activity Type]

            WHEN "Admissions" THEN SUM([Admissions])

            WHEN "Boxoffice" THEN SUM([Boxoffice])

          END

           

          for yours it maybe will look more like this...

           

          CASE [Activity Type]

            WHEN "Min" THEN MIN([Sales])

            WHEN "Max" THEN MAX([Sales])

            WHEN "Avg" THEN AVG([Sales])

          END

           

          then add 'activity' to the label and add the parameter control.

          as you change between the 3 (via the parameter control) your output should dynamically change.

           

          i hope that makes some sense!!

           

          Kind regards

          Mark

          • 2. Re: Toggle between min, max and average
            Alex Money

            Mark that is fabulous. Am sure that will work. Thank you so much!! Alex

            • 3. Re: Toggle between min, max and average
              Mark Fraser

              You're welcome Alex

              I'm using this successfully (albeit with only 2 measures), if you have any questions/ problems let me know.

               

              Cheers

              Mark

              • 4. Re: Toggle between min, max and average
                Alex Money

                Thanks again for this, Mark. I have about 20 measures and I use the

                'measure names' function in my worksheets. Do you know if there is there a

                way I could apply this here, or do I need to write out the 3 cases (min max

                avg) for each of the 20 measures? Alex

                 

                On 21 November 2014 at 15:29, Mark Fraser <