1 Reply Latest reply on Oct 18, 2016 2:49 AM by ra.sae.0

    Referring to 'Measure Values' in a calculated field

    Rae Ann Boswell

      Hi, I would like to write a calculated field that allows for the color and shape of arrows to change based off of the measure value. For example:

      if 'measure value' >=0 then 'positive arrow' else 'negative arrow' end ... and then place this calculated field in the color and shape marks.

       

      Workbook is attached and would appreciate any workarounds. As of now, my only thought is to put the 'Enrollment' measure in one sheet and the 'Enrollment Velocity' measure in a second sheet and write specific calculated fields for both (i.e. -if 'enrollments' >=0 then 'positive arrow' else 'negative arrow' end .

       

       

      Work is on second tab (monthly- enroll %)

      Thanks!