Having problems with your account or logging in?
A lot of changes are happening in the community right now. Some may affect you. READ MORE HERE
Highlighted
DineshPoudel Respected Contributor.
Respected Contributor.
351 views

Grouping same field in Report

Jump to solution

Hi,

Can anyone help me with this report:

I have data as follows:

User1          10.10.10.1

User2          10.10.10.2

User3          10.10.10.1    

User1          10.10.10.3

User2          10.10.10.4

User1          10.10.10.2

User1          10.10.10.1

User3          10.10.10.3

I want to achieve a report which looks something like(In a table) :

Username     IP                    count

User1          10.10.10.1           2

                   10.10.10.3           1

                   10.10.10.2           1

User2          10.10.10.2           1   

                   10.10.10.4           1

User3          10.10.10.1           1

                   10.10.10.3           1

I am doing something like this:

SELECT:

Username

IP

Count(IP)

GROUP BY

Username

IP

ORDER BY

Username

I am getting following result.

Username     IP                    count

User1          10.10.10.1           2

User1          10.10.10.3           1

User1          10.10.10.2           1

User2          10.10.10.2           1   

User2          10.10.10.4           1

User3          10.10.10.1           1

User3          10.10.10.3           1

As you can see, i want to grab only one unique value.

Any help will be really appreciated.

Thank you

Labels (2)
Tags (2)
0 Likes
1 Solution

Accepted Solutions
rhope Acclaimed Contributor.
Acclaimed Contributor.

Re: Grouping same field in Report

Jump to solution

This is a display option in the report, basically you just need to drag the header of the Username column up from the fields row to the groups row in the data tab of your report

0 Likes
2 Replies
rhope Acclaimed Contributor.
Acclaimed Contributor.

Re: Grouping same field in Report

Jump to solution

This is a display option in the report, basically you just need to drag the header of the Username column up from the fields row to the groups row in the data tab of your report

0 Likes
DineshPoudel Respected Contributor.
Respected Contributor.

Re: Grouping same field in Report

Jump to solution

That worked, thank you Richard.

0 Likes
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.