Jump to content
We've recently updated our Privacy Statement, available here. ×

Seeking formula


Robin Stoevelaar

Recommended Posts

Hi all,

It could be that it is too easy, but I cannot think of a formula or method that gives me the outcome I need. I have a data table containing 4 columns as below

 

 

 

ID

Position

Chances

Conversions

 

 

A

1

3

1

 

 

A

1

2

0

 

 

A

1

4

2

 

 

A

3

6

5

 

 

A

1

4

2

 

 

A

1

2

2

 

 

B

2

6

3

 

 

B

2

1

1

 

 

B

6

2

2

 

 

 

I made an average on conversions vs chances, I made a cross table so that I can see that ID A made 7 conversions on 15 chances at position 1 etc. etc. But I want to filter on the couple of chances at a particular position, so that I can see the average conversions with a minimum amount of chances at that particular position. (It wouldn't be fair if person B would win with 100% conversion rate at position 6 while only having 2 chances, right)

 

Hope I am clear on what I want to archieve, I hope you could help me.

Thanks in advance!

Robin

Link to comment
Share on other sites

  • 1 month later...

Can you provide screenshot of your expected output. As it is not clear how you want to show them. If it in cross table, filtering on chances will automatically populate on those records.

Filter cannot be applied to calculated column unless you setup a datafunction to update a document property based on filter selection and then use that document property in the expression of the calculated column

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...