1 Reply Latest reply on Jul 23, 2012 5:28 AM by Russell Christopher

    How can you dynamically change a mark type

    Andrew Norris

      Hi

       

      How do you dynamically change a mark. For example if I have a measure - and the value keep going up - then I display an up arrrow mark. I can control the colour of this arrow using a calculation i.e. I can change the colour of the arrows to green or red , but I am not sure how to change the arrow to a down arrow when required.

       

      How can this be done.

       

      Thanks

       

      Andrew

        • 1. Re: How can you dynamically change a mark type
          Russell Christopher

          Hey Andrew -

           

          You should base the shape on the output of a calculated field, not your actual measure. Then you can take full control over what you want to see.

           

          For example:

           

          If [Measure] > 1000 Then "Good"

              elseif [Measure] >500 AND [Measure} < 1000 "OK"

          else

              "Stinky"

          END

           

          In the expression above, we now to expect one of three values. We can drag this field to our Shapes shelf, and code each string (Good, OK, Stinky) to a specific shape.

           

          Hope this helps!