I'm not sure I completely understand the issue. When all three fields above are place on the view and a count of ID is also place on the view, 1 should be returned. Can you post a twbx file showing the issue?
The issue I'm having is I only want the count to display on the view, not any of the fields, so I was trying to make a calculated field that contained the count that I can put on the view.
Here's the twbx. The three columns I'm interested in are from the New Shifts datasource (not New Shifts 2), and are ShiftId, CancelledAt and SupervisorId, which correspond to Id, Stuff and Things in the above example.
Thanks for your help!
Shifts.twbx.zip 341.5 KB