
Re: TagTot for day and month
Eugene Lee Nov 26, 2018 10:19 AM (in response to igreguri)1 of 1 people found this helpfulYou 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('*'),'*')


Re: TagTot for day and month
Eugene Lee Nov 26, 2018 10:59 AM (in response to igreguri)3 of 3 people found this helpfulThe result that you get by using TagMean is not correct. TagMean calculates the eventweighted average of the tag which is probably not what you want. If you want the timeweighted average, you can consider TagAvg.



Re: TagTot for day and month
Eugene Lee Nov 27, 2018 8:37 AM (in response to igreguri)2 of 2 people found this helpfulYou 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 TimeWeighted and EventWeighted Totals and Averages Work

Re: TagTot for day and month
gregor Nov 27, 2018 2:58 PM (in response to igreguri)1 of 1 people found this helpfulHello 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 eventweighted. 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.



