Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

include information already filtered out

edited Nov 25, 2020 5:09PM in Reporting & Analytics for B2C Service 2 comments

Summary

Add a count of incidents assigned to group/accounts already filtered out of a report.

Content

Hi all. 

I have a report that shows a manager all open incidents assigned to their team by using the incidents.assgn_group_id=Logged In filter. It shows various bits of useful information contained within the Contact & Incident tables but what I really want to be able to do is add a column to show whether there are also open incidents assigned to particular Accounts that we use as specialists. An expression is straightforward enough but because those users are not within the same group as the person running the report (and therefore excluded by the filter) I can't quite work out how to

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!