Avatar

Community Advisor

you can use "approximate count distinct" with a weekday segment to get the number of a certain werkday in a specific month. but this only works for past data since you need to have at least one hit on each weekday to coont agsinst...

I would do this in excel or any other tool outside of analytics...

If you want to use workspace (and calculated metrics) you might try to upload a metric for each day using data source. basically you could upload a metric value for each day which indicates the number of werkdays the month have... (would be 4 for each day in february...)

the drawback is, that you can't upload data for the future, you might need to upload every day.... (hope I'm not wrong with this statement...)