I need to create a calculation that counts one group counseling session per date but counts the number of rows for all other service types. I've tried a number of solutions with the help of ChatGPT, but to no avail. Any ideas?
8 risposte
@Amelia Kohm
You may use:
SUM({FIXED [Service Type],DATE([Date / Time]):
IF MAX([Service Type])="Group Counseling" THEN
COUNTD([Group Counseling Count Per Day (Single Count)])
ELSE
COUNT([Service Type])
END
})
If this post resolves the question, would you be so kind to "Select as Best"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.
Regards,
Diego Martinez
Tableau Visionary and Forums Ambassador
