# Time Series Analysis Tools

**URL:** <https://forum.inductiveautomation.com/t/time-series-analysis-tools/42582>\
**Category:** Ignition\
**Created:** [January 25, 2021, 4:19pm UTC](https://forum.inductiveautomation.com/t/time-series-analysis-tools/42582 "2021-01-25T16:19:43Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![cody.abbott](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/cody.abbott/32/17533_2.png) [@cody.abbott](https://forum.inductiveautomation.com/u/cody.abbott)\
**Post date:** [January 25, 2021, 4:19pm UTC](https://forum.inductiveautomation.com/t/time-series-analysis-tools/42582/1 "2021-01-25T16:19:43Z")

</div>

I’m pulling data out of my MSSQL historian DB for use in reporting tools like Tableau, but I’m having problems with efficiently aggregating the data. For example, if I want to show a temperature trend over an entire year, my report will pull in massive amounts of data and inevitably crash; basically I have no way to bucket data…  
What TimeScale DB provides looks appealing, but it doesn’t appear to be compatible with the Ignition Historian. Is there some pre-canned abstraction layer out there that can plug into the Ignition Historian tables?

---

<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:** [January 25, 2021, 5:38pm UTC](https://forum.inductiveautomation.com/t/time-series-analysis-tools/42582/2 "2021-01-25T17:38:44Z")

</div>

[https://inductiveautomation.com/moduleshowcase/module/kymera-systems-inc-influxdb-history-provider](https://inductiveautomation.com/moduleshowcase/module/kymera-systems-inc-influxdb-history-provider)  
Kymera provides an InfluxDB historian implementation.

---

<div class="post-metadata">

**Author:** ![MMaynard](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mmaynard/32/3366_2.png) [@MMaynard](https://forum.inductiveautomation.com/u/MMaynard)\
**Post date:** [January 25, 2021, 5:43pm UTC](https://forum.inductiveautomation.com/t/time-series-analysis-tools/42582/3 "2021-01-25T17:43:53Z")

</div>

We use the WebDev module with some custom web methods for outside systems to query large datasets from the Ignition historian.