Give control dropdown a pseudonym based on another field

Question & Answer
, , , ,
1

I would like to add a Control with a dropdown which displays one field (user_name) but contains a different but related field (user_id).

The context is I have one dataset containing user information (user_id and user_name) and another dataset with a timeseries containing only user_id. I know one solution would be to create a new dataset joining user_id and user_name, but my timeseries dataset is very large and the join takes forever.

Ideally the user would select a user_name from the dropdown, and this would trigger a filter on the user_id in the timerseries visualization.

2

Seems to be related to the archived post here: Use a filter control for one field, but implement the actual filter on a different field and here: Control/Update graph with non-key field

3

@mba ,

As I understand this is currently not possible. Instead of joining 2 datasets in and creating a new dataset in QuickSight, as part of the ETL / ELT process, you could update the main table to include both user_id and user_name . Then you would have just the main timeseries dataset that will help in filtering .

Kind regards,
Koushik

4

Hi @mba,
It’s been awhile since we last heard from you. Was Koushik’s work around solution helpful for what you were looking to achieve? I’ll go ahead and mark this as a feature request but if you have any further questions, feel free to let us know or create a new topic for discussion.

Thank you!

5

Hi @mba,
Since we have not heard back, I’ll go ahead and mark the solution to close out this topic. However, if you have any further questions, feel free to create a new topic in the community and link this discussion for further context.

Thank you!