Trend reports using an arbitrary date field

Idea ID 2737421

Trend reports using an arbitrary date field

While submit date works for many cases, it doesn't work in all scenarios where other date fields like close date or a user created field might fit better. Reports like tasks completed in a specific month would become possible. An arbitrary data field would remove all restrictions from the functionality.

7 Comments
Absent Member.
Absent Member.
To clarify your idea, can you provide an example of what you want to do that can't be done today? In a trend report, for example, one can today set the Search Filter on a date field besides submit date with an operand and a date value. For example, Last State Change Date >= '01/01/2014 12:00:00 AM'
Micro Focus Contributor
Micro Focus Contributor
David, the break down of weeks/months/etc needs to be by any user created date field. Currently, the weeks/months are only by Submit Date. The drop lists (single selection) for 1st/2nd Field do not offer a date field. Per help - "The list contains Binary/Trinary, Single Relational, Single Selection, and User fields". Really need to have these reports by a user created date, in addition to Submit Date. Hope that helps... Thanks!
Absent Member.
Absent Member.
After review, we believe that this idea will be possible using the Advanced Reporting capability being introduced in SBM 11.0. I'll put this feature "Under Consideration" to show it's targeted for that release. SBM 11.0 is estimated to release by the end of the year, likely by early November.
Absent Member.
Absent Member.
As discussed on ichange, I think this is very hard to implement via advanced reporting. The problem is that the results of advanced reporting cannot be used in trend reports. Create an advanced report whose result is displaying a trend in a distribution report is very hard (and quite inconvenient, since the modifying the date range or the grouping (week/ day) would imply modifying the xml on the server side). So IMO, it is inaccurate to consider this addressed. If you consider there is enough demand to address it, you could either enable trend reports on auxiliary tables (therefore being able to use the result of an advanced report to trend on), or make the user able to choose the date field in the trend report.
Admiral
Admiral
Exactly what I'm looking for!
Absent Member.
Absent Member.
After reviewing with the team, we agree that implementing the first part of request, i.e. have ability to specify different date field to use instead of 'submit date'. That said, the broader request - i.e. add date fields to drop-down lists for selection of 1st/2nd fields - could lead to difficulties in presentation. In general, a trend report is supposed to have (relatively) limited number of values on the left (/rows) with unlimited time-line going to the right. Having a large vertical scale with the same long array of numbers/dates as for horizontal firstly may not make sense, and secondly could cause some memory/performance issues with the browser. I will reopen the request for the original idea and we'll consider it for a 1HCY'17 release of SBM.
Micro Focus Expert
Micro Focus Expert
Status changed to: Delivered

Delivered in SBM 11.8

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.