[仅限PaaS]{class="badge informative" title="仅适用于云项目(Adobe管理的PaaS基础架构)和内部部署项目上的Adobe Commerce 。"}

在时间段内报告

NOTE
本主题包含有关使用原始架构和新架构的客户端的说明。 如果您在主工具栏中选择后有Data Warehouse视图​_部分可用,则表示您位于_​新架构Manage Data中。

Report Builder允许您轻松查看一段时间的趋势,并更改您可能希望比较的时间段的视角。 本主题将演示如何设置功能板以更深层次地创建,从而允许您创建逐周、逐月、逐年的报表。

显示逐周、逐月和同比比较的仪表板

在开始之前,您应该查看更多详细信息此处和独立的时间选项此处,以探索视角。

此分析包含高级计算列

计算列

  • Sales_flat_order​表

  • 原始架构:​以下列由分析师创建,作为[YoY WoW MoM ANALYSIS]票证的一部分

  • created_at (month-day)

  • created_at (month)

  • created_at (day of the month)

  • created_at (day of the week)

  • created_at (hour of the day)

  • 新架构: SQL如下所列,其中包含有关如何创建此计算的示例照片

    • created_at (month-day) Calculation: to_char(A, 'mm-dd')
    • created_at (month) Calculation: to_char(A, 'mm-month')
    • created_at (day of the month)< Calculation: to_char(A, 'dd')
    • created_at (day of the week) Calculation: to_char(A, 'd-Day')
    • created_at (hour of the day) Calculation: ​ to_char(A, 'hh24')**
      在Data Warehouse Manager中创建计算列接口

量度

无。

NOTE
确保在生成新报告之前将所有新列作为维度添加到量度

报告

  • 按年图表

    • Metric: Number of orders

    • Metric: Number of orders

    • Time options: Time range (Custom)2 years ago to 1 year ago

    • Show top/bottom:前100%按​ created_at (month-day) ​排序*

  • 量度AThis year

  • 量度BLast year

  • Time period: 1 year ago to 0 years ago


  • Interval: None

  • Group by: created_at (month-day)


  • Chart Type: Line

  • MoM图表

    • Metric: Number of orders

    • Metric: Number of orders

    • 时间选项: Time range (Custom)2 months ago to 1 month ago

    • 显示前/后:前100%按​ created_at (day of month) ​排序*

  • 量度A:本月*

  • 量度B:上个月*

  • Time period:一个月前至0个月前


  • Interval: None

  • Group by: created_at (day of month)


  • Chart Type: Line

  • WoW图表

    • Metric: Number of orders

    • Metric: Number of orders

    • Time options: Time range (Custom)2 weeks ago to 1 week ago

    • Show top/bottom:前100%按created_at (day of week)排序

  • 量度AThis week

  • 量度BLast week

  • Time period: 1 week ago to 0 weeks ago


  • Interval: None

  • Group by: created_at (day of week)


  • Chart Type: Line

  • DoD图表

    • Metric: Number of orders

    • Metric: Number of orders

    • Time options: Time range (Custom)2 days ago to 1 day ago

    • Show top/bottom:前100%按created_at (hour of day)排序

  • 量度AToday

  • 指标B: Yesterday

  • Time period: 1 day ago to 0 days ago


  • Interval: None

  • Group by: created_at (hour of day)


  • Chart Type: Line

在编译所有报告后,您可以根据需要将报告组织在功能板上。 结果可能类似于此页面顶部的图像。

recommendation-more-help
e1f8a7e8-8cc7-4c99-9697-b1daa1d66dbc