Line Chart by Seconds and values ...points interpolation

Question & Answer
,
#1

Dear community

I have one issue creating a Line Chart visualization where on the X axis I have the time in seconds and on Y values with different values … thinks that is a speed that move from 6 to 0 … that remain for different time to 0 and than again to 4 .
On my table i have value like this:

Time Speed
t1 6
t2 7
t3 0
t4 6

Than the line chart do a interpolation and connect the 0 with the 6… but in reality the speed remain for a long period to 0 than become 6 and I expect to have a line for this long period to 0 and than 6.
Do you know if there is the possibility to have this ?

Thanks

#2

It would be good to share a screenshot of the issue as it shard to follow along.
Talking about line interpolation, the time series charts do support interpolation(missing data point) under Y axis. Not sure if you have played around with these. Also, for these options to show up you would need to make sure that the fields on x axis is recognized as time field
image

#3

Hi, @enrico. Did @Bchadha’s solution work for you? I am marking his reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community Q&A Forum!