[僅限PaaS]{class="badge informative" title="僅適用於雲端專案(Adobe管理的PaaS基礎結構)和內部部署專案的Adobe Commerce 。"}
特定時段的報告
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')**
量度
無。
報表
-
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)排序*
-
-
量度
A:This year -
量度
B:Last 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)排序
-
-
量度
A:This week -
量度
B:Last 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)排序
-
-
量度
A:Today -
量度B:
Yesterday -
Time period:
1 day ago to 0 days ago -
Interval:None -
Group by:
created_at (hour of day) -
Chart Type:Line
編譯所有報表後,您可以視需要在控制面板上組織報表。 結果看起來可能像這個頁面頂端的影像。