Expand my Community achievements bar.

Applications for the 2024-2025 Adobe Analytics Champion Program are open!

How to identify occurrences with common value between two dimensions


Level 3



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 help categorize Community content and increase your ability to discover relevant content.

2 Replies


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!


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.