Line chart in QUicksight

Q&A
, ,
1

Hi community. I am new to quicksight and also to building visualizations in general. I am trying a couple of things but haven’t had any luck yet. I have a dataset. Below is the sample of data. I have a question here.

  1. I am trying to plot a line chart with datetime on x axis and the car 1 on y axis. It is just a line which keeps changing status between 1 and 0. For somereason I am not able to this. It should be straightforward. But is not. It seems complex than it should. It is not allowing me to plot as desired.

An example plot in mind would be:

image
image779×556 6.84 KB

I am able to plot this in python easily but plotting it in quicksight is turning out to be a bit more complex than I imagined. Any help is appreciated. Thank you!

car1 car2 car3 car1_active car1_rest car2_active car2_rest car3_active car3_rest
2024-02-04 15:00:00+00:00 1 1 FALSE FALSE FALSE FALSE FALSE FALSE
2024-02-04 16:00:00+00:00 1 1 FALSE FALSE FALSE FALSE FALSE FALSE
2024-02-04 17:00:00+00:00 1 1 FALSE FALSE FALSE FALSE FALSE FALSE
2024-02-04 18:00:00+00:00 1 1 FALSE FALSE FALSE FALSE FALSE FALSE
2024-02-04 19:00:00+00:00 1 1 1 FALSE FALSE FALSE FALSE FALSE FALSE
2024-02-04 20:00:00+00:00 1 1 1 FALSE FALSE FALSE FALSE FALSE FALSE
2024-02-04 21:00:00+00:00 1 1 1 FALSE FALSE FALSE FALSE FALSE FALSE
2024-02-04 22:00:00+00:00 1 0 1 FALSE FALSE FALSE TRUE FALSE FALSE
2024-02-04 23:00:00+00:00 1 0 1 FALSE FALSE FALSE FALSE FALSE FALSE
2024-02-05 00:00:00+00:00 1 0 1 FALSE FALSE FALSE FALSE FALSE FALSE
2024-02-05 01:00:00+00:00 1 0 1 FALSE FALSE FALSE FALSE FALSE FALSE
2024-02-05 02:00:00+00:00 1 1 0 FALSE FALSE TRUE FALSE FALSE TRUE
2024-02-05 03:00:00+00:00 1 1 0 FALSE FALSE FALSE FALSE FALSE FALSE
2

Hi @TK2895
what exactly is the issue?

grafik
grafik995×452 46.9 KB

BR

2 Likes
3

Thanks this helped. The car1 data was not integer type in my data. I converted it and is working fine as expected.

4

@TK2895 Perfect.
Could you please solve the topic?

5

I do have another question - I have multiple columns, one for each car. Can I add a filter to pick each car at a time to visualize the line graph for that specific car? I know if there are limited cars, I can add them to the value field and add a filter to pick and choose from the filter. But if I have a thousand columns for cars, is it possible create that filter easily?

6

hi @TK2895 below please find filter documentation. Will marks eriks response as the solution. For further questions please create a new ticket.

cheers!

1 Like