Week over week — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Week over week

Received Response
1
Views
2
Comments
3193829
3193829 Rank 5 - Community Champion

Hi,

I have to calculate week over week date. The user can choose a date from the Date prompt on dashboard and based on it, i should calculate a week before date and do some calculations.

I am using the formula wow date = (todays date - 7 days).

However, my customer was pointing out that when she selects this monday, the previous monday date should be given. I think my formula works the same way. I am just wondering if i am missing something as my client was pointing out so much of how it should be calculated.

am i missing to capture something here ?

Thanks & Regards,

Kalpana

Answers

  • SriniVEERAVALLI
    SriniVEERAVALLI Rank 6 - Analytics Lead

    I guess thats good.

    just in case check this cool-bi.com

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    You need the week number and day of the week number in your time dimension ... then you can give your client day-to-day comparisons (Monday to Monday across any time frame) AND date-to-date (5/16/2016 - 30 days).  Also a well-formed date dimension has indicators for workday and/or weekend ... so proper calculations for business can be made.

    A well-formed date dimension is critical for analytics.