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

Counting Unique Variables in Webi (Related to duplicates)



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


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

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.