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.

Best Answer

  • GrantSmith
    GrantSmith Coach
    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!**

Answers

  • GrantSmith
    GrantSmith Coach
    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!**