I am working on Q topic in Quicksight for Clean Claim Rate dashboard.
It has claim id, original submission date,claim state and other field But I am calculating :-
Now in Q topic i want to create a clean,unclean count based on the latest 7,15 and 30 days timeframe. Timeframe will be calculated based on the today’date - original submission date and if values fall within that time it should show the result else return the 0 value while asking the question in Q topic.
Similary for Unclean claim count and CCR percent. Kindly let me know how i can create a 7,15 and 30 days time frame based calculations to return the clean,unclean counts and CCR percent in Q topic level calculation in quicksight.
For this use case, there are two routes you can go. There is the Natural Language filter or the Manual UI filter. With natural language, you interact with the Topics through natural language and with that, filters can be applied conversationally. For example, ‘what is the clean claim count for the last 7 days’. The modal will take your prompt and automatically apply a filter to your dataset to answer your question. Now the other approach is to manually create a filter. To do this, click the ‘add filter’ button
In your case, I am unsure how the AI will handle 3 different filter types. My recommendation is to go the natural language route and verify your specific questions so that they will always show up under ‘suggested questions’.
Try out both and let me know your thoughts or if you have any additional questions about this topic!
Just checking back in on if you wanted to share your approach. It would be very helpful to the community if you could share your solution in the next 3 business days as other community users could be facing the same problem!
Since I haven’t received any further updates from you, I’ll treat this inquiry as complete at this time. Please feel free to create a new post if you have more questions.
