Histogram panel not working for elasticsearch

Grafana Elasticsearch
1

Hi

I m trying to get the data of elasticsearch mysql data to grafana.
In that for the same data , “tabledatapanel” is working but not “histogram”
Need histogram to work on that.Pls help on this.

image
image1327×273 9.49 KB

2

you mean histogram panel? What does your query look like?

3

select model,modelcount from model_stats order by modelcount desc;

4

That does not look like time series query. The graph panels histogram feature requires time series formated data.

Please have you query return time_sec, value, and metric columns.

5

http://docs.grafana.org/features/datasources/mysql/#time-series-queries

6

can you please help with the query for above?

7

no sorry, helping you write SQL is a bit too time consuming.

But if you follow the link I gave see an example query:

SELECT
  min(UNIX_TIMESTAMP(time_date_time)) as time_sec,
  max(value_double) as value,
  metric1 as metric
FROM test_data
WHERE   $__timeFilter(time_date_time)
GROUP BY UNIX_TIMESTAMP(time_date_time) DIV 300
ORDER BY time_sec asc
8

Just to conform
Table query will not work in histogram?
only time series query will work?

9

yes, that is correct