Forum Discussion
apenaranda
Post Partisan
2 years agoData from a table (count and sum)
Hello, I have the following table as data No Fecha Cod. User 1 01/01/2024 1 2 01/01/2024 1 3 03/01/2024 2 4 04/01/2024 3 5 05/01/2024 3 6 01/01/2024 2 7 07/...
apenaranda
Post Partisan
2 years agoThe measure in point 2 makes the sum of all the registrations for that day, but what I want is to know how many different users there are with registrations that day.
Let's explain it in another way to see if it can be understood better:
Point 3 is basically the sum of records
Point 4, of the entire month (in this example case it is January), how many days there are with at least 1 record, that is, of the 31 days that January has, how many of them there are any records.
Syndicate_Admin
Administrator
2 years ago3) Las filas de conteo simples deberían ser suficientes
4) Aplique CountRows en la tabla donde la fecha está entre el inicio y el final del mes.