DateCategoryFunction should support sliding windows
Reported by Ben Hood | November 1st, 2011 @ 02:33 PM
In order to not have keep on re-defining date based view ranges with absolute upper and lower bounds, it would nice to be able to specify a view in terms of a sliding window. Some use cases include:
- A rolling n hour/day/week/month/year window based on the current time;
- A rolling n hour/day/week/month/year window based on the last aligned hour/day/week/month/year;
- Specifying no upper bound indicates there is no limit;
- Specifying a logical upper bound to prevent including future dated entities from being included - the logical upper bound could be now()/start-of-{today, this-week, this-month, this-year}()/end-of-{today, this-week, this-month, this-year}();
An example of the XML might look like this:
<range-category name="bizDate" data-type="date" lower="days-ago(7)" upper="start-of-today()"/>
No comments found
Please Sign in or create a free account to add a new ticket.
With your very own profile, you can contribute to projects, track your activity, watch tickets, receive and update tickets through your email and much more.
Create new ticket
Create your profile
Help contribute to this project by taking a few moments to create your personal profile. Create your profile ยป
A Real Time Differencing Tool.
People watching this ticket
Ben Hood
Tags
Referenced by
-
262
Sliding window constraint
Duplicated by #405 which contains a more detailed design ...