11 Replies Latest reply: Sep 28, 2018 8:27 AM by Tim Poismans RSS

    Expressions

    Shakeeb Mohammed

      Hi,

       

      can someone assist me with the below please?

       

      I have 3 fields in my app - One is called 'DepartureStatus'  the other one is called 'Trip' and the last one is called 'Location'

       

      DepartureStatus field contains - OnTime,Late and Early and the Trip field contains Trip numbers and location has site departments.

       

      What i want is show how many trips where on Time, early or late by location in a bar chart.

       

      I'm having problems writing this expression - When I use sum(DepartureStatus) and use Location as Dimension i don't get a result  but i do when i use Count - but the figure is incorrect.

       

      Can someone shed some light on this please?