Dashboard to show data older than one month

BSpangenberg

I'm looking to do a dashboard to show certain data based on a date field that is older than one month from today. Is there a formula that can calculate if a date is older than one month from today?

 

Not looking to enter the date into a control each time.

Tracy Chow_f2gtzj

Hello,

Yes, you can use the Atlassian Analytics relative date variables to generate a dynamic date filter.

For example, "Created at" < {TODAY.SUB.(1,'month')} will return all dates older than May 12th.

Let me know if you have further questions on this or how to use relative date variables.