Change in Report Summary Function

Was there a recent change to the summaries function in a report. In my example below the summary count would only calculate if the box was checked.

Screen Shot 2022-01-20 at 2.43.43 PM.png

For example the adj approved count for this section would be 1 and the count for adj rejected would be 4, instead of it counting the total rows for both. Is there a way to change this back. I was reading about the countif function but not sure how to apply to all of the sheets that we pull from.

Find more posts tagged with

Reports

Accepted answers

Genevieve P.

Hi @NikiG

It's been confirmed that the COUNT behaviour on a checkbox column in a Report is currently functioning as it should: it will count all rows that contain a checkbox (unchecked or checked) as a number. You will need to Group by if it's checked or not to see the separate numbers, or use a Filter in your Report. An alternative would be to use a COUNTIF cross sheet formula to gather your numbers instead.

I've submitted an Enhancement Request on your behalf so a COUNTIF statement for checkbox columns in Reports can be considered for future developments.

Cheers,

Genevieve

All comments

Genevieve P.

Hi @NikiG

What you're seeing now is the expected behaviour for a COUNT on Symbol or Checkbox columns in Reports.

If you need to see individual Counts (un-checked versus checked) then you can set up a second Grouping in order to split out the two values:

Screen Shot 2022-01-20 at 2.33.02 PM.png

This was a fix our Product team recently released as previously the grouping of un-checked values would have said 0, which is incorrect.

Cheers,

Genevieve

Genevieve P.

Hi @NikiG

Just a quick note to let you know that I've let the Product team know about your use-case and how this update has affected your current set-up.

They're currently investigating what the expected behaviour for a Report should be when it comes to checkbox columns and summarizing. I'll post again once there's another update on this, although I don't have an ETA for when this may be.

Thanks,

Genevieve

NikiG

@Genevieve P. is there any update on this issue?

Genevieve P.

Hi @NikiG

I've submitted an Enhancement Request on your behalf so a COUNTIF statement for checkbox columns in Reports can be considered for future developments.

Cheers,

Genevieve

Brad Powers

While I understand why the change was made to how the COUNT summary behavior works on checkboxes, it seems like we should have the option to use a SUM function rather than a COUNT to calculate the number of "true" checked values (1) rather than counting all rows. This would be less effort than developing a new COUNTIF function and would make reporting much more efficient.

I currently have to either change my checkbox columns to a text column and use 1 and 0 values, which doesn't make sense to my end users, or I have to add a helper column that converts checkboxes to a text column across all sheets. Many of my sheets are too close to the cell limit to allow for the addition of another helper column.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.