I have a dataset of dates and two different variables I’d like to plot. On a given date, variable 1 may or may not have a value and same goes for variable 2. So my data looks something like this:
Date ---- Variable 1 Value ---- Variable 2 Value
1 ----------------- 19.6 ----------------- Null
2 ----------------- 20.3 ----------------- 21.2
3 ----------------- Null ----------------- 18.9
4 ----------------- Null ----------------- Null
5 ----------------- 21.5 ----------------- 19.4
When I plot this using the Chart feature in Ignition, the lines break whenever there is a date without data. Any way around this?
Here is a screenshot of what I’m seeing. Blue line is variable 1 and red line is variable 2.