Purpose of measure
This is a composition measure to show the report of other business measures about sales like: Total sales, Net sales, profit margin %, Gross Sales, Invoices in a period of time.
We also provide the comparasion with the same previous of time (vs previous week, vs previous month, vs previous year)
2. Data design
3. Strapi Question Design
3.1.Available dimensions for "sales_overview"
- by_customer Group
3.2.Available filters for "sales_overview"
Select a dimension that match with the type of question.
- by_store => dimension is store
- by_category => dimension is category .....
There are two types of question for sales_overview measure**
- Summary table with measures as rows and comparasion as columns
- By a dimension with values of the dimension as rows and the data comparasion as columns
3. LUIS Training
3.1 Question to ask
- Sales summary this month
- Sales by store last month
- Sales of category apple from 10 feb to 15 feb
- Sales by category
- Sales by subcategory
- Sales by channel
- Sales by SKU
- Daily sales this month
- Weekly sales this quarter
- Monthly sales this year
- Sales of sku 8905 this week