Division Question
Hello,
I am trying to find a formula to see the total utilization for online scheduling vs offline scheduling for certain exam types. Online vs. Offline exams are within the same SQL column ('appt_source' will either = 'OFFLINE' or 'ONLINE') whereas exam types are within a separate column ('Modalities'). Any suggestions on how to do this would be great, thank you.
0
Best Answer
-
You can use a beast mode and a case statement to conditionally Sun your values the following will give you the percentage of offline. Create another beast mode for ONLINE
SUM( CASE WHEN `appt_source` = 'OFFLINE' THEN 1 END) /SUM(1)
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2
Categories
- 7.3K All Categories
- 13 Getting Started in the Community
- 141 Beastmode & Analytics
- 1.8K Data Platform & Data Science
- 54 Domo Everywhere
- 2K Charting
- 1K Ideas Exchange
- 903 Connectors
- 236 Workbench
- 342 APIs
- 77 Apps
- 19 Governance & Productivity
- 235 Use Cases & Best Practices
- 50 News
- 473 Onboarding
- 573 日本支部