Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Week over week

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
-
I guess thats good.
just in case check this cool-bi.com
0 -
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.
0