Data tables and mapping

kerrsol1972
Tera Contributor

Hello!  First, please note that I am not a developer, but an active user who is trying to self-teach due to low dev support resources.  My question concerns gathering all the necessary data in one view.  Appreciate any insights.  Thank you!

 

  1. For planning, we need to report at the target level and associate the Initiative, Program, and Portfolio fields.  Here is what I have, but I can't help but think I am missing something simple that will give me everything I need in one list view.
    1. I have an N=627 using the Target table.
    2. I have an N=154 using the Goal/Target relationship table. 
      1. I know here that the linking entity is the Program field, so the N is a sample of me trying to link my goals to a program; however, it is not allowing me to report at the target level.
    3. I have a story in to our dev team to create a custom table so that I can get to all goals, all targets, and the program fields needed, but circle back to - is there something I am missing?
1 REPLY 1

Prashant_S
ServiceNow Employee
ServiceNow Employee

@kerrsol1972  Can you please check what table is your target referring to ? Is it core_goal?  try changing that reference to sn_gf_goal and try creating your report.