Hello, Is there a way to change the date field granularity to biweekly? It is not available in the field well, was someone able to achieve this with calculated fields? Thanks

Here’s what I was thinking with the combining of those two posts. addDateTime(-((dateDiff(truncDate("WK", truncDate('YYYY', {arrival_timestamp})), {arrival_timestamp}, 'WK')+1)%2),'WK',truncDate('WK',{arrival_timestamp})) Let me know if this works^ [image]

Changing date field granularity to biweekly

Question & Answer

Max May 15, 2023, 9:51pm 2

Hi @Marie-LineF

This allows you to group to the 15 minute mark. It might help you.

You can combine that with the week number to check whether it’s odd or even and then group to a specific week.

Let me know if these help.

1 Like