Save the date! Join us on October 16 for our Product Ops launch event. Register here.
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.
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.
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.
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 ...
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(
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.