One way or another, you are either going to write SQL that excludes the unwanted data, or you are going to write a script that omits the unwanted data from a "raw" historical query. Either way, you end up with a data key for the chart that is already filtered. Since the boundaries are also historical (the button status recordings), I would lean towards a script. You've asked about button intervals before--it seems that answer is still valid.
1 Like