Achieving zero counts with group-by function

[48caa5e6b034c457c5c5]

Assume I have a data set as follows:

If I perform a group-by and count, as follows:

I obtain the following result:

However, my end-users/customers require the following:

How can my desired outcome be achieved within Trifacta?

[Trifacta_Alumni]

Happy to help. Let know if you need anything else.

[Trifacta_Alumni]

I think i misunderstood the end outcome. My output is un-aggregated as opposed to aggregated. Thanks Zach.