Add previous calendar week, year and calendar quarter in filters and groupings for views and reports

Idea ID 1660784

Add previous calendar week, year and calendar quarter in filters and groupings for views and reports

In reports and views, is it possible to add the time concept of:

  - the previous calendar week in filters and groupings. Previous calendar week =  the previous full week beginning the previous Monday of the present date and ending the previous Sunday of the present date.

  - the previous calendar quarter in filters and groupings. The previous calendar quarter corresponds to:
            -> the months of January, February and March when the date of the day is included in the months of April, May and June
            -> the months of April, May and June when the date of the day is included in the months of July, August and September
            -> the months of July, August and September when the date of the day is included in the months of October, November and December
            -> the months of October, November and December when the date of the day is included in the months of January, February and March

  - previous calendar year in filters and groupings. The previous calendar year is the full year beginning on January the 1st and ending on the 31 th of December, preceding the current date.

 

Tags (3)
5 Comments
Micro Focus Expert
Micro Focus Expert
Status changed to: Waiting for Votes

Thank you for sharing your idea! It’s open for comments and kudos, and we’re looking forward to input from the community. Once there is enough community traction, it will be further reviewed by the product team

New Member.

Adding Previous Financial Year would also be useful - we do our full year reports on April-March dates.

Respected Contributor.
Respected Contributor.

Past 6 months would also be a useful option. Ideally I'd like the function to state the number of past months e.g. 2, 4 or 9 to be reported on. This would be particularly useful on Public reports where the duration could be set for a rolling period (other than past day, week month or year) rather than needing to manually amend the custom date range.

Micro Focus Expert
Micro Focus Expert

Thanks for the additional input!

Micro Focus Expert
Micro Focus Expert
Status changed to: Under Consideration

Thanks for all the votes and comments. We are looking into this as a future product enhancement. Check the notifications box to be emailed if the status changes.

The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.