Which table / plugin panel to show counts of field keys from influx

Grafana
1

So I have a ton of influx data that looks like this.

select unit_price from agile where unit_price < 4.5 and area_code='J'

1570672800000000000 4.0425
1570674600000000000 3.7905
1570750200000000000 4.389
1570752000000000000 1.155
1570753800000000000 4.389
1570755600000000000 1.5435
1570757400000000000 0.3675
1570759200000000000 2.1735
1570761000000000000 1.659
1570762800000000000 3.045
1570764600000000000 3.6225
1570946400000000000 4.158
1571193000000000000 4.389
1571628600000000000 3.927
1572139800000000000 4.137
1572145200000000000 4.389
1572147000000000000 3.969
1572188400000000000 3.927
1575759600000000000 3.192
1575761400000000000 1.155
1575763200000000000 1.596
1575765000000000000 1.848

I can run a manual count on that data like this, specifying a range in the pricing:

select count(*) from (select unit_price from agile where unit_price < 4.5 and area_code='J')
name: agile
time count_unit_price
---- ----------------
0    252

In Grafana, i’d like to create a table that will show something like this

unit price Count
<0 27
0-1 34
1-2 22
3-4 18
4-5 34

etc

I’ve tried table and just can’t seem to get it to do anything.
Can I do this? If so, how?

Or is there an alternative table plugin worth looking at?

Thanks