How to count how many records with same 2 criteria.

Question

Good day.

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

I have below input.

AgentdateAnna 3/7/2023Anna 3/7/2023Anna 3/8/2023Anna 3/8/2023Anna 3/8/2023Anna 3/9/2023Christina3/7/2023Christina3/7/2023Christina3/8/2023Christina3/9/2023

I am trying to have my output look live below.

AgentDateCalls per dayAnna 3/7/20232Anna 3/8/20233Anna 3/9/20231Christina3/7/20232Christina3/8/20231Christina3/9/20231

Any help would be appreciated.

ShankerV · Accepted Answer

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 Answer

Thank you very much, worked perfectly.