[Performance Analytics] Country Code Breakdown

[Fin Nguyen]

I want to create a Country code breakdown from the Subject person field of an HR case (subject_person.country_code), but checking in the backend, the Country code field is not a choice field, it is a string field, how can we do Breakdown in this case?

[AndersBGS]

Hi @Fin Nguyen ,

Then you can't do it on the current field, but you need a new field with the country code to create the breakdown source. 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

[Fin Nguyen]

Does it mean the breakdown must be from a choice field?

[Tai Vu · Accepted solution]

Hi @Fin Nguyen 

The Country code is under string type, but it is configured as a Dropdown with choices.

So you will find all the choices in the Choice [sys_choice] table.

Just define your Breakdown Source in this table with following query. Then define Breakdown Mapping for your Indicators. After execute the Job Collection, you should be able to see the score for this Breakdown.

Let me know if it works for you.

Cheers,

Tai Vu

[Fin Nguyen]

@Tai Vu , that is the best tip ever, thanks!