How to filter out 'Department, Company, Manager and Location' By using Breakdown Source filter.

mania · ‎12-21-2023

Hi

Am trying to filter out 'Department, Company, Manager and Location' By using Breakdown Source filter for Report Widget. But I couldn't found 'Department, Company' filter is not working.

Can you please help on this. It will be helpful.

Thanks in Advance!

AndersBGS · ‎12-21-2023

Hi @mania ,

If you want to create a breakdown source based on the department or company, you should filter on sys_id for cmn_department table or core_company table:

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/

View solution in original post

AndersBGS · ‎12-21-2023

Hi @mania

Can you please also share a snip of your dashboard properties, together with the interactive filter that you have created for filtering the report?

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/

mania · ‎12-21-2023

@AndersBGS

'Company' is working now perfectly thankyou.

But Am facing one more issue like I need to bring 'City and Country' on the same dashboard filter option. so can you help me this please.

Thanks!

Mania

Dr Atul G- LNG · ‎12-21-2023

@AndersBGS is best 🙂

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************