Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a big problem with creating a timeline chart of my data (Trains).
I have this database:
Key | Start_Place | End_Place | Start_Time | End_Time |
---|---|---|---|---|
12345 | Munich | Cologne | 01.02.2017 05:00 | 01.02.2017 12:34 |
12345 | Cologne | Hamburg | 01.02.2017 14:00 | 01.02.2017 19:24 |
12345 | Hamburg | Berlin | 02.02.2017 04:01 | 02.02.2017 07:55 |
98765 | Paris | Cologne | 04.03.2017 07:33 | 04:03.2017 15:43 |
98765 | Cologne | Munich | 04.03.2017 16:00 | 04.03.2017 22:05 |
I want to have a linechart about the trains.
(When the trains is driving from one place to another and how long the train is at one place waiting)
I hope someone can help me!
Thank you!
How do you know that train wait time at one place?
Probably by matching the Start_Place to the End_Place of the previous leg and subtracting corresponding Start_Time from End_Time.
Can you show us an example of the line chart you want to obtain? Including dimensions?
You can do this in Excel with dummy data.
Yes i would do that.
But the big problem is linechart.
So I think you need to have End_Place as dimension, where train halts. Right?
And avg(Waiting_Time) as an expression? Sounds good. But a line chart?
Yes, this seems to be good as per the data and requirement.
Yes, something like this.
But it would be better if we change the Time/Place dimension.
So if the train is waiting there is a straight line and every place is only one time there.
Is there any way I can get a Chart like this?
I really need some help...