topic Using P in Set Analysis in App Development

Using P in Set Analysis

Josh — Sat, 16 Nov 2024 03:55:32 GMT

Hey community,

Scenario:

I have a website that shows videos. Before entering the video, there is a pretest.

I am trying to find the amount of people who took the pretest and watched the segment. (I can't use an "if" statement as the fields are from different databases and the numbers come all messed up). I am trying to use the possible P into the equations and it has yet to work for me.

The fields are session_id, quiz_type, and event_type.

Once again I need the count of distinct session_id's that took the pretest (quiz_type = 1) and played the video (event_type=33,34,35).

This is the code I tried.

Count(${<session_id = P({<event_type={33,34,35}, quiz_type = {1} >} distinct session_id)>} distinct session_id)

It actually produces the same result as

Count( distinct session_id)

which means something is wrong in here ${<session_id = P({<event_type={33,34,35}, quiz_type = {1} >} distinct session_id)>}

Any help is greatly appreciated!

Re: Using P in Set Analysis

y_grynechko — Wed, 04 Dec 2019 17:11:11 GMT

Hey, can you share some data sample?

Re: Using P in Set Analysis

Josh — Wed, 04 Dec 2019 17:41:07 GMT

So there are two tables with session_Id being the primary keys.

Re: Using P in Set Analysis

sunny_talwar — Wed, 04 Dec 2019 18:03:44 GMT

What is the expected count of sessions id based on the input shared?

Re: Using P in Set Analysis

Josh — Wed, 04 Dec 2019 18:11:37 GMT

For this particular example: the output for distinct session_id should be 3. Because A,B,and C all have a 1 for a quiz type and at least 1 of the 3 required event_types (33,34,35).

Re: Using P in Set Analysis

sunny_talwar — Wed, 04 Dec 2019 18:21:06 GMT

Your expression with small modifications give me 3

Count({$<session_id = P({<event_type = {33,34,35}, quiz_type = {1}>} session_id)>} DISTINCT session_id)

1) Note that $ comes after { and not before

2) DISTINCT is not needed within the p() function

Re: Using P in Set Analysis

Josh — Wed, 04 Dec 2019 18:27:56 GMT

Sunny,

Unfortunately that didn't work....it gives me 0.

However, with some trial and error over the past few hours we have this now that seems to work....BUT I would appreciate feedback on what people think of this new formula. Just want to see if it seems sound as I am not used to using *.

=count( {< session_id = p( {<quiz_type={1}>} ) * p( {<event_type={33,34,35}>} ) >} distinct session_id)

Re: Using P in Set Analysis

sunny_talwar — Wed, 04 Dec 2019 18:35:25 GMT

Did you open the .qvf file and not seeing this?