Hi All,
I am trying to create a table view with a simple count over a grouped column. I am a beginner, and am sure there is a clear way to do this, but I canโt figure it out! I couldnโt find anything in the documentationโฆ
The config of my view is in the image below, what bugs me are the empty rows in the table viewโฆ how to remove those?
Hi @Franz_Krauth Try grouping by Dress Name a second time and add some more columns to your column order.
You may not need dress name there.
If you have blanks in the
Dress Name column, and donโt want them displayed, you could try to base your view on a slice with a row filter condition = ISNOTBLANK[dress name].
Maybe that will help?
Hi @Aleksi_Alkio, Translate
Hi @Lynn
Not exactly what I need, but this was helpful!! Grouping by Dress Name twice (why???) did remove the empty rows, but now I have an arrow on the right which I donโt want - any way to remove that as well?
Thanks heaps!!!
Hi @Mike_Adler , I donโt have blanks in the Dress Names, but this is also helpful as I now learned what slices can be good for!!
This is how it looks after the โdouble groupingโโฆ suggested by @Lynn. No more empty rows!!
I
donโt need an action on this view though, and also no other infoโฆ so the arrow on the right is not desired. Also, is there any way to sort by the aggregate (the count in this case)?
Thanks a lot again, I already learned heaps!!
Hi @Franz_Krauth What was on those empty rows?
Hi @Lynn There was one row for each of the entries in the aggregate table. You can see 1 empty row if the count is 1, and 3 if the count was threeโฆ I guess this are the detail records of the aggregate. It was removed by grouping it twice with over the same columnโฆ why I donโt know thoughโฆ
In your first printscreen, it was doing it correctly but you just didnโt have any value for the first column in your column order. Yes you had the โDress nameโ but because itโs used for the grouping, it doesnโt show it again. When you have only one column chosen, there is no any other column to show. When you double grouped the view, it shows the group column value instead of that columnโs value and it sounds that solution is solved, but itโs not because that wasnโt the original problem.
Thanks @Aleksi_Alkio! Yes, of course - that makes sense!
Is there a way to only show the group name with aggregate, without any details?
The double grouping is the closest one if you want that itโs dynamic (more groups you add, more rows you have).
User | Count |
---|---|
41 | |
36 | |
30 | |
23 | |
16 |