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

Avatar

Avatar
Validate 1
Level 1
maureenf8735217
Level 1

Likes

0 likes

Total Posts

11 posts

Correct reply

1 solution
Top badges earned
Validate 1
Affirm 1
View profile

Avatar
Validate 1
Level 1
maureenf8735217
Level 1

Likes

0 likes

Total Posts

11 posts

Correct reply

1 solution
Top badges earned
Validate 1
Affirm 1
View profile
maureenf8735217
Level 1

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

Avatar

Avatar
Validate 1
Level 1
maureenf8735217
Level 1

Likes

0 likes

Total Posts

11 posts

Correct reply

1 solution
Top badges earned
Validate 1
Affirm 1
View profile

Avatar
Validate 1
Level 1
maureenf8735217
Level 1

Likes

0 likes

Total Posts

11 posts

Correct reply

1 solution
Top badges earned
Validate 1
Affirm 1
View profile
maureenf8735217
Level 1

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.