Expand my Community achievements bar.

The Analytics Community Lens news letter for February 2024 is now here! Come see upcoming events and what's been going on in the community!

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

Avatar

Level 2

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. 

1 Reply

Avatar

Level 2

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.