How to count orders for previous 2 weeks to show in KPI
Hello @Shalini and welcome to the Quicksight community!
I would recommend creating a filter like the one in the screenshot below and making sure that in the “Applied to” field that you have “only this visual” selected.
When creating your filter you will want to choose the field that relates to order date where the data type is a date.
Let me know if this helps!
Thanks @duncan for the solution
This solution is working but if we need to create that using calculated field then how can we make