10 Replies Latest reply on May 7, 2018 8:43 AM by Rita Bota

# How to get Monthly average order, compare it against current month orders

Hi Team,

I really do need help here. I just started using tableau but i have a huge task in front of me. I would like to calculate monthly average of orders, monthly orders and compare them along side. Help me out guys. I have attached dataset . version 10.5

• ###### 1. Re: How to get Monthly average order, compare it against current month orders

What do you want to compare?

Could you illustrate something for us to understand your needs  better.

Shin

• ###### 2. Re: How to get Monthly average order, compare it against current month orders

I want to get the monthly average order, monthly order all in one view so i can see which months are good as well as bad months in terms of orders

• ###### 3. Re: How to get Monthly average order, compare it against current month orders

Could you specify the logic of those?

monthly average order

monthly order

How the reservation ID affect?

Are you counting orders ID/ counting Reservation ID /   average of count of order by reservation ID

Monthly average means ie Jan average across years?

Many unknown things there....

Thanks,

Shin

• ###### 4. Re: How to get Monthly average order, compare it against current month orders

I don' think the reservation I'D has to be in the calculation.  I need to calculations;

- number of orders per for each year

- Monthly average of orders for each year.

As for the monthly orders for each year, I can handle that . However, I need help with the monthly average(avg # of orders/month for each year); I need an LOD calculation that can help me determine the monthly average orders for each month. I hope it make some sense now.

• ###### 5. Re: How to get Monthly average order, compare it against current month orders

Let me confirm little bit more..

Monthly average per year = count of orders per year / 12 ?

or something like  :  count of orders per year / 365 x day of month ?

Thanks,

Shin

• ###### 6. Re: How to get Monthly average order, compare it against current month orders

We need to use LoD expressions to calculate the Monthly average order

• ###### 7. Re: How to get Monthly average order, compare it against current month orders

Rita,

I am so sorry.

I don't understand your request very well.

It's tricky to define "Average" without getting detail explanations about "LOGIC" not what kind of formula is expected.

Thanks,

Shin

• ###### 8. Re: How to get Monthly average order, compare it against current month orders

Hi Shin,

Thanks for your time and dedication towards my query. Let explain it in details.

we are a firm whose objective is to book event for the public, we book numerous event on monthly basis and we have been collecting this data since Jan, 2014 to present on monthly basis. we have the order ID and order date. now my boss want to see the average monthly order for each month since then

• ###### 9. Re: How to get Monthly average order, compare it against current month orders

HI Rita,

I am not sure Jim already answered same thing or not anyways.

Starting from today, the number of count is decreasing significantly because rest of them is future date.

So I added parameter to filter out any date you want to cut.

Flat Average by month.

Thanks,

Shin

1 of 1 people found this helpful
• ###### 10. Re: How to get Monthly average order, compare it against current month orders

Thanks Shin, This was not my desired outcome but it helped me a lot in achieving my goal.