Hi, if you wish to count appearance of every Cookie ID, you should use Subset formulas

SUBSET_NONEMPTYCOUNT([Cookie ID], SUBSET([Cookie ID]))

You can also have different cookie count for every visit, where you see same ID, but at a different time. In that case you will use above formula, but will replace SUBSET with SUBSET2, that will combine [Cookie ID] with [Time] field.
In this scenario you will have to format the Time field to be a date field, and contain dd/MM/yyyy elements (day part can be hidden, but must be present in the field).

For a summary - list of cookie IDs and count against each - use Aggregation in the Table View, with Singleton as default function in your formula field.

Hi Paola,

Thanks for your response. The problem with the above, is that the formula has given the total number of Cookie ID appearances per row rather than counting each one individually.

If you can let me know if there is another formula to use or a workaround that would be great.

Many thanks,

Sherrick Chavda

Hi, this formula will count appearances of the same Cookie Id, and list them in chronological order (in my case Date/Time field).

RANK([Date],[Date],true, SUBSET([Cookie ID]))

"True" stands for ascending order - if omitted order will be descending.

If we were to use your data set (where there is no Date/time field) you could add a row number, as a new field, and then replace [Date] with that field in the Rank function above.

CURRENTROW()