Hey! I have a csv with timestamp in first column, and a lot of other entries in the other.
When I use timestamp on X-axis I only get dots where there are active entries. Is there a way for flow to assume emtpy entries to get continous lines?
Ignoring blanks for continous lines
Ignoring blanks for continous lines
- Attachments
-
- Uten navn.png (94.68 KiB) Viewed 5551 times
Re: Ignoring blanks for continous lines
Hello Ezy!
First of all, terribly sorry for the delayed response. For some reason I didn't get an email notification.
I assume that what you would like is to connect the dots with diagonal lines, i.e. interpolate between them? Unfortunately this is currently not supported in Flow. What you could do is to write a formula that fills in the gaps with the last known value whenever there is no value as follows:
x_continuous = x if not isnan(x) else x_continuous[t-1]
Here, x is the variable name for the column. For column headers containing non-alphanumeric characters, the variable names are printed in the message view when you open the file. I can see that you have quite many variables (and also quite long variable names), so I'm afraid it might be a bit cumbersome.
Best regards,
Gustaf
First of all, terribly sorry for the delayed response. For some reason I didn't get an email notification.
I assume that what you would like is to connect the dots with diagonal lines, i.e. interpolate between them? Unfortunately this is currently not supported in Flow. What you could do is to write a formula that fills in the gaps with the last known value whenever there is no value as follows:
x_continuous = x if not isnan(x) else x_continuous[t-1]
Here, x is the variable name for the column. For column headers containing non-alphanumeric characters, the variable names are printed in the message view when you open the file. I can see that you have quite many variables (and also quite long variable names), so I'm afraid it might be a bit cumbersome.
Best regards,
Gustaf