Expand my Community achievements bar.

Join us for the next Community Q&A Coffee Break on Tuesday April 23, 2024 with Eric Matisoff, Principal Evangelist, Analytics & Data Science, who will join us to discuss all the big news and announcements from Summit 2024!
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

5 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 1

Hi Andrey, I tried looking for this earlier but I saw that it was removed. Any idea how I can see the static number now?

 

NelsonLi_0-1705543430077.png

 

Avatar

Level 2

Hi NelsonLim, are you looking to the calculated metric builder or the segment builder?

I may be wrong, but it looks like your screen shot is from segment builder, I believe the Static number functionality lives in the calculated metric builder.

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