# Tag History Average

**URL:** <https://forum.inductiveautomation.com/t/tag-history-average/112637>\
**Category:** General Discussion\
**Tags:** scripting\
**Created:** [December 5, 2025, 3:04am UTC](https://forum.inductiveautomation.com/t/tag-history-average/112637 "2025-12-05T03:04:30Z")\
**Posts on this page:** 14\
**Page:** 1

<div class="post-metadata">

**Author:** ![Philip\_Knowlton](https://avatars.discourse-cdn.com/v4/letter/p/e495f1/32.png) [@Philip\_Knowlton](https://forum.inductiveautomation.com/u/Philip_Knowlton)\
**Post date:** [December 5, 2025, 3:04am UTC](https://forum.inductiveautomation.com/t/tag-history-average/112637/1 "2025-12-05T03:04:30Z")

</div>

Hello all,

I’m working on some tag history queries and I’m curious why I’m seeing a discrepancy between when I have the queryTagHistory function aggregate the simple average and when I get the values and calculate the simple average myself. It’s a small difference, but I don’t understand what might be causing it.

The script that I’m running:

```python
path = ['[default]316/Hydro/Lane 1/DRIVE_OUTPUT_FREQ']
startDate = system.date.addHours(system.date.now(), -8)
endDate = system.date.now()
aggregationMode = 'SimpleAverage'
average = system.tag.queryTagHistory(paths=path, startDate=startDate, endDate=endDate, aggregationMode=aggregationMode, returnSize=1)
dataset = system.tag.queryTagHistory(paths=path, startDate=startDate, endDate=endDate)
data = system.dataset.toPyDataSet(dataset)

pyaverage = system.dataset.toPyDataSet(average)

data
sums = 0
count = 0
for item in data:
    sums += item[1]
    count += 1

calcAvg = sums/count
pyAvg = pyaverage[0][1]
difference = abs(calcAvg - pyAvg)
'Calculated Avg = ' + str(calcAvg)
'Simple Average = ' + str(pyAvg)
'Difference = ' + str(difference)

```

This returns the following every time (I’m including the data from the dataset as well):

```python
> [[Thu Dec 04 13:56:44 EST 2025, 46.98334884643555], [Thu Dec 04 13:59:27 EST 2025, 46.27568054199219], [Thu Dec 04 13:59:30 EST 2025, 47.99862289428711], [Thu Dec 04 13:59:36 EST 2025, 46.52957534790039], [Thu Dec 04 14:03:52 EST 2025, 47.79416275024414], [Thu Dec 04 14:03:55 EST 2025, 45.62660598754883], [Thu Dec 04 14:04:04 EST 2025, 47.362735748291016], [Thu Dec 04 14:06:43 EST 2025, 46.46141052246094], [Thu Dec 04 14:07:44 EST 2025, 47.132850646972656], [Thu Dec 04 14:08:59 EST 2025, 45.69489669799805], [Thu Dec 04 14:09:02 EST 2025, 47.708099365234375], [Thu Dec 04 14:09:29 EST 2025, 46.661434173583984], [Thu Dec 04 14:16:55 EST 2025, 47.59531784057617], [Thu Dec 04 14:17:01 EST 2025, 45.718021392822266], [Thu Dec 04 14:17:04 EST 2025, 47.47039031982422], [Thu Dec 04 14:17:07 EST 2025, 45.97634506225586], [Thu Dec 04 14:17:25 EST 2025, 47.48807907104492], [Thu Dec 04 14:17:46 EST 2025, 46.2236213684082], [Thu Dec 04 14:18:01 EST 2025, 46.61347961425781], [Thu Dec 04 14:19:32 EST 2025, 46.18155288696289], [Thu Dec 04 14:20:14 EST 2025, 47.334739685058594], [Thu Dec 04 14:20:38 EST 2025, 46.05891036987305], [Thu Dec 04 14:20:41 EST 2025, 47.69902420043945], [Thu Dec 04 14:20:44 EST 2025, 46.01299285888672], [Thu Dec 04 14:20:56 EST 2025, 47.299495697021484], [Thu Dec 04 14:21:38 EST 2025, 47.73240661621094], [Thu Dec 04 14:21:41 EST 2025, 45.700714111328125], [Thu Dec 04 14:21:50 EST 2025, 47.46564865112305], [Thu Dec 04 14:21:53 EST 2025, 45.56600570678711], [Thu Dec 04 14:21:56 EST 2025, 47.967002868652344], [Thu Dec 04 14:22:08 EST 2025, 47.20979309082031], [Thu Dec 04 14:24:21 EST 2025, 47.25664520263672], [Thu Dec 04 14:27:06 EST 2025, 47.49977493286133], [Thu Dec 04 14:27:21 EST 2025, 46.54741668701172], [Thu Dec 04 14:28:18 EST 2025, 47.5872917175293], [Thu Dec 04 14:28:30 EST 2025, 46.510684967041016], [Thu Dec 04 14:29:19 EST 2025, 47.36219787597656], [Thu Dec 04 14:30:25 EST 2025, 46.23542785644531], [Thu Dec 04 14:30:52 EST 2025, 46.896881103515625], [Thu Dec 04 14:34:17 EST 2025, 47.143253326416016], [Thu Dec 04 14:36:15 EST 2025, 45.66246795654297], [Thu Dec 04 14:36:18 EST 2025, 47.549800872802734], [Thu Dec 04 14:36:30 EST 2025, 47.21089172363281], [Thu Dec 04 14:37:36 EST 2025, 47.66851043701172], [Thu Dec 04 14:37:39 EST 2025, 45.618839263916016], [Thu Dec 04 14:37:42 EST 2025, 47.774986267089844], [Thu Dec 04 14:37:51 EST 2025, 45.933868408203125], [Thu Dec 04 14:37:54 EST 2025, 47.18854904174805], [Thu Dec 04 14:38:51 EST 2025, 47.06993865966797], [Thu Dec 04 14:40:15 EST 2025, 47.71101379394531], [Thu Dec 04 14:40:18 EST 2025, 45.55598831176758], [Thu Dec 04 14:40:27 EST 2025, 47.09587860107422], [Thu Dec 04 14:41:19 EST 2025, 46.080909729003906], [Thu Dec 04 14:41:22 EST 2025, 47.663814544677734], [Thu Dec 04 14:41:34 EST 2025, 45.50700759887695], [Thu Dec 04 14:41:37 EST 2025, 47.14875793457031], [Thu Dec 04 14:43:04 EST 2025, 46.36251449584961], [Thu Dec 04 14:43:34 EST 2025, 47.67601013183594], [Thu Dec 04 14:44:22 EST 2025, 46.12061309814453], [Thu Dec 04 14:45:25 EST 2025, 47.76698303222656], [Thu Dec 04 14:45:28 EST 2025, 45.96742248535156], [Thu Dec 04 14:45:46 EST 2025, 47.63303756713867], [Thu Dec 04 14:45:55 EST 2025, 47.16328430175781], [Thu Dec 04 14:46:47 EST 2025, 47.93854522705078], [Thu Dec 04 14:46:50 EST 2025, 45.744293212890625], [Thu Dec 04 14:46:53 EST 2025, 48.02195739746094], [Thu Dec 04 14:46:59 EST 2025, 46.00933837890625], [Thu Dec 04 14:47:48 EST 2025, 47.22980499267578], [Thu Dec 04 14:47:51 EST 2025, 45.593719482421875], [Thu Dec 04 14:47:54 EST 2025, 47.13865280151367], [Thu Dec 04 14:48:30 EST 2025, 45.930294036865234], [Thu Dec 04 14:48:36 EST 2025, 48.1173210144043], [Thu Dec 04 14:48:39 EST 2025, 46.48741149902344], [Thu Dec 04 14:51:51 EST 2025, 46.17542266845703], [Thu Dec 04 14:51:54 EST 2025, 48.08400344848633], [Thu Dec 04 14:51:57 EST 2025, 46.09372329711914], [Thu Dec 04 14:52:00 EST 2025, 47.86171340942383], [Thu Dec 04 14:52:09 EST 2025, 46.30685806274414], [Thu Dec 04 14:52:25 EST 2025, 46.582801818847656], [Thu Dec 04 14:54:07 EST 2025, 46.56275177001953], [Thu Dec 04 14:54:25 EST 2025, 47.511985778808594], [Thu Dec 04 14:56:04 EST 2025, 46.298282623291016], [Thu Dec 04 14:56:07 EST 2025, 47.857749938964844], [Thu Dec 04 14:56:10 EST 2025, 45.78828048706055], [Thu Dec 04 14:56:16 EST 2025, 47.134613037109375], [Thu Dec 04 14:59:02 EST 2025, 46.204288482666016], [Thu Dec 04 14:59:05 EST 2025, 47.38050079345703], [Thu Dec 04 14:59:47 EST 2025, 45.833675384521484], [Thu Dec 04 14:59:50 EST 2025, 47.473243713378906], [Thu Dec 04 14:59:53 EST 2025, 45.59413146972656], [Thu Dec 04 15:00:11 EST 2025, 46.945152282714844], [Thu Dec 04 15:01:32 EST 2025, 47.14221954345703], [Thu Dec 04 15:01:38 EST 2025, 46.85291290283203], [Thu Dec 04 15:02:47 EST 2025, 46.00080490112305], [Thu Dec 04 15:03:58 EST 2025, 47.24273681640625], [Thu Dec 04 15:04:22 EST 2025, 46.967262268066406], [Thu Dec 04 15:05:19 EST 2025, 46.39208984375], [Thu Dec 04 15:05:28 EST 2025, 48.311561584472656], [Thu Dec 04 15:05:31 EST 2025, 46.28877258300781], [Thu Dec 04 15:05:43 EST 2025, 47.33297348022461], [Thu Dec 04 15:05:52 EST 2025, 46.99588394165039], [Thu Dec 04 15:10:29 EST 2025, 46.04734802246094], [Thu Dec 04 15:10:38 EST 2025, 48.078895568847656], [Thu Dec 04 15:10:41 EST 2025, 46.27861404418945], [Thu Dec 04 15:11:02 EST 2025, 47.462493896484375], [Thu Dec 04 15:11:14 EST 2025, 46.19480514526367], [Thu Dec 04 15:11:26 EST 2025, 46.45966720581055], [Thu Dec 04 15:14:59 EST 2025, 46.42288589477539], [Thu Dec 04 15:16:48 EST 2025, 47.55547332763672], [Thu Dec 04 15:17:00 EST 2025, 47.09760284423828], [Thu Dec 04 15:21:29 EST 2025, 46.33409881591797], [Thu Dec 04 15:22:23 EST 2025, 47.50423812866211], [Thu Dec 04 15:22:59 EST 2025, 46.62060546875], [Thu Dec 04 15:23:14 EST 2025, 46.576541900634766], [Thu Dec 04 15:24:08 EST 2025, 47.826927185058594], [Thu Dec 04 15:24:14 EST 2025, 45.77653121948242], [Thu Dec 04 15:24:17 EST 2025, 47.597190856933594], [Thu Dec 04 15:24:32 EST 2025, 46.27937316894531], [Thu Dec 04 15:26:29 EST 2025, 47.49794387817383], [Thu Dec 04 15:26:32 EST 2025, 46.04222869873047], [Thu Dec 04 15:26:42 EST 2025, 47.22065353393555], [Thu Dec 04 15:27:21 EST 2025, 45.965152740478516], [Thu Dec 04 15:27:30 EST 2025, 47.45490646362305], [Thu Dec 04 15:28:18 EST 2025, 46.08833694458008], [Thu Dec 04 15:28:24 EST 2025, 46.28999328613281], [Thu Dec 04 15:30:18 EST 2025, 47.436744689941406], [Thu Dec 04 15:30:21 EST 2025, 45.782493591308594], [Thu Dec 04 15:30:30 EST 2025, 47.5121955871582], [Thu Dec 04 15:30:33 EST 2025, 46.13022232055664], [Thu Dec 04 15:31:00 EST 2025, 47.6919059753418], [Thu Dec 04 15:31:09 EST 2025, 46.62355041503906], [Thu Dec 04 15:32:06 EST 2025, 47.36103439331055], [Thu Dec 04 15:32:30 EST 2025, 46.435302734375], [Thu Dec 04 15:32:56 EST 2025, 46.470794677734375], [Thu Dec 04 15:37:08 EST 2025, 47.205909729003906], [Thu Dec 04 15:38:29 EST 2025, 46.2726936340332], [Thu Dec 04 15:38:51 EST 2025, 47.62767791748047], [Thu Dec 04 15:40:51 EST 2025, 45.355125427246094], [Thu Dec 04 15:40:54 EST 2025, 47.64714050292969], [Thu Dec 04 15:41:09 EST 2025, 46.32932662963867], [Thu Dec 04 15:42:36 EST 2025, 47.217891693115234], [Thu Dec 04 15:43:57 EST 2025, 47.09811782836914], [Thu Dec 04 15:47:13 EST 2025, 47.68549346923828], [Thu Dec 04 15:47:16 EST 2025, 45.5410041809082], [Thu Dec 04 15:47:25 EST 2025, 48.07463073730469], [Thu Dec 04 15:47:34 EST 2025, 46.50251770019531], [Thu Dec 04 15:50:02 EST 2025, 48.13511657714844], [Thu Dec 04 15:50:09 EST 2025, 46.63682556152344], [Thu Dec 04 15:51:06 EST 2025, 47.268157958984375], [Thu Dec 04 15:51:18 EST 2025, 46.149375915527344], [Thu Dec 04 15:51:42 EST 2025, 47.597286224365234], [Thu Dec 04 15:52:06 EST 2025, 46.56608963012695], [Thu Dec 04 15:52:21 EST 2025, 47.99241256713867], [Thu Dec 04 15:52:24 EST 2025, 45.941837310791016], [Thu Dec 04 15:52:27 EST 2025, 47.990638732910156], [Thu Dec 04 15:52:42 EST 2025, 46.07080078125], [Thu Dec 04 15:52:45 EST 2025, 47.80990982055664], [Thu Dec 04 15:52:48 EST 2025, 45.43292236328125], [Thu Dec 04 15:52:51 EST 2025, 47.41161346435547], [Thu Dec 04 15:53:09 EST 2025, 47.16603088378906], [Thu Dec 04 15:54:27 EST 2025, 45.966644287109375], [Thu Dec 04 15:54:33 EST 2025, 47.957862854003906], [Thu Dec 04 15:54:36 EST 2025, 45.921268463134766], [Thu Dec 04 15:54:48 EST 2025, 47.885108947753906], [Thu Dec 04 15:55:15 EST 2025, 46.322086334228516], [Thu Dec 04 15:55:24 EST 2025, 47.251853942871094], [Thu Dec 04 15:56:04 EST 2025, 45.09432601928711], [Thu Dec 04 15:56:07 EST 2025, 47.23249053955078], [Thu Dec 04 15:56:25 EST 2025, 45.86875534057617], [Thu Dec 04 15:56:34 EST 2025, 47.352333068847656], [Thu Dec 04 15:57:01 EST 2025, 46.46088790893555], [Thu Dec 04 15:57:10 EST 2025, 47.46621322631836], [Thu Dec 04 15:57:31 EST 2025, 46.279212951660156], [Thu Dec 04 15:57:34 EST 2025, 47.531532287597656], [Thu Dec 04 15:57:37 EST 2025, 45.556697845458984], [Thu Dec 04 15:57:40 EST 2025, 47.87958908081055], [Thu Dec 04 15:57:43 EST 2025, 46.11418151855469], [Thu Dec 04 15:57:55 EST 2025, 47.592315673828125], [Thu Dec 04 16:00:01 EST 2025, 46.093257904052734], [Thu Dec 04 16:00:10 EST 2025, 47.90593338012695], [Thu Dec 04 16:00:28 EST 2025, 46.700660705566406], [Thu Dec 04 16:02:38 EST 2025, 47.629051208496094], [Thu Dec 04 16:02:41 EST 2025, 45.794071197509766], [Thu Dec 04 16:02:50 EST 2025, 47.25967025756836], [Thu Dec 04 16:03:11 EST 2025, 46.328739166259766], [Thu Dec 04 16:03:14 EST 2025, 47.831172943115234], [Thu Dec 04 16:03:17 EST 2025, 46.3115234375], [Thu Dec 04 16:03:20 EST 2025, 48.050811767578125], [Thu Dec 04 16:03:23 EST 2025, 46.300479888916016], [Thu Dec 04 16:03:44 EST 2025, 46.82675552368164], [Thu Dec 04 16:05:12 EST 2025, 47.675697326660156], [Thu Dec 04 16:05:15 EST 2025, 45.6332893371582], [Thu Dec 04 16:05:18 EST 2025, 46.97443389892578], [Thu Dec 04 16:06:27 EST 2025, 45.93950271606445], [Thu Dec 04 16:06:30 EST 2025, 47.84481430053711], [Thu Dec 04 16:06:33 EST 2025, 45.939727783203125], [Thu Dec 04 16:06:36 EST 2025, 47.31392288208008], [Thu Dec 04 16:08:22 EST 2025, 45.269046783447266], [Thu Dec 04 16:08:28 EST 2025, 47.753597259521484], [Thu Dec 04 16:08:52 EST 2025, 46.437992095947266], [Thu Dec 04 16:09:40 EST 2025, 47.424137115478516], [Thu Dec 04 16:09:52 EST 2025, 46.816158294677734], [Thu Dec 04 16:13:23 EST 2025, 46.64979934692383], [Thu Dec 04 16:13:26 EST 2025, 48.0799446105957], [Thu Dec 04 16:13:29 EST 2025, 46.17212677001953], [Thu Dec 04 16:13:50 EST 2025, 47.31455612182617], [Thu Dec 04 16:14:56 EST 2025, 47.1671028137207], [Thu Dec 04 16:15:29 EST 2025, 46.222835540771484], [Thu Dec 04 16:16:41 EST 2025, 47.86396026611328], [Thu Dec 04 16:16:44 EST 2025, 45.7034912109375], [Thu Dec 04 16:16:59 EST 2025, 47.09933853149414], [Thu Dec 04 16:26:26 EST 2025, 46.577606201171875], [Thu Dec 04 16:26:29 EST 2025, 47.77180099487305], [Thu Dec 04 16:26:32 EST 2025, 45.40517044067383], [Thu Dec 04 16:26:35 EST 2025, 47.61018371582031], [Thu Dec 04 16:26:56 EST 2025, 46.42325210571289], [Thu Dec 04 16:29:20 EST 2025, 46.614803314208984], [Thu Dec 04 16:32:48 EST 2025, 47.46504211425781], [Thu Dec 04 16:32:57 EST 2025, 46.22206115722656], [Thu Dec 04 16:35:44 EST 2025, 47.3664665222168], [Thu Dec 04 16:36:29 EST 2025, 46.22618103027344], [Thu Dec 04 16:36:32 EST 2025, 47.50592803955078], [Thu Dec 04 16:36:53 EST 2025, 45.688419342041016], [Thu Dec 04 16:36:56 EST 2025, 47.64204406738281], [Thu Dec 04 16:37:26 EST 2025, 45.72358703613281], [Thu Dec 04 16:37:44 EST 2025, 47.2235107421875], [Thu Dec 04 16:38:05 EST 2025, 45.94649124145508], [Thu Dec 04 16:38:11 EST 2025, 47.40217208862305], [Thu Dec 04 16:38:17 EST 2025, 45.8856086730957], [Thu Dec 04 16:38:23 EST 2025, 47.58566665649414], [Thu Dec 04 16:38:50 EST 2025, 46.19305419921875], [Thu Dec 04 16:40:47 EST 2025, 47.31653594970703], [Thu Dec 04 16:41:17 EST 2025, 46.523075103759766], [Thu Dec 04 16:44:48 EST 2025, 48.29185485839844], [Thu Dec 04 16:44:51 EST 2025, 46.170074462890625], [Thu Dec 04 16:45:45 EST 2025, 47.7791633605957], [Thu Dec 04 16:46:03 EST 2025, 48.53673553466797], [Thu Dec 04 16:46:36 EST 2025, 52.18955993652344], [Thu Dec 04 17:12:34 EST 2025, 50.167301177978516], [Thu Dec 04 17:15:58 EST 2025, 49.69611358642578], [Thu Dec 04 17:55:38 EST 2025, 46.07004165649414], [Thu Dec 04 17:55:41 EST 2025, 47.843841552734375], [Thu Dec 04 17:55:45 EST 2025, 46.08115768432617], [Thu Dec 04 17:56:18 EST 2025, 47.3884391784668], [Thu Dec 04 17:56:30 EST 2025, 46.22011184692383], [Thu Dec 04 17:56:39 EST 2025, 47.09139633178711], [Thu Dec 04 17:57:39 EST 2025, 45.73651885986328], [Thu Dec 04 17:57:42 EST 2025, 47.85816192626953], [Thu Dec 04 17:57:48 EST 2025, 47.38394546508789], [Thu Dec 04 17:58:24 EST 2025, 47.87290573120117], [Thu Dec 04 17:58:27 EST 2025, 45.828678131103516], [Thu Dec 04 17:58:42 EST 2025, 47.269752502441406], [Thu Dec 04 17:59:00 EST 2025, 46.00988006591797], [Thu Dec 04 17:59:09 EST 2025, 47.957542419433594], [Thu Dec 04 17:59:12 EST 2025, 46.63042449951172], [Thu Dec 04 18:04:55 EST 2025, 47.3066520690918], [Thu Dec 04 18:05:31 EST 2025, 46.080562591552734], [Thu Dec 04 18:06:19 EST 2025, 47.438594818115234], [Thu Dec 04 18:06:49 EST 2025, 46.53171157836914], [Thu Dec 04 18:09:42 EST 2025, 47.90958023071289], [Thu Dec 04 18:09:45 EST 2025, 46.04317855834961], [Thu Dec 04 18:10:21 EST 2025, 48.08060836791992], [Thu Dec 04 18:10:24 EST 2025, 46.18787384033203], [Thu Dec 04 18:11:06 EST 2025, 47.42878341674805], [Thu Dec 04 18:11:24 EST 2025, 46.04720687866211], [Thu Dec 04 18:11:33 EST 2025, 47.332801818847656], [Thu Dec 04 18:12:39 EST 2025, 46.09174728393555], [Thu Dec 04 18:12:51 EST 2025, 47.3135871887207], [Thu Dec 04 18:14:28 EST 2025, 46.312904357910156], [Thu Dec 04 18:14:43 EST 2025, 47.261199951171875], [Thu Dec 04 18:15:34 EST 2025, 46.40986251831055], [Thu Dec 04 18:16:34 EST 2025, 47.27790451049805], [Thu Dec 04 18:17:40 EST 2025, 46.82395553588867], [Thu Dec 04 18:19:58 EST 2025, 45.477962493896484], [Thu Dec 04 18:20:01 EST 2025, 47.78178405761719], [Thu Dec 04 18:20:07 EST 2025, 47.25088882446289], [Thu Dec 04 18:24:30 EST 2025, 46.08639907836914], [Thu Dec 04 18:24:33 EST 2025, 48.0147705078125], [Thu Dec 04 18:24:51 EST 2025, 46.05486297607422], [Thu Dec 04 18:25:30 EST 2025, 47.26300811767578], [Thu Dec 04 18:26:34 EST 2025, 45.95487976074219], [Thu Dec 04 18:27:16 EST 2025, 47.380592346191406], [Thu Dec 04 18:30:31 EST 2025, 46.41165542602539], [Thu Dec 04 18:30:40 EST 2025, 47.82911682128906], [Thu Dec 04 18:30:49 EST 2025, 46.48750305175781], [Thu Dec 04 18:30:55 EST 2025, 47.01919174194336], [Thu Dec 04 18:32:38 EST 2025, 46.85212326049805], [Thu Dec 04 18:32:41 EST 2025, 45.15773391723633], [Thu Dec 04 18:32:56 EST 2025, 47.24235534667969], [Thu Dec 04 18:39:07 EST 2025, 46.255950927734375], [Thu Dec 04 18:39:10 EST 2025, 48.048095703125], [Thu Dec 04 18:39:13 EST 2025, 46.38821792602539], [Thu Dec 04 18:39:43 EST 2025, 47.47113800048828], [Thu Dec 04 18:41:22 EST 2025, 46.34101867675781], [Thu Dec 04 18:43:01 EST 2025, 47.407196044921875], [Thu Dec 04 18:43:14 EST 2025, 46.05341339111328], [Thu Dec 04 18:43:53 EST 2025, 47.569976806640625], [Thu Dec 04 18:44:26 EST 2025, 46.00157165527344], [Thu Dec 04 18:44:29 EST 2025, 47.74413299560547], [Thu Dec 04 18:44:53 EST 2025, 46.56635284423828], [Thu Dec 04 18:56:29 EST 2025, 47.31626892089844], [Thu Dec 04 18:56:47 EST 2025, 48.28163528442383], [Thu Dec 04 18:58:53 EST 2025, 47.48373794555664], [Thu Dec 04 18:59:05 EST 2025, 50.05424118041992], [Thu Dec 04 19:00:29 EST 2025, 50.70169448852539], [Thu Dec 04 19:00:51 EST 2025, 52.18955993652344], [Thu Dec 04 19:03:39 EST 2025, 52.18955993652344], [Thu Dec 04 19:14:48 EST 2025, 50.23786163330078], [Thu Dec 04 19:15:12 EST 2025, 49.03375244140625], [Thu Dec 04 19:31:01 EST 2025, 46.86906433105469], [Thu Dec 04 19:36:20 EST 2025, 45.961421966552734], [Thu Dec 04 19:36:24 EST 2025, 48.0367431640625], [Thu Dec 04 19:36:30 EST 2025, 46.71452331542969], [Thu Dec 04 19:37:09 EST 2025, 47.6085090637207], [Thu Dec 04 19:38:18 EST 2025, 46.54679870605469], [Thu Dec 04 19:44:10 EST 2025, 47.724205017089844], [Thu Dec 04 19:44:13 EST 2025, 46.12644958496094], [Thu Dec 04 19:44:19 EST 2025, 47.18888473510742], [Thu Dec 04 19:49:30 EST 2025, 45.95455551147461], [Thu Dec 04 19:49:36 EST 2025, 48.1844482421875], [Thu Dec 04 19:49:39 EST 2025, 46.155845642089844], [Thu Dec 04 19:50:15 EST 2025, 46.810394287109375], [Thu Dec 04 19:55:49 EST 2025, 46.99318313598633], [Thu Dec 04 20:09:22 EST 2025, 46.50411605834961], [Thu Dec 04 20:09:28 EST 2025, 46.74446105957031], [Thu Dec 04 20:11:05 EST 2025, 47.13508987426758], [Thu Dec 04 20:12:59 EST 2025, 46.459102630615234], [Thu Dec 04 20:13:23 EST 2025, 47.88423538208008], [Thu Dec 04 20:13:26 EST 2025, 46.42216110229492], [Thu Dec 04 20:14:26 EST 2025, 47.451820373535156], [Thu Dec 04 20:14:50 EST 2025, 46.363956451416016], [Thu Dec 04 20:16:22 EST 2025, 47.50119400024414], [Thu Dec 04 20:16:34 EST 2025, 46.35538864135742], [Thu Dec 04 20:16:58 EST 2025, 47.597862243652344], [Thu Dec 04 20:17:13 EST 2025, 46.60463333129883], [Thu Dec 04 20:18:37 EST 2025, 47.47768020629883], [Thu Dec 04 20:19:34 EST 2025, 46.44517517089844], [Thu Dec 04 20:22:38 EST 2025, 47.92182540893555], [Thu Dec 04 20:22:41 EST 2025, 46.21126937866211], [Thu Dec 04 20:23:05 EST 2025, 47.63313293457031], [Thu Dec 04 20:24:02 EST 2025, 46.28367614746094], [Thu Dec 04 20:24:23 EST 2025, 47.33415985107422], [Thu Dec 04 20:25:32 EST 2025, 46.445152282714844], [Thu Dec 04 20:26:02 EST 2025, 47.656673431396484], [Thu Dec 04 20:27:51 EST 2025, 46.56018829345703], [Thu Dec 04 20:29:57 EST 2025, 47.7087516784668], [Thu Dec 04 20:30:12 EST 2025, 46.50257873535156], [Thu Dec 04 20:32:25 EST 2025, 47.4967155456543], [Thu Dec 04 20:32:53 EST 2025, 46.35053634643555], [Thu Dec 04 20:34:17 EST 2025, 47.506439208984375], [Thu Dec 04 20:35:44 EST 2025, 46.08468246459961], [Thu Dec 04 20:35:53 EST 2025, 47.393707275390625], [Thu Dec 04 20:37:14 EST 2025, 46.553855895996094], [Thu Dec 04 20:39:18 EST 2025, 47.34282684326172], [Thu Dec 04 20:43:15 EST 2025, 46.38200378417969], [Thu Dec 04 20:43:18 EST 2025, 47.990333557128906], [Thu Dec 04 20:43:21 EST 2025, 46.1215705871582], [Thu Dec 04 20:43:24 EST 2025, 47.8768424987793], [Thu Dec 04 20:43:36 EST 2025, 46.545143127441406], [Thu Dec 04 20:44:16 EST 2025, 47.00385665893555], [Thu Dec 04 21:04:24 EST 2025, 47.68045425415039], [Thu Dec 04 21:04:42 EST 2025, 45.965576171875], [Thu Dec 04 21:04:45 EST 2025, 47.685428619384766], [Thu Dec 04 21:05:21 EST 2025, 46.71894073486328], [Thu Dec 04 21:11:47 EST 2025, 47.384521484375], [Thu Dec 04 21:12:02 EST 2025, 46.220916748046875], [Thu Dec 04 21:13:47 EST 2025, 47.512935638427734], [Thu Dec 04 21:14:08 EST 2025, 46.11501693725586], [Thu Dec 04 21:14:11 EST 2025, 47.60273742675781], [Thu Dec 04 21:15:54 EST 2025, 46.676124572753906], [Thu Dec 04 21:19:54 EST 2025, 47.5144157409668], [Thu Dec 04 21:20:36 EST 2025, 46.03337478637695], [Thu Dec 04 21:20:57 EST 2025, 47.54075241088867], [Thu Dec 04 21:21:06 EST 2025, 46.365150451660156], [Thu Dec 04 21:24:05 EST 2025, 47.18470001220703], [Thu Dec 04 21:25:35 EST 2025, 46.6080322265625], [Thu Dec 04 21:31:51 EST 2025, 47.42105484008789], [Thu Dec 04 21:33:22 EST 2025, 46.30924606323242], [Thu Dec 04 21:34:37 EST 2025, 47.45130920410156], [Thu Dec 04 21:34:40 EST 2025, 46.1158332824707], [Thu Dec 04 21:34:46 EST 2025, 46.74706268310547], [Thu Dec 04 21:35:46 EST 2025, 46.84524917602539], [Thu Dec 04 21:38:48 EST 2025, 47.481056213378906], [Thu Dec 04 21:38:51 EST 2025, 45.87385559082031], [Thu Dec 04 21:38:57 EST 2025, 47.23835372924805], [Thu Dec 04 21:41:09 EST 2025, 46.5411491394043], [Thu Dec 04 21:41:57 EST 2025, 47.49198532104492], [Thu Dec 04 21:42:33 EST 2025, 47.72723388671875], [Thu Dec 04 21:43:30 EST 2025, 52.18955993652344], [Thu Dec 04 21:56:23 EST 2025, 52.18955993652344]]
> 'Calculated Avg = 46.9925031222'
> 'Simple Average = 46.979143079'
> 'Difference = 0.0133600432245'

```

This isn’t a big deal obviously, but any insight would be appreciated.

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [December 5, 2025, 4:29am UTC](https://forum.inductiveautomation.com/t/tag-history-average/112637/2 "2025-12-05T04:29:41Z")

</div>

Hi, Philip. If you edit your post to format your return data as \</\> **preformatted text** (as you did with the script) rather than as a quotation, it will limit the post length and add a scroll bar to that section. As it is, it's 393 lines long on my portrait monitor. Thanks.

---

<div class="post-metadata">

**Author:** ![JVDM](https://avatars.discourse-cdn.com/v4/letter/j/ac8455/32.png) [@JVDM](https://forum.inductiveautomation.com/u/JVDM)\
**Post date:** [December 5, 2025, 10:38am UTC](https://forum.inductiveautomation.com/t/tag-history-average/112637/3 "2025-12-05T10:38:38Z")

</div>

This indeed is a very small difference, which makes me suspect it is a rounding error.

The Simple Average answer is one decimal shorter than your Calculated Avg, which makes me think calculations are done with one less decimal. I’m not sure how many records you have in this calculation, a few hundred small differences could just add up to 0,013.

Edit: I just noticed the following:

- 52.18955993652344 ← used in your data
- 46.9925031222 ← calculated average
- 46.979143079 ← Simple Average

I was doubtful that a few hundred of one-decimal differences could add up to 0.013, but it seems there are about 5 decimals missing, making me a bit more confident in this suspicion.

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [December 5, 2025, 5:22pm UTC](https://forum.inductiveautomation.com/t/tag-history-average/112637/4 "2025-12-05T17:22:20Z")

</div>

> [@Philip\_Knowlton](#):
>
> `> 'Simple Average = 46.979143079'`

This is the value you get by averaging your input dataset, excluding the final row.

The historian does some complicated stuff I've never fully understood that includes or excludes certain values based on complicated internal logic. I don't think you've found a bug, although I'm not the person to explain all the nuances of this behavior 🤷

[Live Code](https://play.kotlinlang.org/#eyJ2ZXJzaW9uIjoiMi4yLjIxIiwicGxhdGZvcm0iOiJqYXZhIiwiYXJncyI6IiIsIm5vbmVNYXJrZXJzIjp0cnVlLCJ0aGVtZSI6ImlkZWEiLCJjb2RlIjoidmFsIGRhdGEgPSBhcnJheU9mKFxuICAgIDQ2Ljk4MzM0ODg0NjQzNTU1LFxuICAgIDQ2LjI3NTY4MDU0MTk5MjE5LFxuICAgIDQ3Ljk5ODYyMjg5NDI4NzExLFxuICAgIDQ2LjUyOTU3NTM0NzkwMDM5LFxuICAgIDQ3Ljc5NDE2Mjc1MDI0NDE0LFxuICAgIDQ1LjYyNjYwNTk4NzU0ODgzLFxuICAgIDQ3LjM2MjczNTc0ODI5MTAxNixcbiAgICA0Ni40NjE0MTA1MjI0NjA5NCxcbiAgICA0Ny4xMzI4NTA2NDY5NzI2NTYsXG4gICAgNDUuNjk0ODk2Njk3OTk4MDUsXG4gICAgNDcuNzA4MDk5MzY1MjM0Mzc1LFxuICAgIDQ2LjY2MTQzNDE3MzU4Mzk4NCxcbiAgICA0Ny41OTUzMTc4NDA1NzYxNyxcbiAgICA0NS43MTgwMjEzOTI4MjIyNjYsXG4gICAgNDcuNDcwMzkwMzE5ODI0MjIsXG4gICAgNDUuOTc2MzQ1MDYyMjU1ODYsXG4gICAgNDcuNDg4MDc5MDcxMDQ0OTIsXG4gICAgNDYuMjIzNjIxMzY4NDA4MixcbiAgICA0Ni42MTM0Nzk2MTQyNTc4MSxcbiAgICA0Ni4xODE1NTI4ODY5NjI4OSxcbiAgICA0Ny4zMzQ3Mzk2ODUwNTg1OTQsXG4gICAgNDYuMDU4OTEwMzY5ODczMDUsXG4gICAgNDcuNjk5MDI0MjAwNDM5NDUsXG4gICAgNDYuMDEyOTkyODU4ODg2NzIsXG4gICAgNDcuMjk5NDk1Njk3MDIxNDg0LFxuICAgIDQ3LjczMjQwNjYxNjIxMDk0LFxuICAgIDQ1LjcwMDcxNDExMTMyODEyNSxcbiAgICA0Ny40NjU2NDg2NTExMjMwNSxcbiAgICA0NS41NjYwMDU3MDY3ODcxMSxcbiAgICA0Ny45NjcwMDI4Njg2NTIzNDQsXG4gICAgNDcuMjA5NzkzMDkwODIwMzEsXG4gICAgNDcuMjU2NjQ1MjAyNjM2NzIsXG4gICAgNDcuNDk5Nzc0OTMyODYxMzMsXG4gICAgNDYuNTQ3NDE2Njg3MDExNzIsXG4gICAgNDcuNTg3MjkxNzE3NTI5MyxcbiAgICA0Ni41MTA2ODQ5NjcwNDEwMTYsXG4gICAgNDcuMzYyMTk3ODc1OTc2NTYsXG4gICAgNDYuMjM1NDI3ODU2NDQ1MzEsXG4gICAgNDYuODk2ODgxMTAzNTE1NjI1LFxuICAgIDQ3LjE0MzI1MzMyNjQxNjAxNixcbiAgICA0NS42NjI0Njc5NTY1NDI5NyxcbiAgICA0Ny41NDk4MDA4NzI4MDI3MzQsXG4gICAgNDcuMjEwODkxNzIzNjMyODEsXG4gICAgNDcuNjY4NTEwNDM3MDExNzIsXG4gICAgNDUuNjE4ODM5MjYzOTE2MDE2LFxuICAgIDQ3Ljc3NDk4NjI2NzA4OTg0NCxcbiAgICA0NS45MzM4Njg0MDgyMDMxMjUsXG4gICAgNDcuMTg4NTQ5MDQxNzQ4MDUsXG4gICAgNDcuMDY5OTM4NjU5NjY3OTcsXG4gICAgNDcuNzExMDEzNzkzOTQ1MzEsXG4gICAgNDUuNTU1OTg4MzExNzY3NTgsXG4gICAgNDcuMDk1ODc4NjAxMDc0MjIsXG4gICAgNDYuMDgwOTA5NzI5MDAzOTA2LFxuICAgIDQ3LjY2MzgxNDU0NDY3NzczNCxcbiAgICA0NS41MDcwMDc1OTg4NzY5NSxcbiAgICA0Ny4xNDg3NTc5MzQ1NzAzMSxcbiAgICA0Ni4zNjI1MTQ0OTU4NDk2MSxcbiAgICA0Ny42NzYwMTAxMzE4MzU5NCxcbiAgICA0Ni4xMjA2MTMwOTgxNDQ1MyxcbiAgICA0Ny43NjY5ODMwMzIyMjY1NixcbiAgICA0NS45Njc0MjI0ODUzNTE1NixcbiAgICA0Ny42MzMwMzc1NjcxMzg2NyxcbiAgICA0Ny4xNjMyODQzMDE3NTc4MSxcbiAgICA0Ny45Mzg1NDUyMjcwNTA3OCxcbiAgICA0NS43NDQyOTMyMTI4OTA2MjUsXG4gICAgNDguMDIxOTU3Mzk3NDYwOTQsXG4gICAgNDYuMDA5MzM4Mzc4OTA2MjUsXG4gICAgNDcuMjI5ODA0OTkyNjc1NzgsXG4gICAgNDUuNTkzNzE5NDgyNDIxODc1LFxuICAgIDQ3LjEzODY1MjgwMTUxMzY3LFxuICAgIDQ1LjkzMDI5NDAzNjg2NTIzNCxcbiAgICA0OC4xMTczMjEwMTQ0MDQzLFxuICAgIDQ2LjQ4NzQxMTQ5OTAyMzQ0LFxuICAgIDQ2LjE3NTQyMjY2ODQ1NzAzLFxuICAgIDQ4LjA4NDAwMzQ0ODQ4NjMzLFxuICAgIDQ2LjA5MzcyMzI5NzExOTE0LFxuICAgIDQ3Ljg2MTcxMzQwOTQyMzgzLFxuICAgIDQ2LjMwNjg1ODA2Mjc0NDE0LFxuICAgIDQ2LjU4MjgwMTgxODg0NzY1NixcbiAgICA0Ni41NjI3NTE3NzAwMTk1MyxcbiAgICA0Ny41MTE5ODU3Nzg4MDg1OTQsXG4gICAgNDYuMjk4MjgyNjIzMjkxMDE2LFxuICAgIDQ3Ljg1Nzc0OTkzODk2NDg0NCxcbiAgICA0NS43ODgyODA0ODcwNjA1NSxcbiAgICA0Ny4xMzQ2MTMwMzcxMDkzNzUsXG4gICAgNDYuMjA0Mjg4NDgyNjY2MDE2LFxuICAgIDQ3LjM4MDUwMDc5MzQ1NzAzLFxuICAgIDQ1LjgzMzY3NTM4NDUyMTQ4NCxcbiAgICA0Ny40NzMyNDM3MTMzNzg5MDYsXG4gICAgNDUuNTk0MTMxNDY5NzI2NTYsXG4gICAgNDYuOTQ1MTUyMjgyNzE0ODQ0LFxuICAgIDQ3LjE0MjIxOTU0MzQ1NzAzLFxuICAgIDQ2Ljg1MjkxMjkwMjgzMjAzLFxuICAgIDQ2LjAwMDgwNDkwMTEyMzA1LFxuICAgIDQ3LjI0MjczNjgxNjQwNjI1LFxuICAgIDQ2Ljk2NzI2MjI2ODA2NjQwNixcbiAgICA0Ni4zOTIwODk4NDM3NSxcbiAgICA0OC4zMTE1NjE1ODQ0NzI2NTYsXG4gICAgNDYuMjg4NzcyNTgzMDA3ODEsXG4gICAgNDcuMzMyOTczNDgwMjI0NjEsXG4gICAgNDYuOTk1ODgzOTQxNjUwMzksXG4gICAgNDYuMDQ3MzQ4MDIyNDYwOTQsXG4gICAgNDguMDc4ODk1NTY4ODQ3NjU2LFxuICAgIDQ2LjI3ODYxNDA0NDE4OTQ1LFxuICAgIDQ3LjQ2MjQ5Mzg5NjQ4NDM3NSxcbiAgICA0Ni4xOTQ4MDUxNDUyNjM2NyxcbiAgICA0Ni40NTk2NjcyMDU4MTA1NSxcbiAgICA0Ni40MjI4ODU4OTQ3NzUzOSxcbiAgICA0Ny41NTU0NzMzMjc2MzY3MixcbiAgICA0Ny4wOTc2MDI4NDQyMzgyOCxcbiAgICA0Ni4zMzQwOTg4MTU5MTc5NyxcbiAgICA0Ny41MDQyMzgxMjg2NjIxMSxcbiAgICA0Ni42MjA2MDU0Njg3NSxcbiAgICA0Ni41NzY1NDE5MDA2MzQ3NjYsXG4gICAgNDcuODI2OTI3MTg1MDU4NTk0LFxuICAgIDQ1Ljc3NjUzMTIxOTQ4MjQyLFxuICAgIDQ3LjU5NzE5MDg1NjkzMzU5NCxcbiAgICA0Ni4yNzkzNzMxNjg5NDUzMSxcbiAgICA0Ny40OTc5NDM4NzgxNzM4MyxcbiAgICA0Ni4wNDIyMjg2OTg3MzA0NyxcbiAgICA0Ny4yMjA2NTM1MzM5MzU1NSxcbiAgICA0NS45NjUxNTI3NDA0Nzg1MTYsXG4gICAgNDcuNDU0OTA2NDYzNjIzMDUsXG4gICAgNDYuMDg4MzM2OTQ0NTgwMDgsXG4gICAgNDYuMjg5OTkzMjg2MTMyODEsXG4gICAgNDcuNDM2NzQ0Njg5OTQxNDA2LFxuICAgIDQ1Ljc4MjQ5MzU5MTMwODU5NCxcbiAgICA0Ny41MTIxOTU1ODcxNTgyLFxuICAgIDQ2LjEzMDIyMjMyMDU1NjY0LFxuICAgIDQ3LjY5MTkwNTk3NTM0MTgsXG4gICAgNDYuNjIzNTUwNDE1MDM5MDYsXG4gICAgNDcuMzYxMDM0MzkzMzEwNTUsXG4gICAgNDYuNDM1MzAyNzM0Mzc1LFxuICAgIDQ2LjQ3MDc5NDY3NzczNDM3NSxcbiAgICA0Ny4yMDU5MDk3MjkwMDM5MDYsXG4gICAgNDYuMjcyNjkzNjM0MDMzMixcbiAgICA0Ny42Mjc2Nzc5MTc0ODA0NyxcbiAgICA0NS4zNTUxMjU0MjcyNDYwOTQsXG4gICAgNDcuNjQ3MTQwNTAyOTI5NjksXG4gICAgNDYuMzI5MzI2NjI5NjM4NjcsXG4gICAgNDcuMjE3ODkxNjkzMTE1MjM0LFxuICAgIDQ3LjA5ODExNzgyODM2OTE0LFxuICAgIDQ3LjY4NTQ5MzQ2OTIzODI4LFxuICAgIDQ1LjU0MTAwNDE4MDkwODIsXG4gICAgNDguMDc0NjMwNzM3MzA0NjksXG4gICAgNDYuNTAyNTE3NzAwMTk1MzEsXG4gICAgNDguMTM1MTE2NTc3MTQ4NDQsXG4gICAgNDYuNjM2ODI1NTYxNTIzNDQsXG4gICAgNDcuMjY4MTU3OTU4OTg0Mzc1LFxuICAgIDQ2LjE0OTM3NTkxNTUyNzM0NCxcbiAgICA0Ny41OTcyODYyMjQzNjUyMzQsXG4gICAgNDYuNTY2MDg5NjMwMTI2OTUsXG4gICAgNDcuOTkyNDEyNTY3MTM4NjcsXG4gICAgNDUuOTQxODM3MzEwNzkxMDE2LFxuICAgIDQ3Ljk5MDYzODczMjkxMDE1NixcbiAgICA0Ni4wNzA4MDA3ODEyNSxcbiAgICA0Ny44MDk5MDk4MjA1NTY2NCxcbiAgICA0NS40MzI5MjIzNjMyODEyNSxcbiAgICA0Ny40MTE2MTM0NjQzNTU0NyxcbiAgICA0Ny4xNjYwMzA4ODM3ODkwNixcbiAgICA0NS45NjY2NDQyODcxMDkzNzUsXG4gICAgNDcuOTU3ODYyODU0MDAzOTA2LFxuICAgIDQ1LjkyMTI2ODQ2MzEzNDc2NixcbiAgICA0Ny44ODUxMDg5NDc3NTM5MDYsXG4gICAgNDYuMzIyMDg2MzM0MjI4NTE2LFxuICAgIDQ3LjI1MTg1Mzk0Mjg3MTA5NCxcbiAgICA0NS4wOTQzMjYwMTkyODcxMSxcbiAgICA0Ny4yMzI0OTA1Mzk1NTA3OCxcbiAgICA0NS44Njg3NTUzNDA1NzYxNyxcbiAgICA0Ny4zNTIzMzMwNjg4NDc2NTYsXG4gICAgNDYuNDYwODg3OTA4OTM1NTUsXG4gICAgNDcuNDY2MjEzMjI2MzE4MzYsXG4gICAgNDYuMjc5MjEyOTUxNjYwMTU2LFxuICAgIDQ3LjUzMTUzMjI4NzU5NzY1NixcbiAgICA0NS41NTY2OTc4NDU0NTg5ODQsXG4gICAgNDcuODc5NTg5MDgwODEwNTUsXG4gICAgNDYuMTE0MTgxNTE4NTU0NjksXG4gICAgNDcuNTkyMzE1NjczODI4MTI1LFxuICAgIDQ2LjA5MzI1NzkwNDA1MjczNCxcbiAgICA0Ny45MDU5MzMzODAxMjY5NSxcbiAgICA0Ni43MDA2NjA3MDU1NjY0MDYsXG4gICAgNDcuNjI5MDUxMjA4NDk2MDk0LFxuICAgIDQ1Ljc5NDA3MTE5NzUwOTc2NixcbiAgICA0Ny4yNTk2NzAyNTc1NjgzNixcbiAgICA0Ni4zMjg3MzkxNjYyNTk3NjYsXG4gICAgNDcuODMxMTcyOTQzMTE1MjM0LFxuICAgIDQ2LjMxMTUyMzQzNzUsXG4gICAgNDguMDUwODExNzY3NTc4MTI1LFxuICAgIDQ2LjMwMDQ3OTg4ODkxNjAxNixcbiAgICA0Ni44MjY3NTU1MjM2ODE2NCxcbiAgICA0Ny42NzU2OTczMjY2NjAxNTYsXG4gICAgNDUuNjMzMjg5MzM3MTU4MixcbiAgICA0Ni45NzQ0MzM4OTg5MjU3OCxcbiAgICA0NS45Mzk1MDI3MTYwNjQ0NSxcbiAgICA0Ny44NDQ4MTQzMDA1MzcxMSxcbiAgICA0NS45Mzk3Mjc3ODMyMDMxMjUsXG4gICAgNDcuMzEzOTIyODgyMDgwMDgsXG4gICAgNDUuMjY5MDQ2NzgzNDQ3MjY2LFxuICAgIDQ3Ljc1MzU5NzI1OTUyMTQ4NCxcbiAgICA0Ni40Mzc5OTIwOTU5NDcyNjYsXG4gICAgNDcuNDI0MTM3MTE1NDc4NTE2LFxuICAgIDQ2LjgxNjE1ODI5NDY3NzczNCxcbiAgICA0Ni42NDk3OTkzNDY5MjM4MyxcbiAgICA0OC4wNzk5NDQ2MTA1OTU3LFxuICAgIDQ2LjE3MjEyNjc3MDAxOTUzLFxuICAgIDQ3LjMxNDU1NjEyMTgyNjE3LFxuICAgIDQ3LjE2NzEwMjgxMzcyMDcsXG4gICAgNDYuMjIyODM1NTQwNzcxNDg0LFxuICAgIDQ3Ljg2Mzk2MDI2NjExMzI4LFxuICAgIDQ1LjcwMzQ5MTIxMDkzNzUsXG4gICAgNDcuMDk5MzM4NTMxNDk0MTQsXG4gICAgNDYuNTc3NjA2MjAxMTcxODc1LFxuICAgIDQ3Ljc3MTgwMDk5NDg3MzA1LFxuICAgIDQ1LjQwNTE3MDQ0MDY3MzgzLFxuICAgIDQ3LjYxMDE4MzcxNTgyMDMxLFxuICAgIDQ2LjQyMzI1MjEwNTcxMjg5LFxuICAgIDQ2LjYxNDgwMzMxNDIwODk4NCxcbiAgICA0Ny40NjUwNDIxMTQyNTc4MSxcbiAgICA0Ni4yMjIwNjExNTcyMjY1NixcbiAgICA0Ny4zNjY0NjY1MjIyMTY4LFxuICAgIDQ2LjIyNjE4MTAzMDI3MzQ0LFxuICAgIDQ3LjUwNTkyODAzOTU1MDc4LFxuICAgIDQ1LjY4ODQxOTM0MjA0MTAxNixcbiAgICA0Ny42NDIwNDQwNjczODI4MSxcbiAgICA0NS43MjM1ODcwMzYxMzI4MSxcbiAgICA0Ny4yMjM1MTA3NDIxODc1LFxuICAgIDQ1Ljk0NjQ5MTI0MTQ1NTA4LFxuICAgIDQ3LjQwMjE3MjA4ODYyMzA1LFxuICAgIDQ1Ljg4NTYwODY3MzA5NTcsXG4gICAgNDcuNTg1NjY2NjU2NDk0MTQsXG4gICAgNDYuMTkzMDU0MTk5MjE4NzUsXG4gICAgNDcuMzE2NTM1OTQ5NzA3MDMsXG4gICAgNDYuNTIzMDc1MTAzNzU5NzY2LFxuICAgIDQ4LjI5MTg1NDg1ODM5ODQ0LFxuICAgIDQ2LjE3MDA3NDQ2Mjg5MDYyNSxcbiAgICA0Ny43NzkxNjMzNjA1OTU3LFxuICAgIDQ4LjUzNjczNTUzNDY2Nzk3LFxuICAgIDUyLjE4OTU1OTkzNjUyMzQ0LFxuICAgIDUwLjE2NzMwMTE3Nzk3ODUxNixcbiAgICA0OS42OTYxMTM1ODY0MjU3OCxcbiAgICA0Ni4wNzAwNDE2NTY0OTQxNCxcbiAgICA0Ny44NDM4NDE1NTI3MzQzNzUsXG4gICAgNDYuMDgxMTU3Njg0MzI2MTcsXG4gICAgNDcuMzg4NDM5MTc4NDY2OCxcbiAgICA0Ni4yMjAxMTE4NDY5MjM4MyxcbiAgICA0Ny4wOTEzOTYzMzE3ODcxMSxcbiAgICA0NS43MzY1MTg4NTk4NjMyOCxcbiAgICA0Ny44NTgxNjE5MjYyNjk1MyxcbiAgICA0Ny4zODM5NDU0NjUwODc4OSxcbiAgICA0Ny44NzI5MDU3MzEyMDExNyxcbiAgICA0NS44Mjg2NzgxMzExMDM1MTYsXG4gICAgNDcuMjY5NzUyNTAyNDQxNDA2LFxuICAgIDQ2LjAwOTg4MDA2NTkxNzk3LFxuICAgIDQ3Ljk1NzU0MjQxOTQzMzU5NCxcbiAgICA0Ni42MzA0MjQ0OTk1MTE3MixcbiAgICA0Ny4zMDY2NTIwNjkwOTE4LFxuICAgIDQ2LjA4MDU2MjU5MTU1MjczNCxcbiAgICA0Ny40Mzg1OTQ4MTgxMTUyMzQsXG4gICAgNDYuNTMxNzExNTc4MzY5MTQsXG4gICAgNDcuOTA5NTgwMjMwNzEyODksXG4gICAgNDYuMDQzMTc4NTU4MzQ5NjEsXG4gICAgNDguMDgwNjA4MzY3OTE5OTIsXG4gICAgNDYuMTg3ODczODQwMzMyMDMsXG4gICAgNDcuNDI4NzgzNDE2NzQ4MDUsXG4gICAgNDYuMDQ3MjA2ODc4NjYyMTEsXG4gICAgNDcuMzMyODAxODE4ODQ3NjU2LFxuICAgIDQ2LjA5MTc0NzI4MzkzNTU1LFxuICAgIDQ3LjMxMzU4NzE4ODcyMDcsXG4gICAgNDYuMzEyOTA0MzU3OTEwMTU2LFxuICAgIDQ3LjI2MTE5OTk1MTE3MTg3NSxcbiAgICA0Ni40MDk4NjI1MTgzMTA1NSxcbiAgICA0Ny4yNzc5MDQ1MTA0OTgwNSxcbiAgICA0Ni44MjM5NTU1MzU4ODg2NyxcbiAgICA0NS40Nzc5NjI0OTM4OTY0ODQsXG4gICAgNDcuNzgxNzg0MDU3NjE3MTksXG4gICAgNDcuMjUwODg4ODI0NDYyODksXG4gICAgNDYuMDg2Mzk5MDc4MzY5MTQsXG4gICAgNDguMDE0NzcwNTA3ODEyNSxcbiAgICA0Ni4wNTQ4NjI5NzYwNzQyMixcbiAgICA0Ny4yNjMwMDgxMTc2NzU3OCxcbiAgICA0NS45NTQ4Nzk3NjA3NDIxOSxcbiAgICA0Ny4zODA1OTIzNDYxOTE0MDYsXG4gICAgNDYuNDExNjU1NDI2MDI1MzksXG4gICAgNDcuODI5MTE2ODIxMjg5MDYsXG4gICAgNDYuNDg3NTAzMDUxNzU3ODEsXG4gICAgNDcuMDE5MTkxNzQxOTQzMzYsXG4gICAgNDYuODUyMTIzMjYwNDk4MDUsXG4gICAgNDUuMTU3NzMzOTE3MjM2MzMsXG4gICAgNDcuMjQyMzU1MzQ2Njc5NjksXG4gICAgNDYuMjU1OTUwOTI3NzM0Mzc1LFxuICAgIDQ4LjA0ODA5NTcwMzEyNSxcbiAgICA0Ni4zODgyMTc5MjYwMjUzOSxcbiAgICA0Ny40NzExMzgwMDA0ODgyOCxcbiAgICA0Ni4zNDEwMTg2NzY3NTc4MSxcbiAgICA0Ny40MDcxOTYwNDQ5MjE4NzUsXG4gICAgNDYuMDUzNDEzMzkxMTEzMjgsXG4gICAgNDcuNTY5OTc2ODA2NjQwNjI1LFxuICAgIDQ2LjAwMTU3MTY1NTI3MzQ0LFxuICAgIDQ3Ljc0NDEzMjk5NTYwNTQ3LFxuICAgIDQ2LjU2NjM1Mjg0NDIzODI4LFxuICAgIDQ3LjMxNjI2ODkyMDg5ODQ0LFxuICAgIDQ4LjI4MTYzNTI4NDQyMzgzLFxuICAgIDQ3LjQ4MzczNzk0NTU1NjY0LFxuICAgIDUwLjA1NDI0MTE4MDQxOTkyLFxuICAgIDUwLjcwMTY5NDQ4ODUyNTM5LFxuICAgIDUyLjE4OTU1OTkzNjUyMzQ0LFxuICAgIDUyLjE4OTU1OTkzNjUyMzQ0LFxuICAgIDUwLjIzNzg2MTYzMzMwMDc4LFxuICAgIDQ5LjAzMzc1MjQ0MTQwNjI1LFxuICAgIDQ2Ljg2OTA2NDMzMTA1NDY5LFxuICAgIDQ1Ljk2MTQyMTk2NjU1MjczNCxcbiAgICA0OC4wMzY3NDMxNjQwNjI1LFxuICAgIDQ2LjcxNDUyMzMxNTQyOTY5LFxuICAgIDQ3LjYwODUwOTA2MzcyMDcsXG4gICAgNDYuNTQ2Nzk4NzA2MDU0NjksXG4gICAgNDcuNzI0MjA1MDE3MDg5ODQ0LFxuICAgIDQ2LjEyNjQ0OTU4NDk2MDk0LFxuICAgIDQ3LjE4ODg4NDczNTEwNzQyLFxuICAgIDQ1Ljk1NDU1NTUxMTQ3NDYxLFxuICAgIDQ4LjE4NDQ0ODI0MjE4NzUsXG4gICAgNDYuMTU1ODQ1NjQyMDg5ODQ0LFxuICAgIDQ2LjgxMDM5NDI4NzEwOTM3NSxcbiAgICA0Ni45OTMxODMxMzU5ODYzMyxcbiAgICA0Ni41MDQxMTYwNTgzNDk2MSxcbiAgICA0Ni43NDQ0NjEwNTk1NzAzMSxcbiAgICA0Ny4xMzUwODk4NzQyNjc1OCxcbiAgICA0Ni40NTkxMDI2MzA2MTUyMzQsXG4gICAgNDcuODg0MjM1MzgyMDgwMDgsXG4gICAgNDYuNDIyMTYxMTAyMjk0OTIsXG4gICAgNDcuNDUxODIwMzczNTM1MTU2LFxuICAgIDQ2LjM2Mzk1NjQ1MTQxNjAxNixcbiAgICA0Ny41MDExOTQwMDAyNDQxNCxcbiAgICA0Ni4zNTUzODg2NDEzNTc0MixcbiAgICA0Ny41OTc4NjIyNDM2NTIzNDQsXG4gICAgNDYuNjA0NjMzMzMxMjk4ODMsXG4gICAgNDcuNDc3NjgwMjA2Mjk4ODMsXG4gICAgNDYuNDQ1MTc1MTcwODk4NDQsXG4gICAgNDcuOTIxODI1NDA4OTM1NTUsXG4gICAgNDYuMjExMjY5Mzc4NjYyMTEsXG4gICAgNDcuNjMzMTMyOTM0NTcwMzEsXG4gICAgNDYuMjgzNjc2MTQ3NDYwOTQsXG4gICAgNDcuMzM0MTU5ODUxMDc0MjIsXG4gICAgNDYuNDQ1MTUyMjgyNzE0ODQ0LFxuICAgIDQ3LjY1NjY3MzQzMTM5NjQ4NCxcbiAgICA0Ni41NjAxODgyOTM0NTcwMyxcbiAgICA0Ny43MDg3NTE2Nzg0NjY4LFxuICAgIDQ2LjUwMjU3ODczNTM1MTU2LFxuICAgIDQ3LjQ5NjcxNTU0NTY1NDMsXG4gICAgNDYuMzUwNTM2MzQ2NDM1NTUsXG4gICAgNDcuNTA2NDM5MjA4OTg0Mzc1LFxuICAgIDQ2LjA4NDY4MjQ2NDU5OTYxLFxuICAgIDQ3LjM5MzcwNzI3NTM5MDYyNSxcbiAgICA0Ni41NTM4NTU4OTU5OTYwOTQsXG4gICAgNDcuMzQyODI2ODQzMjYxNzIsXG4gICAgNDYuMzgyMDAzNzg0MTc5NjksXG4gICAgNDcuOTkwMzMzNTU3MTI4OTA2LFxuICAgIDQ2LjEyMTU3MDU4NzE1ODIsXG4gICAgNDcuODc2ODQyNDk4Nzc5MyxcbiAgICA0Ni41NDUxNDMxMjc0NDE0MDYsXG4gICAgNDcuMDAzODU2NjU4OTM1NTUsXG4gICAgNDcuNjgwNDU0MjU0MTUwMzksXG4gICAgNDUuOTY1NTc2MTcxODc1LFxuICAgIDQ3LjY4NTQyODYxOTM4NDc2NixcbiAgICA0Ni43MTg5NDA3MzQ4NjMyOCxcbiAgICA0Ny4zODQ1MjE0ODQzNzUsXG4gICAgNDYuMjIwOTE2NzQ4MDQ2ODc1LFxuICAgIDQ3LjUxMjkzNTYzODQyNzczNCxcbiAgICA0Ni4xMTUwMTY5MzcyNTU4NixcbiAgICA0Ny42MDI3Mzc0MjY3NTc4MSxcbiAgICA0Ni42NzYxMjQ1NzI3NTM5MDYsXG4gICAgNDcuNTE0NDE1NzQwOTY2OCxcbiAgICA0Ni4wMzMzNzQ3ODYzNzY5NSxcbiAgICA0Ny41NDA3NTI0MTA4ODg2NyxcbiAgICA0Ni4zNjUxNTA0NTE2NjAxNTYsXG4gICAgNDcuMTg0NzAwMDEyMjA3MDMsXG4gICAgNDYuNjA4MDMyMjI2NTYyNSxcbiAgICA0Ny40MjEwNTQ4NDAwODc4OSxcbiAgICA0Ni4zMDkyNDYwNjMyMzI0MixcbiAgICA0Ny40NTEzMDkyMDQxMDE1NixcbiAgICA0Ni4xMTU4MzMyODI0NzA3LFxuICAgIDQ2Ljc0NzA2MjY4MzEwNTQ3LFxuICAgIDQ2Ljg0NTI0OTE3NjAyNTM5LFxuICAgIDQ3LjQ4MTA1NjIxMzM3ODkwNixcbiAgICA0NS44NzM4NTU1OTA4MjAzMSxcbiAgICA0Ny4yMzgzNTM3MjkyNDgwNSxcbiAgICA0Ni41NDExNDkxMzk0MDQzLFxuICAgIDQ3LjQ5MTk4NTMyMTA0NDkyLFxuICAgIDQ3LjcyNzIzMzg4NjcxODc1LFxuICAgIDUyLjE4OTU1OTkzNjUyMzQ0LFxuICAgIDUyLjE4OTU1OTkzNjUyMzQ0LFxuKVxuXG5mdW4gbWFpbigpIHtcbiAgICBwcmludGxuKGRhdGEuYXZlcmFnZSgpKVxuICAgIHByaW50bG4oZGF0YS5kcm9wTGFzdCgxKS5hdmVyYWdlKCkpXG59In0=)

---

<div class="post-metadata">

**Author:** ![Philip\_Knowlton](https://avatars.discourse-cdn.com/v4/letter/p/e495f1/32.png) [@Philip\_Knowlton](https://forum.inductiveautomation.com/u/Philip_Knowlton)\
**Post date:** [December 5, 2025, 8:17pm UTC](https://forum.inductiveautomation.com/t/tag-history-average/112637/5 "2025-12-05T20:17:28Z")

</div>

Oh, that’s very interesting! I wonder what the use-case/decision-point is that would cause it to not include a datapoint that you were explicitly trying to include…

Great find nonetheless, it makes me feel a little bit less crazy that the numbers were repeatable.

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [December 5, 2025, 8:39pm UTC](https://forum.inductiveautomation.com/t/tag-history-average/112637/6 "2025-12-05T20:39:34Z")

</div>

@paul-griffith, is the historian time-weighting the average? (Which I would expect if the intervals aren't exact....)

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [December 5, 2025, 8:49pm UTC](https://forum.inductiveautomation.com/t/tag-history-average/112637/7 "2025-12-05T20:49:00Z")

</div>

I think it's simpler than that - the last value in the dataset is `52.18955993652344` repeated twice, so I think it's the "seed" value being included (if the date range includes realtime now?)

Again, I'm not the person to explain all this 🤷

---

<div class="post-metadata">

**Author:** ![Philip\_Knowlton](https://avatars.discourse-cdn.com/v4/letter/p/e495f1/32.png) [@Philip\_Knowlton](https://forum.inductiveautomation.com/u/Philip_Knowlton)\
**Post date:** [December 5, 2025, 8:59pm UTC](https://forum.inductiveautomation.com/t/tag-history-average/112637/8 "2025-12-05T20:59:36Z")

</div>

@pturmel the SimpleAverage is _supposed_ to be distinct from Average (time-weighted).

@paul-griffith I like playing “Stump The Developer” 🙂

I’ll try running it again tonight selecting a set window of time rather than using now() and we’ll see if we get a repeated value.

---

<div class="post-metadata">

**Author:** ![Philip\_Knowlton](https://avatars.discourse-cdn.com/v4/letter/p/e495f1/32.png) [@Philip\_Knowlton](https://forum.inductiveautomation.com/u/Philip_Knowlton)\
**Post date:** [December 5, 2025, 9:19pm UTC](https://forum.inductiveautomation.com/t/tag-history-average/112637/9 "2025-12-05T21:19:14Z")

</div>

@paul-griffith check this out:

I just ran the following, the only difference being that I’m selecting a static 1 hour of time:

```python
path = ['[default]316/Hydro/Lane 1/DRIVE_OUTPUT_FREQ']
startDate = system.date.parse('2025-12-4 16:00:00')
endDate = system.date.parse('2025-12-4 17:00:00')
aggregationMode = 'SimpleAverage'
average = system.tag.queryTagHistory(paths=path, startDate=startDate, endDate=endDate, aggregationMode=aggregationMode, returnSize=1)
dataset = system.tag.queryTagHistory(paths=path, startDate=startDate, endDate=endDate)
data = system.dataset.toPyDataSet(dataset)

pyaverage = system.dataset.toPyDataSet(average)

data

sums = 0
count = 0
for item in data:
    sums += item[1]
    count += 1

calcAvg = sums/count
pyAvg = pyaverage[0][1]
difference = abs(calcAvg - pyAvg)
'Calculated Avg = ' + str(calcAvg)
'Simple Average = ' + str(pyAvg)
'Difference = ' + str(difference)

```

It still returned a difference:

```python
[[Thu Dec 04 16:00:01 EST 2025, 46.093257904052734], [Thu Dec 04 16:00:10 EST 2025, 47.90593338012695], [Thu Dec 04 16:00:28 EST 2025, 46.700660705566406], [Thu Dec 04 16:02:38 EST 2025, 47.629051208496094], [Thu Dec 04 16:02:41 EST 2025, 45.794071197509766], [Thu Dec 04 16:02:50 EST 2025, 47.25967025756836], [Thu Dec 04 16:03:11 EST 2025, 46.328739166259766], [Thu Dec 04 16:03:14 EST 2025, 47.831172943115234], [Thu Dec 04 16:03:17 EST 2025, 46.3115234375], [Thu Dec 04 16:03:20 EST 2025, 48.050811767578125], [Thu Dec 04 16:03:23 EST 2025, 46.300479888916016], [Thu Dec 04 16:03:44 EST 2025, 46.82675552368164], [Thu Dec 04 16:05:12 EST 2025, 47.675697326660156], [Thu Dec 04 16:05:15 EST 2025, 45.6332893371582], [Thu Dec 04 16:05:18 EST 2025, 46.97443389892578], [Thu Dec 04 16:06:27 EST 2025, 45.93950271606445], [Thu Dec 04 16:06:30 EST 2025, 47.84481430053711], [Thu Dec 04 16:06:33 EST 2025, 45.939727783203125], [Thu Dec 04 16:06:36 EST 2025, 47.31392288208008], [Thu Dec 04 16:08:22 EST 2025, 45.269046783447266], [Thu Dec 04 16:08:28 EST 2025, 47.753597259521484], [Thu Dec 04 16:08:52 EST 2025, 46.437992095947266], [Thu Dec 04 16:09:40 EST 2025, 47.424137115478516], [Thu Dec 04 16:09:52 EST 2025, 46.816158294677734], [Thu Dec 04 16:13:23 EST 2025, 46.64979934692383], [Thu Dec 04 16:13:26 EST 2025, 48.0799446105957], [Thu Dec 04 16:13:29 EST 2025, 46.17212677001953], [Thu Dec 04 16:13:50 EST 2025, 47.31455612182617], [Thu Dec 04 16:14:56 EST 2025, 47.1671028137207], [Thu Dec 04 16:15:29 EST 2025, 46.222835540771484], [Thu Dec 04 16:16:41 EST 2025, 47.86396026611328], [Thu Dec 04 16:16:44 EST 2025, 45.7034912109375], [Thu Dec 04 16:16:59 EST 2025, 47.09933853149414], [Thu Dec 04 16:26:26 EST 2025, 46.577606201171875], [Thu Dec 04 16:26:29 EST 2025, 47.77180099487305], [Thu Dec 04 16:26:32 EST 2025, 45.40517044067383], [Thu Dec 04 16:26:35 EST 2025, 47.61018371582031], [Thu Dec 04 16:26:56 EST 2025, 46.42325210571289], [Thu Dec 04 16:29:20 EST 2025, 46.614803314208984], [Thu Dec 04 16:32:48 EST 2025, 47.46504211425781], [Thu Dec 04 16:32:57 EST 2025, 46.22206115722656], [Thu Dec 04 16:35:44 EST 2025, 47.3664665222168], [Thu Dec 04 16:36:29 EST 2025, 46.22618103027344], [Thu Dec 04 16:36:32 EST 2025, 47.50592803955078], [Thu Dec 04 16:36:53 EST 2025, 45.688419342041016], [Thu Dec 04 16:36:56 EST 2025, 47.64204406738281], [Thu Dec 04 16:37:26 EST 2025, 45.72358703613281], [Thu Dec 04 16:37:44 EST 2025, 47.2235107421875], [Thu Dec 04 16:38:05 EST 2025, 45.94649124145508], [Thu Dec 04 16:38:11 EST 2025, 47.40217208862305], [Thu Dec 04 16:38:17 EST 2025, 45.8856086730957], [Thu Dec 04 16:38:23 EST 2025, 47.58566665649414], [Thu Dec 04 16:38:50 EST 2025, 46.19305419921875], [Thu Dec 04 16:40:47 EST 2025, 47.31653594970703], [Thu Dec 04 16:41:17 EST 2025, 46.523075103759766], [Thu Dec 04 16:44:48 EST 2025, 48.29185485839844], [Thu Dec 04 16:44:51 EST 2025, 46.170074462890625], [Thu Dec 04 16:45:45 EST 2025, 47.7791633605957], [Thu Dec 04 16:46:03 EST 2025, 48.53673553466797], [Thu Dec 04 16:46:36 EST 2025, 52.18955993652344], [Thu Dec 04 17:12:34 EST 2025, 50.167301177978516]]'Calculated Avg = 47.0128024992''Simple Average = 46.9602275213''Difference = 0.052574977979'

```

Though what’s especially interesting is that it doesn’t seem to have repeated the last value in this dataset…

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [December 5, 2025, 9:33pm UTC](https://forum.inductiveautomation.com/t/tag-history-average/112637/10 "2025-12-05T21:33:00Z")

</div>

> [@Philip\_Knowlton](#):
>
> Stump The Developer

Paul is getting much better at dodging the nerd-sniping attempts. 😁

---

<div class="post-metadata">

**Author:** ![robertm](https://avatars.discourse-cdn.com/v4/letter/r/ea5d25/32.png) [@robertm](https://forum.inductiveautomation.com/u/robertm)\
**Post date:** [December 5, 2025, 10:49pm UTC](https://forum.inductiveautomation.com/t/tag-history-average/112637/11 "2025-12-05T22:49:47Z")

</div>

Out of curiosity, what's the value of you use Tag Query Calculation?

---

<div class="post-metadata">

**Author:** ![Philip\_Knowlton](https://avatars.discourse-cdn.com/v4/letter/p/e495f1/32.png) [@Philip\_Knowlton](https://forum.inductiveautomation.com/u/Philip_Knowlton)\
**Post date:** [December 6, 2025, 12:47am UTC](https://forum.inductiveautomation.com/t/tag-history-average/112637/12 "2025-12-06T00:47:14Z")

</div>

@robertm I’m helping a coworker build a simple application where he wanted the average from tag history. Long story short, I had some questions about how system.tag.queryTagHistory() worked with aggregations and why it returned certain values and set about learning through trials. That led me to this.

---

<div class="post-metadata">

**Author:** ![robertm](https://avatars.discourse-cdn.com/v4/letter/r/ea5d25/32.png) [@robertm](https://forum.inductiveautomation.com/u/robertm)\
**Post date:** [December 6, 2025, 12:02pm UTC](https://forum.inductiveautomation.com/t/tag-history-average/112637/13 "2025-12-06T12:02:06Z")

</div>

Understood, but I was referring to a different method that I normally use:

> **[system.tag.queryTagCalculations | Ignition User Manual](https://www.docs.inductiveautomation.com/docs/8.1/appendix/scripting-functions/system-tag/system-tag-queryTagCalculations)**
>
> Queries various calculations (aggregations) for a set of tags over a specified range.

---

<div class="post-metadata">

**Author:** ![Philip\_Knowlton](https://avatars.discourse-cdn.com/v4/letter/p/e495f1/32.png) [@Philip\_Knowlton](https://forum.inductiveautomation.com/u/Philip_Knowlton)\
**Post date:** [December 8, 2025, 10:47pm UTC](https://forum.inductiveautomation.com/t/tag-history-average/112637/14 "2025-12-08T22:47:30Z")

</div>

Oh gotcha, I haven’t used that function specifically though I probably will moving forward. Just as a test I threw in an additional line using queryTagCalculations and got a value very similar to queryTagHistory except it seems to have additional decimal points retained.

```python
path = ['[default]316/Hydro/Lane 1/DRIVE_OUTPUT_FREQ']
startDate = system.date.parse('2025-12-4 16:00:00')
endDate = system.date.parse('2025-12-4 17:00:00')
aggregationMode = 'SimpleAverage'
average = system.tag.queryTagHistory(paths=path, startDate=startDate, endDate=endDate, aggregationMode=aggregationMode, returnSize=1)
dataset = system.tag.queryTagHistory(paths=path, startDate=startDate, endDate=endDate)
tagHistory = system.dataset.toPyDataSet(system.tag.queryTagCalculations(paths=path, calculations=['SimpleAverage'], startDate=startDate, endDate=endDate))[0][1]
data = system.dataset.toPyDataSet(dataset)

pyaverage = system.dataset.toPyDataSet(average)
tagHistory
#data

sums = 0
count = 0
for item in data:
    sums += item[1]
    count += 1

calcAvg = sums/count
pyAvg = pyaverage[0][1]
difference = abs(calcAvg - pyAvg)
'Calculated Avg = ' + str(calcAvg)
'Simple Average = ' + str(pyAvg)
'Difference = ' + str(difference)

```

This returns:

```python
46.96022752126058 (value from queryTagCalculations)
'Calculated Avg = 47.0128024992'
'Simple Average = 46.9602275213'
'Difference = 0.052574977979'

```