View that displays count

[DelannaLeonard]

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

[SkrOYC]

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

[DelannaLeonard]

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

[SkrOYC]

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