# Data Graph / Database?

**URL:** <https://community.smartthings.com/t/data-graph-database/50419>\
**Category:** Projects & Stories\
**Created:** [June 14, 2016, 8:47pm UTC](https://community.smartthings.com/t/data-graph-database/50419 "2016-06-14T20:47:01Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![michaelahess](https://yyz2.discourse-cdn.com/smartthings/user_avatar/community.smartthings.com/michaelahess/32/27733_2.png) [@michaelahess](https://community.smartthings.com/u/michaelahess)\
**Post date:** [June 15, 2016, 9:35pm UTC](https://community.smartthings.com/t/data-graph-database/50419/3 "2016-06-15T21:35:44Z")

</div>

I’m betting you can do this with:

> [@SmartThings Data Visualisation using InfluxDB and Grafana](https://community.smartthings.com/t/smartthings-data-visualisation-using-influxdb-and-grafana/44946):
>
> Hi all, Here’s a write-up of how I’m using InfluxDB and Grafana to visualise SmartThings device states in charts and dashboards. The solution uses a [custom SmartApp I’ve written](https://github.com/codersaur/SmartThings) to send data from SmartThings to InfluxDB. Crucially it supports the database server being on the same private LAN as the SmartThings hub, so there’s no need to make your database server accessible from the internet. I’m quite pleased with it so far. In conjunction with my Evohome (Connect) SmartApp I’m getting some great graphs of my home heating behaviour and energy usage. Here’s an example of a temperature chart: [image] Here’s an Evohome Heating Zone chart with some overlays: [image] I aim to post another article covering some of the more-advanced Grafana features like templating and annotations in th…

Here’s a power and temp dashboard I use:

> [@\[OBSOLETE\] IoT Logger](https://community.smartthings.com/t/iot-logger-release/48052/5):
>
> Grafana and InfluxDB is awesome, and all local so no worries about thingspeak or someone else loosing my stuff. I used Highcharts and thingspeak primarily before as well.

You can select all devices in a group type or all devices, then filter the ones you want, so should be able to do what you want.

---

_[View the full topic](https://community.smartthings.com/t/data-graph-database/50419)._
