topic Re: "p" in set analysis in App Development

"p" in set analysis

BPetosa — Tue, 21 May 2019 20:52:46 GMT

Hello Everyone,

I am attempting to count distinct session_id's that have done event 33 after already doing event 36. This is in a table visualization with segment _id as the dimension. The weird thing is it works when I query an individual segment_id, but is wrong when looking at all the segments at once. I wonder if I am missing an argument? Here is what I have:

count({<session_id = p({<event_type={36}>}) * p({<event_type={33}>}) >} distinct session_id)

Table:

segment_id event_type36 formula above

1 100 80

2 250 200

** the weird part is that the above is wrong. When I query segment_id = 1, I get:

segment_id event_type36 formula above

1 100 70

*This is correct when I query by individual segment.

any help is much appreciated.

Thanks,

Ben

Re: "p" in set analysis

lironbaram — Wed, 22 May 2019 05:24:53 GMT

i created a formula similar to yours on a data set i have and it seems to work

how does the fields event type and session_id and segment_id are connected

are they all in the same table , or in different tables

Re: "p" in set analysis

BPetosa — Wed, 22 May 2019 15:10:57 GMT

They are all in the same table. However, they are also spread across other tables as well and this particular app is large (100+ tables). I am going to create a new app with just the main table, and see if it works then.

Thanks,

Ben