Workbook Information
Author: Unknown
Embedded Datasources
Datasource: Parameters
Connection
Measure
Calculated/Other
Measure: Base Salary
Role: Continous Measure
Data Type: integer
Formula: 50000
Default Value: 50000
Parameter Type: range
Measure: Commission Rate
Role: Continous Measure
Data Type: real
Formula: 18.400000000000002
Default Value: 18.400000000000002
Parameter Type: range
Measure: New Quota
Role: Continous Measure
Data Type: integer
Formula: 500000
Default Value: 500000
Parameter Type: range
Measure: Sort by
Role: Discrete Measure
Data Type: string
Formula: "Names"
Default Value: "Names"
Parameter Type: list
Measure: New Business Growth
Role: Continous Measure
Data Type: real
Formula: 0.59999999999999998
Default Value: 0.59999999999999998
Parameter Type: range
Measure: Churn Rate
Role: Continous Measure
Data Type: real
Formula: 0.064000000000000001
Default Value: 0.064000000000000001
Parameter Type: range
Datasource: Sample - Superstore
Connection
Data Sources
Data Source: Sample - Superstore
Attributes
authentication: auth-username-password
class: hyper
dbname: extract/5e/21/{7B91B292-41EE-427A-91FD-327A63425493}/dataengine_42019_618651678240lea.hyper
default-settings: yes
extract-engine: true
management-tablespace: extracts
port: 8633
schema: Extract
server: localhost
tablename: Extract
username: tableau_internal_user
Tables
Table: Extract
Database Object: [Extract].[Extract]
Connection: Sample - Superstore
Dimension
Extract
Dimension: Category
Role: Discrete Dimension
Remote Column: [Extract].[Category]
Data Type: string
Dimension: City
Role: Discrete Dimension
Remote Column: [Extract].[City]
Data Type: string
Dimension: Country
Role: Discrete Dimension
Remote Column: [Extract].[Country]
Data Type: string
Dimension: Customer Name
Role: Discrete Dimension
Remote Column: [Extract].[Customer Name]
Data Type: string
Dimension: Order Date
Role: Discrete Dimension
Remote Column: [Extract].[Order Date]
Data Type: date
Dimension: Order ID
Role: Discrete Dimension
Remote Column: [Extract].[Order ID]
Data Type: string
Dimension: Postal Code
Role: Discrete Dimension
Remote Column: [Extract].[Postal Code]
Data Type: integer
Dimension: Product Name
Role: Discrete Dimension
Remote Column: [Extract].[Product Name]
Data Type: string
Dimension: Region
Role: Discrete Dimension
Remote Column: [Extract].[Region]
Data Type: string
Dimension: Segment
Role: Discrete Dimension
Remote Column: [Extract].[Segment]
Data Type: string
Dimension: Ship Mode
Role: Discrete Dimension
Remote Column: [Extract].[Ship Mode]
Data Type: string
Dimension: State
Role: Discrete Dimension
Remote Column: [Extract].[State]
Data Type: string
Dimension: Sub-Category
Role: Discrete Dimension
Remote Column: [Extract].[Sub-Category]
Data Type: string
Calculated/Other
Dimension: :Measure Names
Role: Discrete Dimension
Data Type: string
Dimension: Ship Status
Role: Discrete Dimension
Data Type: string
Formula: if [Days to Ship Actual]> [Days to Ship Scheduled] then "Shipped Late"
elseIF [Days to Ship Actual]= [Days to Ship Scheduled] then "Shipped On Time"
Else "Shipped Early" end
Dimension: Order Profitable?
Role: Discrete Dimension
Data Type: boolean
Formula: {fixed [Order ID]:sum([Profit])}>0
// calculates the profit at the order level
Dimension: Customer ID
Role: Discrete Dimension
Data Type: string
Dimension: Product ID
Role: Discrete Dimension
Data Type: string
Measure
Extract
Measure: Discount
Role: Continous Measure
Remote Column: [Extract].[Discount]
Data Type: real
Measure: Profit
Role: Continous Measure
Remote Column: [Extract].[Profit]
Data Type: real
Measure: Sales
Role: Continous Measure
Remote Column: [Extract].[Sales]
Data Type: real
Measure: Quantity
Role: Continous Measure
Remote Column: [Extract].[Quantity]
Data Type: integer
Aggregation: Sum
Measure: Ship Date
Role: Continous Measure
Remote Column: [Extract].[Ship Date]
Data Type: date
Aggregation: Year
Calculated/Other
Measure: Days to Ship Actual
Role: Continous Measure
Data Type: integer
Formula: DATEDIFF('day',[Order Date],[Ship Date])
Measure: Sales Forecast
Role: Continous Measure
Data Type: real
Formula: [Sales]*(1-[Parameters].[Parameter 2])*(1+[Parameters].[Parameter 1])
Measure: Days to Ship Scheduled
Role: Continous Measure
Data Type: integer
Formula: CASE [Ship Mode]
WHEN "Same Day" THEN 0
WHEN "First Class" THEN 1
WHEN "Second Class" THEN 3
WHEN "Standard Class" THEN 6
END
Measure: Profit per Customer
Role: Continous Measure
Data Type: real
Formula: sum([Profit])/countD([Customer Name])
Measure: Sales per Customer
Role: Continous Measure
Data Type: real
Formula: Sum([Sales])/countD([Customer Name])
Measure: Profit Ratio
Role: Continous Measure
Data Type: real
Formula: sum([Profit])/sum([Sales])
Measure: Sales above Target?
Role: Discrete Measure
Data Type: string
Formula: If Sum([Sales])>SUM([federated.0z0pi331stuxay1ce6y5f1yxvsw9].[Sales Target]) then "Above Target" else "Below Target" end
Measure: Number of Records
Role: Continous Measure
Data Type: integer
Formula: 1
Measure: Order Quantity
Role: Continous Measure
Data Type: real
Measure: Row ID
Role: Continous Measure
Data Type: integer
Measure: Units estimate
Role: Continous Measure
Data Type: real
Formula: ROUND([Quantity]*(1-[Parameters].[Parameter 2])*(1+[Parameters].[Parameter 1]),0)
Measure: Profit per Order
Role: Continous Measure
Data Type: real
Formula: Sum([Profit])/countD([Order ID])
Parameter
Calculated/Other
Measure: New Business Growth
Role: Continous Measure
Data Type: real
Formula: 0.59999999999999998
Default Value: 0.59999999999999998
Parameter Type: range
Measure: Churn Rate
Role: Continous Measure
Data Type: real
Formula: 0.064000000000000001
Default Value: 0.064000000000000001
Parameter Type: range
Semantic Values
[Country].[Name]: "United States"
Datasource: Sales Target Extract
Connection
Data Sources
Data Source: Sales Target
Attributes
authentication: auth-username-password
class: hyper
dbname: extract/5e/21/{7B91B292-41EE-427A-91FD-327A63425493}/hyper_0b9ww9a086u1d41dqjy2d0vs8f.hyper
default-settings: yes
extract-engine: true
management-tablespace: extracts
port: 8633
schema: Extract
server: localhost
tablename: Extract
username: tableau_internal_user
Tables
Table: Extract
Database Object: [Extract].[Extract]
Connection: Sales Target
Measure
Extract
Measure: Category
Role: Continous Measure
Remote Column: [Extract].[Category]
Data Type: string
Aggregation: Count
Measure: Order Date
Role: Continous Measure
Remote Column: [Extract].[Order Date]
Data Type: date
Aggregation: Year
Measure: Sales Target
Role: Continous Measure
Remote Column: [Extract].[Sales Target]
Data Type: integer
Aggregation: Sum
Measure: Segment
Role: Continous Measure
Remote Column: [Extract].[Segment]
Data Type: string
Aggregation: Count
Calculated/Other
Measure: Number of Records
Role: Continous Measure
Data Type: integer
Formula: 1
Semantic Values
[Country].[Name]: "United States"
Datasource: Sales Commission
Connection
Data Sources
Data Source: Sales Commission
Attributes
authentication: auth-username-password
class: hyper
dbname: extract/5e/21/{7B91B292-41EE-427A-91FD-327A63425493}/Sales Planning newleaf.hyper
default-settings: yes
extract-engine: true
management-tablespace: extracts
port: 8633
schema: Extract
server: localhost
tablename: Extract
username: tableau_internal_user
Tables
Table: Extract
Database Object: [Extract].[Extract]
Connection: Sales Commission
Dimension
Extract
Dimension: Order Date
Role: Discrete Dimension
Remote Column: [Extract].[Order Date]
Data Type: datetime
Dimension: Region
Role: Discrete Dimension
Remote Column: [Extract].[Region]
Data Type: string
Dimension: Sales Person1
Role: Discrete Dimension
Remote Column: [Extract].[Sales Person]
Data Type: string
Calculated/Other
Dimension: Estimate Compensation label
Role: Discrete Dimension
Data Type: string
Formula: "Estimated Compensation:"
Dimension: Total Sales label
Role: Discrete Dimension
Data Type: string
Formula: "Total Sales:"
Measure
Extract
Measure: Sales
Role: Continous Measure
Remote Column: [Extract].[Sales]
Data Type: integer
Calculated/Other
Measure: Achievement (estimated)
Role: Continous Measure
Data Type: integer
Formula: [Sales]
Measure: Achieved Quota
Role: Discrete Measure
Data Type: string
Formula: if SUM([Achievement (copy)]) >= [Parameters].[New Quota] then "100% +"
elseif SUM([Achievement (copy)]) >= 0.75 * [Parameters].[New Quota] then "75-100%"
elseif SUM([Achievement (copy)]) >= 0.5 * [Parameters].[New Quota] then "50-75%"
else "Below 50%" end
Measure: Base (Variable)
Role: Continous Measure
Data Type: integer
Formula: [Parameters].[Base Salary]
Measure: % of quota achieved
Role: Continous Measure
Data Type: real
Formula: AVG([Achievement (copy)])/[Parameters].[New Quota]
Measure: Rank over 3
Role: Continous Measure
Data Type: real
Formula: ROUND(INDEX() / 3 - 0.6,0) + 1
Measure: Sort by field
Role: Discrete Measure
Data Type: real
Formula: if [Parameters].[Parameter 1 1]="Names" then 0
elseif [Parameters].[Parameter 1 1]="% quota descending" then -[% of quota achieved]
else [% of quota achieved] end
Measure: Commission (Variable)
Role: Continous Measure
Data Type: real
Formula: ([Parameters].[Commission Rate]*[Sales])/100
Measure: OTE (Variable)
Role: Continous Measure
Data Type: real
Formula: [Parameters].[Base Salary] + ([Parameters].[Commission Rate]*[Parameters].[New Quota])/100
Measure: Total Compensation
Role: Continous Measure
Data Type: real
Formula: MIN([Base (Variable)]) + SUM([Commission (Variable)])
Parameter
Calculated/Other
Measure: Base Salary
Role: Continous Measure
Data Type: integer
Formula: 50000
Default Value: 50000
Parameter Type: range
Measure: Commission Rate
Role: Continous Measure
Data Type: real
Formula: 18.400000000000002
Default Value: 18.400000000000002
Parameter Type: range
Measure: New Quota
Role: Continous Measure
Data Type: integer
Formula: 500000
Default Value: 500000
Parameter Type: range
Measure: Sort by
Role: Discrete Measure
Data Type: string
Formula: "Names"
Default Value: "Names"
Parameter Type: list
Semantic Values
[Country].[Name]: "United States"
Dashboards
Dashboard: Commission Model
Worksheets
Worksheet: QuotaAttainment
Datasources: Parameters
Sales Commission
Used Dimensions & Measures: [% of quota achieved]
[Achieved Quota]
[Achievement (estimated)]
[Base (Variable)]
[Base Salary]
[Commission (Variable)]
[Commission Rate]
[New Quota]
[OTE (Variable)]
[Rank over 3]
[Sales Person1]
[Sales]
[Total Compensation]
Used Remote Columns: [Extract].[Sales Person]
[Extract].[Sales]
Worksheet: CommissionProjection
Datasources: Parameters
Sales Commission
Used Dimensions & Measures: [% of quota achieved]
[Achieved Quota]
[Achievement (estimated)]
[Base (Variable)]
[Base Salary]
[Commission (Variable)]
[Commission Rate]
[New Quota]
[OTE (Variable)]
[Rank over 3]
[Sales Person1]
[Sales]
[Sort by field]
[Sort by]
[Total Compensation]
Used Remote Columns: [Extract].[Sales Person]
[Extract].[Sales]
Worksheet: Sales
Datasources: Parameters
Sales Commission
Used Dimensions & Measures: [% of quota achieved]
[Achievement (estimated)]
[New Quota]
[Sales]
Used Remote Columns: [Extract].[Sales]
Worksheet: OTE
Datasources: Parameters
Sales Commission
Used Dimensions & Measures: [Base Salary]
[Commission Rate]
[New Quota]
[OTE (Variable)]
Dashboard Objects:
Text: Enter new quota, commission rate and base salary to estimate sales and compensation
Dashboard: Customers
Worksheets
Worksheet: CustomerScatter
Datasources: Sample - Superstore
Used Dimensions & Measures: [Category]
[Customer Name]
[Order Date]
[Profit Ratio]
[Profit]
[Region]
[Sales]
[Segment]
Used Remote Columns: [Extract].[Category]
[Extract].[Customer Name]
[Extract].[Order Date]
[Extract].[Profit]
[Extract].[Region]
[Extract].[Sales]
[Extract].[Segment]
Worksheet: CustomerRank
Datasources: Sample - Superstore
Used Dimensions & Measures: [Category]
[Customer Name]
[Order Date]
[Profit Ratio]
[Profit]
[Region]
[Sales]
[Segment]
Used Remote Columns: [Extract].[Category]
[Extract].[Customer Name]
[Extract].[Order Date]
[Extract].[Profit]
[Extract].[Region]
[Extract].[Sales]
[Extract].[Segment]
Worksheet: CustomerOverview
Datasources: Sample - Superstore
Used Dimensions & Measures: [Category]
[Customer Name]
[Days to Ship Actual]
[Days to Ship Scheduled]
[Order Date]
[Profit Ratio]
[Profit]
[Quantity]
[Region]
[Sales per Customer]
[Sales]
[Segment]
[Ship Date]
[Ship Mode]
Used Remote Columns: [Extract].[Category]
[Extract].[Customer Name]
[Extract].[Order Date]
[Extract].[Profit]
[Extract].[Quantity]
[Extract].[Region]
[Extract].[Sales]
[Extract].[Segment]
[Extract].[Ship Date]
[Extract].[Ship Mode]
Dashboard Objects:
Filter: [Sample - Superstore].[YEAR(Order Date)]
Filter: [Sample - Superstore].[Category]
Filter: [Sample - Superstore].[Segment]
Dashboard: Order Details
Worksheets
Worksheet: Product Detail Sheet
Datasources: Sample - Superstore
Used Dimensions & Measures: [Category]
[City]
[Customer Name]
[Days to Ship Actual]
[Days to Ship Scheduled]
[Discount]
[Order Date]
[Order ID]
[Order Profitable?]
[Postal Code]
[Profit Ratio]
[Profit]
[Quantity]
[Region]
[Sales]
[Segment]
[Ship Date]
[Ship Mode]
[State]
Used Remote Columns: [Extract].[Category]
[Extract].[City]
[Extract].[Customer Name]
[Extract].[Discount]
[Extract].[Order Date]
[Extract].[Order ID]
[Extract].[Postal Code]
[Extract].[Profit]
[Extract].[Quantity]
[Extract].[Region]
[Extract].[Sales]
[Extract].[Segment]
[Extract].[Ship Date]
[Extract].[Ship Mode]
[Extract].[State]
Dashboard Objects:
Filter: [Sample - Superstore].[Order Date]
Filter: [Sample - Superstore].[Region]
Filter: [Sample - Superstore].[State]
Filter: [Sample - Superstore].[City]
Filter: [Sample - Superstore].[Category]
Filter: [Sample - Superstore].[Segment]
Dashboard: Overview
Worksheets
Worksheet: Total Sales
Datasources: Parameters
Sample - Superstore
Used Dimensions & Measures: [Category]
[Churn Rate]
[Customer Name]
[Discount]
[New Business Growth]
[Order Date]
[Order ID]
[Order Profitable?]
[Profit per Order]
[Profit Ratio]
[Profit]
[Quantity]
[Region]
[Sales Forecast]
[Sales per Customer]
[Sales]
[Segment]
[State]
[Units estimate]
Used Remote Columns: [Extract].[Category]
[Extract].[Customer Name]
[Extract].[Discount]
[Extract].[Order Date]
[Extract].[Order ID]
[Extract].[Profit]
[Extract].[Quantity]
[Extract].[Region]
[Extract].[Sales]
[Extract].[Segment]
[Extract].[State]
Worksheet: Sale Map
Datasources: Sample - Superstore
Used Dimensions & Measures: [Order Date]
[Order ID]
[Order Profitable?]
[Postal Code]
[Profit Ratio]
[Profit]
[Region]
[Sales]
[State]
Used Remote Columns: [Extract].[Order Date]
[Extract].[Order ID]
[Extract].[Postal Code]
[Extract].[Profit]
[Extract].[Region]
[Extract].[Sales]
[Extract].[State]
Worksheet: Sales by Segment
Datasources: Sample - Superstore
Used Dimensions & Measures: [Category]
[Order Date]
[Order ID]
[Order Profitable?]
[Postal Code]
[Profit]
[Region]
[Sales]
[Segment]
[State]
Used Remote Columns: [Extract].[Category]
[Extract].[Order Date]
[Extract].[Order ID]
[Extract].[Postal Code]
[Extract].[Profit]
[Extract].[Region]
[Extract].[Sales]
[Extract].[Segment]
[Extract].[State]
Worksheet: Sales by Product
Datasources: Sample - Superstore
Used Dimensions & Measures: [Category]
[Order Date]
[Order ID]
[Order Profitable?]
[Postal Code]
[Profit]
[Region]
[Sales]
[Segment]
[State]
Used Remote Columns: [Extract].[Category]
[Extract].[Order Date]
[Extract].[Order ID]
[Extract].[Postal Code]
[Extract].[Profit]
[Extract].[Region]
[Extract].[Sales]
[Extract].[Segment]
[Extract].[State]
Dashboard Objects:
Filter: [Sample - Superstore].[Region]
Filter: [Sample - Superstore].[Order Date]
Filter: [Sample - Superstore].[Profit Ratio]
Dashboard: Product
Worksheets
Worksheet: ProductView
Datasources: Sample - Superstore
Used Dimensions & Measures: [Category]
[Order Date]
[Profit]
[Region]
[Sales]
Used Remote Columns: [Extract].[Category]
[Extract].[Order Date]
[Extract].[Profit]
[Extract].[Region]
[Extract].[Sales]
Worksheet: ProductDetails
Datasources: Sample - Superstore
Used Dimensions & Measures: [Category]
[Order Date]
[Product Name]
[Profit Ratio]
[Profit]
[Region]
[Sales]
[Segment]
[Sub-Category]
Used Remote Columns: [Extract].[Category]
[Extract].[Order Date]
[Extract].[Product Name]
[Extract].[Profit]
[Extract].[Region]
[Extract].[Sales]
[Extract].[Segment]
[Extract].[Sub-Category]
Dashboard Objects:
Filter: [Sample - Superstore].[Region]
Dashboard: Shipping
Worksheets
Worksheet: ShipSummary
Datasources: Sample - Superstore
Used Dimensions & Measures: [Days to Ship Actual]
[Days to Ship Scheduled]
[Number of Records]
[Order Date]
[Region]
[Ship Date]
[Ship Mode]
[Ship Status]
Used Remote Columns: [Extract].[Order Date]
[Extract].[Region]
[Extract].[Ship Date]
[Extract].[Ship Mode]
Worksheet: ShippingTrend
Datasources: Sample - Superstore
Used Dimensions & Measures: [Days to Ship Actual]
[Days to Ship Scheduled]
[Number of Records]
[Order Date]
[Region]
[Ship Date]
[Ship Mode]
[Ship Status]
Used Remote Columns: [Extract].[Order Date]
[Extract].[Region]
[Extract].[Ship Date]
[Extract].[Ship Mode]
Worksheet: DaystoShip
Datasources: Sample - Superstore
Used Dimensions & Measures: [Customer Name]
[Days to Ship Actual]
[Days to Ship Scheduled]
[Order Date]
[Order ID]
[Product Name]
[Region]
[Ship Date]
[Ship Mode]
[Ship Status]
Used Remote Columns: [Extract].[Customer Name]
[Extract].[Order Date]
[Extract].[Order ID]
[Extract].[Product Name]
[Extract].[Region]
[Extract].[Ship Date]
[Extract].[Ship Mode]
Dashboard Objects:
Filter: [Sample - Superstore].[YEAR(Order Date)]
Filter: [Sample - Superstore].[QUARTER(Order Date)]
Filter: [Sample - Superstore].[Region]
Filter: [Sample - Superstore].[Ship Mode]
Worksheets
Worksheet: CommissionProjection
Visible: Yes
Used Datasources
Datasource: Parameters
Continous Measure: Base Salary
Continous Measure: Commission Rate
Continous Measure: New Quota
Discrete Measure: Sort by
Datasource: Sales Commission
Discrete Dimension: Sales Person1
Remote Column: [Extract].[Sales Person]
Continous Measure: Achievement (estimated)
Discrete Measure: Achieved Quota
Continous Measure: Base (Variable)
Continous Measure: % of quota achieved
Continous Measure: Rank over 3
Discrete Measure: Sort by field
Continous Measure: Commission (Variable)
Continous Measure: OTE (Variable)
Continous Measure: Sales
Remote Column: [Extract].[Sales]
Continous Measure: Total Compensation
Marks
Mark: All
Type: Automatic
Tooltip: <[Sales Commission].[Sales Person]>
<[Sales Commission].[Achievement (variable) (copy)]> Quota Achieved

Total Sales: <[Sales Commission].[SUM(Achievement (copy))]>
Compensation: <[Sales Commission].[Total Compensation]>
View
Rows: [Sales Commission].[Rank over 3]
[Sales Commission].[Sales Person]
Columns: [Sales Commission].[Multiple Values]
Filters: [Sales Commission].[Measure Names()]
Manual Sorting: [Sales Commission].[Measure Names()] ASC
[Sales Commission].[Achievement (variable) (copy)] ASC
Slices: [Sales Commission].[Measure Names()]
Styles
Style: axis
[Sales Commission].[Multiple Values]
title: Compensation ($)
auto-subtitle: true
Style: header
[Sales Commission].[Sales Person]
width: 136
Style: label
[Sales Commission].[Rank over 3]
display: false
[Sales Commission].[SUM(Achievement (copy))]
text-format: n#,##0,K;-#,##0,K
Style: worksheet
rows
display-field-labels: false
Style: refline
refline2
stroke-color: #acacac
color: #000000
refline3
color: #000000
refline4
stroke-color: #acacac
color: #000000
Style: legend
Other
background-color: #ffffff
[Sales Commission].[Measure Names()]
col-width: 240
Style: legend-title-text
[Sales Commission].[Measure Names()]
Worksheet: CustomerOverview
Visible: Yes
Used Datasources
Datasource: Sample - Superstore
Discrete Dimension: Category
Remote Column: [Extract].[Category]
Discrete Dimension: Customer Name
Remote Column: [Extract].[Customer Name]
Discrete Dimension: Order Date
Remote Column: [Extract].[Order Date]
Discrete Dimension: Region
Remote Column: [Extract].[Region]
Discrete Dimension: Segment
Remote Column: [Extract].[Segment]
Discrete Dimension: Ship Date
Remote Column: [Extract].[Ship Date]
Discrete Dimension: Ship Mode
Remote Column: [Extract].[Ship Mode]
Continous Measure: Days to Ship Actual
Continous Measure: Days to Ship Scheduled
Continous Measure: Sales per Customer
Continous Measure: Profit Ratio
Continous Measure: Profit
Remote Column: [Extract].[Profit]
Continous Measure: Quantity
Remote Column: [Extract].[Quantity]
Continous Measure: Sales
Remote Column: [Extract].[Sales]
Marks
Mark: All
Type: Automatic
Tooltip: <[Sample - Superstore].[Region]>
Customers: <[Sample - Superstore].[Customer Name]>
Sales: <[Sample - Superstore].[SUM(Sales)]>
Sales/Customer: <[Sample - Superstore].[Sales per Customer]>
Quantity: <[Sample - Superstore].[SUM(Quantity)]>
Profit: <[Sample - Superstore].[SUM(Profit)]>
Profit Ratio: <[Sample - Superstore].[Profit Ratio]>
View
Rows: [Sample - Superstore].[Region]
Columns: [Sample - Superstore].[Measure Names()]
[Sample - Superstore].[Multiple Values]
Filters: [Sample - Superstore].[Measure Names()]
[Sample - Superstore].[Category]
[Sample - Superstore].[Region]
[Sample - Superstore].[Segment]
[Sample - Superstore].[QUARTER(Order Date)]
[Sample - Superstore].[YEAR(Order Date)]
Manual Sorting: [Sample - Superstore].[Measure Names()] ASC
Slices: [Sample - Superstore].[YEAR(Order Date)]
[Sample - Superstore].[QUARTER(Order Date)]
[Sample - Superstore].[Segment]
[Sample - Superstore].[Category]
[Sample - Superstore].[Measure Names()]
[Sample - Superstore].[Region]
[Sample - Superstore].[Order Date]
Styles
Style: axis
[Sample - Superstore].[Customer Name]
height: 22
[Sample - Superstore].[SUM(Profit)]
height: 22
[Sample - Superstore].[SUM(Quantity)]
height: 22
[Sample - Superstore].[SUM(Sales)]
height: 22
[Sample - Superstore].[Sales per Customer]
height: 22
[Sample - Superstore].[Profit Ratio]
height: 22
[Sample - Superstore].[Multiple Values]
display: false
Style: cell
[Sample - Superstore].[Region]
height: 23
Other
text-align: center
[Sample - Superstore].[SUM(Quantity)]
text-format: n#,##0;-#,##0
[Sample - Superstore].[Sales per Customer]
text-format: c"$"#,##0;("$"#,##0)
Style: header
[Sample - Superstore].[Region]
width: 60
cols
border-style: none
rows
border-style: none
Style: label
[Sample - Superstore].[Measure Names()]
text-align: left
font-size: 9
font-family: Tableau Regular
font-weight: bold
Style: pane
cols
border-style: none
rows
border-style: none
Style: worksheet
rows
display-field-labels: false
Style: gridline
cols
line-visibility: off
Style: table-div
rows
line-visibility: off
cols
line-visibility: off
Style: header-div
cols
line-visibility: off
Style: quick-filter
[Sample - Superstore].[YEAR(Order Date)]
title: Year
Other
background-color: #f7f7f7
Worksheet: CustomerRank
Visible: Yes
Used Datasources
Datasource: Sample - Superstore
Discrete Dimension: Category
Remote Column: [Extract].[Category]
Discrete Dimension: Customer Name
Remote Column: [Extract].[Customer Name]
Discrete Dimension: Order Date
Remote Column: [Extract].[Order Date]
Discrete Dimension: Region
Remote Column: [Extract].[Region]
Discrete Dimension: Segment
Remote Column: [Extract].[Segment]
Continous Measure: Profit Ratio
Continous Measure: Profit
Remote Column: [Extract].[Profit]
Continous Measure: Sales
Remote Column: [Extract].[Sales]
Marks
Mark: All
Type: Automatic
Tooltip: <[Sample - Superstore].[Customer Name]>
Sales Rank: <[Sample - Superstore].[SUM(Sales)]>
Sales: <[Sample - Superstore].[SUM(Sales)]>
Profit: <[Sample - Superstore].[SUM(Profit)]>
Profit Ratio: <[Sample - Superstore].[Profit Ratio]>
View
Rows: [Sample - Superstore].[Customer Name]
Columns: [Sample - Superstore].[SUM(Sales)]
Filters: [Sample - Superstore].[Action (Region)]
[Sample - Superstore].[Category]
[Sample - Superstore].[Region]
[Sample - Superstore].[Segment]
[Sample - Superstore].[YEAR(Order Date)]
Slices: [Sample - Superstore].[Action (Region)]
[Sample - Superstore].[YEAR(Order Date)]
[Sample - Superstore].[Segment]
[Sample - Superstore].[Category]
[Sample - Superstore].[Region]
[Sample - Superstore].[Order Date]
Styles
Style: axis
cols
tick-color: #f0f0f0
Style: worksheet
rows
display-field-labels: false
Style: refline
refline0
fill-above: #00000000
fill-below: #00000000
vertical-align: top
stroke-size: 1
text-align: center
Style: gridline
cols
line-pattern-only: solid
line-visibility: on
Style: table-div
rows
line-visibility: off
cols
line-visibility: off
Style: title
Other
background-color: #00000000
Worksheet: CustomerScatter
Visible: Yes
Used Datasources
Datasource: Sample - Superstore
Discrete Dimension: Category
Remote Column: [Extract].[Category]
Discrete Dimension: Customer Name
Remote Column: [Extract].[Customer Name]
Discrete Dimension: Order Date
Remote Column: [Extract].[Order Date]
Discrete Dimension: Region
Remote Column: [Extract].[Region]
Discrete Dimension: Segment
Remote Column: [Extract].[Segment]
Continous Measure: Profit Ratio
Continous Measure: Profit
Remote Column: [Extract].[Profit]
Continous Measure: Sales
Remote Column: [Extract].[Sales]
Marks
Mark: All
Type: Automatic
Tooltip: <[Sample - Superstore].[Customer Name]>
Sales: <[Sample - Superstore].[SUM(Sales)]>
Profit: <[Sample - Superstore].[SUM(Profit)]>
Profit Ratio: <[Sample - Superstore].[Profit Ratio]>
View
Rows: [Sample - Superstore].[SUM(Profit)]
Columns: [Sample - Superstore].[SUM(Sales)]
Filters: [Sample - Superstore].[Action (Region)]
[Sample - Superstore].[Category]
[Sample - Superstore].[Region]
[Sample - Superstore].[Segment]
[Sample - Superstore].[YEAR(Order Date)]
Slices: [Sample - Superstore].[Action (Region)]
[Sample - Superstore].[YEAR(Order Date)]
[Sample - Superstore].[Segment]
[Sample - Superstore].[Category]
[Sample - Superstore].[Region]
[Sample - Superstore].[Order Date]
Styles
Style: axis
[Sample - Superstore].[SUM(Profit)]
width: 84
cols
tick-color: #f0f0f0
Style: pane
rows
border-style: none
Style: refline
Other
stroke-size: 1
Style: gridline
Other
line-pattern-only: dotted
line-visibility: on
Style: table-div
rows
line-visibility: off
cols
line-visibility: off
Style: title
Other
background-color: #00000000
Style: quick-filter
[Sample - Superstore].[YEAR(Order Date)]
title: Year
Worksheet: DaystoShip
Visible: Yes
Used Datasources
Datasource: Sample - Superstore
Discrete Dimension: Ship Status
Discrete Dimension: Customer Name
Remote Column: [Extract].[Customer Name]
Discrete Dimension: Order Date
Remote Column: [Extract].[Order Date]
Discrete Dimension: Order ID
Remote Column: [Extract].[Order ID]
Discrete Dimension: Product Name
Remote Column: [Extract].[Product Name]
Discrete Dimension: Region
Remote Column: [Extract].[Region]
Discrete Dimension: Ship Date
Remote Column: [Extract].[Ship Date]
Discrete Dimension: Ship Mode
Remote Column: [Extract].[Ship Mode]
Continous Measure: Days to Ship Actual
Continous Measure: Days to Ship Scheduled
Marks
Mark: All
Type: Automatic
Tooltip: <[Sample - Superstore].[Ship Mode]> - <[Sample - Superstore].[Ship Status]>
<[Sample - Superstore].[SUM(Days to Ship Actual)]> days to ship
Product Name: <[Sample - Superstore].[Product Name]>
Customer Name: <[Sample - Superstore].[Customer Name]>
Order Date: <[Sample - Superstore].[Order Date]>
Order ID: <[Sample - Superstore].[Order ID]>
View
Rows: [Sample - Superstore].[Product Name]
Columns: [Sample - Superstore].[Order Date]
Filters: [Sample - Superstore].[Action (Delayed?)]
[Sample - Superstore].[Action (Ship Status)]
[Sample - Superstore].[Action (Ship Status,YEAR(Order Date),WEEK(Order Date))]
[Sample - Superstore].[Ship Status]
[Sample - Superstore].[Region]
[Sample - Superstore].[Ship Mode]
[Sample - Superstore].[QUARTER(Order Date)]
[Sample - Superstore].[YEAR(Order Date)]
Slices: [Sample - Superstore].[Ship Status]
[Sample - Superstore].[YEAR(Order Date)]
[Sample - Superstore].[QUARTER(Order Date)]
[Sample - Superstore].[Ship Mode]
[Sample - Superstore].[Action (Delayed?)]
[Sample - Superstore].[Action (Ship Status)]
[Sample - Superstore].[Action (Ship Status,YEAR(Order Date),WEEK(Order Date))]
[Sample - Superstore].[Region]
[Sample - Superstore].[Order Date]
Styles
Style: axis
[Sample - Superstore].[Order Date]
auto-subtitle: true
height: 37
Style: header
[Sample - Superstore].[Product Name]
width: 300
[Sample - Superstore].[Customer Name]
width: 116
[Sample - Superstore].[Order ID]
width: 108
Style: worksheet
rows
display-field-labels: false
Style: gridline
Other
line-pattern-only: solid
line-visibility: on
Style: table-div
rows
line-visibility: off
Style: title
Other
background-color: #00000000
Worksheet: Forecast
Visible: No
Used Datasources
Datasource: Sample - Superstore
Discrete Dimension: Order Date
Remote Column: [Extract].[Order Date]
Discrete Dimension: Region
Remote Column: [Extract].[Region]
Discrete Dimension: Segment
Remote Column: [Extract].[Segment]
Continous Measure: Sales
Remote Column: [Extract].[Sales]
Marks
Mark: All
Type: Automatic
Tooltip: <[Sample - Superstore].[Forecast Indicator]> Sales
<[Sample - Superstore].[Segment]>, <[Sample - Superstore].[MONTH(Order Date)]>
Sales: <[Sample - Superstore].[SUM(Sales)]>
View
Rows: [Sample - Superstore].[Segment]
[Sample - Superstore].[SUM(Sales)]
Columns: [Sample - Superstore].[MONTH(Order Date)]
Filters: [Sample - Superstore].[Region]
Slices: [Sample - Superstore].[Region]
[Sample - Superstore].[Order Date]
Styles
Style: axis
[Sample - Superstore].[SUM(Sales)]
auto-subtitle: true
width: 76
[Sample - Superstore].[MONTH(Order Date)]
title: Order Date
auto-subtitle: true
height: 43
Style: header
[Sample - Superstore].[Segment]
width: 28
Style: label
[Sample - Superstore].[Segment]
display: true
text-orientation: -90
font-size: 10
[Sample - Superstore].[MONTH(Order Date)]
text-orientation: 0
Style: worksheet
cols
display-field-labels: false
rows
display-field-labels: false
Style: zeroline
cols
line-visibility: off
rows
line-visibility: off
Style: axis-title
[Sample - Superstore].[MONTH(Order Date)]
font-size: 10
Worksheet: OTE
Visible: Yes
Used Datasources
Datasource: Parameters
Continous Measure: Base Salary
Continous Measure: Commission Rate
Continous Measure: New Quota
Datasource: Sales Commission
Continous Measure: OTE (Variable)
Marks
Mark: All
Type: Automatic
View
Rows: [Sales Commission].[Measure Names()]
Filters: [Sales Commission].[Measure Names()]
Manual Sorting: [Sales Commission].[Measure Names()] ASC
Slices: [Sales Commission].[Measure Names()]
Styles
Style: cell
Other
width: 173
[Sales Commission].[SUM(OTE (Variable))]
font-weight: bold
font-size: 16
text-format: c"$"#,##0,,.00M;("$"#,##0,,.00M)
[Sales Commission].[AVG(OTE (Variable))]
font-weight: bold
font-size: 16
text-format: c"$"#,##0,K;("$"#,##0,K)
[Sales Commission].[Multiple Values]
text-format: c"$"#,##0.00;("$"#,##0.00)
font-weight: bold
font-size: 16
Style: header
[Sales Commission].[Measure Names()]
width: 260
rows
band-color: #00000000
Other
height-header: 12
Style: label
[Sales Commission].[Measure Names()]
color: #cc721e
font-weight: bold
font-size: 12
text-align: right
Style: pane
rows
band-color: #00000000
Style: table
Other
omit-on-special: false
break-on-special: false
show-null-value-warning: false
rows
band-size: 1
Style: worksheet
rows
display-field-labels: false
Style: table-div
rows
line-visibility: off
cols
line-visibility: off
Style: title
Other
background-color: #ffffff
Worksheet: Performance
Visible: No
Used Datasources
Datasource: Sample - Superstore
Discrete Dimension: Category
Remote Column: [Extract].[Category]
Discrete Dimension: Order Date
Remote Column: [Extract].[Order Date]
Discrete Dimension: Region
Remote Column: [Extract].[Region]
Discrete Dimension: Segment
Remote Column: [Extract].[Segment]
Continous Measure: SUM([Sales])-SUM([Sales Target].[Sales Target])
Discrete Measure: Sales above Target?
Continous Measure: Sales
Remote Column: [Extract].[Sales]
Datasource: Sales Target Extract
Continous Measure: Sales Target
Remote Column: [Extract].[Sales Target]
Marks
Mark: All
Type: Bar
Tooltip: <[Sample - Superstore].[Sales above Target?]> - <[Sample - Superstore].[Segment]> <[Sample - Superstore].[Category]>
<[Sample - Superstore].[MONTH(Order Date)]> <[Sample - Superstore].[YEAR(Order Date)]>
Sales: <[Sample - Superstore].[SUM(Sales)]>
Sales Target: <[Sales Target Extract].[SUM(Sales Target)]>
Difference: $<[Sample - Superstore].[SUM([Sales])-SUM([Sales Target].[Sales Target])]>
View
Rows: [Sample - Superstore].[YEAR(Order Date)]
([Sample - Superstore].[MONTH(Order Date)]
[Sample - Superstore].[Segment]))
Columns: [Sample - Superstore].[Category]
[Sample - Superstore].[SUM(Sales)]
Filters: [Sample - Superstore].[Region]
[Sample - Superstore].[YEAR(Order Date)]
Slices: [Sample - Superstore].[YEAR(Order Date)]
[Sample - Superstore].[Region]
[Sample - Superstore].[Order Date]
Styles
Style: axis
[Sample - Superstore].[SUM(Sales)]
auto-subtitle: true
Style: header
[Sample - Superstore].[Category]
height: 20
[Sample - Superstore].[Segment]
width: 96
Style: label
[Sample - Superstore].[YEAR(Order Date)]
display: false
[Sample - Superstore].[MONTH(Order Date)]
font-size: 9
[Sample - Superstore].[Category]
font-size: 9
Style: table
rows
band-level: 0
band-size: 3
Style: worksheet
cols
display-field-labels: false
rows
display-field-labels: false
Style: refline
refline0
stroke-color: #000000
Style: refband
refline1
reverse-palette: false
palette: gray80
Style: gridline
cols
line-visibility: off
Style: table-div
rows
line-visibility: off
div-level: 0
cols
div-level: 0
line-visibility: off
Style: legend-title-text
[Sample - Superstore].[Sales above Target?]
color: Sales above Budget?
Style: quick-filter
[Sample - Superstore].[YEAR(Order Date)]
title: Year
Worksheet: Product Detail Sheet
Visible: Yes
Used Datasources
Datasource: Sample - Superstore
Discrete Dimension: Order Profitable?
Discrete Dimension: Category
Remote Column: [Extract].[Category]
Discrete Dimension: City
Remote Column: [Extract].[City]
Discrete Dimension: Customer Name
Remote Column: [Extract].[Customer Name]
Discrete Dimension: Order Date
Remote Column: [Extract].[Order Date]
Discrete Dimension: Order ID
Remote Column: [Extract].[Order ID]
Discrete Dimension: Postal Code
Remote Column: [Extract].[Postal Code]
Discrete Dimension: Region
Remote Column: [Extract].[Region]
Discrete Dimension: Segment
Remote Column: [Extract].[Segment]
Discrete Dimension: Ship Date
Remote Column: [Extract].[Ship Date]
Discrete Dimension: Ship Mode
Remote Column: [Extract].[Ship Mode]
Discrete Dimension: State
Remote Column: [Extract].[State]
Continous Measure: Days to Ship Actual
Continous Measure: Days to Ship Scheduled
Continous Measure: Profit Ratio
Continous Measure: Discount
Remote Column: [Extract].[Discount]
Continous Measure: Profit
Remote Column: [Extract].[Profit]
Continous Measure: Quantity
Remote Column: [Extract].[Quantity]
Continous Measure: Sales
Remote Column: [Extract].[Sales]
Marks
Mark: All
Type: Automatic
Tooltip: Customer Name: <[Sample - Superstore].[Customer Name]>
<[Sample - Superstore].[Measure Names()]>: <[Sample - Superstore].[Multiple Values]>
Order Date: <[Sample - Superstore].[Order Date]>
Order ID: <[Sample - Superstore].[Order ID]>
Ship Date: <[Sample - Superstore].[Ship Date]>
Ship Mode: <[Sample - Superstore].[Ship Mode]>
View
Rows: [Sample - Superstore].[Order ID]
([Sample - Superstore].[Customer Name]
([Sample - Superstore].[Order Date]
([Sample - Superstore].[Ship Date]
[Sample - Superstore].[Ship Mode]))))
Columns: [Sample - Superstore].[Measure Names()]
Filters: [Sample - Superstore].[Measure Names()]
[Sample - Superstore].[Action (Order Profitable?,MONTH(Order Date),Segment)]
[Sample - Superstore].[Action (Postal Code,State) 1]
[Sample - Superstore].[Category]
[Sample - Superstore].[City]
[Sample - Superstore].[Order Date]
[Sample - Superstore].[Region]
[Sample - Superstore].[Segment]
[Sample - Superstore].[State]
Manual Sorting: [Sample - Superstore].[Measure Names()] ASC
Slices: [Sample - Superstore].[Measure Names()]
[Sample - Superstore].[Category]
[Sample - Superstore].[Segment]
[Sample - Superstore].[Region]
[Sample - Superstore].[State]
[Sample - Superstore].[City]
[Sample - Superstore].[Action (Order Profitable?,MONTH(Order Date),Segment)]
[Sample - Superstore].[Action (Postal Code,State) 1]
[Sample - Superstore].[Order Date]
[Sample - Superstore].[Order Date]
Styles
Style: cell
[Sample - Superstore].[SUM(Discount)]
text-format: p0%
Style: header
[Sample - Superstore].[Order ID]
width: 120
[Sample - Superstore].[Ship Mode]
width: 116
[Sample - Superstore].[Ship Date]
width: 88
[Sample - Superstore].[Order Date]
width: 88
[Sample - Superstore].[Customer Name]
width: 140
Style: field-labels
Other
font-family: Tableau Medium
font-weight: bold
Style: field-labels-decoration
Other
font-weight: bold
Style: label
[Sample - Superstore].[Measure Names()]
color: #333333
font-family: Tableau Medium
font-weight: bold
Worksheet: ProductDetails
Visible: Yes
Used Datasources
Datasource: Sample - Superstore
Discrete Dimension: Category
Remote Column: [Extract].[Category]
Discrete Dimension: Order Date
Remote Column: [Extract].[Order Date]
Discrete Dimension: Product Name
Remote Column: [Extract].[Product Name]
Discrete Dimension: Region
Remote Column: [Extract].[Region]
Discrete Dimension: Segment
Remote Column: [Extract].[Segment]
Discrete Dimension: Sub-Category
Remote Column: [Extract].[Sub-Category]
Continous Measure: Profit Ratio
Continous Measure: Profit
Remote Column: [Extract].[Profit]
Continous Measure: Sales
Remote Column: [Extract].[Sales]
Marks
Mark: All
Type: Circle
Tooltip: <[Sample - Superstore].[Segment]> > <[Sample - Superstore].[Category]> > <[Sample - Superstore].[Sub-Category]>
<[Sample - Superstore].[Sub-Category]>: <[Sample - Superstore].[Product Name]>
Sales: <[Sample - Superstore].[SUM(Sales)]>
Profit: <[Sample - Superstore].[SUM(Profit)]>
Profit Ratio: <[Sample - Superstore].[Profit Ratio]>
View
Rows: [Sample - Superstore].[Category]
[Sample - Superstore].[Sub-Category]
Columns: [Sample - Superstore].[Segment]
[Sample - Superstore].[SUM(Sales)]
Filters: [Sample - Superstore].[Action (Category,YEAR(Order Date),MONTH(Order Date))]
[Sample - Superstore].[Action (YEAR(Order Date),MONTH(Order Date))]
[Sample - Superstore].[Action (YEAR(Order Date),MONTH(Order Date),Product Category)]
[Sample - Superstore].[MONTH(Order Date)]
[Sample - Superstore].[Region]
[Sample - Superstore].[YEAR(Order Date)]
Slices: [Sample - Superstore].[YEAR(Order Date)]
[Sample - Superstore].[MONTH(Order Date)]
[Sample - Superstore].[Action (YEAR(Order Date),MONTH(Order Date))]
[Sample - Superstore].[Action (YEAR(Order Date),MONTH(Order Date),Product Category)]
[Sample - Superstore].[Action (Category,YEAR(Order Date),MONTH(Order Date))]
[Sample - Superstore].[Region]
[Sample - Superstore].[Order Date]
Styles
Style: axis
[Sample - Superstore].[SUM(Sales)]
auto-subtitle: true
height: 45
Style: cell
[Sample - Superstore].[Sub-Category]
height: 21
Style: header
[Sample - Superstore].[Sub-Category]
width: 99
[Sample - Superstore].[Category]
width: 103
Style: label
[Sample - Superstore].[MONTH(Order Date)]
text-format: iLLL
Style: worksheet
cols
display-field-labels: false
rows
display-field-labels: false
Style: refline
refline1
fill-above: #00000000
fill-below: #00000000
stroke-size: 2
stroke-color: #555555
Style: table-div
rows
stroke-color: #f0f0f0
stroke-size: 2
Style: header-div
rows
stroke-size: 2
Style: legend
Other
background-color: #f5f5f5
Style: quick-filter
Other
background-color: #f5f5f5
Worksheet: ProductView
Visible: Yes
Used Datasources
Datasource: Sample - Superstore
Discrete Dimension: Category
Remote Column: [Extract].[Category]
Discrete Dimension: Order Date
Remote Column: [Extract].[Order Date]
Discrete Dimension: Region
Remote Column: [Extract].[Region]
Continous Measure: Profit
Remote Column: [Extract].[Profit]
Continous Measure: Sales
Remote Column: [Extract].[Sales]
Marks
Mark: All
Type: Square
Tooltip: <[Sample - Superstore].[Category]>
<[Sample - Superstore].[MONTH(Order Date)]> <[Sample - Superstore].[YEAR(Order Date)]>
Sales: <[Sample - Superstore].[SUM(Sales)]>
Profit: <[Sample - Superstore].[SUM(Profit)]>
View
Rows: [Sample - Superstore].[Category]
[Sample - Superstore].[YEAR(Order Date)]
Columns: [Sample - Superstore].[MONTH(Order Date)]
Filters: [Sample - Superstore].[Region]
Slices: [Sample - Superstore].[Region]
[Sample - Superstore].[Order Date]
Styles
Style: cell
Other
text-align: center
Style: header
[Sample - Superstore].[YEAR(Order Date)]
width: 40
[Sample - Superstore].[Category]
width: 98
Style: label
[Sample - Superstore].[MONTH(Order Date)]
font-weight: normal
text-format: iLLL
Style: worksheet
cols
display-field-labels: false
rows
display-field-labels: false
Style: table-div
rows
stroke-size: 4
stroke-color: #ffffff
cols
line-visibility: off
Style: header-div
cols
line-visibility: off
Style: legend
Other
background-color: #f5f5f5
Style: quick-filter
[Sample - Superstore].[YEAR(Order Date)]
title: Order Year
[Sample - Superstore].[MONTH(Order Date)]
title: Order Year
Other
background-color: #f7f7f7
Worksheet: QuotaAttainment
Visible: Yes
Used Datasources
Datasource: Parameters
Continous Measure: Base Salary
Continous Measure: Commission Rate
Continous Measure: New Quota
Datasource: Sales Commission
Discrete Dimension: Sales Person1
Remote Column: [Extract].[Sales Person]
Continous Measure: Achievement (estimated)
Discrete Measure: Achieved Quota
Continous Measure: Base (Variable)
Continous Measure: % of quota achieved
Continous Measure: Rank over 3
Continous Measure: Commission (Variable)
Continous Measure: OTE (Variable)
Continous Measure: Sales
Remote Column: [Extract].[Sales]
Continous Measure: Total Compensation
Marks
Mark: All
Type: Automatic
Tooltip: <[Sales Commission].[Sales Person]>
<[Sales Commission].[Achievement (variable) (copy)]> Quota Achieved
Total Sales: $<[Sales Commission].[SUM(Achievement (copy))]>
Compensation: <[Sales Commission].[Total Compensation]>
View
Rows: [Sales Commission].[Rank over 3]
[Sales Commission].[Sales Person]
Columns: [Sales Commission].[SUM(Achievement (copy))]
Manual Sorting: [Sales Commission].[Achievement (variable) (copy)] ASC
Styles
Style: axis
[Sales Commission].[SUM(Achievement (copy))]
title: Sales ($)
auto-subtitle: true
Style: label
[Sales Commission].[Rank over 3]
display: false
[Sales Commission].[SUM(Achievement (copy))]
text-format: n#,##0,K;-#,##0,K
Style: refline
refline0
fill-above: #00000000
fill-below: #00000000
Style: refband
refline1
reverse-palette: false
Style: legend-title-text
[Sales Commission].[Achievement (variable) (copy)]
Worksheet: Sale Map
Visible: Yes
Used Datasources
Datasource: Sample - Superstore
Discrete Dimension: Order Profitable?
Discrete Dimension: Order Date
Remote Column: [Extract].[Order Date]
Discrete Dimension: Order ID
Remote Column: [Extract].[Order ID]
Discrete Dimension: Postal Code
Remote Column: [Extract].[Postal Code]
Discrete Dimension: Region
Remote Column: [Extract].[Region]
Discrete Dimension: State
Remote Column: [Extract].[State]
Continous Measure: Profit Ratio
Continous Measure: Profit
Remote Column: [Extract].[Profit]
Continous Measure: Sales
Remote Column: [Extract].[Sales]
Marks
Mark: All
Type: Multipolygon
Tooltip: <[Sample - Superstore].[State]> <[Sample - Superstore].[Profit Ratio]> overall
Profit Ratio by City
<Sheet name="Tooltip: Profit Ratio by City" maxwidth="300" maxheight="300" filter="<All Fields>">
View
Rows: [Sample - Superstore].[Latitude (generated)]
Columns: [Sample - Superstore].[Longitude (generated)]
Filters: [Sample - Superstore].[Order Profitable?]
[Sample - Superstore].[Region]
[Sample - Superstore].[Profit Ratio]
Slices: [Sample - Superstore].[Order Date]
[Sample - Superstore].[Region]
[Sample - Superstore].[Profit Ratio]
[Sample - Superstore].[Order Profitable?]
Styles
Style: legend
Other
font-family: Tableau Book
Style: legend-title-text
[Sample - Superstore].[Profit Ratio]
color: Profit Ratio
Style: map-layer
tab_base
enabled: true
um_lcover
enabled: false
tab_coastline
enabled: true
pp2_line
enabled: false
light_adm0_bnd
enabled: false
light_adm0_lbl
enabled: false
um_adm0_bnd
enabled: true
um_adm0_lbl
enabled: false
light_pp2_statebounds
enabled: false
light_pp2_statelabels
enabled: false
pp2_adminlabels
enabled: false
pp2_statebounds
enabled: false
pp2_statelabels
enabled: false
countybounds
enabled: false
countylabels
enabled: false
zipbounds
enabled: false
ziplabels
enabled: false
tab_areabounds
enabled: false
tab_arealabels
enabled: false
tab_msabounds
enabled: false
tab_msalabels
enabled: false
Style: map
Other
washout: 0.33000001311302185
map-style: tableau-light-gray
Style: map-data-layer
Other
palette: tableau-map-blue-green-light
Style: quick-filter
Other
background-color: #f7f7f7
border-width: 2
border-color: #f7f7f7
border-style: none
Worksheet: Sales
Visible: Yes
Used Datasources
Datasource: Parameters
Continous Measure: New Quota
Datasource: Sales Commission
Continous Measure: Achievement (estimated)
Continous Measure: % of quota achieved
Continous Measure: Sales
Remote Column: [Extract].[Sales]
Marks
Mark: All
Type: Automatic
View
Rows: [Sales Commission].[Measure Names()]
Filters: [Sales Commission].[Measure Names()]
Manual Sorting: [Sales Commission].[Measure Names()] ASC
Slices: [Sales Commission].[Measure Names()]
Styles
Style: cell
Other
width: 171
[Sales Commission].[SUM(Sales)]
font-weight: bold
font-size: 16
text-format: c"$"#,##0,,.00M;("$"#,##0,,.00M)
[Sales Commission].[Multiple Values]
font-size: 16
font-weight: bold
Style: header
[Sales Commission].[Measure Names()]
width: 228
rows
band-color: #00000000
Style: label
[Sales Commission].[Measure Names()]
color: #cc721e
font-size: 12
text-align: right
font-weight: bold
Style: pane
rows
band-color: #00000000
Style: table
Other
omit-on-special: false
break-on-special: false
show-null-value-warning: false
rows
band-size: 1
Style: worksheet
rows
display-field-labels: false
Style: table-div
rows
line-visibility: off
cols
line-visibility: off
Style: title
Other
background-color: #ffffff
Worksheet: Sales by Product
Visible: Yes
Used Datasources
Datasource: Sample - Superstore
Discrete Dimension: Order Profitable?
Discrete Dimension: Category
Remote Column: [Extract].[Category]
Discrete Dimension: Order Date
Remote Column: [Extract].[Order Date]
Discrete Dimension: Order ID
Remote Column: [Extract].[Order ID]
Discrete Dimension: Postal Code
Remote Column: [Extract].[Postal Code]
Discrete Dimension: Region
Remote Column: [Extract].[Region]
Discrete Dimension: Segment
Remote Column: [Extract].[Segment]
Discrete Dimension: State
Remote Column: [Extract].[State]
Continous Measure: Profit
Remote Column: [Extract].[Profit]
Continous Measure: Sales
Remote Column: [Extract].[Sales]
Marks
Mark: All
Type: Area
Tooltip: <[Sample - Superstore].[Category]> - <[Sample - Superstore].[MONTH(Order Date)]>
<[Sample - Superstore].[Order Profitable?]> Orders
Sales: <[Sample - Superstore].[SUM(Sales)]>
Profit: <[Sample - Superstore].[SUM(Profit)]>
View
Rows: [Sample - Superstore].[Category]
[Sample - Superstore].[SUM(Sales)]
Columns: [Sample - Superstore].[MONTH(Order Date)]
Filters: [Sample - Superstore].[Action (MONTH(Order Date),Segment)]
[Sample - Superstore].[Action (Postal Code,State)]
[Sample - Superstore].[Action (State)]
[Sample - Superstore].[Order Profitable?]
[Sample - Superstore].[Region]
Manual Sorting: [Sample - Superstore].[Order Profitable?] ASC
Slices: [Sample - Superstore].[Action (State)]
[Sample - Superstore].[Action (Postal Code,State)]
[Sample - Superstore].[Action (MONTH(Order Date),Segment)]
[Sample - Superstore].[Region]
[Sample - Superstore].[Order Date]
[Sample - Superstore].[Order Profitable?]
Styles
Style: axis
[Sample - Superstore].[MONTH(Order Date)]
auto-subtitle: true
[Sample - Superstore].[SUM(Sales)]
auto-subtitle: true
width: 60
Style: cell
[Sample - Superstore].[MONTH(Order Date)]
text-format: *m/d/yyyy
Style: header
[Sample - Superstore].[Category]
width: 84
Style: label
[Sample - Superstore].[MONTH(Order Date)]
Style: worksheet
rows
display-field-labels: false
Style: refline
refline0
fill-above: #00000000
fill-below: #00000000
Worksheet: Sales by Segment
Visible: Yes
Used Datasources
Datasource: Sample - Superstore
Discrete Dimension: Order Profitable?
Discrete Dimension: Category
Remote Column: [Extract].[Category]
Discrete Dimension: Order Date
Remote Column: [Extract].[Order Date]
Discrete Dimension: Order ID
Remote Column: [Extract].[Order ID]
Discrete Dimension: Postal Code
Remote Column: [Extract].[Postal Code]
Discrete Dimension: Region
Remote Column: [Extract].[Region]
Discrete Dimension: Segment
Remote Column: [Extract].[Segment]
Discrete Dimension: State
Remote Column: [Extract].[State]
Continous Measure: Profit
Remote Column: [Extract].[Profit]
Continous Measure: Sales
Remote Column: [Extract].[Sales]
Marks
Mark: All
Type: Area
Tooltip: <[Sample - Superstore].[Segment]> - <[Sample - Superstore].[MONTH(Order Date)]>
<[Sample - Superstore].[Order Profitable?]> Orders
Sales: <[Sample - Superstore].[SUM(Sales)]>
Profit: <[Sample - Superstore].[SUM(Profit)]>
View
Rows: [Sample - Superstore].[Segment]
[Sample - Superstore].[SUM(Sales)]
Columns: [Sample - Superstore].[MONTH(Order Date)]
Filters: [Sample - Superstore].[Action (MONTH(Order Date),Product Category)]
[Sample - Superstore].[Action (Postal Code,State)]
[Sample - Superstore].[Action (State)]
[Sample - Superstore].[Order Profitable?]
[Sample - Superstore].[Region]
Manual Sorting: [Sample - Superstore].[Order Profitable?] ASC
Slices: [Sample - Superstore].[Action (State)]
[Sample - Superstore].[Action (Postal Code,State)]
[Sample - Superstore].[Action (MONTH(Order Date),Product Category)]
[Sample - Superstore].[Order Date]
[Sample - Superstore].[Region]
[Sample - Superstore].[Order Profitable?]
Styles
Style: axis
[Sample - Superstore].[MONTH(Order Date)]
auto-subtitle: true
[Sample - Superstore].[SUM(Sales)]
auto-subtitle: false
width: 60
Style: cell
[Sample - Superstore].[MONTH(Order Date)]
text-format: *m/d/yyyy
Style: label
[Sample - Superstore].[MONTH(Order Date)]
Style: worksheet
rows
display-field-labels: false
cols
display-field-labels: false
Style: refline
refline0
fill-above: #00000000
fill-below: #00000000
Style: legend-title-text
[Sample - Superstore].[Order Profitable?]
Worksheet: ShipSummary
Visible: Yes
Used Datasources
Datasource: Sample - Superstore
Discrete Dimension: Ship Status
Discrete Dimension: Order Date
Remote Column: [Extract].[Order Date]
Discrete Dimension: Region
Remote Column: [Extract].[Region]
Discrete Dimension: Ship Date
Remote Column: [Extract].[Ship Date]
Discrete Dimension: Ship Mode
Remote Column: [Extract].[Ship Mode]
Continous Measure: Days to Ship Actual
Continous Measure: Days to Ship Scheduled
Continous Measure: Number of Records
Marks
Mark: All
Type: Automatic
Label: <[Sample - Superstore].[SUM(Number of Records)]> <[Sample - Superstore].[Ship Status]>
View
Columns: [Sample - Superstore].[SUM(Number of Records)]
Filters: [Sample - Superstore].[Ship Status]
[Sample - Superstore].[Region]
[Sample - Superstore].[Ship Mode]
[Sample - Superstore].[QUARTER(Order Date)]
[Sample - Superstore].[YEAR(Order Date)]
Manual Sorting: [Sample - Superstore].[Ship Status] ASC
Slices: [Sample - Superstore].[Ship Status]
[Sample - Superstore].[QUARTER(Order Date)]
[Sample - Superstore].[Ship Mode]
[Sample - Superstore].[YEAR(Order Date)]
[Sample - Superstore].[Region]
[Sample - Superstore].[Order Date]
Styles
Style: axis
[Sample - Superstore].[SUM(Number of Records)]
display: false
auto-subtitle: true
Style: cell
Other
font-size: 14
font-weight: bold
text-align: center
border-style: none
cols
border-width: 1
border-color: #ffffff
[Sample - Superstore].[SUM(Number of Records)]
text-format: p0%
Style: label
[Sample - Superstore].[Ship Status]
display: true
font-size: 10
Style: pane
Other
border-style: none
Style: table
Other
background-color: #00000000
Style: worksheet
cols
display-field-labels: false
Style: table-div
cols
stroke-size: 2
line-visibility: off
rows
line-visibility: off
Style: title
Other
background-color: #00000000
Worksheet: ShippingTrend
Visible: Yes
Used Datasources
Datasource: Sample - Superstore
Discrete Dimension: Ship Status
Discrete Dimension: Order Date
Remote Column: [Extract].[Order Date]
Discrete Dimension: Region
Remote Column: [Extract].[Region]
Discrete Dimension: Ship Date
Remote Column: [Extract].[Ship Date]
Discrete Dimension: Ship Mode
Remote Column: [Extract].[Ship Mode]
Continous Measure: Days to Ship Actual
Continous Measure: Days to Ship Scheduled
Continous Measure: Number of Records
Marks
Mark: All
Type: Area
Tooltip: <[Sample - Superstore].[Ship Status]>
Week of <[Sample - Superstore].[WEEK(Order Date)]>
Shipments: <[Sample - Superstore].[SUM(Number of Records)]>
View
Rows: [Sample - Superstore].[SUM(Number of Records)]
Columns: [Sample - Superstore].[YEAR(Order Date)]
[Sample - Superstore].[WEEK(Order Date)]
Filters: [Sample - Superstore].[Action (Delayed?)]
[Sample - Superstore].[Action (Ship Status)]
[Sample - Superstore].[Region]
[Sample - Superstore].[Ship Mode]
[Sample - Superstore].[QUARTER(Order Date)]
[Sample - Superstore].[YEAR(Order Date)]
Manual Sorting: [Sample - Superstore].[Ship Status] ASC
Slices: [Sample - Superstore].[YEAR(Order Date)]
[Sample - Superstore].[QUARTER(Order Date)]
[Sample - Superstore].[Ship Mode]
[Sample - Superstore].[Action (Delayed?)]
[Sample - Superstore].[Action (Ship Status)]
[Sample - Superstore].[Region]
[Sample - Superstore].[Order Date]
Styles
Style: axis
[Sample - Superstore].[SUM(Number of Records)]
title: Number of Shipments
auto-subtitle: true
width: 48
Style: label
[Sample - Superstore].[YEAR(Order Date)]
display: false
Style: worksheet
cols
display-field-labels: false
rows
display-field-labels: false
Style: header-div
cols
line-visibility: off
Style: title
Other
background-color: #00000000
Style: legend-title-text
[Sample - Superstore].[Ship Status]
color: On Time?
Style: quick-filter
[Sample - Superstore].[YEAR(Order Date)]
title: Order Year
[Sample - Superstore].[QUARTER(Order Date)]
title: Order Quarter
Other
background-color: #f7f7f7
Worksheet: Tooltip: Profit Ratio by City
Visible: Yes
Used Datasources
Datasource: Sample - Superstore
Discrete Dimension: City
Remote Column: [Extract].[City]
Discrete Dimension: Order Date
Remote Column: [Extract].[Order Date]
Discrete Dimension: State
Remote Column: [Extract].[State]
Continous Measure: Profit Ratio
Continous Measure: Profit
Remote Column: [Extract].[Profit]
Continous Measure: Sales
Remote Column: [Extract].[Sales]
Marks
Mark: All
Type: Automatic
View
Rows: [Sample - Superstore].[City]
Columns: [Sample - Superstore].[Profit Ratio]
Filters: [Sample - Superstore].[Tooltip (State)]
Slices: [Sample - Superstore].[Order Date]
[Sample - Superstore].[Tooltip (State)]
Styles
Style: axis
[Sample - Superstore].[Profit Ratio]
display: false
cols
line-visibility: off
rows
line-visibility: off
Style: cell
[Sample - Superstore].[Profit Ratio]
font-style: italic
Style: label
[Sample - Superstore].[Profit Ratio]
font-style: italic
Style: worksheet
rows
display-field-labels: false
Style: gridline
cols
line-visibility: off
Worksheet: Total Sales
Visible: Yes
Used Datasources
Datasource: Parameters
Continous Measure: New Business Growth
Continous Measure: Churn Rate
Datasource: Sample - Superstore
Discrete Dimension: Order Profitable?
Discrete Dimension: Category
Remote Column: [Extract].[Category]
Discrete Dimension: Customer Name
Remote Column: [Extract].[Customer Name]
Discrete Dimension: Order Date
Remote Column: [Extract].[Order Date]
Discrete Dimension: Order ID
Remote Column: [Extract].[Order ID]
Discrete Dimension: Region
Remote Column: [Extract].[Region]
Discrete Dimension: Segment
Remote Column: [Extract].[Segment]
Discrete Dimension: State
Remote Column: [Extract].[State]
Continous Measure: Sales Forecast
Continous Measure: Sales per Customer
Continous Measure: Profit Ratio
Continous Measure: Discount
Remote Column: [Extract].[Discount]
Continous Measure: Profit
Remote Column: [Extract].[Profit]
Continous Measure: Quantity
Remote Column: [Extract].[Quantity]
Continous Measure: Units estimate
Continous Measure: Profit per Order
Continous Measure: Sales
Remote Column: [Extract].[Sales]
Marks
Mark: All
Type: Automatic
Label: <[Sample - Superstore].[Multiple Values]>
View
Columns: [Sample - Superstore].[Measure Names()]
Filters: [Sample - Superstore].[Measure Names()]
[Sample - Superstore].[Action (Order Profitable?,Category,MONTH(Order Date))]
[Sample - Superstore].[Action (Order Profitable?,MONTH(Order Date),Segment)]
[Sample - Superstore].[Action (State)]
[Sample - Superstore].[Region]
Manual Sorting: [Sample - Superstore].[Measure Names()] ASC
Slices: [Sample - Superstore].[Region]
[Sample - Superstore].[Action (State)]
[Sample - Superstore].[Action (Order Profitable?,MONTH(Order Date),Segment)]
[Sample - Superstore].[Measure Names()]
[Sample - Superstore].[Action (Order Profitable?,Category,MONTH(Order Date))]
[Sample - Superstore].[Order Date]
Styles
Style: cell
Other
text-align: center
font-weight: bold
font-size: 12
Style: header
[Sample - Superstore].[Measure Names()]
height: 23
Style: label
Other
text-align: center
[Sample - Superstore].[Measure Names()]
font-size: 8
font-family: Tableau Regular
Style: table-div
cols
line-visibility: off
rows
line-visibility: off
Worksheet: What If Forecast
Visible: No
Used Datasources
Datasource: Parameters
Continous Measure: New Business Growth
Continous Measure: Churn Rate
Datasource: Sample - Superstore
Discrete Dimension: Order Date
Remote Column: [Extract].[Order Date]
Discrete Dimension: Region
Remote Column: [Extract].[Region]
Discrete Dimension: Segment
Remote Column: [Extract].[Segment]
Continous Measure: Sales Forecast
Continous Measure: SUM([Sales])-SUM([Sales Forecast])
Continous Measure: Quantity
Remote Column: [Extract].[Quantity]
Continous Measure: Sales
Remote Column: [Extract].[Sales]
Marks
Mark: All
Type: Automatic
Tooltip: <[Sample - Superstore].[Region]> <[Sample - Superstore].[Segment]>
<[Sample - Superstore].[MONTH(Order Date)]>
Actual: <[Sample - Superstore].[SUM(Sales)]>
Forecast: <[Sample - Superstore].[SUM(Sales Forecast)]>
Difference: $<[Sample - Superstore].[SUM([Sales])-SUM([Sales Forecast])]>
View
Rows: [Sample - Superstore].[Region]
([Sample - Superstore].[Segment]
[Sample - Superstore].[Measure Names()]))
Columns: [Sample - Superstore].[QUARTER(Order Date)]
[Sample - Superstore].[MONTH(Order Date)]
Filters: [Sample - Superstore].[Measure Names()]
[Sample - Superstore].[Region]
[Sample - Superstore].[YEAR(Order Date)]
Manual Sorting: [Sample - Superstore].[Measure Names()] ASC
Slices: [Sample - Superstore].[YEAR(Order Date)]
[Sample - Superstore].[Measure Names()]
[Sample - Superstore].[Region]
[Sample - Superstore].[Order Date]
Styles
Style: cell
[Sample - Superstore].[MONTH(Order Date)]
Style: header
[Sample - Superstore].[Measure Names()]
width: 124
Other
border-width: 2
rows
border-width: 1
border-width: 1
cols
border-width: 1
Style: pane
Other
border-width: 2
rows
border-width: 1
border-width: 1
cols
border-width: 1
border-width: 1
Style: worksheet
cols
display-field-labels: false
Style: table-div
rows
div-level: 0
cols
div-level: 0
Style: quick-filter
[Sample - Superstore].[YEAR(Order Date)]
title: Order Date