Multipe lines in timeseries using AWS Timestream

[phil]

Hi,

I am using AWS Timestream as a datasource.
My data structure looks like this:

Currently I add multiple queries like this:
SELECT sensor_id, time, measure_value::double FROM "sensordb"."mytable" WHERE sensor_id = '28-011921d74ee8' AND "measure_value::varchar" IS NULL
…

How can I draw multiple lines with only one sql statement? (Is this possible with AWS Timestream?)

Thank you

[yosiasz]

Welcome

Can you try this transformation?

[phil]

Where can I find this option? I clicked on transform. Not sure where to look?

Thank you for the fast reply!

[phil]

Thank you so much! I was working on this for several hours …

Is it possible to set for each “sensor_id” a predifed color and rename them?

[yosiasz]

Was your problem solved fir the 1st question? If so please mark the answer as solution and post a new question in a new thread?

[phil]

Yes thank you so much and excuse me for asking a second question.