This article will help you learn about the fields available in the Calender view, the field types, descriptions and how the fields are calculated
Key Topics
Click on the links below to take you to the section where you can learn more about this View and where it is used and how it is created
View Definition
This view is linked to the [drp.calendar] table which generated as part of the Daasity transformation process and has the following fields available/visible for use.
Field Name | Field Type | Description | Source/Calculation |
Dynamic Date Type Picker | Parameter | This field allows you to pick between date, week, and month in tiles that use the Dynamic Date Type date field | N/A |
Calendar Date | Dimension Group | The date for the field selected | calendar_date |
0 - Pivot by Today | Dimension | Pivot Dataset by Today (Retail Week): TY vs LY. To Use, Pivot This Field and Add a Filter for 'Dimension is Not Null' | today |
1 - Pivot by Yesterday | Dimension | Pivot Dataset by Yesterday (Retail Week): TY vs LY. To Use, Pivot This Field and Add a Filter for 'Dimension is Not Null' | yesterday |
2 - Pivot by Retail Week | Dimension | Pivot Dataset by Current Week: TY, LY, & LW. To Use, Pivot This Field and Add a Filter for 'Dimension is Not Null' | wtw |
3 - Pivot by Month | Dimension | Pivot Dataset by Current Month: TY, LY, & LM. To Use, Pivot This Field and Add a Filter for 'Dimension is Not Null' | mtm |
4 - Pivot by Retail Month | Dimension | Dataset by Current Month: TY, LY, & LM. To Use, Pivot This Field and Add a Filter for 'Dimension is Not Null' | retail_mtm |
5 - Pivot by Quarter | Dimension | Pivot Dataset by Current Quarter: TY vs LY. To Use, Pivot This Field and Add a Filter for 'Dimension Is Not Null' | quarter |
6 - Pivot by Year | Dimension | Pivot Dataset by Current Year: TY vs LY. To Use, Pivot This Field and Add a Filter for 'Dimension is Not Null' | year |
7 - Pivot by Retail Year | Dimension | Pivot Dataset by Current Year: TY vs LY. To Use, Pivot This Field and Add a Filter for 'Dimension is Not Null' | retail_yoy |
Dynamic Date Type | Dimension | Display your graph by Date, Week, Month or Year | CASE WHEN = 'Date' THEN TO_CHAR(${TABLE}.calendar_date, 'YYYY-MM-DD') WHEN = 'Week' THEN TO_CHAR(DATE(DATEADD(day,(0 - EXTRACT(DOW FROM ${TABLE}.calendar_date )::integer), ${TABLE}.calendar_date )), 'YYYY-MM-DD') WHEN = 'Month' THEN TO_CHAR(DATE_TRUNC('month', ${TABLE}.calendar_date ), 'YYYY-MM') WHEN = 'Year' THEN TO_CHAR(DATE_TRUNC('year', ${TABLE}.calendar_date ), 'YYYY') END ;; |
Retail Day of Week | Dimension | Day of Week of Selected Date Based on Sunday Week Start (NRF Calendar) | retail_day_of_week |
Retail Month | Dimension | Retail Week Based on the NRF Calendar | retail_week |
Retail Week | Dimension | Retail Month Based on the NRF Calendar | retail_month |
Retail Week Day Number | Dimension | Retail Week and Day of Week Based on the NRF Calendar | retail_week_day_number |
Retail Year | Dimension | Retail Year Based on the NRF Calendar | retail_year |
Calendar - Compare to Previous: This Period | Filter | Filter-Only Dimension used to define custom date range for Comparison | N/A |
Calendar - Compare to Previous: Comparison Periods | Dimension | Fields that are being compared. Consists of "This Period", "Previous Period", and "Last Year" | CASE WHEN ${calendar_date} >= ${compare_to_previous_filter_start_date} AND ${calendar_date} < ${compare_to_previous_filter_end_date} THEN 'This Period' WHEN ${calendar_date} >= ${compare_to_previous_start_date} AND ${calendar_date} < ${compare_to_previous_filter_start_date} THEN 'Previous Period' WHEN ${calendar_date} >= DATEADD(year,-1,${compare_to_previous_filter_start_date}) AND ${calendar_date} < DATEADD(year,-1,${compare_to_previous_filter_end_date}) THEN 'Previous Year' ELSE NULL END |
Explores
This view is part of the following explores:
- Daily Company Metrics
- Email Campaign Performance Details
- Email Unsubscribes
- GA PDP Performance (NO LONGER IN USE AS OF 3/27/23)
- Product Page
- GA Shopping Stage (NO LONGER IN USE AS OF 3/27/23)
- Shopping Stage
- GA Traffic (NO LONGER IN USE AS OF 3/27/23)
- Traffic
- Gorgias Tickets
- Loop Returns
- Marketing Attribution Explorer (New)
- Channel and Vendor Level Facebook Performance
- Channel and Vendor Level Google Performance
- Channel and Vendor Level Marketing Performance
- Multi Channel Transactions
- Order & Order Line Revenue
- Transactional Sales Report
- Daily Marketing Plan to Actual Marketing Performance
- Daily Plan to Actual
- Shipstation
Transformation Code
This view is a Daasity derived table generated by the following code:
- [0120_INI_BAS_retail_calendar.sql]