Views
      Back to home
      1. Help Center
      2. Daasity Platform | Business User Analytics
      3. Views

      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]