- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 05, 2024 06:34 AM
Hi,
How can I set a condition in intefaces so that the chart displays data only from the last calendar year?
Within the past year apparently does not count the calendar year, but the year itself. I need January 2024 not to be there anymore.
Thank you for your help.
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 06, 2024 07:48 AM - edited ‎Jan 06, 2024 07:49 AM
Could you do it by building out the filters with specific dates? There might be some manual updating of filters at some point, this might be able to work for you.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 06, 2024 07:48 AM - edited ‎Jan 06, 2024 07:49 AM
Could you do it by building out the filters with specific dates? There might be some manual updating of filters at some point, this might be able to work for you.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 08, 2024 04:59 AM
This would be possible and easy to set up. But too laborious for the amount of elements.
I would need something automatic ...
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 17, 2024 08:29 AM - edited ‎Jan 17, 2024 08:33 AM
You can create a formula field called "Number of Years Ago" with the following formula, which basically calculates how many years have passed between your date field and now:
DATETIME_DIFF(
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 25, 2024 06:31 AM
@cntorres I've been looking for a week for a way to filter and group by Calendar Year and this solved the problem!!!! It allows me to set up dashboards for some teams in my organization that won't require them to keep updating filters as the years pass if they want to compare year-over-year performance. Thanks so much, brilliant stuff.