I have a dashboard with charts from multiple worksheets. Every worksheet has the the column “Owner_ID”. Only one of the sheets has 'Full_Name". I am trying to create a dashboard filter of “Full_Name” (so that it displays the users name), but then have the filter apply the 'Owner_ID" to all the worksheets. This is because “Full_Name” is not in every worksheet and I do not want to join to the owner table in every worksheet. When I set the filter action to filter by 'Owner_ID", all of the worksheets return NULL results. Am I able to pass filter values that are different from the actual filter pic list?
You can have the display values on a pick list be different than their actual values. Unfortunatley, you can’t currently do this while also dynamically generating that list of values. Sounds like a great feature request!