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 (123 KiB) Viewed 3816 times

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

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

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

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.

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

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 (150.98 KiB) Viewed 3707 times

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

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.

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".

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

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


Sent from my iPhone using Tapatalk Pro

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

hold off updating. 7.1 breaks the Discrete panel.

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

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

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