Query advanced function | Community
Skip to main content
GiustaMa
Level 2
Sep 28, 2022 7:07 AM UTC
Solved

Query advanced function

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!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
bisswangAccepted solution
Employee
Sep 28, 2022 1:41 PM UTC

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
View reply

1 reply

bisswangAccepted solution
Employee
Sep 28, 2022 1:41 PM UTC

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
Translate
    Terms & ConditionsAccessibility statement

    Loading footer...