Group by values

HH3571 — Tue, 13 Dec 2022 09:38:16 GMT

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

Re: Group by values

Rockstar7 — Tue, 13 Dec 2022 10:36:47 GMT

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;

topic Group by values in Connectivity & Data Prep

Group by values

Re: Group by values