3 Replies Latest reply on Oct 11, 2016 7:16 AM by Elliott Robin

    How to parameter dynamic center value ?

    Elliott Robin

      Hi there,

       

      I'm looking for a way to dynamically parameter the center value of my color legend. This way the end user can set his own value in the parameter that will become the center (white) value. (see picture)

       

      Thanks a lot for your help

       

      Elliott

        • 1. Re: How to parameter dynamic center value ?
          Sherzodbek Ibragimov

          Elliot,

          Lets see if following steps help you to get your desired results:

          1. Create a parameter, Ad Hoc Color a boolean data type.

          2. Create a parameter, New Center Amount,an integer data type.

           

          3. Create a formula, Color Formatting as below:

           

           

          Make sure you use 1st and 2nd step as filters. So, if Ad Hod Color is no, no matter what you type in New Center Amount, colors will not change. But, if it is yes, then center amount will be based on New Center Amount thus will make colors to change based on user defined number.

           

          I hope it helps to answer your question. Thank you

          • 2. Re: How to parameter dynamic center value ?
            Sherzodbek Ibragimov

            Forgot to mention that you have to bring Calculated field 'Color Formatting' to color.

            • 3. Re: How to parameter dynamic center value ?
              Elliott Robin

              Hi Sherzodbek,

               

              First of all, thanks for replying. You're almost there!

               

              Right now I'm calculating productivity rates for different teams. That's why I want the dynamic center: Example: for team A productivity treshold can be 100% (1 in the parameter) and for team B it can be 80% (0.8 in the parameter, which is why I switched data type to float)

               

              It now seems to have a problem with the MAX function in the calculated field because as you can see in the example below in 2 blue circles, my new center amount is 1 but the color of the square is the same as the one with the 0 value.

               

              The goal of my need is to show red squares for values under the New Center Amount and green ones for values over...

              example.PNG

               

              I hope it's clear,

               

              thanks and have a good day !

               

              Elliott