4 Replies Latest reply on Jul 9, 2018 7:38 AM by James Ham

    Trend arrows and colours

    James Ham

      Hi all,


      I am trying to create a dashboard that uses some business logic.


      I have 4 different reporting periods with each period aiming for a target of 20.


      I would like to achieve the following:


      - Use a Up/ Down trend arrow depending on the performance of the reporting period. EG if 20 for June and 21 for July, the trend would be up.

      - Use a colour code against the target. EG if for June 20 then Green and 21 for July Red.


      I have tried a number of formulas however none have worked.


      Any help would be appreciated.