Expand my Community achievements bar.

Announcement: Calling all learners and mentors! Applications are now open for the Adobe Analytics 2024 Mentorship Program! Come learn from the best to prepare for an official certification in Adobe Analytics.
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.