My columns are Program Name, Date, and Counts. The dates are 2024, 2022, 2015, and 2013.
I have a filter for the Date that only allows users to select between 2024 and 2022. However, in the Tooltip, I want the Counts for 2015 and 2013 to show. I want only the 2015 Counts to show if 2024 is selected and 2013 Counts to show if 2022 is selected in my filter.
What formula would get me this?
#Tableau Public
Hi, @Abby Ebelherr
Are you looking for something like the attached? Please take a look.
I created some dummy data to give shape to your request.
<sample>
If this is what you had in mind, I can provide additional explanations.
If anything is missing or if I’ve misunderstood something, please let me know.
<calc>
Four calculated fields are created and used for control.
