Division Question

chrissy · 2022-09-19T21:59:50+00:00

There was an error rendering this rich post.

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.

Find more posts tagged with

Accepted answers

GrantSmith

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)

All comments

GrantSmith

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)

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Best Of