Single score card report on dashboard

[Snehal Bhagat1]

Hi There,

I have created report using single score card report and when I am clicking on the single score its only showing columns of table which I selected while creating report but I wanted to show few columns from other table also in single score card report.

Is it possible?

eg - In report I am using incident table so only fields of incident table are showing while click through on single score card report but my requirement is to show few fields  of change table also in this reports.

[Community Alums]

Hi @Snehal Bhagat1 ,

 Here you are asking two questions !!

To see change fields along with incident fields you need to create a database view.

and to see the specific columns , 

Active false UI policy 'Make report config fields read only' on 'sys_report' table or remove 'field_list' field from UI Policy Actions .

navigate to 'sys_report_list.do', select single score report which you like to change the list of field. Bring 'Select fields for list' field to form layout. Now you can customize the list view fields with slushbucket.

[Snehal Bhagat1]

Hello Sandeep,

I have tried above steps and kept required fields only using slush bucket however when I am clicking on score card report its not showing list as per slush bucket.

Can you please help here?

[Harshitha SR1]

Hi Sandeep,

I have a requirement in reports, the report "Active Onboarding To-dos Starting Later" it is a single score report and OOB, when i open count it is showing default fields or columns in list view, here i need to add 2 more fields or columns like subject person and opened for field in the list view. How can i achieve it? how it is only fetching default fields or columns? 

Thanks.

[Pavankumar_1]

Hi @Snehal Bhagat1 ,

In ServiceNow each every record of data are stored on the Table level only. If you created report on incident table and want to see the changes then you need to give the condition on change reference field which is on incident. 

or you need to create database view it will use to merge the tables.

In this you can see incidents with changes.