Percentage Calculation

chrissy

Hi -

I am trying to find the % of one column of items compared to another. Specifically, the percentage of "online appointments" (a filtered option of "all appointments") compared to "all orders submitted". I cannot figure out the formula.

Previously, when figuring out the % of online scheduled appointments compared to all scheduled appointments I used the below formula:

case

when sum( case when `appt_source` = 'ONLINE' then 1 end) 

/ sum(1) is NULL then 0 

ELSE sum( case when `appt_source` = 'ONLINE' then 1 end) 

/ sum(1)

end 

However, online / offline appointments were a part of the same column of data. I'm not sure how to replicate this method with 2 columns. Thanks!

DashboardDude

Hi @chrissy ,

You are basically there. I think you just need to move your "sum" to the front of the line. Here's a video I made for you showing you how to do so: https://www.loom.com/share/d57f4594c62245d5b3a4f3fcf5dd22a8

John Le

You're only one dashboard away. 

More video solutions at: https://www.dashboarddudes.com/pantry