How to display a Histogram of 2 groups?


#1

How can I display histogram of 2 groups, where:

X axis will be the groups numbers (1 and 2).
Y will be the ‘last’ value of column ‘counter’.

Data is coming from 2 data sources influxdb , measurements: measurement1 and measurement2

First DataSource:

time                number
----                ------

1502717244858780100 20

First DataSource:

time                number
----                ------
1502717084131709000 32

in metric tab of graph I set:

FROM defaults measurement1 
SELECT field(counter) last()
GROUPBY (N/A)
FORMATAS TimeSeries

FROM defaults measurement2 
SELECT field(counter) last()
GROUPBY (N/A)
FORMATAS TimeSeries

in ‘Axes’, under ‘X-Axis’ section tab I selected ‘Histogram’ from the dropbox.

I expect to see at the X-axis, name of the group (1,2) and on the Y-Axis range of numbers like 0 - 50.
And 2 bars of course.

How Can I do that?


#2

Not sure. Histogram mode can only show value distribution.