Choice Field not Appearing in Breakdown Source for Indicator Breakdown

[ShaidaC]

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?

[Ankur Bawiskar · Accepted solution]

@ShaidaC 

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! 🙏

[ShaidaC]

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