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

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

maureenf8735217
Level 2
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
maureenf8735217
Level 2
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.