I need to have number of defects that were open/in progress now() - 1day i.e. 1 day exactly before than now
Hi @ΣΟΦΙΑ ΦΟΡΑΔΟΥΛΑ
Try this: project = ABC andstatus was in (Open, "In Progress") on startOfDay(-1d)
but if now() is the real now (date and time) -> startofDay (-1d) will show defects open/in progress at 00:00 yesterday and not now time-24h exactly... correct ?
Probably, So you might try this then.
status was in (Open, "In Progress") on -1d
you would have to look at the timings if you have one in mind. This might show everything the previous day and not just the exact 24 hours. you might also try -24h
perfect! - it worked!
Just another similar question - and how can i get number of defect open/in progress "today at 8 in the morning" and then also "yesterday at 8 in the morning"?
It looks like you're new here. Sign in or register to get started.
