Report - Summarize Count Function is not Offering a Column to Select
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:
Best Answer
-
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.
Answers
-
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?
-
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.
-
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.
-
By Grouping setting like so:
-
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
-
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.
