List the "current user" as an "other user" when building report filters

  • 4
  • Idea
  • Updated 1 month ago
I have been building a set of reports for some new dashboards. They're based on timeline data and are (frankly!) awesome!

I wanted to exclude some individuals and teams from the report, including the people who reported to me. So I added a filter for "Manager !=" and wanted to select myself. But the only way to do that is to say "Current User." Report looks great, save, publish... Except when one of the team managers goes to the dashboard none of their CSMs are showing up. After much head-scratching, it's because the "Manger != Current User" filter is eliminating the exact people they're looking to see!

The solution to this is that I have had someone else edit that report and change that filter to "Other User = Jeffrey Coleman", which then applies correctly no matter who runs it.

Suggestion: Don't filter the "Other User" list to exclude the "Current User".
Photo of Jeffrey Coleman

Jeffrey Coleman, Champion

  • 5,866 Points 5k badge 2x thumb

Posted 2 months ago

  • 4
Photo of Rakesh

Rakesh, Employee

  • 234 Points 100 badge 2x thumb
Nice observation Jeffrey! Thanks for bringing this up. 
It does look like there is a gap with the current set of options. This needs to be worked out. I'll try to initiate a discussion and see why this happened. 

Another option apart from having someone else do it is to use contains/does not contain operation in the filter (if applicable) and input name as text. 
 
This does come with its own limitations (Both RandomName and RandomName123 gets filtered for RandomName input)