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
Current Day ['t'] and Calculated Value for today [TimeEQ('tag','y','t',"value")]
Yesterday ['t-1d'] and Calculated Value for yesterday [TimeEQ('tag','t-2d','t-1d',"value")]
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
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
Current Day ['t'] and Calculated Value for today [TimeEQ('tag','y','t',"value")]
Yesterday ['t-1d'] and Calculated Value for yesterday [TimeEQ('tag','t-2d','t-1d',"value")]
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
