Two Dates in single Dashboard

i have two date filters on the same dashboard, one payment date and other order date. payment date can be same date or future date from the order date.

my base filter is payment date as the dashboard is for payments but i want users to be able to filter their desired order date range as well.

for instance:

Product Order Date Payment Date
Samsung 01-15-2021 06-15-2021
iPhone 01-18-2021 06-10-2021
Samsung 02-10-2021 05-18-2021
LG 04-21-2021 08-10-2021

by default both the date filters are set for YTD, and if i change one filter to a specific date range it just doesnt show data completely because the other date filter is not in the same range.

how do i make sure if i select one of the date filter the other either just picks up the same range or at least i can clear the other filter to show all the dates. hope this makes sense 

0 0 216
0 REPLIES 0
Top Labels in this Space
Top Solution Authors