Choice Field not Appearing in Breakdown Source for Indicator Breakdown

Shaida Aslam
Mega Sage

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

ShaidaC_0-1766394776913.png
How do I achieve this?

 

1 ACCEPTED SOLUTION

Ankur Bawiskar
Tera Patron

@Shaida Aslam 

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 

Define a breakdown source 

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

View solution in original post

3 REPLIES 3

Ankur Bawiskar
Tera Patron

@Shaida Aslam 

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 

Define a breakdown source 

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

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

ShaidaC_0-1766466371937.png

 

You just save me a LOT of time! Many thanks.