Custom Field for Report
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-28-2023 09:15 AM
First I have created a custom date / time field in the story table .I am trying to create a report where I want to compare OOB Field with custom field.. but however the custom field is not showing up when I want to compare it with sprint start date while creating a report. Any suggestions for me why its not showing up
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-28-2023 11:13 AM
There are a few potential reasons why your custom date/time field may not be showing up when you are trying to compare it with the sprint start date in a ServiceNow report. Here are a few things to check:
Make sure the custom field is visible in the table view: When you go to the table view for the Story table, do you see your custom date/time field listed as a column? If not, you may need to configure the table view to include your custom field. To do this, go to the list view for the Story table, click the gear icon in the top right corner, and select "Configure > List Layout". From there, you can add your custom field to the list view.
Check the field type: When you created your custom date/time field, did you select the correct field type? Make sure the field type matches the type of field you are trying to compare it to in your report (in this case, the sprint start date field). If the field types don't match, you won't be able to compare them directly.
Check the field's data type: In addition to the field type, make sure the data type of your custom date/time field is compatible with the data type of the sprint start date field. For example, if the sprint start date field is a DateTime field, make sure your custom field is also a DateTime field.
Check the field's visibility settings: Finally, make sure that the visibility settings for your custom date/time field allow it to be used in reports. To do this, go to the field's configuration page, click the "View" tab, and make sure the "Reporting" checkbox is selected.
If you've checked all of these settings and your custom field still isn't showing up in your report, you may want to contact ServiceNow support for further assistance.
Please mark my reply as Helpful and/or Accept Solution, if applicable. Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-28-2023 11:24 AM
Check the field's visibility settings: Finally, make sure that the visibility settings for your custom date/time field allow it to be used in reports. To do this, go to the field's configuration page, click the "View" tab, and make sure the "Reporting" checkbox is selected.I am not able to see view tab in Configure dictionary form of the custom field created
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-28-2023 11:26 AM