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
BedrockMission!

Learn More

View all

Sign in to view all badges

New Unique Values

Avatar

Avatar
Validate 1
Level 2
JeffSt
Level 2

Likes

5 likes

Total Posts

7 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
View profile

Avatar
Validate 1
Level 2
JeffSt
Level 2

Likes

5 likes

Total Posts

7 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
View profile
JeffSt
Level 2

04-09-2018

Is there anyway to check new unique values.

Say we had a evar with a guid or a leads id. and on thursday we added 10 unique values and on friday we added 14.

Is there anyway to easily calculate this easily without going day by day and using count of function?

Thanks!

Jeff

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Shape 25
MVP
Andrey_Osadchuk
MVP

Likes

523 likes

Total Posts

943 posts

Correct Reply

255 solutions
Top badges earned
Shape 25
Bedrock
Coach
Boost 500
Affirm 250
View profile

Avatar
Shape 25
MVP
Andrey_Osadchuk
MVP

Likes

523 likes

Total Posts

943 posts

Correct Reply

255 solutions
Top badges earned
Shape 25
Bedrock
Coach
Boost 500
Affirm 250
View profile
Andrey_Osadchuk
MVP

06-09-2018

jeff35625053​, there is no a straightforward way for that.

I would advise the following method:

  • Configure an event with serialisation
  • Fire that event every time a value is set in the eVar. Serialise the event with the eVar value. This will guarantee that every value will have "1" as a metric (event) regardless how many times the value was passed to the eVar.
  • Run Analysis Workspace and add a freeform table. Add the event to the column. The rows will be filled in with days. The event metric will indicate the number of new values added in every day.

Let me know if that's helpful?

Answers (1)

Answers (1)

Avatar

Avatar
Validate 1
Level 2
JeffSt
Level 2

Likes

5 likes

Total Posts

7 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
View profile

Avatar
Validate 1
Level 2
JeffSt
Level 2

Likes

5 likes

Total Posts

7 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
View profile
JeffSt
Level 2

10-09-2018

Ok cool, this is definitely interesting looking into it.

Allows to create an event that doesn't count several times and de-duplicates everything.

I think that this would work, but the situation that I'm in I don't have the granular control on implementation for something like this. So I would need another solution that would allow me to do the calculations down to the day without having to setup 50+ calculated metrics or doing calculations outside of AA.

Thanks for your response though, it does help for those starting out or with more control on the implementing side!

Best,

Jeff