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 use both SUM and COUNT

Received Response
43
Views
5
Comments
edited Mar 18, 2019 11:19AM in Reporting & Analytics for B2C Service 5 comments

Content

Hi,

We have custom field for a contact called department. It's in the format:

DEPARTMENT.TEAM

I've split this successfully into two columns. The 3rd column does a COUNT(*) showing how many unique teams there are. How would I also add a SUM to show the departments

Let's say we had:

DEPT1.TEAM1

DEPT1.TEAM2

DEPT1.TEAM3

DEPT2.TEAM4

The output would be:

DEPT   | TEAM   | DCOUNT | TCOUNT

DEPT1 | TEAM1 | 3                 | 1

DEPT1 | TEAM2 | 3                 | 1

DEPT1 | TEAM3| 3                 | 1

DEPT2 | TEAM4 | 1                 | 1

Any advice?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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