Query advanced function | Adobe Higher Education
Skip to main content
G
GiustaMa
Level 2
September 28, 2022
Beantwortet

Query advanced function

  • September 28, 2022
  • 1 Antwort
  • 784 Ansichten

Hi all,

I want to query profiles that have total purchase of brand X > total purchase of brand Y.
This data comes from a custom table where we only have the brand chosen by the profile and the total purchase. Brand is text type and the total purchase is floating number type.

I tried doing the query using the advanced function but without result.
Is there anyone who can help me?

 

Thanks!

Dieses Thema wurde für Antworten geschlossen.
Beste Antwort von bisswang

unfortunately you can't do an easy direct comparison on this in a single query.

You rather have to:

  • Do a query to determine the profiles
  • Add the purchase table as relations (with a filter / collection config)
  • Add the amount fields as additional data
  • In a following step (e.g. segmentation) you can then compare the values derived before

1 Antwort

B
Adobe Employee
bisswangAdobe EmployeeAntwort
Adobe Employee
September 28, 2022

unfortunately you can't do an easy direct comparison on this in a single query.

You rather have to:

  • Do a query to determine the profiles
  • Add the purchase table as relations (with a filter / collection config)
  • Add the amount fields as additional data
  • In a following step (e.g. segmentation) you can then compare the values derived before
    Allgemeine NutzungsbedingungenAccessibility statement

    Loading footer...