1 Reply Latest reply on Oct 4, 2018 12:24 PM by Joe Oppelt

    Converting an aggregate calculated field into a dimension

    Basem Ayad

      Hi

       

      I'm trying to use the attached data sample to represent the changes in how quickly stops are being canceled and show that representation over a timeline. I build up calculated field (CONTD stop ID)  to build up the below table info but I cannot use it as a dimension also I tried to use a histogram charts but still cannot find a way to show if the amount of cancellations and the time frame of the cancellations (to request and trip creation) is increasing/decreasing/same as time moves forward.

       

      Stop ID  Count

      Duration from the appt to the cancellation date

      Duration from the trip creation to the cancellation date

      1

      DD:HH:MM:SS

      DD:HH:MM:SS

      2

      DD:HH:MM:SS

      DD:HH:MM:SS

      3

      DD:HH:MM:SS

      DD:HH:MM:SS

      4

      DD:HH:MM:SS

      DD:HH:MM:SS

      5

      DD:HH:MM:SS

      DD:HH:MM:SS