You can use SQL to divide columns. The key is to cast a number as an float, or multiple by 1.0 to get it to work so it doesn't show up as just zeros.

SELECT date, total_created, admin_created, client_created, 1.0*admin_created/total_created as percentage  
FROM report1; 

This zero is because SQL is treating the result as a whole number, and since the number is smaller than 1, it shows as zero. 

You can also use Grows calculated columns to divide columns and you don't have to worry about casting numbers 😉

If you have any questions please chat in and let us know.

Did this answer your question?