Line chart showing up 2 lines coming from the same column

[LuisCG]

Hello everyone!

Can anyone tell me how to draw a line chart that have 2 lines coming from the same column?

I have a column that contains visibility data (numbers) and one date column. I need to draw a line chart with the date in the "X" axis and 2 "Y" axis, the first one counting the number of rows with visibility >= 5000 meters, and the other one counting the number of rows with visibility >= 1000 meters. This means that both lines come from the same data source (column)!

I'm not able to draw this I tried everything possible. Any help will be greatly appreciated!!

[SolomonovAnton]

hello ! 

I think you hould create 2 measures ( visibility >= 5000 meters,  visibility >= 1000 meters) and might be use second X axis 

[LuisCG]

Thank you!

This is what I'm trying to do, but it does not draw it well for some reason.

Could anyone please tell me what specific steps should I follow?

Thanks in advance!

[SolomonovAnton]

could you show some part of data ?

[LuisCG]

Sure! Here it is:

Thanks!

[LuisCG]

Here you can see a day with low visibility conditions:

[SolomonovAnton]

which column from are you want show in graph ( visibility >= 5000 meters,  visibility >= 1000 meters) ?

[LuisCG]

From the column vis 2 (m). 

By the way,  I actually want to draw visibility <= 1000 m and <= 5000 m. Sorry, I wrote it wrong before.

[SolomonovAnton]

in column [vis 2 (m)] you have value '>=1000' it is text, so you have to change it to integer and change column type to integer. After it you are able to create measure based on column [vis 2 (m)]