show if expression sum in text box

[#1]

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

[Nicole-Smith · Accepted solution]

In texbox:

sum(aggr(YourExpression,YourFirstDimension,YourSecondDimension, etc.)

[MayilVahanan]

Hi

Try like this

= Sum(Aggr(if(Count({<EventType={'Buy'}>}distinct SessionIDINT)=1, 1, 0), SessionUserID))