Filip L Posted October 27, 2021 Share Posted October 27, 2021 Dear, I have computed a number daily averaged values via the signal from condition tool using the average operator and the daily bounding condition. They are positioned as discrete data at the start of the interval. Some days have missing values for some of the variables due to start-up, sensor faults, ... Others days don't have data at all due to turnarounds, .... (see figure below) Now I want to export all variables together to xls on a common grid with a 1 day interval for a longer period (e.g., 2 years). Using the export button allows to select: 1. Automatic gridding period 2. Custom gridding period (here selected as 1day) 3. Ungridded original time stamps. Option 1 and 2 result in the warning "This signal could not be automatically gridded because it is not interpolated. You can either turn gridding off or set maxInterpolation to a value greater than zero." and empty data columns. Option 3 gives full data columns but for each variable with its own time stamp columns which requires matiching the timestamps afterwards. This is quite a job because of the number of tags and can be error prone. Any advice how to tackle this question for exporting these values on a common custom grid? Many thanks in advance! Filip Link to comment Share on other sites More sharing options...
Seeq Team Joe Reckamp Posted October 27, 2021 Seeq Team Share Posted October 27, 2021 Hi Filip, You can turn the discrete signals into step signals by doing $signal.tostep(1d) such that it will interpolate all data points within a day of each other and then the custom grid will work effectively. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now