I have two columns on custom objects, want to group by date first, then by user
Date User
9 Sep ABC
9 Sep XYZ
10 Sep ABC
10 Sep XYZ
11 Sep LMN
Need unique user count per day something like
Date User Count
9 Sep 1
10 Sep 2
11 Sep 1
I know there is something power of one but not able to fit in my situation. Any Help.