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

Mike_A · 05-11-2018 05:00 PM

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).

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.

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

Aleksi_Alkio

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.

Mike_A

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.

Mike_A

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.

Aleksi_Alkio

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])))

lala_land

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.

Thanks alot