4 Replies Latest reply on Jan 28, 2015 1:42 PM by dng

# Tagtot Question

Hi Guys! I am trying to create an analysis that will get the total consumption for a specific month. The problem is I am having  problem on how to write the expression.

For example the date would be the 17th of the month. How will I write it that it will only compute a total of 17 days?

Since the analysis depends on what day it is, how will you write it? Or is this impossible?

The problem when writing *-30d is that it will include days from the previous month and I don't want to do that.

If impossible with Tagtot what are other ways and how will I do that?

• ###### Re: Tagtot Question

Hi Ricky,

You can simply put '1' as timestamp to represent the beginning of the month, or use funtion BOM(). Here are two examples:

TagTot('Tag','1','*')

TagTot('Tag',BOM('*'),'*')

1 of 1 people found this helpful
• ###### Re: Tagtot Question

To add to Zhengqi's comment, remember to add the conversion factor when you are using TagTot because the system chooses a scale factor such that the integral will be correct only if the flow is expressed in units per day. If the flow is expressed in units per hour, or per some other time unit, you must multiply this result by a conversion factor. The conversion factor equals the number of actual flow time units in a day.

1 of 1 people found this helpful
• ###### Re: Tagtot Question

Do you know the conversion factor for kwH? I tried Tagtot but I get wrong results.

• ###### Re: Tagtot Question

Hi Ricky,

What is the source unit? If you are trying to calculate the total of an attribute with kW to get to kWh, the conversion factor should be 24.