I want to filter the data by 2 columns with a single word in quick sight Q topic
Ex: In my data set I have the Txn Schld Date column, I named it as “processed date”
and I have txn status code column, here when that value is 6 then i.e "processed date. please refer below screenshots.
when I ask a question like “how many number of payments are processed date in jan 2024 ?”
in the result for the processed word, it is considered either txn status code or txn schld date.
Is there any way to achieve this? Please help me
1 Like
Hello @jayakumarim, there isn’t a way to refer to 2 columns in this way. QuickSight Q is going to try to select the column that matches the natural language question and this type of functionality isn’t going to work as expected.
If the values are nearly the same, wouldn’t filtering by 1 or the other accomplish the same result in the returned data?
Hi @DylanM , Is there any way to create a filter by using two columns like Name Entiry? In Name Entity, we can mentioned many details with a single word right? Like Adress can include name, H.No, City etc…
Is there any kind of for filter?
1 Like
Hello @jayakumarim, there are possible work-arounds for functionality like this. One option would be to create a custom list of options in a control dropdown, then depending on the user selection, you could reference that parameter value in a calculated field to return the columns you are expecting. I’ll include an example of this below:
If you wanted a user to be able to filter by different options, you could build a custom list like this - Region, Country, and City. So first I would make a parameter:
Then, I would create a control from the parameter and provide the options I would want the user to select from:
Then in a calculated field, you can check for the value the user selected and run any filter logic on the field you want to return.
ifelse(${CustomList} = 'Region' AND {Region} = 'AMER', {Region},
${CustomList} = 'Country' AND {Country} = 'Canada', {Country},
${CustomList} = 'City' AND {City} = 'Seattle', {City},
NULL)
This is a fairly basic demonstration, but that is how you could give a user an option to filter different columns depending on a selection in the dropdown. You will never link it as a filter but rather write the logic for when each option is chosen. I will mark this as the solution, but please let me know if you have any remaining questions. Thank you!
