This is very nice and helped better undestand fow the fields are created. If only there was a way to see where exactly a particular field visible in a SNOW RITM,INC,REQ,TASK etc. came from in the first place would make life much easier for creating reports.
Thank you, If you were looking at a particular form and wondering where the fields on that form are coming from then you can download a Chrome plugin called SN_Utils and that will give you the column names of every field on the screen.There is an option on top to see which table that column belongs to.
nice video.. Its seems simple.. but I´m not able to join INC and RITM tables in the same report. I want to create a chart showing total tickets per year to specific assigment group..
Are you talking about this in particular? I don't have experience in using this, or were you talking about measuring usage in general? developer.servicenow.com/dev.do#!/reference/next-experience/xanadu/shared-components/sn-dashboard/usage
Those columns which are not available in the base table should be available in any of the reference tables. So, in our example above you see that the green column names are green with a little plus icon. You should see something similar, and should be able to add columns in another table that is referenced from your base table.
Thank you for the short and clear video. Request you to please create more content like this.
Thank you so much for your kind comment!
This is very nice and helped better undestand fow the fields are created. If only there was a way to see where exactly a particular field visible in a SNOW RITM,INC,REQ,TASK etc. came from in the first place would make life much easier for creating reports.
Thank you, If you were looking at a particular form and wondering where the fields on that form are coming from then you can download a Chrome plugin called SN_Utils and that will give you the column names of every field on the screen.There is an option on top to see which table that column belongs to.
nice video.. Its seems simple.. but I´m not able to join INC and RITM tables in the same report. I want to create a chart showing total tickets per year to specific assigment group..
The incident table normally has the assignment group column in it. Is that field empty for you? You shouldn’t need to join two tables for this report.
Do u have any idea about tracking and reporting on dashboard usage module
Are you talking about this in particular? I don't have experience in using this, or were you talking about measuring usage in general? developer.servicenow.com/dev.do#!/reference/next-experience/xanadu/shared-components/sn-dashboard/usage
How to add if some columns/fields are not available in the base table?
Those columns which are not available in the base table should be available in any of the reference tables. So, in our example above you see that the green column names are green with a little plus icon. You should see something similar, and should be able to add columns in another table that is referenced from your base table.