Group by values

[HH3571]

Hello,

I have 1 column (VALUES) with data (user1, user2, user3) with duplicates connected to a specific time for each data point.

Values:        Time(today)

user1           timestamp1

user2          timestamp2

user1          timestamp3

user3          timestamp4

I would like to group all "user" values and  get a count for how many specific users there is per day, my time format is in timestamp. Something like  Group by(Sum(Count(Values))

What is the simpliest way to do this?

Best regards

H

[Rockstar7 · Accepted solution]

first convert the timestamp into date by doing 

date(floor(timestamp),'DD/MM/YYYY') as Date

then apply group by the table like

Load 

Date,

Count(values) as ValuesCount

Resident table group by Date;