The Atlassian Community Forums are currently in read-only mode. We will be relaunching on a new platform on September 22 (read more here). We apologize for the extended downtime. For concerns or questions, please email communitymanagers@atlassian.com. See you on the other side, on the new Atlassian Community Forums! :)

×

Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

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.

TAGS
AUG Leaders

Atlassian Community Events