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
Is there a way I could filter an issue within a specific time but also it has an interval date?
Something like this:
project = SO AND created > "2017/11/20 22:00" AND created < "2017/11/21 6:00"
I would like to know the number of tickets by night within a single day.
For dynamic dates , you can do something like
project = SO and created > startOfDay("-2h") and createdDate < startOfDay("+5h")
This will give you night tickets for every day. I.e. tickets created between 10 pm (last day) and 5 am (of current day)
@Richard Cross - there's no difference, one's an alias (but don't ask me which one!). 😅
If you have any other questions, definitely start a new thread on Community! (Click Ask the community in the header).
You certainly can, just use:
createdDate >= "2017-11-16 14:00" and createdDate <= "2017-11-16 23:00"
That should give you the tickets created during the specific time window you are looking for.
Hope this helps,