1 2 Previous Next 22 Replies Latest reply on Nov 9, 2016 12:49 AM by Khalid Baker

    Can I calculate a shape as an 'up' or 'down' arrow depending on a quick table calculation?

    Robert Bell

      Hi

       

      I've produced a view with multiple mark types with a bar to show the number of student applications year on year and a line to show the percentage difference from the previous year.

       

      Instead, I'd prefer to show the percentage change in applications from last year as an up or down arrow, depending if greater or less than zero, with the actual percentage as the label (like stocks and shares graphics). Ideally, the colour gradient should move deep green (very positive) to deep red (very negative) depending on the percentage difference. It would be great if the up down arrows could appear in line rather higher or lower on the view depending on their value.

       

      Attached is what I've done so far by way of an illustration.

       

      Can anyone help?

       

      Thanks

       

      Bob

        1 2 Previous Next