Mini Gauge in straight table problem

[#1]

Hi all

I'm trying to include a mini bar chart in my straight table to show bars for my values.

I have selected Sum(Value) as my expression, Linear gauge as my Representation. The only Dimension in the table is drug_name.

In gauge settings I have one segment with lower bound of 0.0, gauge settings have Min 0 and max =max(total aggr(sum(Value),drug_name))

The indicator mode is Fill to value.

The result is showing only a couple of black lines, no nice bars?

Please can anyone advise?

Thanks

Dominic