Ability to filter on "Other Users" for Custom Fields in Reports
CS Reports & Dashboards
Hi,
My organization currently has a need to filter on "Other Users" on custom fields in reports. I was told only Standard Objects can be filtered by All Users, Current User and Other Users. The custom fields are only All Users and Current User.
Our use case is on the My Customer Health report. We use a CSM and CSE field. Managers of CSE's would like to easily enter their employees to view their accounts and health scores associated with them.
Any feedback or workarounds are welcome!
Thanks,
Joe
My organization currently has a need to filter on "Other Users" on custom fields in reports. I was told only Standard Objects can be filtered by All Users, Current User and Other Users. The custom fields are only All Users and Current User.
Our use case is on the My Customer Health report. We use a CSM and CSE field. Managers of CSE's would like to easily enter their employees to view their accounts and health scores associated with them.
Any feedback or workarounds are welcome!
Thanks,
Joe
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
You should be able to create a GSID field in the Company object for your CSE which looks up to the User::GSID field
then map it in Gainsight Connect so that the Company::CSE is loaded with the SFDC ID of the CSE from the Account record:
(That step is just so you can map the CSE for each account to each Company record)
Then provided you have loaded your User table in MDA with the appropriate users, you can add a filter to your dashboard, using the SFDC User ID for the CSE
THen you can search for Other User
This allows you to actually search the entire User table though...so even people who are not CSEs will show up in the Other User list. I haven't figured out how to restrict this to the specific individuals I want displayed in the search.
Don't know if this meets your use case or not. Hope it helps.
Happy to announce that your request has been considered and included as part of Gainsight SFDC v6.5 release. You can find the relevant information in our Gainsight SFDC v6.5 Release Notes.
Due to this enhancement, the 'How to Build Basic Reports' article is updated.
Thanks for posting!