I have a dataset that i am feeding to Quicksight Q, It has the following fields-
Member || Transaction Date || Points Issued || Expiration Date
Transaction Date is the date when points were issued
Expiration Date is the last date till when points are valid, post which they expire
In the topic mentioned above, the default date is Transaction Date (we do not want to change this)
I want to train QuicksightQ to take the following prompt
"Show points expiring per member with expiration date in next 9 months "
Currently, QuicksightQ reads the term ‘month’ and disambiguates it to Transaction Date, instead of Expiration Date (Since Transaction Date is the default date)
However, I would need the prompt to disambiguate such time frame keywords on the basis of the context of the prompt. Since the prompt right now has a context of Expiration Date, ‘month/year/date’ keywords should be disambiguated to Expiration Date, not Transaction Date
Is there a way to do this so that it works consistently ?
PS- For the prompt above, the requirement has to be dynamic. We have asked it for 9 months, it could change to 11 months, 1 year or 30 days as per need