First level "Group By" in view does not show ...

AppSheet AppSheet Q&A
1

First level “Group By” in view does not show “Group aggregate” count.

So… if I define a view with “Group by” set as two columns (Date, Portfolio), I have to click first on the Date, to see the Portfolio groupings, and the count only shows for the last column in the group (Portfolio).

  1. Is there any way to have the Count show for each column defined in the Group By?

Right now, I only see counts after clicking on the first GroupBy (Date).

I want to see the count for each date, and then when I click, see the count for each Portfolio.

This is what I would think is expected behavior when more than one column is allowed in the “Group By” hierarchy.

  1. Is there any way to show both the Date and Portfolio group headers on the first page of the view (not requiring drill down to get to Portfolio)?

eg: Date

Portfolio A

Item 1

Item 2

Portfolio B

vs Date > click to get:

Portfolio

Item 1

Item 2

2

You need to create a virtual column with the count like CONCATENATE([Date]," ",COUNT(SELECT(KeyColumn],[Date]=[_THISROW].[Date]))) and then group the view with this virtual column.

3

Thanks @Aleksi_Alkio.

I have not yet worked much with the List expressions so this will be a good practice.

I will try it and see how it plays into the Group By in the Views.

4

So, the virtual column is an option to provide a count, but it does not provide the nice “Group aggregate” bubble so it’s inconsistent and may confuse the user.

Based on the description in the UI for “Group aggregate - Display a numeric summary of the rows in each group.”, I would think you would get the bubble at each level in a multi-level grouping.

5

Unfortunately you can have the “bubble” only with one group level. You can of corse explain the value like…

CONCATENATE([Date]," & qountity ",COUNT(SELECT(KeyColumn],[Date]=[_THISROW].[Date])))

6

Hi, I have faced similar problem as Mike. I have define a view “Group by” set as two columns (Delivery Wave & Region). I have to click first into the Delivery Wave (Monday 1.30 pm, Tuesday 2.30pm, etc) and then I will need to choose the region (East, North, West, South).
My problem here will be a little complex as I need to count the non duplicate name.
You can refer to my previous post to understand more.

[Count Distinct](https://community.appsheet.com/t/count-distinct/48125) Questions

Hi, I have created a table view and group by Delivery Wave and Region. The following image shows the table view. [image] From the above image, if I choose any of the delivery wave. I will get into this view categorised by the Region (North, South, East, West) shown below. [image] What I want to achieve is to count distinct (count with non duplicate for the “Name” column and display the count here (the place that I have circled out). (See below for better visualisation) I would like to do a…

Thanks alot