Jerone

Discussions

Beast Mode Percentage
Pretty new to domo but is this formula the correct way of getting the percentage of items "sum(`complaint`) / COUNT(`job_number`)" complaint is either a 1 or 0 and job numbers are integers The ask is something like this English > German - 1467 jobs received in the past 12 months - 58 complaints received - 3.95% complaint…
ETL Option to blank field
Im trying to get a field that has blank values to get data from another field is there another way of saying this formula? case when `company_name` = '' then `group_name` else `company_name` END somehow this is not working any other way of saying blank value in domo?