Edit Scorecards 2.0 with Mass Edit Report

Scorecard Unified Fact Object

There exist two Unified Fact objects; Company Scorecard Fact Object and Relationship Scorecard Fact object. All the data for Account Scorecards is stored in the Unified Scorecard Fact - Company Object and all the data for Relationship Scorecards is stored in the Unified Scorecard Fact - Relationship Object. If you do not have any Scorecard for Accounts, the Unified Scorecard Fact - Company is not created and if you do not have any Scorecards for Relationship the Unified Scorecard Fact - Relationship object is not created.

To create a Scorecard Mass Edit report on Unified Fact object:

1. Navigate to Administration > Analytics > Report Builder.
2. Click + REPORT. The Report Builder window is displayed in a new tab.
3. Select either Unified Scorecard Fact - Company or Unified Scorecard Fact - Relationship, from the Select Data source field.  
4. Select Scorecard Mass Edit in the Report Type field.

5. Select the Required Companies and Scorecards in the Show me section.

• Company Id -> Name
• Scorecard Id -> Name

6. Similarly, select the required Measures and other fields in the Show me section.
7. Click RUN.

• You can see that there are three different Scorecards; Company Third, Company Health, and Company Secondary in a single Mass edit report.
• NA implies that the Measure is applicable for a Scorecard but is not yet set. In the above image, Cases Measure is present in Company Health Scorecard but is not yet set.
• Not Applicable implies that the Measure is not part of the Scorecard. In the above image, Bugs measure is not part of the Company Third Scorecard.
  Note:
  • You cannot create a Mass Edit report on an individual Fact object. 

Filter/Sort Mass Edit Report Created from Unified Fact Object

• Filter Scorecard data based on Measure Scores: You can now filter data based on the scores of a Measure. You can use this filter to filter data only to view the scores which are in Red, or scores in Red and Yellow, and so on.

Note: Only the Scheme Types used in the Scorecards are displayed for selection in the filter range. For example, if only Numeric and Color Scheme Types are used in the Scorecards for generating report then only those two Scheme Types are displayed in the filter range, instead of displaying all the Scheme Types.

To apply a filter on Measures in a Mass Edit report:

1. Select the required Measure in Select a Field drop-down menu (here Overall Score).
2. Select the required operator.
3. Select the required filter range.
4. Click APPLY.
5. Click RUN.

• Inline filters for Measure data: You can now apply filters on an individual measure or Measure group in the Mass Edit Report. You can filter data of a measure to view only the Red scores in that Measure or NA scores of that measure. You can also search for stale scores of a Measure or Measure Group.

To apply a filter on Measures in a Mass Edit report:

1. Click the search bar for the required measure or Measure group.
2. Select the required score.
3. Press enter key.

• Server-side Sorting: You can sort the data for any column of the Mass Edit report, in ascending or descending order. This is a server-side sorting and all the records present in the dataset (not just those displayed in the report) are sorted in either ascending or descending order. To sort the data, click the required column name.

• Freeze First Column in Mass Edit Report: You can freeze the first column of the Mass Edit report. This feature is very useful when you have multiple columns in your report and you need to scroll to view data from all the columns. You can include important fields like Company Name as the first column, and then scroll to the right and easily view various aspects of each Company in multiple columns.

To freeze the first column of in Mass Edit Report:

1. Navigate to Administration > Report Builder.
2. Click + REPORT.
3. Select a Unified Fact Object as the source object.
4. Select Scorecard Mass Edit in the Report Type field.

5. Add the required fields in the Show me section.
6. Click RUN.

7. Click the settings icon and select the Table options.
8. Switch on the Freeze First Column button.  

• View Comments for a Specific Measure/Overall Score: you can view the comments for a specific measure or the overall Score, in a Mass edit report. The comments are displayed only for the selected Measures.

To View Comments in a Mass Edit report:

1. Navigate to Administration > Analytics > Report Builder.
2. Click + REPORT.
3. Select a fact object as the source.
4. From the Report Type drop-down menu, select Scorecard Mass Edit.
5. Add Measures and Overall score to the Show me section.
6. Click RUN.
7. From the settings icon, click Chart options and select the checkbox for the measures for which you wish to view comments.

• Perform Self Lookup on Company object: The Company object has a self lookup through the Parent Company on the Company object. You can use this feature while creating reports on fact object or unified fact object.

To use this enhancement:

1. Navigate to Administration > Analytics > Report Builder.
2. Click + REPORT.
3. Select a fact object or Unified fact object as the source.
4. In the Show me section, expand Company, and then Parent Company.
5. Select the required fields from the Parent Company field.
6. Click RUN.