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.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 282 Workbench
- 3 Cloud Amplifier
- 4 Federated
- 2.8K Transform
- 86 SQL DataFlows
- 548 Datasets
- 2.2K Magic ETL
- 3.2K Visualize
- 2.3K Charting
- 544 Beast Mode
- App Studio
- 26 Variables
- 566 Automate
- 134 Apps
- 411 APIs & Domo Developer
- 21 Workflows
- DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 345 Distribute
- 87 Domo Everywhere
- 257 Scheduled Reports
- 1 Software Integrations
- 85 Manage
- 84 Governance & Security
- 8 Product Release Questions
- Community Forums
- 41 Getting Started
- 27 Community Member Introductions
- 81 Community Announcements
- 4.8K Archive