Help with counting totals

@gflores1092

I bet a simple measure of type: count would help you out!

A super basic example is just

measure: count {

    type: count

  }

If you spin that up in your view file and then return Orders Cancel Reason and Count in an explore, you should get

Orders Cancel Reason Count

SATURATION 3

NO_PAYMENT 2

COURIER_NOT_ASSIGNED 1

as your result!

Another way to do this would be to create a measure with the count function built into the sql parameter. This approach would be slightly more complex than using the “type: count” argument.

It would look something like this:

measure: countofstuff {

type: number

sql: count(${TABLE}.item_name) ;;

}