Summary Row Aggregation Options - Driving Factors

💬 App Building
1

I've been trying to work with 'Summary Rows' in tables but have struggled with some of the aggregation options and am looking for clarity.

Background: I'm developing a view to track which clients are signed up to which service. This is represent in a table with clients on the left and services along the top. These are boolean values.

Goal: Get a count at the bottom of how many clients use Service A, Service B, etc.

Problem: For boolean or string values, the only Summary Row aggregation option I get is 'Distinct Count'. This results in a total of 2. One for "true" and one for "false".

Am I missing something in the options presented, or are the options only available for numeric values?

Desire: For all formats, we get a COUNT option as well.

2

Hi @ferret141, here is a post with a similar issue that may be helpful as a workaround. This is a commonly requested feature and I went ahead and bumped it with this post!

1 Like
3

Thanks for bumping up the feature request.

On this occasion I need it to be a bit more elegant so I'll opt for displaying the totals elsewhere.

But I'll definitely keep your recommended workaround in my back pocket for next time :wink:

1 Like