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

SOLVED

New Unique Values

JeffSt
Level 2
Level 2

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

1 Accepted Solution
Andrey_Osadchuk
Correct answer by
Community Advisor
Community Advisor

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?

View solution in original post

2 Replies
Andrey_Osadchuk
Correct answer by
Community Advisor
Community Advisor

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?

View solution in original post

JeffSt
Level 2
Level 2

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