[僅限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
在建立新報表之前,請務必將所有新欄新增為量度的維度。

報表

  • YoY圖表

    • 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