Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Coffee Break: Join us on Wednesday, April 5th at 10am PT to chat with Ben Gaines, Director of Product Management for Adobe Analytics. Ben will be online to answer your Analytics and Adobe Summit questions.

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.