Issues with changes to Grafana 7.x (maybe InfluxDB too)

Posted on
Thu Jun 11, 2020 4:22 pm
sumocomputers offline
Posts: 181
Joined: Jun 23, 2008

Issues with changes to Grafana 7.x (maybe InfluxDB too)

Please see screenshots.

The problem is that a single bar for 1 Day would represent data from 1 Day when you hover over, which worked perfectly on 6.5.2.

On 7.0.3, 1 Day is representing data from 2 different days when you hover over.

I posted on Git, and the Grafana guys said:
We changed so that the bars are centered on the data point, instead of being right-aligned


When asking them for a workaround, they followed up with:
Now the bars are centered on the data point. If the data points are not aligned to midnight, might be a problem in influxdb?


So I am not sure where to go from here. My goal is to stay on 7.x, but get the behavior from 6.x., and not sure if there something I am doing wrong, or if in fact there might be an issue with InfluxDB.

Thanks,

Chris

Screen Shot 2020-06-09 at 9.13.04 AM.jpeg
Screen Shot 2020-06-09 at 9.13.04 AM.jpeg (123 KiB) Viewed 342 times


Screen Shot 2020-06-09 at 9.13.56 AM.jpeg
Screen Shot 2020-06-09 at 9.13.56 AM.jpeg (122.89 KiB) Viewed 342 times


Screen Shot 2020-06-09 at 9.24.15 AM.jpeg
Screen Shot 2020-06-09 at 9.24.15 AM.jpeg (111.65 KiB) Viewed 342 times


Screen Shot 2020-06-09 at 9.24.20 AM.jpeg
Screen Shot 2020-06-09 at 9.24.20 AM.jpeg (113.62 KiB) Viewed 342 times

Posted on
Sun Jul 19, 2020 10:02 am
vtmikel offline
Posts: 487
Joined: Aug 31, 2012
Location: Boston, MA

Re: Issues with changes to Grafana 7.x (maybe InfluxDB too)

That is strange indeed. Sorry for not seeing this message.

I'm glad you went to the Grafana team, as I have little that I can do to help with this. The version of InfluxDB has not changed in a number of my plugin updates. So it's likely that both screenshots were with the same version of InfluxDB so it's just being visualized and calculated differently in Grafana.

I was thinking about upgrading the Grafana version to 7.1. Maybe you could try that once I implement it? I wouldn't hold my breath that it'll address the discrepancy since the Grafana team didn't mention it.

Posted on
Sun Jul 19, 2020 10:05 am
vtmikel offline
Posts: 487
Joined: Aug 31, 2012
Location: Boston, MA

Re: Issues with changes to Grafana 7.x (maybe InfluxDB too)

What happens if you change your time period to last 30 days? Rather than now - 30d?

Posted on
Sun Jul 19, 2020 11:03 am
sumocomputers offline
Posts: 181
Joined: Jun 23, 2008

Re: Issues with changes to Grafana 7.x (maybe InfluxDB too)

vtmikel wrote:
What happens if you change your time period to last 30 days? Rather than now - 30d?


When selecting "Last 30 Days" from the dropdown, it fills in "now-30d to now-10s", which is what I had in the screenshots.

If I select an explicit time range like "2020-06-19 00:00:00 to 2020-07-19 23:59:59" it still looks more or less the same.

Not sure if that is what you are asking for or not.

I found something interesting though. If I change one of charts to last 15 days just to see better, and then add a Time Region for Sat to Sun (blue in screenshots), you will notice that it actually covers July 10, 11, and 12 (a Friday, Saturday, and Sunday). Seems like a Grafana issue to me, unless I am understanding incorrectly.

Grafana-01.jpeg
Grafana-01.jpeg (150.98 KiB) Viewed 233 times


Grafana-02.jpeg
Grafana-02.jpeg (150.55 KiB) Viewed 233 times

Posted on
Sun Jul 19, 2020 11:48 am
vtmikel offline
Posts: 487
Joined: Aug 31, 2012
Location: Boston, MA

Re: Issues with changes to Grafana 7.x (maybe InfluxDB too)

I think there are two issues:

1. the right side of the graph is set to now, and the left side is set to now - 30d. The grid lines in the background are showing the change of a day. The hover for a graph is based on where your cursor is on the gridlines, showing the value for that day.

2. The bars are calculating the average energy usage. It's unclear to me if the bars are being calculated for 24hour intervales, calculating backwards from now, or if it's 24 hour increments starting at 00:00 to 23:59. If it's the latter, then I dont get why Grafana would visualize the bar in the center point of the grid, if the bar represents the data to the left of the grid.

I think the easiest way to fix it in Grafana 7 is to ignore the incomplete day, and force the right side of the graph to be midnight of the current day, which is why I made the suggestion.

Posted on
Sun Jul 19, 2020 11:58 am
sumocomputers offline
Posts: 181
Joined: Jun 23, 2008

Re: Issues with changes to Grafana 7.x (maybe InfluxDB too)

Sorry for being thick, but I am not clear on how to " ignore the incomplete day, and force the right side of the graph to be midnight of the current day".

Posted on
Mon Jul 20, 2020 4:20 pm
sumocomputers offline
Posts: 181
Joined: Jun 23, 2008

Re: Issues with changes to Grafana 7.x (maybe InfluxDB too)

I did make some progress.

So my original problem (hovering showing parts of 2 days for each bar), turned out to be a very simple setting:

Hover Tooltip > Mode > Single (it was on "All Series" for some reason).

I still don't like how Grafana lays out the dates underneath, so I had to tinker with timezones on both the dashboard and panel, and eventually I got it somewhat working.

I did get a response from Grafana support, and they of course recommend I go to 7.1.

Is that something I can just drop into the package contents myself, or do I need to wait for an update to the Indigo plugin?

And out of curiosity, what version of InfluxDB do you use? Is there any possibility to get that updated on next update?

Thanks,

Chris

Posted on
Mon Jul 20, 2020 4:23 pm
vtmikel offline
Posts: 487
Joined: Aug 31, 2012
Location: Boston, MA

Re: Issues with changes to Grafana 7.x (maybe InfluxDB too)

Probably best if I push an upgrade. Give me a day at the most.


Sent from my iPhone using Tapatalk Pro

Posted on
Tue Jul 21, 2020 8:05 am
vtmikel offline
Posts: 487
Joined: Aug 31, 2012
Location: Boston, MA

Re: Issues with changes to Grafana 7.x (maybe InfluxDB too)

Give the beta version (v1.0.18b1) on github a try and see how that works for you. Back up your InfluxDB data directory before upgrading.

Grafana updated to 7.1
InfluxDB upgraded to 1.8.1

Posted on
Tue Jul 21, 2020 9:52 am
vtmikel offline
Posts: 487
Joined: Aug 31, 2012
Location: Boston, MA

Re: Issues with changes to Grafana 7.x (maybe InfluxDB too)

hold off updating. 7.1 breaks the Discrete panel.

Posted on
Tue Jul 21, 2020 10:48 am
sumocomputers offline
Posts: 181
Joined: Jun 23, 2008

Re: Issues with changes to Grafana 7.x (maybe InfluxDB too)

Stopped Indigo, installed beta, and after a bunch of errors in the log not being able to start InfluxDB, I disabled and enabled the plugin, and everything started.

I went ahead and rebuilt both Grafana and Influx to be safe, and everything started.

Seems to be running OK, I will report back after I have a few days of data, and investigate all the weird Grafana issues I had.

Thanks,

Chris

Posted on
Fri Aug 07, 2020 6:22 am
vtmikel offline
Posts: 487
Joined: Aug 31, 2012
Location: Boston, MA

Re: Issues with changes to Grafana 7.x (maybe InfluxDB too)

I've posted a stable update to the plugin that includes Grafana 7.1.1. It fixed the Discrete panel.

Posted on
Fri Aug 07, 2020 9:01 am
sumocomputers offline
Posts: 181
Joined: Jun 23, 2008

Re: Issues with changes to Grafana 7.x (maybe InfluxDB too)

FYI - didn't really see issues with v1.0.18b1, but now on v1.0.18 from Github. I'll keep an eye on it.

Thank You

Page 1 of 1

Who is online

Users browsing this forum: No registered users and 1 guest

cron