Start & End Date Buckets
I have a date field and a variable field. See the example table below.
I need a table (preferably cross table) that looks like this.
I'm just not sure on how to do this. Another challenge is that the original data is not sorted like the first table. I was able to accomplish this in Excel using a formula that created a count when the field value changes but that only works when the original data is sorted.
Thanks in advance.