I want to check if I'm right...
Using function TagTot I want to calculate total today and total for 1 month.
I first calculated averages for today and for current month.
Then multiply this with TagTot for day and month total.
Is that OK or has a better way?
Regards,
Igor
In this way result is a bit more precise.
You can see a comparison...
The result that you get by using TagMean is not correct. TagMean calculates the event-weighted average of the tag which is probably not what you want. If you want the time-weighted average, you can consider TagAvg.
Something else is not clear to me...
If you look at the picture you will see that the average production today is (AVRToday) 124.94 kg/h.
TotalToday (for 11 hours of work) give result 675.05, which is not logical because it should be 124.94 x 11 h = 1374.34
Why did wrong totalizes total amount?
You will need to take into account conversion factors as well. The default is always assumed to be "per day" for the rate tag. Please look at the link for a more information.
KB01585 - How Time-Weighted and Event-Weighted Totals and Averages Work
Hello Igor,
I find it difficult to asses if the calculation returns the correct result without knowing the raw data. For this reason, I suggest you to use PI DataLink to retrieve compressed values for a certain day and to use Excel to see if you could reproduce the results. Please note that there is quite some difference between calculating time- or event-weighted. When you are able to say that the daily results are good, you can look into the monthly ones.
One thing to note is that while the 'Evaluate' button allows to check if the formula is generally working, you should not take the 'evaluated' results as real. I don't recall the exact details but that the results showing here are not trustworthy because formula's are evaluated at current time. So, please only compare real formula evaluations performed by the Analysis Processor. At least for the assessment of calculation results, you may want to map the output to a PI Point Attribute but I also like to suggest this in general. With a static Attribute, you will not be able to check this month's Total against the previous month's Total.
When building a daily Total and a monthly Total, it may be wise to use the daily Total as input for the monthly calculation. My expectation here is that the amount of archived events with the daily Total is way less than with the raw point but that calculating based on daily values is still accurate.
Hi, I am just following this thread for one of the calculations I am working on. I have a question regarding TagTot() function. I have to calculate daily flow average and daily total for a flow tag which shows reading in m3/h. Both calculation runs just after midnight at 24 hours interval daily.
- For average, I am using TagAvg('Flow', 'y', 't', 85) and it gives a time-weighted average value (m3/h) which looks right.
- For total, I am using TagTot('Flow', 'y', 't', 85) and it gives same values in m3 but it gives the same values as average which doesn't sound right.
For e.g. If 'Flow' tag is a high frequency tag whose minimum value for yesterday (24 hour) is around 0.65 m3/hr and max value is around 332 m3/hr is giving average values as 115.95 m3/hr which sounds right but even total values is giving the same value i.e. 115.95 m3 which doesn't sound right.
I know if I do the TagTot('Flow', 'y', 't', 85) * 24, it will give more sensible figure i.e. 2782.9 m3. My question is: Why should I have to multiply the result value of TagTot() by number of hours. AF should automatically do it else what's the difference between TagTot() and TagAvg()
Also, TagTot('Flow', 'y', 't', 85) * EventCount('Flow', 'y', 't') gives event weighted total and a big number i.e. 302060. Do you know in practical world , where is it in use ?
Any feedback comments from OSIsoft will be appreciated.
on Nov 26, 2018
You can just use the raw process tag 'Mass' with TagTot like this for total today
TagTot('Mass','t','*')
and like this for current month total.
TagTot('Mass',Bom('*'),'*')