How to do a particular kind of count

[sameersheikh]

I need help with an assignment question.

This is what it asks:

I'm stuck on how to find the "Number of Customer Service Associates".  This section introduced the Summarize tool, so other than the fairly rudimentary tools, I don't have too much knowing of a particular tool that may do what I need done.

The solution provided looks like this:

I have no clue how to get a column that looks like that.  This is what I have:

I'm including my workflow file if anyone wants to take a look at what I've done.

Any and all help will be appreciated.

[gawa]

hi@sameersheikh 

First of all, your shared workflow seems education material for Spark ED program. Please make sure of no issue to share those materials in public according to terms and conditions, and also asking for solution here in community would have no problem, either. As I'm not familiar with Spark ED programs, I might be worried about it too much, but for just in case...

If everything is ok, then please see my advice as follows:

First, you put Data Cleansing tool to replace null to 0, however records having score=0 means "not applicable", so you should filter out null records instead of replacing with 0.

Second, you group by "Team", "Month", "Associate", however solution seems summarizing by combo of "Team" and "Month", so please delete group by "Associate". Second Summarize tool is not needed.

[sameersheikh]

I've looked through the terms and conditions, and it's vague about sharing, so I'll defer this to a mod.  If I inadvertently violated some terms and or conditions, then I'll be more than happy to remove the content or have the mod do it.

Next, thank you for your effort.  It looks like it got me to the finish line.  I added a "Count Non Null" action to the Summary Tool, and I managed to get an answer that matches the solution.

Here's the thing.  It was more of a guess and check approach.  I don't fully understand why this works.  Like - why did you add the !IsNull filter, and why did the "Count Non Null" action result in proper answer? 

[gawa]

@sameersheikh  You are right. My solution shown in the above had the waste step. As you said, just connecting Summarize tool and do "Count Non-null" would be more straight way.