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
BedrockMission!

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

985

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

985

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