1 of 1 people found this helpful
You've to work on your data source. Transpose all the date fields from columns to rows so that all date values comes under one dimension. Then it'll be easy for your to do the rest.
You may follow this link for more information about transpose
Hope this help.
I'm going to try the Pivot function.
But I also want to group them by day. Can I do that with that too?
Ah, by doing a count([ID]) as the data...