custom metric to flag a certain % change

[dasparomita1984]

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!

[yuhuisg · Accepted solution]

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

[dasparomita1984]

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