Dynamic Dashboard report for logged in user

[Randy34]

I've created a Dashboard that includes several report widgets specific to me. I've been asked to share it with my team, but for that to be useful the report widget filters will need to be updated to return data specific to the user running the dashboard. Other posts suggest using "javascript:gs.getUserID()" with the Assigned To field, but that apparently isn't allowed in the filter as it does not allow free text, but only specific names from a dropdown list.

How do I create a report widget that returns dynamic data based on the logged-in user?

[Abhay Kumar1]

Hi randy, Please try with either 'is one of' or 'contains' it will work, i have even used same for one of my report.

Hope this will help you.

[Randy34]

Unfortunately, adding "javascript:gs.getUserID()" using the contains operator returns no results. My guess is that it's trying to find it as a username, and not resolve the code.

Any other ideas would be appreciated.

[Abhay Kumar1]

What do you see in breadcrumbs after run?, For me it shows sysid of user and if i search that sysid in customer table i get result. Can you give a try to check this.

[Community Alums · Accepted solution]

Hello,

Could you please try this. PFA screen shot.

Regards,

Akshay