How to count how many records with same 2 criteria.

[MartinHapag]

Good day.

I am trying to create a workflow measuring how many calls are handled per day.

I have below input.

Agent	date
Anna	3/7/2023
Anna	3/7/2023
Anna	3/8/2023
Anna	3/8/2023
Anna	3/8/2023
Anna	3/9/2023
Christina	3/7/2023
Christina	3/7/2023
Christina	3/8/2023
Christina	3/9/2023

I am trying to have my output look live below.

Agent	Date	Calls per day
Anna	3/7/2023	2
Anna	3/8/2023	3
Anna	3/9/2023	1
Christina	3/7/2023	2
Christina	3/8/2023	1
Christina	3/9/2023	1

Any help would be appreciated.

[ShankerV · Accepted solution]

Hi @MartinHapag 

You can achieve the solution with one tool.

Summarize tool.

Agent -> Group By

date -> Group By

date -> Count (Change the column heading to Calls Per day)

Many thanks

Shanker V

[MartinHapag · Accepted solution]

Thank you very much, worked perfectly.