View: Calendar

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]