Skip to main content

The calculation reports

Eleven reports in Buckets Dashboard, every one marked DO NOT TOUCH. They exist only to be read by a dashboard tile.

What they have in common​

Nine of the eleven are matrix reports on Activities with Contacts with the same shape:

RowsFS Created By, then Call Result
ColumnsDate, then Status
Detail columnsSubject, First Name, Last Name, and one formula column
Standard filtersAll activities · Completed Activities · Tasks and Events
DateCustom — set from the dashboard, not the report

The formula column is the point. The record count is never what a tile shows; the sum of a 1-or-0 formula is. Every one is written out in Formula columns.

Rep Totals Dials​

Every call attempt. The denominator for everything else.

Formula columnRep Attempts — 1 for any recognised call result
Summary formulaTotal Dials = RowCount
warning

In the org checked, this report also carries a filter First Name equals Chris. That is not in the original build document and looks like a leftover from testing — it would reduce Total Dials to calls made to contacts with that first name, and every percentage built on it with them. Check this filter before trusting the dial figures.

Connects​

Calls where a human was reached.

FilterSubject contains Call
Columns groupingDate, then Bucket Status (not Status — this one is different)
Formula columnConnects Counter — 0 for the non-connect results, 1 for everything else
Summary formulaD2C% = Connects ÷ rows

Connects Counter is written inverted — it lists what is not a connect and returns 1 for everything else. That makes it the only formula here that counts a call result nobody thought of as a connect. See the defects.

Connect Incomplete​

Reached somebody, did not finish the conversation.

Formula columnConnect - Incomplete — 1 when the result is Connect - Incomplete
Summary formulaConnect - Incomplete %

Completions​

Calls that reached a conclusion.

Formula columnCorrect Completes
Summary formulaCorrect Complete %

Counted as a completion: Meeting Scheduled, Activated Lead, Not Now, Not Me, Referred, Not Interested, Not In Swimlane, Follow Up.

Completions Breakdown​

The same population split by Call Result, with no formula column — the chart is a record count sliced by result.

RowsCall Result
FilterCall Result equals Meeting Scheduled, Activated Lead, Not Now, Not Me, Referred, Not In Swimlane, Follow Up, Not Interested

Feeds the donut on Calling Dashboard V2.

Activated​

Calls that moved somebody forward.

Formula columnActivated Connects — Meeting Scheduled, Activated Lead, Follow Up, Unscheduled Intro
Summary formulaActivated Connects %

Meetings Scheduled​

Formula columnMeeting Scheduled Connects — Meeting Scheduled, Unscheduled Intro
Summary formulaMeeting Scheduled Connect %

Bad Data​

Calls that found the record was wrong.

RowsCall Result (no rep grouping)
Formula columnBad Data — Needs Attention, No Longer With Company
Summary formulaBad Data %

The one report here that measures the data rather than the calling. A rising Bad Data % means the lists are decaying faster than they are being fixed.

Activated Lead Table​

FormatTabular
FilterCall Result equals Activated Lead
ColumnsAccount Name, Title, Follow Up Date

Three columns, because it is displayed as a table tile — not a number.

Meetings Scheduled Table​

The same, with Call Result equals Meeting Scheduled.

Activity by List​

Which calling lists are actually being worked.

FormatSummary
RowsDate, then Campaign // List Name
FilterSubject starts with Call
ColumnsFS Last List Name · Subject · First Name · Last Name · Account Name · Call Result · Call Result AI

The only calculation report grouped by list rather than by rep, and the one that answers "is this list being called at all?".

Why "DO NOT TOUCH"​

Changing a grouping, a column or a formula here changes a dashboard number silently. There is no error and nothing turns red — the tile simply starts meaning something else.

If you need a variation, clone the report and point a new tile at the clone.

Where this fits​

The formulas are in Formula columns. What reads these is Calling Dashboard and Calling Dashboard V2.