Expand my Community achievements bar.

SOLVED

How to identify occurrences with common value between two dimensions

Avatar

Level 3

Hello,

 

My team has eVar dimensions (X & Y for this example) for two cookie ID values, and we recently noticed that dimension Y is presenting as duplicate of dimension X. We want to see how long this has been happening and create an alert to be notified if it continues to happen.

 

Is there a segmentation method to view the occurrences where dimension Y has the same value as dimension X?

 

Thank you!

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Unfortunately, this feature doesn't exist.. this is one area that I know is often requested... either for use in Segments or in Calculated Metrics.

 

The best I can suggest at this time is to create a Report Builder report pulling in the two dimensions, then use Excel formulas such as VLOOKUP / MATCH to identify where X equals Y. Or even doing a Data Warehouse extract, and using Excel to find the issues.

 

Good luck!

View solution in original post

2 Replies

Avatar

Correct answer by
Community Advisor

Unfortunately, this feature doesn't exist.. this is one area that I know is often requested... either for use in Segments or in Calculated Metrics.

 

The best I can suggest at this time is to create a Report Builder report pulling in the two dimensions, then use Excel formulas such as VLOOKUP / MATCH to identify where X equals Y. Or even doing a Data Warehouse extract, and using Excel to find the issues.

 

Good luck!

Avatar

Community Advisor

I agree with Jennifer, this problem could have easily been solved if we can compare dimension values in calculated metrics.

Please download the csv format for both the dimensions (evar x and y) and then in a new column in excel, write a formula to divide evar x/evar y, and for all the values where you get 1, you have required entries.