I have sample data in Table1 format. In QuickSight, is it possible to create an analysis where the user can select a client ID, and the corresponding data for that client is displayed as shown in the output below?
Hi @AnilTyagi
Create two calculated fields , one for “Country” values and another for “Status” values, and control them with separate filters, follow the steps below
Example :
-
Country
ifelse({CUSTOM FILTER} = 'COUNTRY',{CUSTOM VALUE},'') -
Status
ifelse({CUSTOM FILTER} = 'STATUS',{CUSTOM VALUE},'')
1 Like
@Xclipse Thank you for the solution! However, is it possible to add a single filter control, such as CLIENT ID, so that when a user selects CLIENT ID = 1, the table dynamically shows the data related to CLIENT ID 1, and when they select CLIENT ID = 2, it updates to show the data for CLIENT ID 2? Essentially, I want the column titles and values to change dynamically based on the selected client.
Hi @AnilTyagi
Yes, using a parameter, you can control it with a single filter. Refer to the following screenshots to create a parameter and apply it to the filter.
Create a parameter
Select - Control
Create a filter and apply it to Table 1 and Table 2 visuals and then select a parameter.
1 Like
@Xclipse Thank you! I realize I’m asking a lot since I’m new to QuickSight:). If possible, instead of having two tables, could we have just one table where the values change dynamically based on the client ID selection? This means that the 2nd column header names and the values would update based on the selected client ID
Hi @AnilTyagi
Changing column header is bit complex.
Please refer the below community posts this might be helpful for you.
Example:
ifelse(${ClientId} = 1 , Country, toString(Status))
Hope this helps!
1 Like
@Xclipse Thank you so much! Yes, Your solutions help me a lots.
1 Like