topic Re: Filter button to choose Fiscal or Calendar Years in App Development

Filter button to choose Fiscal or Calendar Years

cfountain72 — Sat, 16 Nov 2024 03:19:36 GMT

We have a Date Dimension table with both Fiscal and Calendar Year fields in it. I want to allow the user to be able to use either Fiscal or Calendar Years fields from a filter selection button. How do I use a filter selector to allow the user to choose which field to use? The expectation is the user would have a Fiscal/Calendar selector, and a Year selector. Does this require a variable or...?

Thanks,

Chris

Re: Filter button to choose Fiscal or Calendar Years

Rodj — Sun, 09 Feb 2020 22:32:03 GMT

Yes, a variable would be a good way to go for this. If you have a button assigning the "fiscal" or "calendar" value to the variable and then include the variable in a set modifier in all your calculations you'll have a relatively simple switch between the two. Exactly how you manage the set selection will depend on how you construct your date dimension and can flag the calendar types. You might need to add a new dimension to make it easier and an alternative would be to just use that dimension in an normal filter control.

This discussion might be useful to you as there are a few things to think about that get covered in it.

Cheers,

Rod

Re: Filter button to choose Fiscal or Calendar Years

cfountain72 — Mon, 10 Feb 2020 11:44:30 GMT

Thanks Rod.