In this post, I will explain how to define a synonym for a column so if the business users use another word with the same meaning, still they able to use Q&A visual.
I am using the same data set for customer feedback. In the customer data set, we have a column name as Country-Region,
if the manager instead of Country-Region using Branch.
what branch has more ticket count
The branch column name is not defined in data set, so it has been shown as Red color.
The branch is not identified, so it is in red color. we need to add this word to the Q&A dictionary. Click on the setting icon at the top right corner.
In the new page, click on the Teach Q&A , in the text box you can see the question.
Click on the submit and under the refer, choose the column that is a synonym , In this example Branch, is refer to Country-Region
Then after define it, just save it.
After saving the definition, you will see the there is no red color in the question, and the Q&A able to identify the branch as a known column,