Summarize event titles that are text?

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
I have a parent table of event types that are text and a child table of records that contain the different event types. I would like to have a report that will summarize how many time the event type was used even if it is zero?
Photo of Kimberly


  • 20 Points

Posted 1 year ago

  • 0
  • 1
Photo of Chris


  • 4,430 Points 4k badge 2x thumb

You can create a summary field in the parent that summarized the # of child records for an event.

Go into the relationship manager between the two tables in question.

On the parent side, click Add Summary.

Follow the defaults to the end and then name your summary field.

Photo of Matthew Neil

Matthew Neil

  • 31,698 Points 20k badge 2x thumb
If I understand it correctly your parent table is "event types" and the child is most likely "events".

You can either create a summary report on the 'events' table and summarize based on event type, or you can create a summary field that summarizes the "# of events" for each 'event type'.