In StateSummaryHistory, what do the Contained Time columns refer to?

In StateSummaryHistory, the Contained Time columns specifically reference state periods that start and end within the query's time parameters. This means that when you execute a query to examine state changes over a particular period, the Contained Time columns will only account for those state changes that fully occur within the specified timeframe of the query.

This is crucial for accurate historical analysis because it provides a clear picture of the states that are relevant to the specific time period being investigated. Data that does not fall completely within the queried time range (for example, if a state began before and ended after the timeframe) would not be captured in the Contained Time columns, ensuring that analysis is focused on the relevant data only.

Understanding this concept helps in interpreting the results of a query effectively, especially when analyzing historical performance or events.