Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hey guys,
I have this column called COOKIE_ID and a column VISIT_ID.
I want to figure out if a visitor (identified by COOKIE_ID) comes for the first time or is a returning visitor or an annonymous visitor.
For this I figured I write the following formula:
What am I doing wrong here?
Solved! Go to Solution.
Silly me... I was using a measure instead of calculated column.
Silly me... I was using a measure instead of calculated column.
Hi @Anonymous
try to wrap it with MAX
Hey Tamer,
Even if I wrap it in MAX I get the following error:
A single value for column 'COOKIE_ID' in table 'OD - All Page Visits Portal' cannot be determined. This can happen if the measure formula refers to a column that contains many values and no aggregation such as min, max, count, or sum has been specified to obtain a single result.
@Anonymous
That is strange. Would you please paste the a screenshot of the formula along with the error message?
If you look at the screenshot above, you can see that COOKIE_ID is underlined in red.
The error message is in Dutch, I translated it above.
I cannot select COOKIE_ID in this formula.
@Anonymous
But if you wrap it with MAX you should not receive an error asking you to provide aggregation of the column because MAX is an aggregator. This why I asked you to provide a screenshot of the measure code to mske sure no mistake in the code. However, please make sure the MAX function is placed inside the ISBLANK function not outside.
User | Count |
---|---|
54 | |
23 | |
19 | |
18 | |
17 |
User | Count |
---|---|
89 | |
87 | |
50 | |
34 | |
22 |