How can I create a breakdown based on the interaction table sort by the user region.

Vidya Aeil
Tera Contributor

Hi All,

How can I create a breakdown based on the interaction table. I need to build a breakdown filter to sort by the user region, the breakdown will search the user region  on the sys_user record. they want to see user region.

  

VidyaAeil_0-1711811443911.png

VidyaAeil_2-1711811636683.png

VidyaAeil_3-1711811658326.png

So here I'm using breakdown source [fact table is cmn_location] I'm trying to mapping interaction table. I'm not getting the expected data.

Kindly help out me.

 

Thank you,

Vidya A

1 REPLY 1

AndersBGS
Tera Patron
Tera Patron

Hi @Vidya Aeil ,

 

If the table you need to breakdown is created based on the incident metric table, you should just "map" it correctly in the breakdown mapping:

AndersBGS_0-1711873778326.png

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

 

Best regards

Anders

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

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/