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.
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.
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.