# Graph lines are invisible and not showing correctly

**URL:** <https://community.grafana.com/t/graph-lines-are-invisible-and-not-showing-correctly/7800>\
**Category:** Dashboards\
**Tags:** mixed-dbs\
**Created:** [May 30, 2018, 6:57pm UTC](https://community.grafana.com/t/graph-lines-are-invisible-and-not-showing-correctly/7800 "2018-05-30T18:57:10Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![ciscojer](https://avatars.discourse-cdn.com/v4/letter/c/ee7513/32.png) [@ciscojer](https://community.grafana.com/u/ciscojer)\
**Post date:** [May 30, 2018, 6:57pm UTC](https://community.grafana.com/t/graph-lines-are-invisible-and-not-showing-correctly/7800/1 "2018-05-30T18:57:10Z")

</div>

Hi, I created a Graph using both Elastic and Influx data sources, 2 queries each. The legend shows the data correctly but the lines do not show in the chart, however when I mouse-over the info is displayed. See screen recording for details at [Grafana graphing issue - YouTube](https://youtu.be/KHZyyVgeQEI) Also see [Grafana doesn't show Lines - Album on Imgur](https://imgur.com/a/pjvJ5YA) for screenshot of editing the chart which shows “Lines” is enabled. When I switch to bars or points there is data, but not for lines…

Is this a bug or a user/configuration/data source issue? How to make it so that the lines display correctly every time?

Grafana v5.1.3

Thx, Jeremy

---

<div class="post-metadata">

**Author:** ![jangaraj](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/jangaraj/32/39197_2.png) [@jangaraj](https://community.grafana.com/u/jangaraj)\
**Post date:** [May 30, 2018, 7:27pm UTC](https://community.grafana.com/t/graph-lines-are-invisible-and-not-showing-correctly/7800/2 "2018-05-30T19:27:40Z")

</div>

You are selecting only one data point from InfluxDB - _LAST()_, so you can’t draw lines. You may try to use _MEAN()_ aggregation function, instead of _LAST()_.

BTW: Query inspector can help you verify and understand your datasource request/response [Using Grafana's Query Inspector to troubleshoot issues](https://community.grafana.com/t/using-grafanas-query-inspector-to-troubleshoot-issues/2630)

---

<div class="post-metadata">

**Author:** ![ciscojer](https://avatars.discourse-cdn.com/v4/letter/c/ee7513/32.png) [@ciscojer](https://community.grafana.com/u/ciscojer)\
**Post date:** [May 30, 2018, 11:23pm UTC](https://community.grafana.com/t/graph-lines-are-invisible-and-not-showing-correctly/7800/3 "2018-05-30T23:23:55Z")

</div>

Thanks for the reply. I changed from last to mean but that still didn’t change it. I noticed the “Null value” option in the “Display” tab and set that to “connected” and now the chart displays as expected.

[[Album] imgur.com ![](https://i.imgur.com/hkRd0Wz.png?fb "imgur.com") ](https://imgur.com/a/lSm3edk)

Thx, Jeremy

---

<div class="post-metadata">

**Author:** ![jangaraj](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/jangaraj/32/39197_2.png) [@jangaraj](https://community.grafana.com/u/jangaraj)\
**Post date:** [May 31, 2018, 4:59pm UTC](https://community.grafana.com/t/graph-lines-are-invisible-and-not-showing-correctly/7800/4 "2018-05-31T16:59:41Z")

</div>

I was also wrong. Because you are grouping by time, then also LAST function makes sense.