Count of records/table per day
Is there a way to count how many entries have the same day in some date field?
Eventually, I need to calculate the average of records over several months, counting only those days that feature in the given date field.
I did not manage to iterate through something like 'my table'.'date field'....
13 replies
-
Can you post your code that you are working with?
-
said:
Then, I'd like to check how many records of 'entries' per i.We all need a nudge in the right direction.
My next question is where is this formula happening? On the 'entries' table? or on a dashboard?
I ask because you originally ask:
said:
Is there a way to count how many entries have the same day in some date field?So where is this "some date field"?
May I suggest you start by adding a field to your entries table that does the day() command of the created_on field. You can also do a month(), year(), and other date commands fields as well. This will help for future data analysis.
-
said:
The count formula is to be run on a dashboard.On your dashboard, I'm guessing you want a table of days of the month in one column and a count in the other?
Or something else?
-
said:
Total Transaction > a field that is in Table1 but called Number. It is just a number field and I set this column to be summed.Indeed, that was easier than expected. However, I still fail to get the average calculated (neither in the chart nor as formula). I think there should be a function to group in a select statement!
-
said:
I think there should be a function to group in a select statement!I don't quite understand why you would need to group in the select. The current method gets all of the data that you want and then you can create groups based on whatever fields you need.
Content aside
- 6 mths agoLast active
- 13Replies
- 152Views
-
2
Following