Report, group by and label not the same. is it possible ?

[eyal abu hamad]

Hello, I want to create a report that dose group by on specific filed but I want to show label of other filed.
I have X table and every record have a name, and I also have Count filed in each record
I want to group by the count and show the record name and not the number
here is an example for my problem 

as you can see only number is shown

[Yashsvi]

Hi @eyal abu hamad,

To create a report in ServiceNow that groups by the Count field and displays the Name field, you can follow these steps:

1. Create a New Report:

   • Navigate to Reports > Create New in your ServiceNow instance.
   • Choose the appropriate report type (e.g., List, Pivot, etc.) based on your requirements.

2. Define Report Criteria:

   • Add a filter to specify any conditions you need for the records to include in the report.

3. Grouping and Aggregation:

   • Drag the Count field into the Group By section to group records based on the Count field.

4. Displaying Name Instead of Count:

   • Drag the Name field (or whichever field contains the labels you want to display) into the report columns section.

5. Customize Column Display:

   • Ensure that the report is configured to display the Name field's data. You might need to adjust column settings to show the field label instead of the value if required.

6. Sorting and Formatting:

   • Optionally, adjust sorting and formatting settings to enhance readability and usability of the report.

7. Save and Run the Report:

   • Save your report configuration and run it to preview the results.
   • Adjust as necessary to ensure the report meets your needs.

Thank you, please make helpful if you accept the solution.

[eyal abu hamad]

I want to show for each record the count filed but with the name of the record

[Yashsvi · Accepted solution]

Hi @eyal abu hamad,

Using a List Report:

1. Create a New Report:

   • Navigate to Reports > Create New in your ServiceNow instance.
   • Select List as the type of report.

2. Select the Table:

   • Choose the appropriate table (e.g., X table) for your report.

3. Add Columns:

   • Add the Name field to the list of columns.
   • Add the Count field to the list of columns.

4. Group by Count Field:

   • You can group by the Count field by dragging it to the Group By section or setting it in the Group By field.
   • Ensure the report is set to display records grouped by the Count field.

5. Save and Run the Report:

   • Save your report configuration and run it to preview the results.

Using a Pivot Table Report:

1. Create a New Report:

   • Navigate to Reports > Create New in your ServiceNow instance.
   • Select Pivot as the type of report.

2. Select the Table:

   • Choose the appropriate table (e.g., X table) for your report.

3. Configure the Pivot Table:

   • For the Rows, add the Name field.
   • For the Columns, add the Count field.

4. Aggregation:

   • Set the Aggregation method for the Count field (e.g., SUM, COUNT, etc.) as needed.

5. Save and Run the Report:

   • Save your report configuration and run it to preview the results.

Thank you, please make helpful if you accept the solution.

[eyal abu hamad]

1. Displaying Name Instead of Count:

   • Drag the Name field (or whichever field contains the labels you want to display) into the report columns section.
     
     ?? how is this done. from where to drag ???