Beast Mode Percentage

Options
Jerone
Jerone Member
edited March 2023 in Beast Mode

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 rate

English > Japanese - 2467 jobs received in the past 12 months - 45 complaints received - 1.82% complaint rate Hoping for a little help here

😀



Answers