Hello Beast Mode experts,
I have a web activity dataset with IP_Address and Session_ID columns
The relation between the columns is: possible one or more Session_IDs per one IP_Address
When there is one Session_ID per one IP_Address then I count One Time Visit
When there is more than one Session_IDs per one IP_Address then I count Return Visit
I have created this (test) Beast Mode
case when Count (Distinct `session_id`) = 1 then 'Return Visit' else 'One Time Visit' end
It returns the correct text value when I use in table chart type as below but I cannot use Sum or Count for these values and it only returns Count in the Total line
IP_Address | Distinct Session ID Count | Visit Type |
11.11.11.11 | 4 | Return Visit |
11.11.11.12 | 1 | One Time Visit |
11.11.11.13 | 3 | Return Visit |
11.11.11.14 | 1 | One Time Visit |
11.11.11.15 | 1 | One Time Visit |
11.11.11.16 | 2 | Return Visit |
GRAND TOTAL | 12 | Count 6 |
Also, when using the new text field as filter I can see only the Return Visitor value which means the One Time Visitor value exists only in the table alongside the IP_Address value but not on its own.
* What woule be the correct beast mode to use to make the Distinct count per specific IP_Address and not by all ? (or is there a way to use Select in beast mode) ?
Thanks for the help
Joseph