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

dasparomita1984
Level 1
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
yuhuisg
Correct answer by
Community Advisor
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
yuhuisg
Correct answer by
Community Advisor
Community Advisor

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

dasparomita1984
Level 1
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