Forum Discussion
Post PartisanData from a table (count and sum)
Post PartisanThe 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.
Administrator3) 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.
- apenaranda
2) I already get it, but would there be a way for me to also add up the total for every day?
Now it sets me for 1/1/2024 there are 2 users
For 2/1/2024 there are 3 users
I would only need the sum of all the days.
3) if correct, a count already adds up the records per day
4) I don't really understand what you mean.