Summing data for Calendar Report

Question

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 Damage"

How do I write the formula to sum the numbers of damages per day? I will then color-code the day of the week based on the rating of the damages.

Thank you!

------------------------------
Debbie Becker
------------------------------

MarkShnierYou · Answer

This 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
------------------------------

Sign up

Login to the community