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

How to set up future kpi's by use of calculated metric?

Avatar

Avatar
Validate 1
Level 3
saraht69310464
Level 3

Likes

39 likes

Total Posts

29 posts

Correct Reply

3 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
View profile

Avatar
Validate 1
Level 3
saraht69310464
Level 3

Likes

39 likes

Total Posts

29 posts

Correct Reply

3 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
View profile
saraht69310464
Level 3

17-06-2019

Hi there,

We are trying to set up a calculated metric representing a target KPI which is different for each month of the year, and used the IF-condition (see screenshot).

Variable target - if condition.png

We notice that it only works for past/current month(s) but not for future months since the # of visits = 0 there (see screenshot).

Variable target - result table.png

Does someone has an idea about how to set this up?

Thanks in advance,

Sarah

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Coach
MVP
ursboller
MVP

Likes

521 likes

Total Posts

1,020 posts

Correct Reply

256 solutions
Top badges earned
Coach
Contributor
Bedrock
Seeker
Springboard
View profile

Avatar
Coach
MVP
ursboller
MVP

Likes

521 likes

Total Posts

1,020 posts

Correct Reply

256 solutions
Top badges earned
Coach
Contributor
Bedrock
Seeker
Springboard
View profile
ursboller
MVP

17-06-2019

I think it isn't easy to create a metric like this. the problem is that the dimension used as rows filters the data and does not allow to check outside...

I once saw a possible way to go but can't find it anymore. however, maybe you can use some fancy "cumulative sum" (where you look back for the last x month) and segments for last/previous month to find out in what month you might be.

One idea: why don't you use the dimension "month of year" which would allow to check data (month) of "last year" to figure out in which row you are. the display something based on current year. to achieve this, you need to have full data of last 2 years in the table (or in the metric)... never tried it but might work

Answers (1)

Answers (1)

Avatar

Avatar
Validate 1
Level 3
saraht69310464
Level 3

Likes

39 likes

Total Posts

29 posts

Correct Reply

3 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
View profile

Avatar
Validate 1
Level 3
saraht69310464
Level 3

Likes

39 likes

Total Posts

29 posts

Correct Reply

3 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
View profile
saraht69310464
Level 3

20-06-2019

Thanks! Your idea worked well for us.