You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
It is easy to create a filter when using a fixed date for the duration operator:
project = "Project A" AND (assignee was in (user1, user2, user3) during (2023-09-21, 2023-09-27))
here, the start date belongs to CW38, while the end date is CW39.
This filter works fine but for every new week, we will need to create a new filter with hardcoded dates. How to implement a universal filter that will always give actual information from Thursday to Wednesday?
Example 1: if the filter is executed on Tuesday it shows all issues from Thursday previous week till Wednesday this week.
Example 2: if the filter is executed on Friday it shows all issues from Thursday this week till Wednesday next week.
Can you try this instead and check if it solve your problem
this should be a dynamic filter to get the data during the current week
@Andrii Karazhov the query I provided will get data from Monday--> Friday
you can get from Thursday and Wednesday using DURING (startOfWeek(3d),endOfWeek(5d)) and you can play with the number of days to get the right data