How to create a calculate metric that shows month-specific targets | Community
Skip to main content
Level 2
February 24, 2023
Solved

How to create a calculate metric that shows month-specific targets

  • February 24, 2023
  • 2 replies
  • 971 views

Dear all,

 

I would really appreciate, if you could help me, which function I can use to create a calculate metric that shows month-specific targets to be able to make a comparison of measured monthly revenue versus static month-specific target numbers.

 

Best regards Martin

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by yuhuisg

Do your monthly targets change every month? E.g.

January: 20,000

February: 10,000

March: 100,000

etc.

If so, then it probably could be done, but it won't be trivial.

2 replies

yuhuisg
Community Advisor
yuhuisgCommunity AdvisorAccepted solution
Community Advisor
February 24, 2023

Do your monthly targets change every month? E.g.

January: 20,000

February: 10,000

March: 100,000

etc.

If so, then it probably could be done, but it won't be trivial.

Ma_Ha_01Author
Level 2
February 24, 2023

Yes! Targets differ from month to month. 

Jennifer_Dungan
Community Advisor and Adobe Champion
Community Advisor and Adobe Champion
February 24, 2023

So I believe what you are saying is you want a monthly specific target that you compare your actual with (something like metric - target / metric  OR  target - metric / metric but with monthly specific targets)?

 

You can create a series of nested IF statements to check for the month, the set a target using a static value:

 

 

Then you can built this nested setup in conjunction with your calculation. You will notice that I used occurrences here, this is just the most all-inclusive metric to ensure that there is data to match against the month of the year... Since we are overriding the value with a static target anyway, this can be used for any other type of these nested IF value type of logic blocks.

 

You will use your actual metric into the math where you calculate the difference and then do your division to get your % difference.