Trying to make a table using perspective in 8.1 that I can grab the data from historian and show the proper values i want.
Ex. I pick 11:59pm September 14th till 7:59am Sept 16th I want to see where data 1 at 8am data 2 at 4pm and data 3 at midnight and it resets everyday.
Sept 14th 11:59pm Data 3
Sept 15th 7:59am Data 1
Sept 15th 3:59pm Data 2
Sept 15th 11:59pm Data 3
Sept 16th 7:59am Data 1
This is one form of my current table which is close but this is how the data is using last value:
Sept 14th 11:59pm Data 1(From Monday the 15th)
Sept 15th 7:59am Data 2
Sept 15th 3:59pm Data 3
Sept 15th 11:59pm Data 1(From Tuesday the 16th)
Sept 16th 7:59am Data 2
So as you can see its taking the value at the end of the 8 hours from the time start. There is no option in ignition dropdown to use starting value or first value or something like that. This way has no errors other than everything is offset wrong 8 hours ahead of the number its next too.
I get closer to seeing what i want using MinMax but Sundays screw up the data because usage for the whole day Sunday is smaller than Monday 12:00am-8am.
These are my settings in the ignition table anyone that can help would be awesome I keep trying things and can’t get my data right.
I’ve tried changing the period to -8(minus 8) but that changes the dataset to like 40930 rows and looks at it randomly in seconds instead of once per 8 hours.
Thanks
Jim