Beast mode - Calculate how many rows per individual

user16684

Is there a way for me to create a beast mode calculation to return how many rows there are for each individual?

 

For example, the data would have:

 

Employee ID             Employee                   Training Completed                         Completion Date

123                           Joe                               Welcome to Company ABC             2/5/19

123                           Joe                               How to use DOMO                           3/9/19

222                           Mary                             Welcome to Company ABC             4/8/19

 

The beast mode calculation would output that Joe = 2 and Mary = 1. In the end, I want to be able to display how many employees have completed 0 trainings, 1-3 trainings, or more than 3 trainings.

 

 

Thank you!

Sambo_Servicer

Hey there,

 

Sounds like you need a count of completed courses and then categorization for the "How many courses have been completed."

Maybe something like this will help:

 

Case

             when sum(Case when `Completion` is not null then 1 end) =0 then '0'

             when sum(Case when `Completion` is not null then 1 end) ❤️ then '1-3'

             when sum(Case when `Completion` is not null then 1 end) >0 then '3+'

END

 

Props on using coursebuilder, btw.