Am I missing something or is Tableau just bad?
I am not a tableau developer but I work with some. We collaborated on dashboard to show some data from a web application my team is making. I supplied a SQL view for them to use and they wired it up. It works but I noticed it was a little slow. I realized in my testing I queried using id (integer) and they used a date field. Logically this works, it's a 1-1 relationship, but when I asked if they can make the filter using the id but display the date to users, apparently not.
From what I read, it can be done with parameters or there is a way to format the label if static but these values change so neither of these seemed right. I am surprised because this is common in web dev and SSRS and every other system I've used.
I'd want to pick a field to filter on and then pick a second field as the label. My responsibility to make sure that makes sense as Tableau would get the distinct set of those to use.
Is Tableau really that limited or is there a way to do this?