# How to use transaction groups with easy chart?

**URL:** <https://forum.inductiveautomation.com/t/how-to-use-transaction-groups-with-easy-chart/41123>\
**Category:** Ignition\
**Tags:** vision, ignition80\
**Created:** [December 2, 2020, 7:48am UTC](https://forum.inductiveautomation.com/t/how-to-use-transaction-groups-with-easy-chart/41123 "2020-12-02T07:48:15Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![anarula](https://avatars.discourse-cdn.com/v4/letter/a/ebca7d/32.png) [@anarula](https://forum.inductiveautomation.com/u/anarula)\
**Post date:** [December 2, 2020, 7:48am UTC](https://forum.inductiveautomation.com/t/how-to-use-transaction-groups-with-easy-chart/41123/1 "2020-12-02T07:48:15Z")

</div>

or custom data on easy chart?

---

<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 2, 2020, 12:24pm UTC](https://forum.inductiveautomation.com/t/how-to-use-transaction-groups-with-easy-chart/41123/2 "2020-12-02T12:24:52Z")

</div>

That is what database pens are for. You select a datasource, table or view within it, and the value and timestamp columns applicable. Optional “Where” clause for the generated SQL.

If you maintain meta-information about your table/column versus tag combinations, the onTagsDropped extension function can be made to mimic the convenience of the Tag Historian.

---

<div class="post-metadata">

**Author:** ![marshall.r](https://avatars.discourse-cdn.com/v4/letter/m/8e7dd6/32.png) [@marshall.r](https://forum.inductiveautomation.com/u/marshall.r)\
**Post date:** [January 7, 2021, 8:31pm UTC](https://forum.inductiveautomation.com/t/how-to-use-transaction-groups-with-easy-chart/41123/3 "2021-01-07T20:31:37Z")

</div>

I’m attempting to utilize the database pens via transaction groups as well. However, when I run diagnostics from within the Edit Pen prompt, I receive an error stating that "The type of column ‘t\_stamp’ is not a date. This is the column that is autogenerated by the transaction group. I’ve also tried using current\_date\_time as well with the same result.  
Any insight would be much appreciated!