I have one requirement.
In my dashboard i have date prompt filter, that filer is current date of transaction date to next 3 years of transaction date, i.e 6/7/23 -6/6/26.could you let me know how to achieve this dynamically.
This date range change every day in dashboard filter.
Do you mean that you want 1095 values to show up in a prompt list?
Or that you don't want a prompt at all, but do want a rolling three years future data included in the dashboard?
A few things: