I would like to know how I can get the unique number of form submissions with a scenario below?
Contact ID = "A" submits form "Y"
Contact ID = "A" submits form "Y"
Contact ID = "A" submits form "Z"
This is currently calculated as:
Total Form Submissions: 3
or
Unique form submissions: 1
What I would like to see here is: 2 (As Contact A has submitted two different forms)
How can I achieve this with the Oracle Business Intelligence tool in Eloqua?