How can i totalize the amount of time that a Tag has an especific value in a day?

You can create a Calculation with a PIExpression or Performance Equation:

TagEQ('tag','y','t',"value"), this will count the seconds your tag is equivalent to a value, in between "" if is an string or a number if its an int. One day has 86400 seconds. Hope it helps

Thank you, i just changed TagEQ for TimeEQ and it worked.

yeah it was TimeEQ, my bad. The same syntaxis applies for other cases, greater equal (TimeGE), lower equal (TimeLE), greater than (TimeGT), lower than (TimeLT) and Not Equal (TimeNE)

Thank you, it helped a lot, i´m new in PI Vision. Now i have another issue, i want to have a dates table and show the calculated value for each day, could you please give me an idea to solve it?

Im thinking of creating one two calculated expression for each day, one that shows the date and one that shows the calculated value for each day (last 7 days for example). Considerar that the timevalue 't' indicates the current day at 00:00

1. Current Day ['t'] and Calculated Value for today [TimeEQ('tag','y','t',"value")]
2. Yesterday ['t-1d'] and Calculated Value for yesterday [TimeEQ('tag','t-2d','t-1d',"value")]
3. Two days ago ['t-2d'] and Calculated Value for yesterday [TimeEQ('tag','t-3d','t-2d',"value")]

You keep iterating the date argument so it covers your entire time period, this way the values are dynamically changing in the date table when changing the time interval of your screen. The trends of the current day will show you (for example) the trend for the time for the last 8 hours, 1 day, etc. You will have to display the values manually once to set it up like a table