April 30, 2021 at 12:35 pm #639
May 4, 2021 at 4:05 pm #640FrankKeymaster
- Topics Started - 75
- Replies Written - 53
What about seeing Week Starting/Ending dates?
This is another easy thing to do in Stratum. Using the same techniques as in the original post you’ll want to start with Year Weeks or Year Based Weeks Based. You must use a week dimension that includes a year because weeks start/end on different dates in each year.
Once you are in the view explorer and you’ve got your Year Based Weeks Based or Year Weeks included expand the dimension so you see the Years and Weeks.
This next step is in addition to the techniques in the previous post – because in this case we have to include the Start and/or End date for the week (BTW you can do the same thing for Months and Quarters) because it is not included by default.
Right Click on the Weeks or Weeks Based and select Edit Attributes. In the Edit Attributes window include the Start or End date, whichever you want – or both if you want. I normally use only the start date.
Once that is done – just do pretty much the same as described in the original post – and use the Start or End date in the Display Text instead of the Value. You’ll also want to remember to hide whatever you use in the Display Text (as described in the original post) so that you don’t see the same description twice.
Hope that helps!
You must be logged in to reply to this topic.