Hi all -
I have multiple queries returning time series I want to put in one table - a column per query. In general this works by merging the single results but since the time series are not time-stamp-aligned, I get empty cells as can be seen on below image. I would like to implement one of the following if possible:
- Fill the empty cells with the last known value (no idea how)
- Resample the data so they are time-stamp aligned (this I tried with an expression but no success)
queries
transforms
approach expression
I found this old thread with a similar question, unfortunately no answer so far:
Hoping anyone has some thoughts on this to share.
Regards,
Oliver