Count unique items on given date

Need help Database
1

Hello! I’d like to plot a chart that displays a count of unique field items per date. The Thing “Message” has 3 fields:

  • “UserID”
  • “Date”
  • “Content”

Each UserID can send multiple Messages on a given day. I am able to count the number of Messages per day (using a group by Date and a Count aggregation). However I’m unable to count the number of unique UserIDs who sent a Message on a given day.

Example:

  • UserIDs: “ABC” and “DEF”
  • Date: “Aug 23”
  • The user “ABC” sends 3 Messages and the user “DEF” sends 4 Messages on Aug 23. The result should be 2 for Aug 23 (2 unique users). This will be plotted as a timeseries over Dates.

I guess the solution is along the lines of “Group by UserID” as 1st grouping and “Group by Date” as 2nd grouping, followed by a count of the number of 2nd groups per date, but that does not work…

Can you help me?

2

I think you can just get this by Do a Search for Messages:each item’s users:unique elements

3

@foraanyas that would not work as it only gives you back the unique users, not grouped by date nor with a count.

I found the solution: Do a Search for Messages:Group by Date, UserID:Group by Date (Count as aggregation):each item's Count