Tag Calculation Query Video at Inductive University

Transcript

(open in window)

[00:00] In this lesson, I'll show you how to import aggregated tag history data into your report with the tag calculation query data source. From the Data tab, the first thing you'll need to do is create a new data source and select Tag Calculation Query. The available historical tags window will list your historical providers and you can drill into them to find your historical tags. I'm storing tag history on some tags that generate random values that I'd like to add to my report. Once I find my tags, I'll drag them over to the selected historical tags window. Next thing you'll need to do is select the calculations to run against these tags. I'm going to choose Time-weighted Average sum and maximum. Next you can either choose a historical date range that uses start and end date bindings or you can choose a real-time date range where you could specify the most recent number of your time unit of choice. For example, you could pull the most recent 12 hours or seven days, etc. I'll go with the historical day range that uses my start date and end date parameters.

[01:08] I'll move over to the Design tab to show you what it looks like to add this data to your report. I have a table here that is configured for my tag_calc data source, and that has a column set up for each of the calculations. If we look at the data source in the key browser, you can see the different keys that I have access to. You'll notice that there are keys for each calculation, but the individual tags aren't listed. However, there is a tag path key here. When I drag this into one of the columns, this will be populated with the tag path/alias value. This is assigned on the data tab. I'll head over to the Preview tab and we can see what this looks like. Let's say that I don't like the tag path in the report here and this value actually represents a temperature. I can head back over to the Data tab and modify this data source. I can change the Data Key Alias here to temperature and when I go back to the Preview tab, you can see that it now lists the new alias.

In this lesson, I'll show you how to import aggregated tag  history data into your report with the tag calculation query  data source. From the Data tab, the first thing you'll need to do is create a new data  source and select Tag Calculation Query.  The available historical tags window will list your historical providers and  you can drill into them to find your historical tags. I'm storing tag history on some tags that generate random  values that I'd like to add to my report. Once I find my tags, I'll drag them over to the  selected historical tags window. Next thing you'll need to do is select the calculations to  run against these tags. I'm going to choose Time-weighted Average sum and maximum. Next you can either choose a historical date range that  uses start and end date bindings or you can choose a real-time  date range where you could specify the most recent number  of your time unit of choice.   For example, you could pull the most recent 12 hours or seven days, etc. I'll go with the historical day range that uses my start date  and end date parameters.

[01:08]          I'll move over to the Design tab to show you what it looks like to add this  data to your report. I have a table here that is configured for my tag_calc data  source, and that has a column set up for each of the calculations.  If we look at the data source in the key browser, you can  see the different keys that I have access to. You'll notice that there are keys for each calculation, but the  individual tags aren't listed. However, there is a tag path key here. When I drag this into one of the columns, this will be populated with  the tag path/alias value. This is  assigned on the data tab. I'll head over to the Preview tab and we can see what this looks like. Let's say that I don't like the tag path in the report here and  this value actually represents a temperature. I can head back over to the Data tab and modify this data source. I can change the Data Key Alias here to temperature and when I go back to the Preview tab, you can see that  it now lists the new alias.

We are experiencing playback issues from our video hosting provider. Please check back shortly.

LESSON LIST

Take topic challenge