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