Skip to content
O ONCORR

Colour theme

Text size

Contrast

Request a quote

Analysis builder

Build your own table and chart from your events' registrations, invitations, room blocks, agenda sign-ups, feedback answers or events - save, download or email it.

Answer your own questions: pick what to count, how to group it and which events to include. Only your own events and events shared with you are ever included.

Where to find it

Sidebar Reports → Analysis builder.

Build an analysis

  1. Under 1. What do you want to analyse?, choose the Data: Registrations, Invitations, Hotel room blocks, Agenda selections, Feedback answers or Events.
  2. Choose the Count / measure and how to Group rows by — for example Event year.
  3. If you like, pick Split columns by (optional), the Chart type and the Order.
  4. Under 2. Only include rows where… (optional), choose a field, a condition and a value — for example a status that is "Registered".
  5. Under 3. Which events?, pick the dates (Starting from and until) and any other filters.
  6. Press Show the result. Press Start over to clear your choices.

Save your analysis

  1. Under Save this analysis, type a Name and, if you like, a Description (optional).
  2. Press Save analysis. It appears under Saved analyses, private to you.
  3. Open a saved analysis to change it, then press Save changes — or press Delete this saved analysis.

Download and share

  1. Press CSV, Excel or PDF above the result to download it.
  2. On a saved analysis, press E-mail me this to receive it on a schedule — see My reports, favourites and report emails.
  3. Press Add to favourites to keep it under Reports → My reports & e-mails.

Tip: When you filter on a value, type it exactly as it appears in the result table, or choose "contains".

Reference

Fields

1. What do you want to analyse?

Field What to choose
Data Registrations (one row per registration, including not attending, unfinished and deleted ones), Invitations (one row per invitation), Hotel room blocks (one row per hotel offered, with its room allocation), Agenda selections (sessions with the number of attendees who ticked them), Feedback answers (one row per answer on a returned form) or Events (one row per event, with its totals).
Count / measure What to count or add up. The choices depend on the data, for example a number of registrations or an average score.
Group rows by The first grouping, for example Event year.
Split columns by (optional) A second grouping shown as columns. Leave — no second grouping — for a simple list.
Chart Bar chart, Horizontal bars, Line chart, Doughnut (share), Stacked bars or Table only.
Show Top 10, Top 25, Top 50, Top 100 or Top 250 rows.
Order Largest first or A–Z / oldest first.

2. Only include rows where… (optional): up to three conditions, each a field, a condition (is, is not or contains) and a value.

3. Which events?: Starting from and until, Client company contains, Event status, Event type, Kind of event and, when you see events of several organizers, Organizer.

Save this analysis

Field What to enter
Name Required. Up to 150 characters.
Description (optional) Up to 500 characters. Shown under the title when you open it.

Who can do what

  • You only ever see your own events, the events of your sub-organizers if you are a super-organizer, and events shared with you.
  • Saved analyses are private to you. Only you can change or delete them.
  • Test or preview registrations are never counted.

Emails and text messages

Nothing is emailed when you build or download an analysis. E-mail me this on a saved analysis sends it on your schedule until you pause or delete it under Reports → My reports & e-mails. Deleting the saved analysis stops its emails too.

Common mistakes

  • A filter returns nothing: the value must match exactly, for example "Registered" or "2012". Use contains for part of a word.
  • Too few rows: raise Show to a higher top number.
  • Doughnut (share) with averages or percentages makes no sense. Use a bar chart or Table only.
  • Changes to a saved analysis are lost unless you press Save changes.
  • Deleting a saved analysis cannot be undone and stops its scheduled emails.

Related guides

Didn't find your answer? Contact support · All organizers guides