# Roll Up Analysis

Question asked by Koerkel on Nov 5, 2018
Latest reply on Nov 7, 2018 by Koerkel

I have two different types of meters; one measuring at 15 minute intervals and the other measuring at 60 minute intervals.  I want to sum the measurement up to the transformer (the parent).  I found that if I do a standard roll up analyses, PI wants to interpolate values on each quarter hour for the hourly meters.  Thus my rollup value was higher than the actual sum from the meters.  I corrected this by adding a PI point to my 15 minute meters to sum the entire hour to the ordinal hour thus faking my 15 minute meters to look as if they were hourly meters.  Here is the analysis I used:

if Minute('*')<>0 then NoOutput()

else TagMean('Wh Delivered Int Raw value', '*-50m', '*') * EventCount('Wh Delivered Int Raw value', '*-50m', '*')*'CTPTRatio'/1000

For my hourly meters I simply converted the raw measurement into the proper units as so:

'Wh Delivered Int Raw value'*'CTPTRatio'/1000

I then sum the values from these analyses to obtain the hourly summed value.  This works for the most part, however, I am still receiving 96 values per day on my transformer when I expected 24 values. The values on the each quarter of the hour equals the values summed to the previous ordinal hour.  How can I roll up the measurements and only have 24 values?  Here is a simple example of what my data looks like:

 Meter summed to the hour and converted to KWH Meter Raw data in WH Transformer A Wh Load Meter 1 kWh Delivered Interval Meter 1 Wh Delivered Int Raw value Number of Values: 96 Number of Values: 24 Number of Values: 96 10/31/2018 0:15 0.508 10/31/2018 1:00 0.51 10/31/2018 0:15 128 10/31/2018 0:30 0.508 10/31/2018 2:00 0.51 10/31/2018 0:30 129 10/31/2018 0:45 0.508 10/31/2018 3:00 0.515 10/31/2018 0:45 126 10/31/2018 1:00 0.51 10/31/2018 4:00 0.516 10/31/2018 1:00 127 10/31/2018 1:15 0.51 10/31/2018 5:00 0.508 10/31/2018 1:15 127 10/31/2018 1:30 0.51 10/31/2018 6:00 0.502 10/31/2018 1:30 128 10/31/2018 1:45 0.51 10/31/2018 7:00 0.498 10/31/2018 1:45 127 10/31/2018 2:00 0.51 10/31/2018 8:00 0.492 10/31/2018 2:00 128 10/31/2018 2:15 0.51 10/31/2018 9:00 0.498 10/31/2018 2:15 128 10/31/2018 2:30 0.51 10/31/2018 10:00 0.498 10/31/2018 2:30 129 10/31/2018 2:45 0.51 10/31/2018 11:00 0.495 10/31/2018 2:45 129 10/31/2018 3:00 0.515 10/31/2018 12:00 0.498 10/31/2018 3:00 129 10/31/2018 3:15 0.515 10/31/2018 13:00 0.504 10/31/2018 3:15 130 10/31/2018 3:30 0.515 10/31/2018 14:00 0.5 10/31/2018 3:30 129 10/31/2018 3:45 0.515 10/31/2018 15:00 0.506 10/31/2018 3:45 129 10/31/2018 4:00 0.516 10/31/2018 16:00 0.514 10/31/2018 4:00 128 10/31/2018 4:15 0.516 10/31/2018 17:00 1.329 10/31/2018 4:15 129 10/31/2018 4:30 0.516 10/31/2018 18:00 2.699 10/31/2018 4:30 127 10/31/2018 4:45 0.516 10/31/2018 19:00 2.769 10/31/2018 4:45 127 10/31/2018 5:00 0.508 10/31/2018 20:00 2.812 10/31/2018 5:00 125 10/31/2018 5:15 0.508 10/31/2018 21:00 2.854 10/31/2018 5:15 126 10/31/2018 5:30 0.508 10/31/2018 22:00 2.888 10/31/2018 5:30 125 10/31/2018 5:45 0.508 10/31/2018 23:00 2.858 10/31/2018 5:45 126 10/31/2018 6:00 0.502 11/1/2018 0:00 2.779 10/31/2018 6:00 125 10/31/2018 6:15 0.502 10/31/2018 6:15 124 10/31/2018 6:30 0.502 10/31/2018 6:30 124 10/31/2018 6:45 0.502 10/31/2018 6:45 125 10/31/2018 7:00 0.498 10/31/2018 7:00 125 10/31/2018 7:15 0.498 10/31/2018 7:15 123 10/31/2018 7:30 0.498 10/31/2018 7:30 123 10/31/2018 7:45 0.498 10/31/2018 7:45 123 10/31/2018 8:00 0.492 10/31/2018 8:00 123 10/31/2018 8:15 0.492 10/31/2018 8:15 125 10/31/2018 8:30 0.492 10/31/2018 8:30 124 10/31/2018 8:45 0.492 10/31/2018 8:45 124 10/31/2018 9:00 0.498 10/31/2018 9:00 125 10/31/2018 9:15 0.498 10/31/2018 9:15 125 10/31/2018 9:30 0.498 10/31/2018 9:30 124 10/31/2018 9:45 0.498 10/31/2018 9:45 124 10/31/2018 10:00 0.498 10/31/2018 10:00 125 10/31/2018 10:15 0.498 10/31/2018 10:15 123 10/31/2018 10:30 0.498 10/31/2018 10:30 124 10/31/2018 10:45 0.498 10/31/2018 10:45 124 10/31/2018 11:00 0.495 10/31/2018 11:00 124 10/31/2018 11:15 0.495 10/31/2018 11:15 124 10/31/2018 11:30 0.495 10/31/2018 11:30 124 10/31/2018 11:45 0.495 10/31/2018 11:45 124 10/31/2018 12:00 0.498 10/31/2018 12:00 126 10/31/2018 12:15 0.498 10/31/2018 12:15 127 10/31/2018 12:30 0.498 10/31/2018 12:30 127 10/31/2018 12:45 0.498 10/31/2018 12:45 125 10/31/2018 13:00 0.504 10/31/2018 13:00 125 10/31/2018 13:15 0.504 10/31/2018 13:15 125 10/31/2018 13:30 0.504 10/31/2018 13:30 125 10/31/2018 13:45 0.504 10/31/2018 13:45 125 10/31/2018 14:00 0.5 10/31/2018 14:00 125 10/31/2018 14:15 0.5 10/31/2018 14:15 126 10/31/2018 14:30 0.5 10/31/2018 14:30 126 10/31/2018 14:45 0.5 10/31/2018 14:45 126 10/31/2018 15:00 0.506 10/31/2018 15:00 128 10/31/2018 15:15 0.506 10/31/2018 15:15 128 10/31/2018 15:30 0.506 10/31/2018 15:30 129 10/31/2018 15:45 0.506 10/31/2018 15:45 128 10/31/2018 16:00 0.514 10/31/2018 16:00 129 10/31/2018 16:15 0.514 10/31/2018 16:15 129 10/31/2018 16:30 0.514 10/31/2018 16:30 204 10/31/2018 16:45 0.514 10/31/2018 16:45 400 10/31/2018 17:00 1.329 10/31/2018 17:00 596 10/31/2018 17:15 1.329 10/31/2018 17:15 673 10/31/2018 17:30 1.329 10/31/2018 17:30 671 10/31/2018 17:45 1.329 10/31/2018 17:45 673 10/31/2018 18:00 2.699 10/31/2018 18:00 682 10/31/2018 18:15 2.699 10/31/2018 18:15 689 10/31/2018 18:30 2.699 10/31/2018 18:30 691 10/31/2018 18:45 2.699 10/31/2018 18:45 693 10/31/2018 19:00 2.769 10/31/2018 19:00 696 10/31/2018 19:15 2.769 10/31/2018 19:15 699 10/31/2018 19:30 2.769 10/31/2018 19:30 700 10/31/2018 19:45 2.769 10/31/2018 19:45 705 10/31/2018 20:00 2.812 10/31/2018 20:00 708 10/31/2018 20:15 2.812 10/31/2018 20:15 711 10/31/2018 20:30 2.812 10/31/2018 20:30 712 10/31/2018 20:45 2.812 10/31/2018 20:45 715 10/31/2018 21:00 2.854 10/31/2018 21:00 716 10/31/2018 21:15 2.854 10/31/2018 21:15 720 10/31/2018 21:30 2.854 10/31/2018 21:30 721 10/31/2018 21:45 2.854 10/31/2018 21:45 722 10/31/2018 22:00 2.888 10/31/2018 22:00 725 10/31/2018 22:15 2.888 10/31/2018 22:15 720 10/31/2018 22:30 2.888 10/31/2018 22:30 717 10/31/2018 22:45 2.888 10/31/2018 22:45 713 10/31/2018 23:00 2.858 10/31/2018 23:00 708 10/31/2018 23:15 2.858 10/31/2018 23:15 702 10/31/2018 23:30 2.858 10/31/2018 23:30 695 10/31/2018 23:45 2.858 10/31/2018 23:45 692 11/1/2018 0:00 2.779 11/1/2018 0:00 690