Summing data for Calendar Report
Building a Calendar Report - Heat Map. I want to summarize all the data by day to show the "number of events each day." For example - Summarize damages by day of the week. Field name is "Date of ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendThis used to be almost impossible or complex. Now it's easy with Formula Queries except for learning the Syntax, which I don't claim to be an expert.
Maybe this will work
Size(
GetFieldValues(
GetRecords("{6.EX." & [Date] & "}"),3))
You would replace the 6 with the field ID# of the date of the appointment and replace the [Date] with the field name that holds the date of the appointment.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Maybe this will work
Size(
GetFieldValues(
GetRecords("{6.EX." & [Date] & "}"),3))
You would replace the 6 with the field ID# of the date of the appointment and replace the [Date] with the field name that holds the date of the appointment.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Oooh So Close! It is listing the total of the day - but for each record. How do I get just one record showing the total for the day?
Size(
GetFieldValues(
GetRecords("{6.EX." & [Date of Damage] & "}"),3))
------------------------------
Deborah Becker
------------------------------
Size(
GetFieldValues(
GetRecords("{6.EX." & [Date of Damage] & "}"),3))
------------------------------
Deborah Becker
------------------------------