Dashboard to show data older than one month

BSpangenberg June 11, 2024

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.

1 answer

0 votes
Tracy Chow
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
June 12, 2024

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.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events