Historical Report that uses a single tag change to pull data from multiple tags

General Discussion
1

Hi,

I'm trying to build a report simlar to the following structure:
Tag A changes at irregular intervals.
Tag B only changes by operator input.
Tag C changes constantly

I want a report that shows the value for Tag A,B, and C every time Tag A changes for a 24hr period.

I can't seem to make the report only add values for a change in one tag displayed. It either adds a line for a change in any tag or wants to be based on a fixed number of point over a given time. The 24hr period, I understand just fine.

Any help would be appreciated!

2

The report should look like this

A =1 B=5 C=10
A=2 B=5 C=2
A=3 B=5 C=8
A=4 B=5 C=12
A=5 B=4 C=15
A=6 B=4 C=3
A=7 B=4 C=10

3

This is what transaction groups are for. Record all three items with A as the trigger, in "any change" mode.

4

Or just a tag change script, if you're a tight a55 like me :smiley:

1 Like
5

Thanks, that makes sense I was trying to do it just using the historian module since I didn't purchase the SQL bridge, but maybe I'll have to get it. The transaction group converts the time to millis but I cant seem to convert it back to an actual date and time when inputting it into a report. Is there a simple way to do this?

6

Either the expression function fromMillis() or the scripting function system.date.fromMillis() will do the trick.

If you didn't purchase the SQL Bridge module, you can always use a tag change event with system.db.runPrepUpdate() or similar database call.