Forum Discussion
Distinct count with date parameter
Hi Guys I want to create a distinct count for cancel note These "Request from Management - pick up resource hours" should only be count once since it's all from the same date but diffe...
Hi, njxfoster
The sample data you share is not representative, Does the cancel_note column have only one value? The same agent_name appears on only one day? Please describe your needs completely without your subjective operational awareness. In this way we can give an accurate formula.
Do you want to count how many different dates have cancel_note under the current agent_name?
Best Regards,
Community Support Team _ Janey