see the attached
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
count problem_v10.2.twbx 39.6 KB
Note :You need to fix month of your date instead to get the correct Fixed answer since you are fixing month not exact date/day
Making Department as CONTEXT is a good move.
I am getting accurate Tickets count.
I am little confused with your expectation with Users though since i can only see 2 unique users for the month of April and so on
For example Bob and Carli for the month of April , why are you expecting 4 there ?
Please find the attached sheet and let us know if it helps.
Also kindly mark the relevant answers as CORRECT/HELPFUL if anu of the responses really helped you so that it can help others as well.
Sample-3_v10.2.twbx 146.8 KB
Thanks Jim and Ritesh. I probably did not perfectly explain my original question, but with both of your replies I was able to achieve the exact results I was looking for.
Specifically, the Exclude(Jim) and Fixed Month(Ritesh) examples you provided were very helpful.