# Sum/average pen values on easy chart **URL:** \ **Category:** Ignition\ **Created:** [February 18, 2012, 12:14am UTC](https://forum.inductiveautomation.com/t/sum-average-pen-values-on-easy-chart/4023 "2012-02-18T00:14:23Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![diat150](https://avatars.discourse-cdn.com/v4/letter/d/a587f6/32.png) [@diat150](https://forum.inductiveautomation.com/u/diat150)\ **Post date:** [February 18, 2012, 12:14am UTC](https://forum.inductiveautomation.com/t/sum-average-pen-values-on-easy-chart/4023/1 "2012-02-18T00:14:23Z")
just wanted to post this to see the feasibility of adding a feature that would add a sum/average pen that would show up on the trend chart as a sum/average of all pens currently on the chart. Is that something that is even possible? My customer wants this(and I think it would be a great feature for everyone) and their system is too big and has too many scenarios to do expressions on db tags. Heck, they may even pay extra to get it coded in if it is possible. We are in the process of implementing the click to graph on 43000 tags, and this is one of the things they would like to see done. ---
**Author:** ![Joseph\_Mendonca](https://avatars.discourse-cdn.com/v4/letter/j/58f4c7/32.png) [@Joseph\_Mendonca](https://forum.inductiveautomation.com/u/Joseph_Mendonca)\ **Post date:** [February 24, 2012, 4:26am UTC](https://forum.inductiveautomation.com/t/sum-average-pen-values-on-easy-chart/4023/2 "2012-02-24T04:26:46Z")
and another x trace. ---
**Author:** ![nathan](https://avatars.discourse-cdn.com/v4/letter/n/c5a1d2/32.png) [@nathan](https://forum.inductiveautomation.com/u/nathan)\ **Post date:** [February 24, 2012, 7:40am UTC](https://forum.inductiveautomation.com/t/sum-average-pen-values-on-easy-chart/4023/3 "2012-02-24T07:40:51Z")
That's impressive. I'd like to hear how it goes and what, if anything, you do to tweak the system/db. > [@diat150](#): > > We are in the process of implementing the click to graph on 43000 tags. ---
**Author:** ![diat150](https://avatars.discourse-cdn.com/v4/letter/d/a587f6/32.png) [@diat150](https://forum.inductiveautomation.com/u/diat150)\ **Post date:** [February 24, 2012, 12:02pm UTC](https://forum.inductiveautomation.com/t/sum-average-pen-values-on-easy-chart/4023/4 "2012-02-24T12:02:54Z")
seems to work well. We did a few things differently. we wrote a script to write in the tags instead of using bulk pen creation, since we wanted to be selective in what was shown. we also had that script fill in the name/location columns with more relevant information for our system. we also added in functionality to make public/private saved graphs. Our system is setup to filter devices based on users groups/permissions… so we also filter the pen list to only show the devices that user has assigned to them. Only thing we are really missing is the sum/averaging of the pens that are currently on the graph. Nathan, do you have any ideas on that? ---
**Author:** ![nathan](https://avatars.discourse-cdn.com/v4/letter/n/c5a1d2/32.png) [@nathan](https://forum.inductiveautomation.com/u/nathan)\ **Post date:** [February 24, 2012, 1:43pm UTC](https://forum.inductiveautomation.com/t/sum-average-pen-values-on-easy-chart/4023/5 "2012-02-24T13:43:08Z")
I’m not sure how you would do that. I suspect that at some level it might be accomplished somehow either through: the DB, Scripting, or the chart component itself. Anyone? @diat150 - Do you have a separate database machine or virtual machine dedicated to logging your historical data? ---
**Author:** ![diat150](https://avatars.discourse-cdn.com/v4/letter/d/a587f6/32.png) [@diat150](https://forum.inductiveautomation.com/u/diat150)\ **Post date:** [February 24, 2012, 3:47pm UTC](https://forum.inductiveautomation.com/t/sum-average-pen-values-on-easy-chart/4023/6 "2012-02-24T15:47:41Z")
I have a separate db machine. ---
**Author:** ![Travis.Cox](https://avatars.discourse-cdn.com/v4/letter/t/b9bd4f/32.png) [@Travis.Cox](https://forum.inductiveautomation.com/u/Travis.Cox)\ **Post date:** [February 24, 2012, 4:40pm UTC](https://forum.inductiveautomation.com/t/sum-average-pen-values-on-easy-chart/4023/7 "2012-02-24T16:40:58Z")
The easy chart does have an average calculated pen and I believe we are working on sum function. ---
**Author:** ![diat150](https://avatars.discourse-cdn.com/v4/letter/d/a587f6/32.png) [@diat150](https://forum.inductiveautomation.com/u/diat150)\ **Post date:** [February 24, 2012, 7:16pm UTC](https://forum.inductiveautomation.com/t/sum-average-pen-values-on-easy-chart/4023/8 "2012-02-24T19:16:59Z")
The average is for a single pen though. Im talking about avg/sum more than 1 pen. for instance we have: pen 1 pen 2 pen 3 Id like the ability to add a average/sum function that averages all 3 pens and displays a 4th pen on the chart that would be the average/sum of the 3 pens, not just the single pen. ---
**Author:** ![Travis.Cox](https://avatars.discourse-cdn.com/v4/letter/t/b9bd4f/32.png) [@Travis.Cox](https://forum.inductiveautomation.com/u/Travis.Cox)\ **Post date:** [February 24, 2012, 9:41pm UTC](https://forum.inductiveautomation.com/t/sum-average-pen-values-on-easy-chart/4023/9 "2012-02-24T21:41:15Z")
Right, got it. ---
**Author:** ![pdibenedetto](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pdibenedetto/32/6364_2.png) [@pdibenedetto](https://forum.inductiveautomation.com/u/pdibenedetto)\ **Post date:** [May 28, 2013, 7:39pm UTC](https://forum.inductiveautomation.com/t/sum-average-pen-values-on-easy-chart/4023/10 "2013-05-28T19:39:03Z")
One potential client ask me for this particular feature in a demo. He says that competitor tool don’t allowed this. Is this still in roadmap? If yes, which version? Thanks,