Selection Count

Name

Entries

Previous Stage

Conversion Rate

Prospect

10

4

5

16

21

18

26

1

20

29

13

25

31

15

23

6

17

12

22

3

27

2

24

14

19

11

9

8

7

28

30

Qualified

NaN

Qualified

8

4

5

16

21

26

1

20

29

13

25

31

15

23

6

10

17

12

22

3

27

2

Technical Validation

NaN

Technical Validation

1

4

5

16

21

26

20

29

13

25

31

15

23

6

Business Validation

NaN

Business Validation

2

3

4

5

16

21

26

1

20

29

13

25

31

Contract Negotiation

NaN

Contract Negotiation

9

4

5

16

21

26

1

20

29

Closed Won

NaN

Closed Won

6

7

NaN

Count · Rollup

• Relation: Entries

• Property: Name

• Calculate: Count all

Conversion Rate

(prop("Previous Stage")
	.first()
	.prop("Entries")
	.length()
/ prop("Entries").length() * 100)
.round()
/ 100

(prop("Previous Stage").first().prop("Entries").length()
/ prop("Entries").length() * 100)
.round()
/ 100

By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!

round(prop("Previous Count") / prop("Count") * 100) / 100