Configure a Graph with X-Axis mode series

Grafana Time Series Panel
1

Hi,

I trying to configure a graph. I’m not interested in use time series. I want to use one value, and show this value as a bar. Then repeat this with all values of my table.

I configured the graph like this:

Axes
Left Y
Show -> activate
Unit -> Short
Scale -> linear
Y-Min -> 0 Y-Max -> auto
Decimals -> auto
Label -> precio
Right Y (desactivate)
X-Axis
Show -> Activate
Mode -> Series
Value -> Current

Metrics
SELECT
preciounit as value
FROM
productos
WHERE
productoid = 1

This return 2.60. The missage error is “No field name specified to use for x-axis, check your axes settings.” and X-Axis mode are disabled.

Any solution?

Thank you,

Alejandro