- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago
Hi Everyone,
I am trying to create a breakdown on an Indicator that uses a choice field. But while creating the breakdown source, I don't see the choice field for selection. Also, when I created the breakdown source on sys_choice table, I am getting below error while breakdown and Indicator mapping
How do I achieve this?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago
it seems you are doing some wrong steps/configuration and hence it's not allowing you to insert
-> choice fields are not directly selectable in breakdown source
-> you need to use sys_choice table as your facts table for breakdown source and then set the element field to value
Facts table, Field and Conditions selection for Breakdown source for Case Management
💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago
it seems you are doing some wrong steps/configuration and hence it's not allowing you to insert
-> choice fields are not directly selectable in breakdown source
-> you need to use sys_choice table as your facts table for breakdown source and then set the element field to value
Facts table, Field and Conditions selection for Breakdown source for Case Management
💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago
Hi @Ankur Bawiskar ,
Yes! I was not configuring the breakdown wrong. The mapping has done be done in breakdown and it should be same as facts table of Indicator. The table used in Breakdown Source does not matter
