Reporting - one line per time condition is true

Hi All,

Apologies if this is a basic one, but I’m struggling to figure out how to create a tag history query for my report that produces one line for each time some condition is true with the time that it occurred and how long it occurred for (or the time that it stopped being true). The only way I can figure out to do this so far is to create an alarm on that condition, then report on the alarms, but that doesn’t help if I need to drill into old data to create a new report for conditions I hadn’t considered alarming on before.

As a bonus round, if my condition is say {tag}>30, I might want to have a report that includes one row for each value of {tag} for each time that this condition is true, then show that value. Is this possible?

Thanks!