ncelis Member

Comments

  • So I am closer to a solution using this Beast Mode: COUNT(DISTINCT CASE WHEN (Team Member Status = 'Active' OR Team Member Status = 'Unpaid Leave') THEN Team Member ID END) / COUNT(DISTINCT Date Scaffold) This "Average Headcount" now matches my "Active Headcount" totals on a daily basis which is great! (There are 2 lines…
    in Average Count Distinct across Date Range Comment by ncelis January 30
  • Thanks @Jones01 but now I receive an error stating that one of the columns does not exist (event though all columns we're recognized in previous calc). I wish Domo error messages were more descriptive:
    in Average Count Distinct across Date Range Comment by ncelis January 30
  • Thanks @MichelleH, but it looks like Domo is still throwing an error. Here is your calc with my specific field names, and the error message:
    in Average Count Distinct across Date Range Comment by ncelis January 29
Default Avatar