Solved: Nested Group-By inconsistent in showing blank grou... - Page 2

Sorweel · 10-22-2023 07:43 PM

I have a budgeting app all set up. On the right in blue I have a nested group-by setup working flawlessly. I can see all the items I have not categorized yet in the blank category grouping. Perfection.

On the left in red I did the same setup. Except I have a whole load of blank "Reconciled" items not showing up in a blank grouping. I had thought originally that it was because some of the "Project" grouping is also blank, but even if I change the second grouping to "Month" (same as the Category tab), it still doesn't show blank Reconciled groupings like it does on the right. Why would there be a difference?

Not sure if this matters but if I have only one grouping, if I delete "1-Unreconciled' and "2-Pending" items, then only "3-Reconciled" show up and "All" does not. Strange.

WillowMobileSys

@Sorweel wrote:

On the left in red I did the same setup. Except I have a whole load of blank "Reconciled" items not showing up in a blank grouping.

My understanding is that you have a bunch of rows where the [Reconciled] column is blank and you are expecting them to show under a "blank" group in the Table view. Correct?

The most important question is: What datasource are you using for your view and does it actually contain the rows where the [Reconciled] column is blank?

For instance, if you created a Slice where the row criteria is set as something like - IN([Reconciled], {"1-Unreconciled", "2-Pending", "3-Reconciled"})

Then you used this Slice in your view, it would not contain any rows where [Reconciled] is blank.

The second most important question is: What device are you viewing these on?

If you are viewing these on Desktop and have "Desktop Mode Preview" setting turned on, you may be seeing a bug. Desktop Mode Preview is still in implementation/Beta and does have some issues. It is not yet ready for live apps.

@Sorweel wrote:

Not sure if this matters but if I have only one grouping, if I delete "1-Unreconciled' and "2-Pending" items, then only "3-Reconciled" show up and "All" does not. Strange.

This is what I would expect if there is only a single grouping to show (for the record - I don't think this was always the case. I think, in the past, All was always shown). This is another indication that your datasource does NOT include rows where the [Reconciled] column is blank.

View solution in original post

Nested Group-By inconsistent in showing blank grouping?