# Graph don't display mysql count number

**URL:** <https://community.grafana.com/t/graph-dont-display-mysql-count-number/3423>\
**Category:** Time Series Panel\
**Created:** [October 25, 2017, 7:26am UTC](https://community.grafana.com/t/graph-dont-display-mysql-count-number/3423 "2017-10-25T07:26:10Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![liyehaha](https://avatars.discourse-cdn.com/v4/letter/l/fbc32d/32.png) [@liyehaha](https://community.grafana.com/u/liyehaha)\
**Post date:** [October 25, 2017, 7:26am UTC](https://community.grafana.com/t/graph-dont-display-mysql-count-number/3423/1 "2017-10-25T07:26:10Z")

</div>

SQL: select UNIX\_TIMESTAMP(now()) as time\_sec, count(1) as value, ‘总数’ as metric from b\_summary\_bills;

there are data displayed when mouse move to panel, just no draws.

 ![111](https://us1.discourse-cdn.com/grafana/original/2X/b/ba76df7ed60dbdfa7515ebed1edd8646bee94b9d.jpg)

 ![222](https://us1.discourse-cdn.com/grafana/original/2X/8/852a9d65688c80b9cf836e07dc83773f7bb5ae66.jpg)

---

<div class="post-metadata">

**Author:** ![daniellee](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/daniellee/32/41_2.png) [@daniellee](https://community.grafana.com/u/daniellee)\
**Post date:** [October 25, 2017, 9:02am UTC](https://community.grafana.com/t/graph-dont-display-mysql-count-number/3423/2 "2017-10-25T09:02:04Z")

</div>

It looks like you only have one data point. You need two points to draw a line. Choose Points as Draw Mode instead.

![image](https://us1.discourse-cdn.com/grafana/original/2X/3/3fb52164f8e5558522d2c12814e76fd7a3062686.png)

---

<div class="post-metadata">

**Author:** ![liyehaha](https://avatars.discourse-cdn.com/v4/letter/l/fbc32d/32.png) [@liyehaha](https://community.grafana.com/u/liyehaha)\
**Post date:** [October 25, 2017, 9:26am UTC](https://community.grafana.com/t/graph-dont-display-mysql-count-number/3423/3 "2017-10-25T09:26:12Z")

</div>

> [@daniellee](#):
>
> It looks like you only have one data point. You need two points to draw a line. Choose Points as Draw Mode instead.

Thanks！ I had add group by keyword then it worked