Bug 1374157

Summary:	[RFE] Ability to group by category or tag in reports
Product:	Red Hat CloudForms Management Engine	Reporter:	Fred van Zwieten <fvzwieten>
Component:	Reporting	Assignee:	John Hardy <jhardy>
Status:	CLOSED WONTFIX	QA Contact:	Dave Johnson <dajohnso>
Severity:	medium	Docs Contact:
Priority:	medium
Version:	unspecified	CC:	dajohnso, gtanzill, jhardy, jocarter, obarenbo, simaishi
Target Milestone:	GA	Keywords:	FutureFeature, RFE
Target Release:	cfme-future
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:	tag:report
Fixed In Version:		Doc Type:	If docs needed, set a value
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2019-07-17 15:56:46 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:

Description Fred van Zwieten 2016-09-08 06:49:48 UTC

Description of problem:
Suppose I have a category "Departments" with, as tags, the departments of a company. Now I would like to create a report which is:
1) sorted by the categories tags (departments)
2) grouped by the categories tags (departments)
3) be able to have totals on numerical fields or counts by these groups.
4) filtered by an expression containing multiple tags (ie filter by region Europe and only VMware)

For example: list VM's by department, with a total count.

Version-Release number of selected component (if applicable):


How reproducible:


Steps to Reproduce:
1.
2.
3.

Actual results:


Expected results:


Additional info:

Comment 2 Dave Johnson 2016-09-15 12:51:38 UTC

There may be a dupe to this one that we need to find and most likely close this one.

Comment 3 Dave Johnson 2016-09-15 12:55:42 UTC

Yeah, this one appears to be a dupe of bug 1228629 , please confirm and close this one.

Comment 4 Gregg Tanzillo 2016-09-16 19:40:25 UTC

This RFE is addresses with https://github.com/ManageIQ/manageiq/pull/11010

Comment 5 Fred van Zwieten 2016-09-17 07:06:43 UTC

(In reply to Dave Johnson from comment #3)
> Yeah, this one appears to be a dupe of bug 1228629 , please confirm and
> close this one.

No, not the same. 1228629 refers to being able to *filter* on a tag. This RFE is on being able to grouo by tag and show show totals per tag. ie:

+-----------------------+----------+-----------+-----+-------+
| Owner                 | Services | Instances | VMs | Hosts |
+-----------------------+----------+-----------+-----+-------+
| J. Dundey             |       23 |        34 |  38 |     3 |
| M. Phelps             |       22 |        39 |  28 |     5 |
+-----------------------+----------+-----------+-----+-------+
|Total for Department A:|       45 |        73 |  66 |     8 |
+-----------------------+----------+-----------+-----+-------+
| R. Miletzy            |       13 |        24 |  28 |     1 |
| F. Fitzgerald         |       12 |        29 |  18 |     2 |
+-----------------------+----------+-----------+-----+-------+
|Total for Department A:|       25 |        53 |  46 |     3 |
+-----------------------+----------+-----------+-----+-------+
|Totals                 |       70 |       126 | 112 |    11 |
+-----------------------+----------+-----------+-----+-------+

Comment 6 Fred van Zwieten 2016-09-17 07:07:36 UTC

(In reply to Gregg Tanzillo from comment #4)
> This RFE is addresses with https://github.com/ManageIQ/manageiq/pull/11010

No, AFAICT that is only for chargeback. This is for reports in general.

Comment 7 Fred van Zwieten 2016-09-17 07:13:22 UTC

(In reply to Fred van Zwieten from comment #5)
> (In reply to Dave Johnson from comment #3)
> > Yeah, this one appears to be a dupe of bug 1228629 , please confirm and
> > close this one.
> 
> No, not the same. 1228629 refers to being able to *filter* on a tag. This
> RFE is on being able to grouo by tag and show show totals per tag. ie:
> 

This is a better example, but then on reports in general, not just chargeback:

https://cloud.githubusercontent.com/assets/11256940/17962434/806131f4-6ab9-11e6-8b15-a29a955e6b38.png