Hello, I’m looking for a way to count unique dates. I want to do this for a custom field, but I’ll use ‘Issue created date’ to illustrate what I want to do.
Let’s say in June, we had the following activity:
3 tickets created on June 1
2 tickets created on June 8
5 tickets created on June 10
2 tickets created on June 29
The question is: On how many days in June was an issue created?
I don’t want the total number of issues created in June or on any given day; I just want to know on how many different days there was at least one issue created. From there, ideally I’d like to be able to drill down, for example by reporter, such as John = 3 if he created tickets on June 1, 10, and 29.
Is this possible to do in easyBI? Thank you!