Reply To: Can I replace Current Year with the actual year? Same for Months

#640
 Frank
Keymaster
  • Topics Started - 80
  • 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!

CONTACT US

We're not around right now. But you can send us an email and we'll get back to you, asap.

Sending

©2021 KLEO Template a premium and multipurpose theme from Seventh Queen

Log in with your credentials

or    

Forgot your details?