Querying compressed historic values for per minute values

[dtappen1]

We are attempting to get per minute historic results using a SQL query.  The queried point uses historic compression during storage.  Since compression is abled for "significant change", there are minutes that do not have a value in the result set.  How do we get a result set with a value per minute, regardless of whether the there is a stored historic value (i.e. data changed significantly or not)?

[AndrewScott]

Which algorithm are you using to process the historic data?

An interpolated algorithm will give you values for periods where there is no data.

For example: Average Interpolated 

[sbeadle · Accepted solution]

You may find it convenient to configure a Historic View - a new virtual SQL table. This can be set to a 1 minute interval, and you can pick the type of summarisation, e.g. End Last. The View will give you a column with a quality number, telling you if that 1 minute sample was derived from adjacent values or one/more vales in each 1 minute window. Search for 'Create a Historic View' in F1 help.