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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

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

1 Reply

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