1 of 1 people found this helpful
Absolutely, you can do this. I do not have time right now to type out all the instructions, but I believe you can be successful by studying this link:
Just substitute the type of dates you want instead of using multiple year values--in both the parameter itself and the calculated field that controls it.
I hope this is helpful in some way, sorry I don't have more time.
Thanks Matthew, I already understand using parameters for filtering, what I really want to know is the syntax in the calculated field, I am trying to switch between days (M/D/Y) and weeks eg (week 32, week 33, week 34 etc) as I cannot find a function / work-out the syntax that I expect would be something like WEEK(Date) and MDY(Date)
I'm not as experienced as some other members, so hopefully someone can chime in and give you some specific examples of how to create your calculated field--for now here are the Date Functions and some examples: Date Functions
If I understand you correctly, you are trying to use the parameter to switch the format of the date filed.
1. You need to create one/many custom date first (by clicking on the date dimension and select create custom date...). You should be able to see a list of date format options (and you can always use the date formula to create your own as well).
2. Use parameter control to switch out different format of the date you just created (by writing a case statement) something like this:
WHEN "Annually" THEN [Axis_Year]
WHEN "Quarterly" THEN [Axis_Quarter]
WHEN "Monthly" THEN [Axis_Month]
WHEN "Weekly" THEN [Axis_Week]
You create the [Axis_***] fields in step 1.
This should work. Hopefully that is what you are looking for.
Thanks G, this is what I was looking for, completely forgot about custom dates and the ability to include these instead in calcs.
The rest of the calc is elementary