Hi,
I am trying to add a filter to a sheet that contains multiple values from a single parameter chosen by the user.
For example, the data is based on FY/Q (FY2021TTM4). The user selects a date to be used as a parameter which is named [Fiscal Year]. Using the above date as an example, I want to show a chart for a specific metric (Cost) that has five data points: FY2021TTM4/FY2020TTM4/FY2019TTM4/FY2018TTM4/FY2017TTM4.
Please note that this changes as the users chose parameter changes, for example if the user chose FY2020TTM3 then the five data point would be:
FY2020TTM3/FY2019TTM4/FY2018TTM4/FY2017TTM4/FY2016TTM4.
What I have so far:
Multiple calculated fields FY/'FY - 1'/etc where:
FY is [Fiscal Year]
'FY - 1' is "FY"+STR(INT(RIGHT(LEFT([Fiscal Year],6),4))-1)+"TTMQ4"
I need to be able to filter using these five calculated fields.
Trying to use sets on tableau server and it does not display a pop up to create the set.
Thank you for any help.
HI @Zachary Kang
It would be useful if you could upload a packaged workbook as this will help the volunteers of this forum to help you - they will be able to get a better understanding of how your data is structured and will make less assumptions as a result.
For more information on how to create a packaged workbook see here. If you are unable to share your data you can also use the Superstore Sample data source that comes bundled with Tableau or you can also anonymize your data.
Donna
