Date filters in reports and views: let week and month filters refer to actual calendar weeks and months, not to 7 / 30 days periods
Hello! I’d like to set a filter in a report based on the times-entity.
I would like to see all the times spent in the last 3 month + current month.
Example: If today is the 28.7. , I would like to see all times spent from 1.4. to 28.7. Is there a chance?
I understand, that using today-3(months) or today-90(days) I will see than all times from today minus 90 days, that means from 29.04. till today. But I would like to see all times from the first day of april until today.
We have to confirm that it is indeed not possible to refer to the first day of calendar month or week in DSL filters so far. You can only paste there hard-coded date (for example, ?Date gt ‘1-Apr-2015’), but not variable filter that is subtracted from ‘Today’ and automatically updated. We understand that it is inconvenient, sure. Maybe this thing will be changed in future. (Alex, Targetprocess Support Team)
I would like to track all employees timesheet
can i create a view for this track all the empoyee work hour per week?
i prefer a calender week, not last 7 days
Matthew Richer commented
Is there a way to do a filter for 'created this month'.
FOr example: ?CreateDate > Today - 30(days) is a 30 day rolling window. I want ?CreateDate in (current month).
I am trying to filter on cards for planned start dates in the next week. It should show same results on Monday and on Friday of current week.
Graphical report on time spent from 1st day of month 'til TODAY
As i said, i would like to have a graphical report showing the sum of time spent by a user starting from the 1st day of the month until today
How can i get this "1st day of the month" ?
Correct me if i'm wrong... There's no operations i can do on "TODAY"... :(
aggregation by month gives a wrong impression... If you do "TODAY - 1(months)" you get bookings from 12/01/2016 until 12/02/2016...
And if you aggregate by month, you get times spent only from 12/01 until 31/01 for January...
The thing is that we have a lot of teams.
So, we need to show only 1 month (and exactly 1) for each team
Otherwise, at the end of the year, it will come up to a 12-bars dashboard with scrollbars everywhere....
I want to be able to filter by the first day of this month, for example EndDate > "first of this month"
Currently, I can filter either by 'today-30(days)' or by specific date, which is not enough.