1 Reply Latest reply on Mar 30, 2018 7:13 PM by Deepak Rai

    Graphing subtotal averages

    Tommy Shimomura-Nguyen

      I want to make this formula fully automated every time i update my data source. I dont want to enter the number of weekdays or weekend days in a month every time i update the data source. I feel like i am missing a formula to replace the denominator of the formula shown below. For example average weekday formula is total count / 17 days. avg weekend is total count of weekend / 7 days.

       

       

       

       

      My goal is to graph these sub total averages .

       

       

      mahalo,

       

      TN