Magento for B2B Commerce

Filter Sets

A filter set is based on a table, and can include multiple statements with logic to select the data for a report or chart. Magento BI includes several default filter sets that you can use “as is” or modify. There is no limit to the number of filter sets that you can create.

A filter set can be applied to any metric that uses the same table. To learn more, see Creating filter sets for metrics in the Magento BI Help Center.

  • Default Filters by Table

    Field

    Description

    customer_entity

    Registered accounts we count (Saved Filter Set)

    created_at (use)

    Customer’s first 30 day revenue

    Customer’s first order’s billing region

    Customer’s first order’s coupon code

    Customer’s first order date

    Customer’s group code

    Customer’s lifetime number of coupons

    Customer’s lifetime number of orders

    Customer’s lifetime revenue

    email

    entity_id

    group_id

    Seconds since customer’s first order date

    updated_at

    [input] created at

    sales_flat_order

    Orders we count (Saved Filter Set)

    base_grand_total

    base_shipping_amount

    base_tax_amount

    Billing address city

    Billing address country

    Billing address region

    billing_address_id

    coupon_code

    created_at (use)

    Customer’s creation date

    Customer’s first order date

    Customer’s group code

    Customer’s lifetime number of coupons

    Customer’s lifetime revenue

    Customer’s order number

    Customer’s order number (previous-current)

    customer_email

    customer_id

    entity_id

    Is customer’s last order?

    Number of items in order

    order_currency_code

    Seconds between customer’s first order date and this order

    Seconds since previous order

    sales_flat_order_item

    Ordered products we count(Saved Filter Set)

    base_price

    created_at (use)

    Customer’s lifetime number of orders

    Customer’s lifetime revenue

    Customer’s order number

    item_id

    name

    Order’s coupon_code

    Order item total value (quantity * price)

    order_id

    product_id

    product_type

    qty_ordered

    sku

    updated_at

    [input] created_at