[仅限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')**
量度
无。
报告
-
按年图表
-
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
在编译所有报告后,您可以根据需要将报告组织在功能板上。 结果可能类似于此页面顶部的图像。