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

How to count different option from 3 different custom columns in CHATS Reports

edited Dec 20, 2022 10:11PM in Reporting & Analytics for B2C Service 8 comments

Summary: Report table incidents inner join with contacts. I already added filters to show all by contact. I tried adding additional filter/s but is not letting me and the count is showing only as grouping the rep and one request.

I'm trying to count the requests of the representative even if the requests are different, I want them grouped by representative and to count the requests they made.

The report is already two levels.

count () max() when I tried using them together is not letting me, >1 is not working either.


Content (required):


Version (include the version you are using, if applicable):21D

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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