--- title: "View: Calendar" description: This article will help you learn about the fields available in the Calender view, the field types, descriptions and how the fields are calculated --- [Back to home](https://support.daasity.com/migrated/knowledge) - [ Welcome to Daasity ](https://support.daasity.com/migrated/knowledge/welcome-to-daasity) - [ Integration Setup | Connect Your Data Sources ](https://support.daasity.com/migrated/knowledge/welcome-to-daasity#integration-setup-connect-your-data-sources) - [ Integration Setup | Amazon Seller Central ](https://support.daasity.com/migrated/knowledge/welcome-to-daasity#integration-setup-amazon-seller-central) - [ Navigating the Daasity App ](https://support.daasity.com/migrated/knowledge/welcome-to-daasity#navigating-the-daasity-app) - [ Daasity Platform | Business User Analytics ](https://support.daasity.com/migrated/knowledge/daasity-platform-business-user-analytics) - [ Brand Supplied Data (BSD) ](https://support.daasity.com/migrated/knowledge/daasity-platform-business-user-analytics#brand-supplied-data-bsd) - [ Dashboards ](https://support.daasity.com/migrated/knowledge/daasity-platform-business-user-analytics#dashboards) - [ Reports ](https://support.daasity.com/migrated/knowledge/daasity-platform-business-user-analytics#reports) - [ Explores ](https://support.daasity.com/migrated/knowledge/daasity-platform-business-user-analytics#explores) - [ Views ](https://support.daasity.com/migrated/knowledge/daasity-platform-business-user-analytics#views) - [ Audiences ](https://support.daasity.com/migrated/knowledge/daasity-platform-business-user-analytics#audiences) - [ Customizations ](https://support.daasity.com/migrated/knowledge/daasity-platform-business-user-analytics#customizations) - [ ELT+ | Technical User Documentation ](https://support.daasity.com/migrated/knowledge/elt-technical-user-documentation) - [ Platform ](https://support.daasity.com/migrated/knowledge/elt-technical-user-documentation#platform) - [ Transformation ](https://support.daasity.com/migrated/knowledge/elt-technical-user-documentation#transformation) - [ Integrations ](https://support.daasity.com/migrated/knowledge/elt-technical-user-documentation#integrations) - [ User Manual and Support ](https://support.daasity.com/migrated/knowledge/user-manual-and-support) - [ Daasity Logic and Best Practices ](https://support.daasity.com/migrated/knowledge/user-manual-and-support#daasity-logic-and-best-practices) - [ Marketing Analytics ](https://support.daasity.com/migrated/knowledge/user-manual-and-support#marketing-analytics) - [ Customer Analytics ](https://support.daasity.com/migrated/knowledge/user-manual-and-support#customer-analytics) - [ Date Analytics ](https://support.daasity.com/migrated/knowledge/user-manual-and-support#date-analytics) - [ Inventory and Returns Analytics ](https://support.daasity.com/migrated/knowledge/user-manual-and-support#inventory-and-returns-analytics) - [ Submit a Support Request ](https://support.daasity.com/migrated/knowledge/user-manual-and-support#submit-a-support-request) - [ Release Updates ](https://support.daasity.com/migrated/knowledge/release-updates) - [ Release Updates ](https://support.daasity.com/migrated/knowledge/release-updates#release-updates) # 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](https://support.daasity.com/migrated/knowledge/view-drp-calendar#view-definition) - [Explores](https://support.daasity.com/migrated/knowledge/view-drp-calendar#explores) - [Transform Code](https://support.daasity.com/migrated/knowledge/view-drp-calendar#transformation-code) ### 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 ](https://support.daasity.com/knowledge/explore-product-page) - GA Shopping Stage **(NO LONGER IN USE AS OF 3/27/23)** - [Shopping Stage](https://support.daasity.com/knowledge/explore-shopping-stage) - GA Traffic **(NO LONGER IN USE AS OF 3/27/23)** - [Traffic](https://support.daasity.com/knowledge/explore-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]