search

mtanda / grafana-heatmap-epoch-panel

Apache License 2.0
33 stars 3 forks source link

Can't make it work #4

Closed merwy closed 7 years ago

merwy commented 8 years ago

Hi,

I'm using Grafana 3.0 with InfluxDB and can't make this heatmap working. No content is displayed. Is there any trick that needs to be done in the query to make it work?

mtanda commented 8 years ago

Oops, I test it with latest Grafana, it doesn't work now. I'll check the error and fix it.

Pawcio4 commented 8 years ago

Please do, we really would like to use heatmap functionality.

mtanda commented 8 years ago

The problem might be caused by legend name handling. If it doesn't contains symbol characters, it works. I'll fix the issue in this week.

mtanda commented 8 years ago

I fix the error (in my env). Would you update the plugin and test it?

merwy commented 8 years ago

Yes. Sure. Thanks!

merwy commented 8 years ago

I still can't make it work. Whatever query I make, nothing is displayed on the panel. Can you share example of the correct query for influxdb to make it work.

mtanda commented 8 years ago

Sorry for late reply. Personally I don't use InfluxDB, I use Prometheus. I install Grafana 3.0.4-1464167696 release version, and add panel, it works.

heatmap

Can you share screenshot, and if there are error dialog, please share error message.

merwy commented 8 years ago

Let me explain my query. However I’m not sure if this is correct query for your heatmap. I want to show a heatmap of average CPU load where dimensions are time and racks. Time dimension should be drawn on X-axis and different racks should be drawn on Y-axis. I’m not sure if I should use GROUP BY to define dimensions (axis) for the heatmap. To achieve this, I have the following query in Grafana:

1

Unfortunately, as a result of this, nothing is drawn on the panel.

2

Interesting is that after saving a dashboard, going to some other dashboard, and going back to dashboard with heatmap, the following error occurs on the panel: t is undefined

3

mtanda commented 8 years ago

I notice that the query editor has some bug, so the error is shown after dashboard save, might be caused by the bug. And, I don't know well about InfluxDB query, is the query can draw on normal Graph panel?

sikadiamond commented 8 years ago

I'm also strugeling to make it work, could you provide an example db & query for influxdb?

mtanda commented 8 years ago

@sikadiamond Sorry, I don't use this with InfluxDB. Do you try to use InfluxDB histogram() function?

mtanda commented 8 years ago

I don't promise InfluxDB support, but I'll try to use this with InfluxDB.

sikadiamond commented 8 years ago

I have not, see: https://docs.influxdata.com/influxdb/v0.13/query_language/functions/#histogram

sikadiamond commented 8 years ago

I got it to work. Sorry about this.

mtanda commented 8 years ago

That's great! Anyway, I'll try to use InfluxDB, and check how this plugin work.

mtanda commented 8 years ago

I check the behavior of this plugin, when using with InfluxDB. And, I found a bug, fix it. https://github.com/mtanda/grafana-heatmap-epoch-panel/commit/8800fc30efc7defcca3fbed247daf7f48e9215d6 (Ignore first InfluxDB query which respond empty result.)

mtanda commented 7 years ago

Should work with InfluxDB, so close this issue.