Gross Sales

1. Overview

Purpose of measure

To view report about Gross Sales in some dimension and time range.

Measure Code

  • Strapi: Gross Sales

  • OLAP:

  • LUIS: Gross Sales

2. Data design

Data source

OLAP Design

3. Strapi Question Design

3.1.Available dimensions for ""

  • Store

  • Category

  • Channel

  • Subcategory

  • Sku

3.2.Available filters for ""

  • FilterCategory

  • FilterStore

  • FilterSubcategory

  • FilterChannel

  • FilterSku

  • FilterDay

  • FilterWeek

  • FilterMonth

  • FilterQuarter

  • FilterYear

3.3.Question Parameter

Measure

Dimension

Chart type

3.4.Expected Result

  • Gross sales gross-3.png

  • Gross sales by sku

gross-4.png

  • Daily gross sales

gross-5.png

3. LUIS Training

3.1 Question to ask

  • Gross sales

  • Gross sales by store

  • Gross sales by sku

  • Gross sales by category

  • Gross sales by subcategory

  • Gross sales by channel

  • Daily gross sales

  • weeekly gross sales

  • monthly gross sales

  • yearly gross sales

  • Gross sales of store 123

  • Gross sales of category apple

  • Gross sales of subcategory phone

  • gross ales of sku 45343

  • gross sales of channel website

3.2 MeasureList:

gross-1.png

3.3 Luis Training

  • gross sales by order status of category men shoes

  • gross sales by store

  • gross sales filter store name = offline

  • gross sales by month this quarter

  • gross sales by month this year of sku 3453

gross-2.png