Hello!
I have a field of maturity dates on agreements that span out 50 years. I would like to display a visual that shows agreements with ONLY maturity dates UP TO a 12 months from today and another for 13-24 months from today.
Apologies, I am very new to AWS so my knowledge is very basic. I assumed it would be a filter option and have tried creating an ifelse field, but to no avail…
Hi @Kevin_H -
Welcome to the Quick Sight Community! You can use a relative date filter to accomplish both of those. The next 12 months can be accomplished using a relative dates filter - see screenshot. The 13-24 months could be accomplished in a similar way, likely using a parameter as your start date.
Best Regards,
Kellie
Awesome! I will try that today, thank you very much!