Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have made an expression which gives me all sessionuserid where they only have 1 buy. I can make this in a straight table and then sum of total rows. Then i get row many SessionUserIDs who only bought once.
How do i show this in an textbox?
In picture you can see expression - Maybe it can be made otherwise?
Thanks
In texbox:
sum(aggr(YourExpression,YourFirstDimension,YourSecondDimension, etc.)
In texbox:
sum(aggr(YourExpression,YourFirstDimension,YourSecondDimension, etc.)
Hi
Try like this
= Sum(Aggr(if(Count({<EventType={'Buy'}>}distinct SessionIDINT)=1, 1, 0), SessionUserID))