Bug 1374157 - [RFE] Ability to group by category or tag in reports
Summary: [RFE] Ability to group by category or tag in reports
Keywords:
Status: CLOSED WONTFIX
Alias: None
Product: Red Hat CloudForms Management Engine
Classification: Red Hat
Component: Reporting
Version: unspecified
Hardware: Unspecified
OS: Unspecified
medium
medium
Target Milestone: GA
: cfme-future
Assignee: John Hardy
QA Contact: Dave Johnson
URL:
Whiteboard: tag:report
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2016-09-08 06:49 UTC by Fred van Zwieten
Modified: 2019-07-17 15:56 UTC (History)
6 users (show)

Fixed In Version:
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed: 2019-07-17 15:56:46 UTC
Category: ---
Cloudforms Team: ---
Target Upstream Version:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Bugzilla 1228629 0 high CLOSED [RFE] Support tag as a reporting option 2021-02-22 00:41:40 UTC

Internal Links: 1228629

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


Note You need to log in before you can comment on or make changes to this bug.