Expand my Community achievements bar.

SOLVED

custom metric to flag a certain % change

Avatar

Level 1

Hi,

 

Is there a way to create a a custom metric that looks at URL traffic for two different period and flag those are down by a certain %?

 

Thanks in adv for help!

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

You could use the IF function in a calculated metric to return 1 or -1 appropriately.

View solution in original post

2 Replies

Avatar

Correct answer by
Community Advisor

You could use the IF function in a calculated metric to return 1 or -1 appropriately.

Avatar

Level 1

Hi Yuhuisg,

 

Thanks so much for your answer!

I had to first create a custom metric for '% change' to use in the metric with 'IF' function and it worked! One correction though IF function uses 1 and 0 when returns TRUE and FALSE. 

 

Thanks again,

Paromita