# Sales data analysis possible?

**URL:** <https://community.netdata.cloud/t/sales-data-analysis-possible/731>\
**Category:** Help\
**Tags:** agent\
**Created:** [January 8, 2021, 2:53am UTC](https://community.netdata.cloud/t/sales-data-analysis-possible/731 "2021-01-08T02:53:26Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![vcashraf](https://yyz1.discourse-cdn.com/flex029/user_avatar/community.netdata.cloud/vcashraf/32/350_2.png) [@vcashraf](https://community.netdata.cloud/u/vcashraf)\
**Post date:** [January 8, 2021, 2:53am UTC](https://community.netdata.cloud/t/sales-data-analysis-possible/731/1 "2021-01-08T02:53:26Z")

</div>

I want to do simple analytics on my my.SQL data of sales and show the trends and graph in realtime … is that possible ?

---

<div class="post-metadata">

**Author:** ![OdysLam](https://yyz1.discourse-cdn.com/flex029/user_avatar/community.netdata.cloud/odyslam/32/98_2.png) [@OdysLam](https://community.netdata.cloud/u/OdysLam)\
**Post date:** [January 11, 2021, 9:36am UTC](https://community.netdata.cloud/t/sales-data-analysis-possible/731/2 "2021-01-11T09:36:32Z")

</div>

Hey @vcashraf ,

If you want to analyse the data that exist in the database, this is not possible with Netdata. You _could_ write a custom python collector that runs certain SQL queries inside your database and plots the data in real time in the Netdata dashboard, using Netdata as a visualizer for your data.

It looks like a cool idea for a custom collector, which takes as input SQL queries (in yaml configuration file) which should output a single value (not table) and then visualize that number.

What do you think @ilyam8 ?

---

<div class="post-metadata">

**Author:** ![andrewm4894](https://yyz1.discourse-cdn.com/flex029/user_avatar/community.netdata.cloud/andrewm4894/32/125_2.png) [@andrewm4894](https://community.netdata.cloud/u/andrewm4894)\
**Post date:** [January 12, 2021, 1:21pm UTC](https://community.netdata.cloud/t/sales-data-analysis-possible/731/3 "2021-01-12T13:21:20Z")

</div>

Maybe you could use statsd perhaps in some way.

> **[GitHub - statsd/statsd: Daemon for easy but powerful stats aggregation](https://github.com/statsd/statsd)**
>
> Daemon for easy but powerful stats aggregation. Contribute to statsd/statsd development by creating an account on GitHub.

Publish the data from the mysql to the statsd endpoint on the machine and then netdata could read from the statsd perhaps: [statsd.plugin | Learn Netdata](https://learn.netdata.cloud/docs/agent/collectors/statsd.plugin)

So then maybe all you’d need to write would be some little job that reads from mysql and pushed to statsd.

I’ve not done this before so not 100% sure but think it sounds reasonable enough.