Calculate average by Day

[prees959]

Hi,

I need to calculate the 'Average Deliveries' by 'Day of the Week' and by a second dimension.

My value field is Total_Deliveries (eg, sum(Total_Deliveries).  I have a Day_of_Week dimension and also a Delivery_Slot dimension

What would be the best expression to show average daily deliveries by 'Delivery_Slot' and 'Day_of_Week' ?

PS I am using a standard pivot chart

Many thanks for any advice,

Phil

[fvelascog72]

Hi,

You could add the second dimension and a second expression with avg(Total_Deliveries) that should show you what areyou looknig for.

Saludos.

[prees959]

Hi,

When I add AVG(Total_Deliveries) it is showing '1'....  any thoughts? Whereas Total for Monday and Slot 'AM' is 913

[fvelascog72]

Hi,

Can you attach a example file?

Saludos.