It would be very useful in having good, consistent reporting to extend the current date macros available for doing so. Currently, if I want to filter to only include the rolling year's values, I have to put in a filter like Date >= Previous days <365> (and another for Date <= Today, if dates can be in the future) but this is quite clunky and not always the most clear (from memory, Previous Days does not include today's date, hence the greater than or equal to).
Even worse is that there is no real way (without doing something like creating a custom date object & maintaining the lookups to it for all objects with a date) to put a filter on to say "show me the last x complete months", with the partial workaround being similar to the above one, but this does not fulfil the "complete months" aspect of the filter.
I would propose the following would be very useful additions to the filtering setup used in folder config, BP read data steps, chart/metric config, list filtering config & other areas that filtering can be set up throughout Creatio:
High priority:
- Previous x for each of the dropdown's sections, so week, month, quarter, except for "Every year"
- Following x for each of the dropdown's sections as above
Nice to have:
- A checkbox/similar on Previous/Following macros to select whether the current day/week/month etc should be included, to both remove the slight ambiguity and give users more control without needing 2 date filters
Do you like this idea?