Expand my Community achievements bar.

Check out the November edition of the Analytics Community Lens newsletter to see what's been trending in the last two months!
SOLVED

Add a static number using a calculated metric

Avatar

Level 2

Hello,

 

I want to create a calculated metric that is a static number. For example, say the site has a fixed sales target for the year. I can create a graph in workspace to show cumulative sales as the year progresses using a calculated metric, but would like to be able to add an additional "target line" to the graph so I can easily see progress relative to the target. What I'm looking to replicate is something similar in look to the server call usage graph in the Admin console, where the annual limit is a flat line on the graph and the cumulative metric creeps towards it.

Is there a simple way to do this?

1 Accepted Solution

Avatar

Correct answer by
Level 10

@tcrewes1 , it's already supported by the metric builder:

 

Andrey_Osadchuk_0-1607598581782.png

 

View solution in original post

3 Replies

Avatar

Correct answer by
Level 10

@tcrewes1 , it's already supported by the metric builder:

 

Andrey_Osadchuk_0-1607598581782.png

 

Avatar

Level 2
Thank you @Andrey_Osadchuk, this is perfect, I was searching the components list and not seeing it. Appreciate the quick response.

Avatar

Level 8

Hi there,

 

Hopefully this is what you are after (based on a target of 120K orders) with 4 custom metrics:

David-123_5-1607598796605.png

 

 

 

 

 

Cumulative Orders:

David-123_0-1607598553116.png

David-123_1-1607598591708.png

David-123_2-1607598640354.png

 

David-123_4-1607598704318.png