Straight Table to Gauge changing values

[#1]

Hi,

I have a straight table showing the correct result of a simple calculation I'm doing to narrow down a bigger problem but when I convert the table to a gauge as it should be displayed, the values show differently on the gauge and the gauge's text in chart.

I've attached a simplified version of the file.

thanks,

S

[#2]

Hi,

You need to use function AGGR because you have a dimension on the gauge.

But the gauge show the last value, so i do the AVG how your straight table "36.50".

In Text Chart (Gauge) use this formula:

"=AVG(AGGR(avg({<YMDate=DisplayYM,SMD_WarehouseName={'Atlas'}>} (Last_Sales_date - DateReady)), SMD_Reference, DateReady, Last_Sales_date, SMD_WarehouseName))"

[#3]

Hi Eduardo,

Thanks for the reply. It works perfectly for the text in chart but the gauge chart's needle doesn't show the same value.

Why would that be happening?

S

[#4 · Accepted solution]

Hi, I believe that just show the last value for you chart.

If you change your chart to Straight table, you can see two rows, and the value that show are the last.

If you copy the expression in the text chart and delete all dimensions, to expression chart values will be show correct.

[#5]

Thank you very much Eduardo, I appreciate your help. It works now.