Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

pierre-yvesm520
pierre-yvesm520
Offline

Badges

Badges
7

Accepted Solutions

Accepted Solutions
0

Likes Received

Likes Received
3

Posts & Comments

Posts & Comments
7

Discussions

Discussions
0

Questions

Questions
2

Ideas

Ideas
0

Blog Posts

Blog Posts
0
Expand more
Expand menu
View leaderboards
Profile
Trophy case
Top badges earned by pierre-yvesm520
Customize the badges you want to showcase on your profile
Give Back 5
Give Back 3
Give Back
Ignite 1
Validate 1
Boost 3
Boost 1
How to use the SetVar function ?
pierre-yvesm520
- Adobe Campaign Standard 11-07-2019
Hello,I'd like to know how to use the SetVar function avaliable in advanced expression editor.Can anyone give me a use case of this feature please ?Thanks in advance,Pierre-Yves

Views

630

Likes

0

Replies

0
Re: Problem with aggregate function in ACS
pierre-yvesm520
- Adobe Campaign Standard 17-12-2018
OK Thanks to both of you for your answers.asish kumarp59945245 : I'll find a way to perform the calculation I need without using the agregate functions on the advanced expression editor then.anasso21228396​ : I could effectively use the collections to perform agregate calculations (but i'll have to adapt my workflow before)

Views

2.6K

Likes

0

Replies

0
Re: Problem with aggregate function in ACS
pierre-yvesm520
- Adobe Campaign Standard 12-12-2018
Hello,The query in on profiles for example, see below.- Profile : Has children = YesAnd in additionnal Data :- Average(age)This cause an error in the query :I hope my post is detailed enough.Thanks in advance

Views

2.4K

Likes

0

Replies

0
Re: Problem with aggregate function in ACS
pierre-yvesm520
- Adobe Campaign Standard 11-12-2018
Hello,I dont have such options, I working on Adobe Campaign Standard (ACS) and the only option avaliable is to remove duplicate rows :(The screenshot is from a french version)

Views

2.4K

Likes

0

Replies

0
Problem with aggregate function in ACS
pierre-yvesm520
- Adobe Campaign Standard 06-12-2018
Hello, I have a problem using aggregate function in ACS.When I add an additionnal data wich is based on the SUM() function in a simple query activity, I get a PostgreSQL Error : column "n1.irecipientid" must appear in the GROUP BY clause or be used in an aggregate function.I can't do any aggregate, could you help me please.Thanks

Views

4.8K

Likes

3

Replies

11