6 Replies Latest reply on Oct 16, 2018 10:15 PM by Kashish Bhola

# Date Calculation

Hi Guys!

I need your help with this calculation basically I'm more focused on Last 3 Week same day Avg.

I've attached a image for better understanding.

Hi,

• ###### 2. Re: Date Calculation

Hi Meenu!

Actually I don't have any workbook I just want to calculate last 3 weeks same day avg , Suppose today's Monday i need to calculate last 3 weeks monday's Avg.(only monday's of last three week their Avg)

like yesterday i have calculated like this

{Fixed [order date] : sum(if ([order date])= {max([order date])-1} then [Sales] End)}

this is with respect to Superstore, But how should I calculate last 3 weeks same day avg for sales and profit ?

Thanks!

• ###### 3. Re: Date Calculation

Hi Kashish,

You can try below approach:

last 3 day sales AVG

• ###### 4. Re: Date Calculation

Hi Meenu!

Thanks You So much Can you tell me if i want see profit and sales both in same view like it is giving sales for now whatif i need to see profit also can this be done in only one calculated field.

Thanks

• ###### 5. Re: Date Calculation

You can create Profit using the same logic.

last 3 day profit  AVG

• ###### 6. Re: Date Calculation

Hi Meenu!

I wanted to put both Sales and Profit in one Calculated field only.

Sorry for asking So much questions Meenu I had One more Question

that i have two tables in Hadoop Hive and I want to take one more Table from MySQL  so how should I work on 3 of them at the same time?

Thanks

Kashish