Straight Table to Gauge Chart

[#1]

Hello All,

I have a problem where I'm trying to get the average Turn Around Time to display in a Gauge Chart. This should be quite simple and I've narrowed the calculation down to two rows so that I can focus on getting it right before working on the T.A.T for all the branches. The problem is that I'm getting the correct average in a Straight Table but when I clone this and convert it to Gauge, the average changes.

I've attached the file.

Please could you assist, it's probably something stupid and small that I'm overlooking.

tx,

S

[jagan]

Hi,

Try this expression in Gauge chart.

=Sum(AGGR(Avg({<YMDate=DisplayYM,SMD_WarehouseName={'Atlas'}>}(Last_Sales_date - DateReady)),

     SMD_Reference, DateReady, Last_Sales_date,      SMD_WarehouseName))/Count({<YMDate=DisplayYM,SMD_WarehouseName={'Atlas'}>} DISTINCT      SMD_Reference)

Regards,

Jagan.