Report - Summarize Count Function is not Offering a Column to Select

crachon

I created a report from a sheet in which I want to use the summarize count function in the report to count the number of tasks in the report. When I go to Summarize, it does not offer me a column to summarize to count. Screen shot below:

Screenshot 2022-04-19 162847.jpg

Mike TV

Within "Data & Chart Type" settings, uncheck "Use First Column as Series Labels". Then click on "Vertical Axis" and give it a Title that you want. You can also add a Title to the "Horizontal Axis". I believe that should do what you want.

Mike TV

The Summarize Count feature of a Report will not work for a Drop-Down Multi-Select type of column. Why are you using that column type and can you change to a single select?

Mike TV

Here's a possible work-around. On your working sheet create a helper column and create a column formula that's:

=Dept@row

Then create a report using the helper column to report on.

crachon

Thanks, that did work. But how do you count it by Dept if there are multiple departments? I don't want a total count, I want the count of each Dept, if that makes sense.

Mike TV

By Grouping setting like so:

crachon

Thanks. I was able to do that and then create a widget off of the count. My only other issue is that the column name wants to stay next to the chart. And when I click off "use column names as category labels", it uses one of the counts as the axis header. see attached

1.jpg

2.jpg

Mike TV

Within "Data & Chart Type" settings, uncheck "Use First Column as Series Labels". Then click on "Vertical Axis" and give it a Title that you want. You can also add a Title to the "Horizontal Axis". I believe that should do what you want.