Why there is gap in times in some of the data points in excel sheet?
Time Gap in data points
Why there is gap in times in some of the data points in excel sheet?
Hi srashid,
Are you using a rollup in that time period? If you are not, then the raw data is populating the cells and there is millisecond precision determining if a particular point had a value at a time. Note that your time column does not have any empty saves. If on a single point had a value at a particular millisecond, then the other points in the report that share that time range would have an empty cell for that row (if using NONE rollup).
If you have used something like a "First" rollup that can be indicative of not having a value in the period. This is common even when the data source was polling the whole time for certain logging types, like 'When point value changes" which could produce long gaps between samples. For a definition of the rollups, see https://help.infiniteautomation.com/mango-rollups-and-statistics/
Rollups will automatically produce values at the same timestamp for the values in the time period that are subject to that rollup, which means they'll all go on the same row and there shouldn't be the blank spaces you are asking about.
@phildunlap Hi Phildunlop,
I haven't set any rollup. Rollup is none