Hi everyone,
I have a B2B survey where multiple respondents can belong to the same property. Each property has a unique Property code.
For example:
| Respondent | Property Code | Status |
|---|---|---|
| Owner 1 | M001 | Complete |
| Owner 2 | M001 | Complete |
| Owner 3 | M002 | Complete |
| Owner 4 | M003 | Incomplete |
I need the response rate to be based on unique properties, so the numerator should be 2, not 3.
Property Response Rate = Unique Property code with ≥1 completed response / Total eligible properties
We are using Legacy Dashboard Data Mapper, not Data Modeler.
Is there a native way or workaround to calculate a distinct Property Code count based on completed responses in the dashboard?
