Help

Setting the date condition (last calendar year) in intefaces

Solved
Jump to Solution
362 3
cancel
Showing results for 
Search instead for 
Did you mean: 
zukowski
4 - Data Explorer
4 - Data Explorer

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.

1 Solution

Accepted Solutions
simmonkc
5 - Automation Enthusiast
5 - Automation Enthusiast

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.

Screenshot 2024-01-06 at 9.47.25 AM.png

See Solution in Thread

3 Replies 3
simmonkc
5 - Automation Enthusiast
5 - Automation Enthusiast

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.

Screenshot 2024-01-06 at 9.47.25 AM.png

This would be possible and easy to set up. But too laborious for the amount of elements.
I would need something automatic ...

cntorres
4 - Data Explorer
4 - Data Explorer

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(

DATETIME_FORMAT(NOW(), "YYYY"),
DATETIME_FORMAT({Date}, "YYYY"),
'years'
)
 
Then, you can filter your chart by "Where 'Number of Years Ago' = 1".
 
Does that help?