Hello,
I am keeping a couple of filters in my dashboard --year and fund.
Somehow my fund filter has same values but coded in different ways across various years. (Ex: Bofa coded uniquely as "Bofa", "BankofA"; "BankAme" in different years.). How can I ensure my "fund" filter pulls only unique values; when a particular year is chosen from the year filter?
While creating reports, we accomplish this (prompt) by keeping year as a parameter in the query and a dummy column as filter (Ex: Fact_createdate>'01-01-1753') so that it connects to fact and pull that year value only. How do we do this type filter(prompt) in dashboard?
Thanks,