Skip to Content
0
Former Member
Jan 28, 2014 at 04:04 PM

Counting Unique Variables in Webi (Related to duplicates)

1381 Views


Hello,

I'm not sure where to post this, so I hope this is the correct section. I'm trying to count the number of unique forms and I've tried using both the count and sum functions using distinct and all, but nothing is giving me the desired results.

First Name Last Name Form Number John Smith 123 Annie Jones 139 Duncan Hines 139 Betty Crocker

180

I'm working on a summary table that should look like the one below.

Number
of Unique Forms 3 Number of Combined Forms 1

Any suggestions?

By the way I'm using an older version of BOXi, if that matters. We're still on 3.1 here.