Highlighted

Anaysis Workspace: Calculated Metric for Working or Business Days in a Month

maureenf8735217

02-02-2017

Hello,

Has anyone found a way to calculate average daily activity or events based on working days in a month? For example, JAN2017 has 20 working days. If there were 1000 instances of Event 30, I want to be able to show: events "Last Month" divided by the number of working days last month - in a calculated metric - generated automatically in dashboard updates.

Thank you for sharing an experience you've had with this. 

Replies

Highlighted

maureenf8735217

06-02-2017

Maureen Fogel wrote...

Hello,

Has anyone found a way to calculate average daily activity or events based on working days in a month? For example, JAN2017 has 20 working days. If there were 1000 instances of Event 30, I want to be able to show: events "Last Month" divided by the number of working days last month - in a calculated metric - generated automatically in dashboard updates.

Thank you for sharing an experience you've had with this. 

 

Also - for Adobe - working days would be different than what is available now (weekdays) as working days would consider holidays which would be different every month.