
I'm struggling to find a solution to calculate the daily sales average which is sales divided by the number of operating days. This makes a comparable values between partial and complete months.
Each operating day has thousands of records. The problem I'm running into is calculating the correct denominator. I have the schedule pulled into Tableau with True/False listing the non-operating days.
Each operating day has hundreds of records so a formula like below produces an insane value.
{FIXED : COUNTD(IF [Operating Day = True] THEN [Ship Date] END)}

I figured out an answer. In the dataset I added a count of the working days by month and in the workbook added a DATEDIFF field between the min(operating day) and max(operating day) and took an average of that result.