How to identify occurrences with common value between two dimensions | Community
Skip to main content
B
bhutton
Level 2
April 17, 2024
Solved

How to identify occurrences with common value between two dimensions

  • April 17, 2024
  • 1 reply
  • 924 views

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!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Jennifer_Dungan

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!

1 reply

Jennifer_Dungan
Community Advisor and Adobe Champion
Jennifer_DunganCommunity Advisor and Adobe ChampionAccepted solution
Community Advisor and Adobe Champion
April 17, 2024

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!

    Vinay_Chauhan
    Community Advisor
    Vinay_ChauhanCommunity Advisor
    Community Advisor
    April 17, 2024

    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.

      Terms & ConditionsAccessibility statement

      Loading footer...