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

antti_nylund
Community profile antti_nylund Level 1
Job title here
Location here
4 BADGES
Level 1

Level 1

Learn more
Joined the community 15-01-2019 4:46:16 AM
Offline
Top badges earned by antti_nylund
Customize the badges you want to showcase on your profile
Re: Counting number of Mondays for running month
Avatar
Give Back 3
Level 1
antti_nylund
Level 1

Likes

0 likes

Total Posts

5 posts

Correct reply

0 solutions
Top badges earned
Give Back 3
Give Back
Ignite 1
Validate 1
View profile
antti_nylund
- Adobe Analytics
So currently:Yearly target: 100Monthly multiplier (towards yearly goal): 0.1Target for this month: 10Number of each weekday in this month: 4 (February is easy)Multipliers for each weekday:Mon: 0.25Tue: 0.25Wed: 0.09Thu:0.25Fri: 0.04Sat:0.06Sun:0.06Monthly and weekday multiplier were calculated based on last year performanceSo my target for1st of Feb (Friday) would be100*0.1*(0.04/4) = 0.12nd of Feb (Saturday)100*0.1*(0.06/4) = 0.153rd of Feb (Sunday)100*0.1*(0.06/4) = 0.154th of Feb (Monday)100*...

Views

989

Likes

0

Replies

1
Re: Counting number of Mondays for running month
Avatar
Give Back 3
Level 1
antti_nylund
Level 1

Likes

0 likes

Total Posts

5 posts

Correct reply

0 solutions
Top badges earned
Give Back 3
Give Back
Ignite 1
Validate 1
View profile
antti_nylund
- Adobe Analytics
I would like to build a daily target. I have monthly target of 100%. Data indicates that in average Monday, Tuesday and Thursday deliver 25% of Monthly target each and the rest 25% is divided with the rest of the days. I calculated the average from 3 months and made sure that each weekday was present same amount of times.Since amount of weekdays is changing by the month I cannot use static number like 4. If I use COUNT IF day=Monday function in early Feb it would give me 0 or 1 depending if ther...

Views

989

Likes

0

Replies

2
Counting number of Mondays for running month
Avatar
Give Back 3
Level 1
antti_nylund
Level 1

Likes

0 likes

Total Posts

5 posts

Correct reply

0 solutions
Top badges earned
Give Back 3
Give Back
Ignite 1
Validate 1
View profile
antti_nylund
- Adobe Analytics
I'm trying to get the number of Mondays in this month (February).Today is the first Monday of Feb so any way I try I get value 1.The goal would be to get value 4 which is the number of Mondays.Any ideas?

Views

1.2K

Likes

0

Replies

4
Re: Change order of nested containers in Calculated metrics builder
Avatar
Give Back 3
Level 1
antti_nylund
Level 1

Likes

0 likes

Total Posts

5 posts

Correct reply

0 solutions
Top badges earned
Give Back 3
Give Back
Ignite 1
Validate 1
View profile
antti_nylund
- Adobe Analytics
Thanks!That is what I feared... Can you tell if there is a chance for feature request and where to submit that?

Views

134

Likes

0

Replies

0
Change order of nested containers in Calculated metrics builder
Avatar
Give Back 3
Level 1
antti_nylund
Level 1

Likes

0 likes

Total Posts

5 posts

Correct reply

0 solutions
Top badges earned
Give Back 3
Give Back
Ignite 1
Validate 1
View profile
antti_nylund
- Adobe Analytics
Hello,I have container (Cumulative sum) that contains multiple containers. Can I remove Cumulative sum container surrounding the other containers or do I have to start all over?Thanks!

Views

278

Likes

0

Replies

3