Forum Discussion
Same metric from two diff table in QnA
I am adding a QnA functionality in my dashboard where users can ask questions as per there requirement.
I have a situation where I have one metric named "Revenue Own" in table A as well as in table B. So when I am posting a question "Revenue Own by countries in 2024", its retunring data from table A, maybe its going in order and fetching the data.
But my requirement is that either it should show Revenue Own from both table or show revenue own from table B.
Is there any way to customize our selection or get data as per our req.
Any suggested ideas to show both Revenue Own in one view or anything like that would help.
Thanks
Hi ,
Unfortunately, Q&A doesn't support prioritizing a specific table unless the model is designed with clear naming or relationships.To solve this, consider renaming the measures to make them unique (e.g., “Revenue Own A” and “Revenue Own B”) or create a unified table or calculated table that combines both metrics, so Q&A pulls from a single source. You could also create custom synonyms in the Q&A setup to guide it toward the desired field. This gives you more control and lets users get the right data when they ask questions.
7 Replies
Hello poojag820
It will work in same way
What your can do rename metrics
Revenue Own (A)
Revenue Own (B)
Alternative way you can union both table if business logic allows you
Thanks,
Pankaj Namekar | LinkedInIf this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.
User would not know which is A or B, they would just need revenue own and would expect result from table B. Also I cannot union these table as Revenue Own from table A has diff values than Revenue Own from Table B.
okay if table A revenue is not used you can exclude that from filter
Hi ,
Unfortunately, Q&A doesn't support prioritizing a specific table unless the model is designed with clear naming or relationships.To solve this, consider renaming the measures to make them unique (e.g., “Revenue Own A” and “Revenue Own B”) or create a unified table or calculated table that combines both metrics, so Q&A pulls from a single source. You could also create custom synonyms in the Q&A setup to guide it toward the desired field. This gives you more control and lets users get the right data when they ask questions.
Hi poojag820,
I wanted to check if you had the opportunity to review the information provided by rohit1991 pankajnamekar25. Please feel free to contact us if you have any further questions. If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.
Hi poojag820,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
Hi poojag820,
We haven’t heard back from you regarding your issue. If it has been resolved, please mark the helpful response as the solution and give a ‘Kudos’ to assist others. If you still need support, let us know.
Thank you.
