Beast mode - Calculate how many rows per individual
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!
Comments
-
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.
0 -
I tried that but it only returns '+3' for all of the data. I need it to find how many trainings has each individual completed. Does that make sense?
In my fake data example, I would need to show that Joe has completed 2 and Mary has completed 1 so I have 1 user that has completed 2 and 1 that has completed 1.
Thanks for your help!
@Sambo_Servicer wrote: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.
0 -
Sorry. Typo on my end.
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) >=3 then '3+'
END
0
Categories
- All Categories
- 1.2K Product Ideas
- 1.2K Ideas Exchange
- 1.3K Connect
- 1.1K Connectors
- 273 Workbench
- Cloud Amplifier
- 3 Federated
- 2.7K Transform
- 78 SQL DataFlows
- 525 Datasets
- 2.1K Magic ETL
- 2.9K Visualize
- 2.2K Charting
- 434 Beast Mode
- 22 Variables
- 510 Automate
- 114 Apps
- 388 APIs & Domo Developer
- 8 Workflows
- 26 Predict
- 10 Jupyter Workspaces
- 16 R & Python Tiles
- 332 Distribute
- 77 Domo Everywhere
- 255 Scheduled Reports
- 66 Manage
- 66 Governance & Security
- 1 Product Release Questions
- Community Forums
- 40 Getting Started
- 26 Community Member Introductions
- 67 Community Announcements
- 4.8K Archive