# EasyChart Dynamic pens with SQLTags History

**URL:** <https://forum.inductiveautomation.com/t/easychart-dynamic-pens-with-sqltags-history/1932>\
**Category:** Ignition\
**Created:** [June 15, 2010, 10:33am UTC](https://forum.inductiveautomation.com/t/easychart-dynamic-pens-with-sqltags-history/1932 "2010-06-15T10:33:43Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![NorthPoint](https://avatars.discourse-cdn.com/v4/letter/n/a88e4f/32.png) [@NorthPoint](https://forum.inductiveautomation.com/u/NorthPoint)\
**Post date:** [June 15, 2010, 10:33am UTC](https://forum.inductiveautomation.com/t/easychart-dynamic-pens-with-sqltags-history/1932/1 "2010-06-15T10:33:43Z")

</div>

Sorry if this is a “no brainer”, but there don’t see any relevant posts about it.

I am collecting data with SQLTags History- the data appears to be collected in a set of tables, not just one. EasyChart allows you to pick these, which is fine.

What I need is to be able to use the same popup (with chart on it) to display the same three tags from a number of different groups. So in one instance it would show X/Y/SP, X/Y/PV, and X/Y/OUTPUT, in another it would show A/B/SP, A/B/PV, and A/B/OUTPUT.

If anyone can point me in the right direction I would appreciate it.

---

<div class="post-metadata">

**Author:** ![Carl.Gould](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/carl.gould/32/7262_2.png) [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\
**Post date:** [June 15, 2010, 4:25pm UTC](https://forum.inductiveautomation.com/t/easychart-dynamic-pens-with-sqltags-history/1932/2 "2010-06-15T16:25:50Z")

</div>

First - make sure you use Tag Pens for SQLTags history, not DB pens.

Second - The basic idea here is to use either scripting or binding to alter the [tt]tagPens[/tt] dataset on the Chart based upon what group of pens you want to see. A lot of people will create a database table in their database that stores their pen information along with information that lets them query it in meaningful groups.

---

<div class="post-metadata">

**Author:** ![danielsoar](https://avatars.discourse-cdn.com/v4/letter/d/82dd89/32.png) [@danielsoar](https://forum.inductiveautomation.com/u/danielsoar)\
**Post date:** [April 11, 2012, 6:31am UTC](https://forum.inductiveautomation.com/t/easychart-dynamic-pens-with-sqltags-history/1932/3 "2012-04-11T06:31:47Z")

</div>

Any chance there is a way to reference an indirect tag in the easy chart tag path?

I am trying to make a popup chart that references a device based on a root container custom property (deviceID)

Because I have 20ish devices this seemed the easiest way to tackle the problem until I realised I didnt know how to put the tag path into easy chart with a dynamic reference

Is modifying the TAG\_PATH column in the tagPens property of the chart the only way?

(I am hoping that some clever person has come up with a quicker way to do this since the last response)

---

<div class="post-metadata">

**Author:** ![Colby.Clegg](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/colby.clegg/32/3282_2.png) [@Colby.Clegg](https://forum.inductiveautomation.com/u/Colby.Clegg)\
**Post date:** [April 11, 2012, 5:11pm UTC](https://forum.inductiveautomation.com/t/easychart-dynamic-pens-with-sqltags-history/1932/4 "2012-04-11T17:11:44Z")

</div>

Lucky you, there happens to be a video on exactly this:  
[youtube]NxVKA3fNsnM[/youtube]

HOWEVER, there’s another thing you could do that I happen to like more: instead of an easy chart, use a “classic chart”. Then, bind its dataset to a tag history query binding, which support indirection. Anyhow, both are valid, play around and see what you like.

Regards,

---

<div class="post-metadata">

**Author:** ![ecujak](https://avatars.discourse-cdn.com/v4/letter/e/839c29/32.png) [@ecujak](https://forum.inductiveautomation.com/u/ecujak)\
**Post date:** [April 17, 2012, 7:56pm UTC](https://forum.inductiveautomation.com/t/easychart-dynamic-pens-with-sqltags-history/1932/5 "2012-04-17T19:56:37Z")

</div>

Thanks for the videos, Colby. I just subscribed to the InductiveAutomation youtube channel. This kind of thing helps me the quickest. Good stuff.
