# Panel shows extra data from MYSQL that does not show in actual MYSQL

**URL:** <https://community.grafana.com/t/panel-shows-extra-data-from-mysql-that-does-not-show-in-actual-mysql/33064>\
**Category:** Grafana\
**Created:** [July 2, 2020, 11:54am UTC](https://community.grafana.com/t/panel-shows-extra-data-from-mysql-that-does-not-show-in-actual-mysql/33064 "2020-07-02T11:54:47Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![brainz](https://avatars.discourse-cdn.com/v4/letter/b/d9b06d/32.png) [@brainz](https://community.grafana.com/u/brainz)\
**Post date:** [July 2, 2020, 11:54am UTC](https://community.grafana.com/t/panel-shows-extra-data-from-mysql-that-does-not-show-in-actual-mysql/33064/1 "2020-07-02T11:54:47Z")

</div>

Grafana version 7.0.3

I have a very strange issue with one of my dashboard panels. For context I will explain that my dashboard is set up with 2 variables so that we can compare software versions within our data. This means there are 2 of every panel which each refer to their respective variable when running the MYSQL queries.

I have one panel (basic bar graph) that, when I select a specific combination of software versions from my list, I get a load of extra data in the graph which does not show when I manually run the mysql query. See the screen grab below. The correct working graph is on the left. The strange behaviour is on the right.

 ![Screen Shot 2020-07-02 at 12.46.27](https://us1.discourse-cdn.com/grafana/original/2X/b/b33587d7ee73eefe7e6c972cde728d4bcb09595a.png)

Below is the query which is very basic.

 ![Screen Shot 2020-07-02 at 12.46.40](https://us1.discourse-cdn.com/grafana/original/2X/4/48088c5851a60d843fecbc68477ff970d53f2881.png)

The various field and visualisation settings are identical for each graph as I used the duplicate function from the first panel to create the second one.

Any help would be much appreciated.

---

<div class="post-metadata">

**Author:** ![brainz](https://avatars.discourse-cdn.com/v4/letter/b/d9b06d/32.png) [@brainz](https://community.grafana.com/u/brainz)\
**Post date:** [July 2, 2020, 2:00pm UTC](https://community.grafana.com/t/panel-shows-extra-data-from-mysql-that-does-not-show-in-actual-mysql/33064/2 "2020-07-02T14:00:07Z")

</div>

Adding some more info from the query inspecter. You can see that the response is correct. 8 rows which have the mac address and the count value. What on earth is Grafana doing with the visualisation?

 ![Screen Shot 2020-07-02 at 14.58.45](https://us1.discourse-cdn.com/grafana/original/2X/2/2e00ba1b556a185d290dfea8cdd6fdddb6516a51.png)