# Power chart aggregate mode and average **URL:** \ **Category:** Ignition\ **Created:** [March 9, 2022, 8:33am UTC](https://forum.inductiveautomation.com/t/power-chart-aggregate-mode-and-average/57002 "2022-03-09T08:33:06Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![r.p](https://avatars.discourse-cdn.com/v4/letter/r/71e660/32.png) [@r.p](https://forum.inductiveautomation.com/u/r.p)\ **Post date:** [March 9, 2022, 8:33am UTC](https://forum.inductiveautomation.com/t/power-chart-aggregate-mode-and-average/57002/1 "2022-03-09T08:33:06Z")
![unknown](https://us1.discourse-cdn.com/inductiveautomation/original/3X/d/e/de7e0340923f36d92e1c9de8be1260830e2cf33b.png) Can someone shed some light on how the average is calculated in Ignition's power chart? Because we see big discrepancies between the shown average and the average we calculate from an exported spreadsheet. I suspect it has to do with the "aggregate mode" I highlighted in the above screenshot: currently I set it to "default" but ideally I would like a "no aggregate" option which is not available. according to [documentation](https://docs.inductiveautomation.com/display/DOC81/Perspective+-+Power+Chart) : > "aggregate mode: Mode to use to group the data. Options are: default, Average, MinMax, SimpleAverage, Sum, Minimum, Maximum, DurationOn, DurationOff, CountOn, CountOff, Count, Range, Variance, StdDev, PctGood, or PctBad." ---
**Author:** ![tupanaster](https://avatars.discourse-cdn.com/v4/letter/t/5daacb/32.png) [@tupanaster](https://forum.inductiveautomation.com/u/tupanaster)\ **Post date:** [March 28, 2022, 10:24am UTC](https://forum.inductiveautomation.com/t/power-chart-aggregate-mode-and-average/57002/2 "2022-03-28T10:24:28Z")
I was also looking into the aggregate modes. I’m not sure what’s the use of any of them. In my case I was testing “sum” aggregate mode. From my point of view, “no aggregate” would be “default”. You can hide pen control with “showPenControlDisplay”.