View that displays count

AppSheet AppSheet Q&A
, , ,
1

How to display Count summary?

I’m making an app that tracks orders the company I work for orders and makes sure they get to us efficiently.

I have three columns: Vendor, Forwarder (they are currently Enum) and Status which includes: Ordered, Warehouse, In Transit, In SVG and Received. (automatically calculated)

I want to create a view that displays:

  • how many active orders are there(Orders that have not bin received yet)
  • how many of those orders are from a specific Vendor
  • How many of those orders are coming through specific forwarder
2

You will need to make use of the Group By config under the list view you chose.

This is the easiest/fastest way IMO:

  1. Add an extra Virtual Column to your table called something like [Status Group] with this expression:

    IF(
 [Status]="Received",
 "Inactive",
 "Active"
)​

  2. Add the following Group By, in this order:

    1. [Status Group] (or whatever you called it) - Ascending
    2. [Vendor]
    3. [Forwarder]

  3. Inside “Group aggregate” choose “Count” instead of the defaule “None”

Report back if it fits your need

2 Likes
3

It came close to what i wanted but. I dont really want to see inactive count

I also want the enum values from vendor and forwarder to be seen.

And I want them all displayed in the same place. As a list. Like the picture below

preference.png
preference.png565×479 11.1 KB

4

You can’t mix entities. Vendor is one thing, Forwarder is another, etc

1 Like