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
Will This work for you? I created a parameter to Select month, but you can choose if you need it or not?
Thanks
Deepak
For Jan
For Mar