Histogram panel not working for elasticsearch


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.

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

select model,modelcount from model_stats order by modelcount desc;

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.


can you please help with the query for above?

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

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

  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

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

yes, that is correct