Sometimes you just need to know how the total count of items in a specific group or status on your dashboard. Ex: 78 items not in status completed, etc.
Hi @jogo,
If you need it, you can also retrieve that information easily using a chart in a dashboard. Once you create the chart with the information you need, you can filter by group or status so you will only display that set of information.
Hope it helps,
Appreciate the workaround idea Pedro, but then you’re stuck with a single bar or solid pie with a tiny number & % in the legend, when all you need is a count.
Ok I see, considering that approach, once you have the number you can filter the widget by any column, so you can filter by status or group to get the value you need.
If you need another kind of filter that is not available you can use the formulas to create it (IF and SWITCH works very well for that).
Another approach to get your counter would be to create an “Auto ID” column and a formula column. In the formula column you can insert the “Auto ID” so you will get a unique ID for each item that you will be able use to count in the number widget.
1 Like
Much appreciated but the goal is to not have to add overhead columns if not absolutely needed…
2 Likes
Hi @jogo did you ever find a better way to count items? I am running into this problem as well.
1 Like
Not yet, without workarounds. My understanding is this is on the roadmap under craftsmanship / quality of life improvements for a future update.
I’d like to +1 this request.
+1 to this request. Hopefully soon!
Hi There, I am looking for this at present, has it been resolved yet?
Not yet, you still have to have a number or formula column to make this work. Which is fine if your board has/needs a number column anyway, but artificial overhead if you don’t want/need a number column.
This shows up first in Google, so I wanted to provide my approach.
- Create a numbers column
- Setup an automation to set an item’s number column to 1 every time a new item is created
- Hide the column so we don’t have to see it (idk if locking it works with automation, but that might be nice too)
- Create a dashboard view and add the numbers widget. I have four in the board I’m working in: one for the sum of all groups, and three for the sum of each individual group
2 Likes
Is this still not possible without creating a numbers column only to get a filtered count of items on a dashboard?
I’d really like to be able to do a count on overall items on a board and also on individual groups. Any advance yet?
1 Like
Has there been any update on this? I’d really love to see this feature! Excel has had the automatically visible sum/count at the bottom of the application for 15+ years.
Hi @sbullman - a couple of weeks ago a noted this feature was available for number widgets including items and subitems:
Thanks!
Mark
1 Like
This doesn’t work in a table, does it?
Hi everyone!
We can confirm that this feature is now supported in the platform.
Please let us know if you run into any issues 
Hi there! I don’t see the option to then select which items we want to count. For example, if I want a count of unique company names listed under a COMPANY column, how would I go about that?
Can you confirm the type of column the company column is?