Week over week

Question

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

Thomas Dodds · Answer

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.

SriniVEERAVALLI · Answer

I guess thats good.

just in case check this cool-bi.com