Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
You could add the second dimension and a second expression with avg(Total_Deliveries) that should show you what areyou looknig for.
Saludos.
Hi,
When I add AVG(Total_Deliveries) it is showing '1'.... any thoughts? Whereas Total for Monday and Slot 'AM' is 913
Hi,
Can you attach a example file?
Saludos.