Active Customers

1. Overview

Purpose of measure

Measure Code

  • Strapi:

  • OLAP:

  • LUIS:

2. Data design

Data source

OLAP Design

3. Strapi Question Design

3.1.Available dimensions for ""

  • by_store
  • by_category
  • by_sku
  • by_subcategory
  • by_coupon
  • by_customer Group
  • by_channel
  • by_order_status
  • by_day
  • by_week
  • by_month
  • by_quarter
  • by_year

3.2.Available filters for ""

  • FilterStore
  • FilterSku
  • FilterProduct
  • FilterCategory
  • FilterSubcategory
  • FilterSalesChannel
  • FilterCustomerGroup
  • DatetimeV2
  • FilterDay
  • FilterWeek
  • FilterMonth
  • FilterQuarter
  • FilterYear

3.3.Question Parameter

Measure

Dimension

Select a dimension that match with the type of question.

.....

Chart type

3.4.Expected Result

active-customer-list-last-month.png

3. LUIS Training

3.1 Question to ask

  • Active customer

  • active customer 30 days

Help active customer

help-active-customer.png

3.2 MeasureList:

active-customer-measure-list.png

3.3 Luis Training

active-customer-training.png