| Location: | Tableau Server |
| Host: | http://bnbrepository9/#/ |
| Path: | Tableau Samples/Regional |
Workbook Information
Author: Unknown
Embedded Datasources
Datasource: Education
Connection
Data Sources
Data Source: Education
Attributes
authentication: auth-username-password
class: hyper
dbname: extract/e1/0e/{5BCD0A04-D9D7-4222-8ECB-A731EB673D99}/dataengine_42020_795741076392lea.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: Education
Dimension
Extract
Dimension: College
Role: Discrete Dimension
Remote Column: [Extract].[College]
Data Type: string
Dimension: Gender
Role: Discrete Dimension
Remote Column: [Extract].[Gender]
Data Type: string
Dimension: Major
Role: Discrete Dimension
Remote Column: [Extract].[Major]
Data Type: string
Measure
Extract
Measure: Academic Year
Role: Continous Measure
Remote Column: [Extract].[Academic Year]
Data Type: integer
Measure: Ethnicity
Role: Continous Measure
Remote Column: [Extract].[Ethnicity]
Data Type: string
Aggregation: Count
Measure: Math
Role: Continous Measure
Remote Column: [Extract].[Math]
Data Type: real
Aggregation: Sum
Measure: Verbal
Role: Continous Measure
Remote Column: [Extract].[Verbal]
Data Type: real
Aggregation: Sum
Measure: Writing
Role: Continous Measure
Remote Column: [Extract].[Writing]
Data Type: real
Aggregation: Sum
Calculated/Other
Measure: True Average
Role: Continous Measure
Data Type: real
Formula: {SUM([Total Score])/SUM(1)}
//Because this is a table-scoped LOD, filters
//need to be context filters so that they are
//evaluated prior to the calculation
Measure: Total Score
Role: Continous Measure
Data Type: real
Formula: [Math]+[Verbal]+[Writing]
Semantic Values
[Country].[Name]: "United States"
Datasource: Obesity
Connection
Data Sources
Data Source: Obesity
Attributes
authentication: auth-username-password
class: hyper
dbname: extract/e1/0e/{5BCD0A04-D9D7-4222-8ECB-A731EB673D99}/hyper_1809jb10jua5bq1cweope10h9n.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: Obesity
Dimension
Extract
Dimension: County
Role: Discrete Dimension
Remote Column: [Extract].[County]
Data Type: string
Dimension: Region
Role: Discrete Dimension
Remote Column: [Extract].[Region]
Data Type: string
Dimension: State
Role: Discrete Dimension
Remote Column: [Extract].[State]
Data Type: string
Calculated/Other
Dimension: Above or Below?
Role: Discrete Dimension
Data Type: string
Formula: IF ROUND([Regional Obesity Rate],2) = ROUND({FIXED [State],[County]: AVG([Adult Obesity (% of pop)])},2)
THEN "on par with"
ELSEIF ROUND([Regional Obesity Rate],2) < ROUND({FIXED [State],[County]: AVG([Adult Obesity (% of pop)])},2)
THEN STR(ROUND(([Difference from Region]*100),2)) + "% above"
ELSE STR(ROUND(([Difference from Region]*100),2)) + "% below"
END
Measure
Extract
Measure: Adult Obesity (% of pop)
Role: Continous Measure
Remote Column: [Extract].[Adult Obesity (% of pop)]
Data Type: real
Measure: Adult Smokers (% of pop)
Role: Continous Measure
Remote Column: [Extract].[Adult Smokers (% of pop)]
Data Type: real
Measure: Children in Poverty (% of pop)
Role: Continous Measure
Remote Column: [Extract].[Children in Poverty (% of pop)]
Data Type: real
Measure: Diabetic (% of pop)
Role: Continous Measure
Remote Column: [Extract].[Diabetic (% of pop)]
Data Type: real
Measure: Food Insecure (% of pop)
Role: Continous Measure
Remote Column: [Extract].[Food Insecure (% of pop)]
Data Type: real
Measure: Physically Inactive (% of pop)
Role: Continous Measure
Remote Column: [Extract].[Physically Inactive (% of pop)]
Data Type: real
Calculated/Other
Measure: Regional Obesity Rate
Role: Continous Measure
Data Type: real
Formula: {FIXED [Region]: AVG([Adult Obesity (% of pop)])}
Measure: Difference from Region
Role: Continous Measure
Data Type: real
Formula: ABS(ROUND({FIXED [State],[County]: AVG([Adult Obesity (% of pop)])},2)- ROUND([Regional Obesity Rate],2))
Measure: Number of Records
Role: Continous Measure
Data Type: integer
Formula: 1
Semantic Values
[Country].[Name]: "United States"
Datasource: Flight
Connection
Data Sources
Data Source: Flight
Attributes
authentication: auth-username-password
class: hyper
dbname: extract/e1/0e/{5BCD0A04-D9D7-4222-8ECB-A731EB673D99}/dataengine_42020_797469930556lea.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: Flight
Dimension
Extract
Dimension: City
Role: Discrete Dimension
Remote Column: [Extract].[City]
Data Type: string
Dimension: Ontime Category
Role: Discrete Dimension
Remote Column: [Extract].[Ontime Category]
Data Type: string
Dimension: State
Role: Discrete Dimension
Remote Column: [Extract].[State]
Data Type: string
Measure
Extract
Measure: Airport Code
Role: Continous Measure
Remote Column: [Extract].[Airport Code]
Data Type: string
Aggregation: Count
Measure: Airport Name
Role: Continous Measure
Remote Column: [Extract].[Airport Name]
Data Type: string
Aggregation: Count
Measure: Carrier Code
Role: Continous Measure
Remote Column: [Extract].[Carrier Code]
Data Type: string
Aggregation: Count
Measure: Carrier Name
Role: Continous Measure
Remote Column: [Extract].[Carrier Name]
Data Type: string
Aggregation: Count
Measure: Date
Role: Continous Measure
Remote Column: [Extract].[Date]
Data Type: date
Aggregation: Year
Measure: Minutes of Delay
Role: Continous Measure
Remote Column: [Extract].[Minutes of Delay]
Data Type: integer
Aggregation: Sum
Measure: Number of Flights
Role: Continous Measure
Remote Column: [Extract].[Number of Flights]
Data Type: real
Aggregation: Sum
Calculated/Other
Measure: % of Delayed Flights
Role: Continous Measure
Data Type: real
Formula: Sum(if contains([Ontime Category], "Delayed") then [Number of Flights] else 0 end)/sum([Number of Flights])
Measure: Minutes of Delay per Flight
Role: Continous Measure
Data Type: real
Formula: [Minutes of Delay]/[Number of Flights]
Semantic Values
[Country].[Name]: "United States"
Datasource: Stocks
Connection
Data Sources
Data Source: Stocks
Attributes
authentication: auth-username-password
class: hyper
dbname: extract/e1/0e/{5BCD0A04-D9D7-4222-8ECB-A731EB673D99}/dataengine_42038_846130138889lea.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: Stocks
Dimension
Extract
Dimension: Company
Role: Discrete Dimension
Remote Column: [Extract].[Company]
Data Type: string
Dimension: Date
Role: Discrete Dimension
Remote Column: [Extract].[Date]
Data Type: date
Measure
Extract
Measure: Number of Records
Role: Continous Measure
Remote Column: [Extract].[Number of Records]
Data Type: integer
Formula: 1
Measure: Close
Role: Continous Measure
Remote Column: [Extract].[Close]
Data Type: real
Aggregation: Sum
Measure: High
Role: Continous Measure
Remote Column: [Extract].[High]
Data Type: real
Aggregation: Sum
Measure: Low
Role: Continous Measure
Remote Column: [Extract].[Low]
Data Type: real
Aggregation: Sum
Measure: Open
Role: Continous Measure
Remote Column: [Extract].[Open]
Data Type: real
Aggregation: Sum
Measure: Volume
Role: Continous Measure
Remote Column: [Extract].[Volume]
Data Type: integer
Aggregation: Sum
Semantic Values
[Country].[Name]: "United States"
Datasource: Global Temperatures
Connection
Data Sources
Data Source: Global Temperatures
Attributes
authentication: auth-username-password
class: hyper
dbname: extract/e1/0e/{5BCD0A04-D9D7-4222-8ECB-A731EB673D99}/dataengine_1drcocf045eval105hqv7.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: Global Temperatures
Dimension
Calculated/Other
Dimension: Date
Role: Discrete Dimension
Data Type: date
Formula: DATE(DATEPARSE("yyyy/MM",[Year]))
Measure
Extract
Measure: Lower CI
Role: Continous Measure
Remote Column: [Extract].[Lower CI]
Data Type: real
Measure: Median
Role: Continous Measure
Remote Column: [Extract].[Median]
Data Type: real
Measure: Upper CI
Role: Continous Measure
Remote Column: [Extract].[Upper CI]
Data Type: real
Measure: Year
Role: Continous Measure
Remote Column: [Extract].[Year]
Data Type: string
Aggregation: Count
Calculated/Other
Measure: Above Median?
Role: Discrete Measure
Data Type: string
Formula: IF AVG([Median]) > 0
THEN "above median"
ELSEIF AVG([Median]) < 0
THEN "below median"
ELSE "(at median)"
END
Measure: Calculation_585397597232062466
Role: Continous Measure
Data Type: real
Formula: [Calculation_585397597231960065]*[Year - Split 2]
Measure: Calculation_585397597264601092
Role: Continous Measure
Data Type: real
Formula: [Median]+1.5
Measure: Number of Records
Role: Continous Measure
Data Type: integer
Formula: 1
Measure: Year - Split 1
Role: Continous Measure
Data Type: integer
Formula: INT( SPLIT( [Year], "/", 1 ) )
Measure: Year - Split 2
Role: Continous Measure
Data Type: integer
Formula: INT( SPLIT( [Year], "/", 2 ) )
Semantic Values
[Country].[Name]: "Reino Unido"
Datasource: Economy
Connection
Data Sources
Data Source: Economy
Attributes
authentication: auth-username-password
class: hyper
dbname: extract/e1/0e/{5BCD0A04-D9D7-4222-8ECB-A731EB673D99}/dataengine_42020_789079537040lea.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: Economy
Dimension
Extract
Dimension: Date
Role: Discrete Dimension
Remote Column: [Extract].[Date]
Data Type: datetime
Dimension: Decade
Role: Discrete Dimension
Remote Column: [Extract].[Decade]
Data Type: integer
Aggregation: Sum
Dimension: Metric
Role: Discrete Dimension
Remote Column: [Extract].[Metric]
Data Type: string
Measure
Extract
Measure: Value
Role: Continous Measure
Remote Column: [Extract].[Value]
Data Type: real
Semantic Values
[Country].[Name]: "United States"
Dashboards
Dashboard: Economy
Worksheets
Worksheet: S&P Returns Vs Conditions
Datasources: Economy
Used Dimensions & Measures: [Date]
[Decade]
[Metric]
[Value]
Used Remote Columns: [Extract].[Date]
[Extract].[Decade]
[Extract].[Metric]
[Extract].[Value]
Worksheet: S&P Forward Returns
Datasources: Economy
Used Dimensions & Measures: [Date]
[Decade]
[Metric]
[Value]
Used Remote Columns: [Extract].[Date]
[Extract].[Decade]
[Extract].[Metric]
[Extract].[Value]
Worksheet: S&P Returns by Decade
Datasources: Economy
Used Dimensions & Measures: [Date]
[Decade]
[Metric]
[Value]
Used Remote Columns: [Extract].[Date]
[Extract].[Decade]
[Extract].[Metric]
[Extract].[Value]
Dashboard Objects:
Filter: [Economy].[Metric]
Filter: [Economy].[YEAR(Date)]
Text: S&P Economic Indicators
Dashboard: Global Temperatures
Worksheets
Worksheet: Heat Map
Datasources: Global Temperatures
Used Dimensions & Measures: [Above Median?]
[Date]
[Median]
[Year]
Used Remote Columns: [Extract].[Median]
[Extract].[Year]
Worksheet: Scatter
Datasources: Global Temperatures
Used Dimensions & Measures: [Above Median?]
[Date]
[Median]
[Year]
Used Remote Columns: [Extract].[Median]
[Extract].[Year]
Dashboard Objects:
Filter: [Global Temperatures].[MONTH(Date)]
Text: This data contains 100 observations of surface temperature (°C) around the world. Each data point is presented as a difference from the median, or temperature anomaly, calculated relative to the 1961-1990 average.
Dashboard: Obesity
Worksheets
Worksheet: Obesity Map
Datasources: Obesity
Used Dimensions & Measures: [Above or Below?]
[Adult Obesity (% of pop)]
[Adult Smokers (% of pop)]
[County]
[Difference from Region]
[Food Insecure (% of pop)]
[Physically Inactive (% of pop)]
[Region]
[Regional Obesity Rate]
[State]
Used Remote Columns: [Extract].[Adult Obesity (% of pop)]
[Extract].[Adult Smokers (% of pop)]
[Extract].[County]
[Extract].[Food Insecure (% of pop)]
[Extract].[Physically Inactive (% of pop)]
[Extract].[Region]
[Extract].[State]
Worksheet: Obesity Scatter Plot
Datasources: Obesity
Used Dimensions & Measures: [Adult Obesity (% of pop)]
[Adult Smokers (% of pop)]
[County]
[Food Insecure (% of pop)]
[Physically Inactive (% of pop)]
[Region]
[State]
Used Remote Columns: [Extract].[Adult Obesity (% of pop)]
[Extract].[Adult Smokers (% of pop)]
[Extract].[County]
[Extract].[Food Insecure (% of pop)]
[Extract].[Physically Inactive (% of pop)]
[Extract].[Region]
[Extract].[State]
Dashboard Objects:
Filter: [Obesity].[Region]
Worksheets
Worksheet: College
Visible: No
Used Datasources
Datasource: Education
Discrete Dimension: College
Remote Column: [Extract].[College]
Discrete Dimension: Gender
Remote Column: [Extract].[Gender]
Continous Measure: Academic Year
Remote Column: [Extract].[Academic Year]
Continous Measure: 1
Continous Measure: True Average
Continous Measure: Total Score
Continous Measure: Math
Remote Column: [Extract].[Math]
Continous Measure: Verbal
Remote Column: [Extract].[Verbal]
Continous Measure: Writing
Remote Column: [Extract].[Writing]
Marks
Mark: All
Type: Circle
Tooltip: College of <[Education].[College]>
Total Score: <[Education].[Total Score]>
# of Students: <[Education].[COUNT(Number of Records)]>
Avg. Math score: <[Education].[AVG(Math)]>
Avg. Verbal score: <[Education].[AVG(Verbal)]>
Avg. Writing score: <[Education].[AVG(Writing)]>
View
Rows: [Education].[SUM(1)]
Columns: [Education].[Total Score]
Filters: [Education].[Academic Year]
[Education].[College]
[Education].[Gender]
Slices: [Education].[Academic Year]
[Education].[College]
[Education].[Gender]
Styles
Style: axis
[Education].[Total Score]
title: SAT Score
auto-subtitle: true
height: 50
[Education].[SUM(1)]
auto-subtitle: true
Style: cell
[Education].[College]
height: 48
Style: header
[Education].[College]
width: 184
Style: label
[Education].[Total Score]
font-weight: normal
font-size: 8
[Education].[SUM(True Average)]
text-format: n0.00
Style: table
Other
omit-on-special: false
break-on-special: false
show-null-value-warning: false
Style: worksheet
rows
display-field-labels: false
Other
font-size: 9
color: #555555
Style: refline
refline0
vertical-align: top
fill-above: #00000000
fill-below: #00000000
line-pattern-only: dotted
line-visibility: on
Other
stroke-size: 2
stroke-color: #000000
line-pattern-only: solid
line-visibility: on
refline1
fill-above: #00000000
fill-below: #00000000
vertical-align: top
font-weight: bold
stroke-size: 1
text-align: center
stroke-color: #f7f7f7
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
[Education].[Gender]
title: Gender
[Education].[Total Score]
title: Select Score Range:
Other
color: #353535
Style: quick-filter-title
Other
color: #353535
Worksheet: Flight Delays
Visible: No
Used Datasources
Datasource: Flight
Discrete Dimension: Airport Name
Remote Column: [Extract].[Airport Name]
Discrete Dimension: Carrier Name
Remote Column: [Extract].[Carrier Name]
Discrete Dimension: Date
Remote Column: [Extract].[Date]
Discrete Dimension: Ontime Category
Remote Column: [Extract].[Ontime Category]
Continous Measure: % of Delayed Flights
Continous Measure: Minutes of Delay per Flight
Continous Measure: Minutes of Delay
Remote Column: [Extract].[Minutes of Delay]
Continous Measure: Number of Flights
Remote Column: [Extract].[Number of Flights]
Marks
Mark: All
Type: Bar
Tooltip: <[Flight].[Carrier Name]> in <[Flight].[MONTH(Date)]>
% of Delayed Flights: <[Flight].[% of total delayed Flights by Security (copy 2)]>
Avg. Minutes of Delay per Flight: <[Flight].[AVG(Minutes of Delay per Flight)]>
Mark: [Flight].[AVG(Minutes of Delay per Flight)]
Type: Line
Tooltip: <[Flight].[Carrier Name]> in <[Flight].[MONTH(Date)]>
% of Delayed Flights: <[Flight].[% of total delayed Flights by Security (copy 2)]>
Avg. Minutes of Delay per Flight: <[Flight].[AVG(Minutes of Delay per Flight)]>
Mark: [Flight].[% of total delayed Flights by Security (copy 2)]
Type: Area
Tooltip: <[Flight].[Carrier Name]> in <[Flight].[MONTH(Date)]>
% of Delayed Flights: <[Flight].[% of total delayed Flights by Security (copy 2)]>
Avg. Minutes of Delay per Flight: <[Flight].[AVG(Minutes of Delay per Flight)]>
View
Rows: [Flight].[% of total delayed Flights by Security (copy 2)]
[Flight].[AVG(Minutes of Delay per Flight)]
Columns: [Flight].[Carrier Name]
[Flight].[MONTH(Date)]
Filters: [Flight].[Airport Name]
[Flight].[Carrier Name]
[Flight].[Date]
Slices: [Flight].[Date]
[Flight].[Airport Name]
[Flight].[Carrier Name]
Styles
Style: axis
[Flight].[% of total delayed Flights by Security (copy 2)]
auto-subtitle: true
rows
line-pattern-only: solid
tick-color: #f5f5f5
line-visibility: on
Style: header
cols
band-color: #fbfbfb
[Flight].[% of total delayed Flights by Security (copy 2)]
background-color: #f7f7f7
[Flight].[AVG(Minutes of Delay per Flight)]
background-color: #f5eddc
Style: label
[Flight].[Carrier Name]
text-orientation: 0
font-size: 8
[Flight].[MONTH(Date)]
vertical-align: auto
text-align: auto
wrap: auto
text-format: iLLL
text-orientation: -90
font-size: 8
color: #666666
[Flight].[% of total delayed Flights by Security (copy 2)]
font-size: 9
Style: pane
cols
band-color: #fbfbfb
Style: table
Other
show-null-value-warning: false
cols
band-level: 1
band-size: 1
Style: worksheet
cols
display-field-labels: false
Other
font-size: 9
Style: dropline
cols
line-visibility: off
Style: refline
cols
line-visibility: off
Style: table-div
rows
line-visibility: off
cols
line-pattern-only: solid
stroke-size: 1
stroke-color: #f5f5f5
line-visibility: on
Style: header-div
cols
line-visibility: off
Style: quick-filter
[Flight].[Airport Name]
title: Choose Your Airport:
[Flight].[Date]
title: Select Date:
[Flight].[Carrier Name]
title: Choose Your Airline:
Style: quick-filter-title
Other
color: #333333
Worksheet: Heat Map
Visible: Yes
Used Datasources
Datasource: Global Temperatures
Discrete Dimension: Date
Discrete Dimension: Year
Remote Column: [Extract].[Year]
Discrete Measure: Above Median?
Continous Measure: Median
Remote Column: [Extract].[Median]
Marks
Mark: All
Type: Square
Tooltip: <[Global Temperatures].[MONTH(Date)]> <[Global Temperatures].[YEAR(Date)]>
<[Global Temperatures].[AVG(Median)]> <[Global Temperatures].[Above Median?]>
View
Rows: [Global Temperatures].[MONTH(Date)]
Columns: [Global Temperatures].[YEAR(Date)]
Slices: [Global Temperatures].[MONTH(Date)]
Styles
Style: header
[Global Temperatures].[MONTH(Date)]
width: 88
cols
border-style: none
Style: label
[Global Temperatures].[YEAR(Date)]
display: false
[Global Temperatures].[MONTH(Date)]
text-align: right
font-family: Tableau Regular
color: #666666
Style: pane
cols
border-style: none
border-style: none
Style: worksheet
cols
display-field-labels: false
rows
display-field-labels: false
Style: table-div
rows
line-visibility: off
Style: header-div
rows
line-visibility: off
Style: quick-filter
[Global Temperatures].[MONTH(Date)]
title: Select date
Style: data-highlighter-title
[Global Temperatures].[MONTH(Date)]
title: Highlight Month
[Global Temperatures].[YEAR(Date)]
title: Highlight Year
Worksheet: Obesity Map
Visible: Yes
Used Datasources
Datasource: Obesity
Discrete Dimension: Above or Below?
Discrete Dimension: County
Remote Column: [Extract].[County]
Discrete Dimension: Region
Remote Column: [Extract].[Region]
Discrete Dimension: State
Remote Column: [Extract].[State]
Continous Measure: Adult Obesity (% of pop)
Remote Column: [Extract].[Adult Obesity (% of pop)]
Continous Measure: Adult Smokers (% of pop)
Remote Column: [Extract].[Adult Smokers (% of pop)]
Continous Measure: Regional Obesity Rate
Continous Measure: Difference from Region
Continous Measure: Food Insecure (% of pop)
Remote Column: [Extract].[Food Insecure (% of pop)]
Continous Measure: Physically Inactive (% of pop)
Remote Column: [Extract].[Physically Inactive (% of pop)]
Marks
Mark: All
Type: Multipolygon
Label: <[Obesity].[County]> of <[Obesity].[State]>
Tooltip: <[Obesity].[County]> County, <[Obesity].[State]>
<[Obesity].[AVG(Adult Obesity (% of pop))]> obesity rate, <[Obesity].[ATTR(Above or Below?)]> the regional average (<[Obesity].[AVG(Regional Obesity Rate)]>)
<[Obesity].[AVG(Food Insecure (% of pop))]> of people eat few fruits and vegetables
<[Obesity].[AVG(Physically Inactive (% of pop))]> of people do not exercise
<[Obesity].[AVG(Adult Smokers (% of pop))]> of people smoke
View
Rows: [Obesity].[Latitude (generated)]
Columns: [Obesity].[Longitude (generated)]
Filters: [Obesity].[Exclusions (County,Region,State)]
Slices: [Obesity].[Region]
[Obesity].[State]
[Obesity].[Exclusions (County,Region,State)]
Styles
Style: axis
Other
tick-color: #00000000
Style: header
Other
border-style: none
Style: label
[Obesity].[AVG(Adult Obesity (% of pop))]
text-format: p0%
Style: pane
Other
border-style: none
Style: table
Other
omit-on-special: false
break-on-special: false
show-null-value-warning: false
background-color: #00000000
Style: caption
Other
border-style: none
Style: dropline
Other
line-visibility: off
Style: refline
Other
line-visibility: off
Style: table-div
rows
stroke-color: #acacac
line-visibility: off
cols
stroke-color: #acacac
line-visibility: off
Style: header-div
cols
line-visibility: off
rows
line-visibility: off
Style: title
Other
background-color: #f0f0f0
Style: legend
Other
color: #4f4f4f
border-width: 5
border-color: #f0f0f0
border-style: none
Style: legend-title
Other
font-weight: normal
font-size: 8
color: #353535
Style: legend-title-text
[Obesity].[AVG(Adult Obesity (% of pop))]
color: Obesity Rate:
Style: map-layer
tab_base
enabled: true
um_lcover
enabled: true
pp2_line
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
light_adm0_lbl
enabled: false
light_adm0_bnd
enabled: true
light_pp2_statelabels
enabled: false
light_pp2_statebounds
enabled: true
tab_coastline
enabled: false
um_adm0_bnd
enabled: false
um_adm0_lbl
enabled: false
Style: map
Other
washout: 0.0
map-style: tableau-light-gray
Style: map-data-layer
Other
palette: tableau-map-blue-green-light
Style: quick-filter
[Obesity].[Region]
title: Select Region:
[Obesity].[State]
title: Select State:
Other
color: #1b1b1b
border-width: 5
border-color: #f0f0f0
background-color: #f5f5f5
border-style: none
Style: quick-filter-title
Other
color: #353535
Style: data-highlighter
Other
border-width: 3
border-color: #f0f0f0
background-color: #f5f5f5
border-style: none
Style: data-highlighter-title
[Obesity].[State]
title: Select State:
Worksheet: Obesity Scatter Plot
Visible: Yes
Used Datasources
Datasource: Obesity
Discrete Dimension: County
Remote Column: [Extract].[County]
Discrete Dimension: Region
Remote Column: [Extract].[Region]
Discrete Dimension: State
Remote Column: [Extract].[State]
Continous Measure: Adult Obesity (% of pop)
Remote Column: [Extract].[Adult Obesity (% of pop)]
Continous Measure: Adult Smokers (% of pop)
Remote Column: [Extract].[Adult Smokers (% of pop)]
Continous Measure: Food Insecure (% of pop)
Remote Column: [Extract].[Food Insecure (% of pop)]
Continous Measure: Physically Inactive (% of pop)
Remote Column: [Extract].[Physically Inactive (% of pop)]
Marks
Mark: All
Type: Circle
Label: <[Obesity].[County]> County, <[Obesity].[State]>
Tooltip: <[Obesity].[County]> County, <[Obesity].[State]>
<[Obesity].[AVG(Adult Obesity (% of pop))]> of the population is obese
<[Obesity].[AVG(Food Insecure (% of pop))]> of people eat few fruits and vegetables
<[Obesity].[AVG(Physically Inactive (% of pop))]> of people do not exercise
<[Obesity].[AVG(Adult Smokers (% of pop))]> of people smoke
Mark: [Obesity].[AVG(Food Insecure (% of pop))]
Type: Circle
Label: <[Obesity].[County]> County, <[Obesity].[State]>
Tooltip: <[Obesity].[County]> County, <[Obesity].[State]>
<[Obesity].[AVG(Adult Obesity (% of pop))]> of the population is obese
<[Obesity].[AVG(Food Insecure (% of pop))]> of people eat few fruits and vegetables
<[Obesity].[AVG(Physically Inactive (% of pop))]> of people do not exercise
<[Obesity].[AVG(Adult Smokers (% of pop))]> of people smoke
Mark: [Obesity].[AVG(Physically Inactive (% of pop))]
Type: Circle
Label: <[Obesity].[County]> County, <[Obesity].[State]>
Tooltip: <[Obesity].[County]> County, <[Obesity].[State]>
<[Obesity].[AVG(Adult Obesity (% of pop))]> of the population is obese
<[Obesity].[AVG(Food Insecure (% of pop))]> of people eat few fruits and vegetables
<[Obesity].[AVG(Physically Inactive (% of pop))]> of people do not exercise
<[Obesity].[AVG(Adult Smokers (% of pop))]> of people smoke
Mark: [Obesity].[AVG(Adult Smokers (% of pop))]
Type: Circle
Label: <[Obesity].[County]> County, <[Obesity].[State]>
Tooltip: <[Obesity].[County]> County, <[Obesity].[State]>
<[Obesity].[AVG(Adult Obesity (% of pop))]> of the population is obese
<[Obesity].[AVG(Food Insecure (% of pop))]> of people eat few fruits and vegetables
<[Obesity].[AVG(Physically Inactive (% of pop))]> of people do not exercise
<[Obesity].[AVG(Adult Smokers (% of pop))]> of people smoke
View
Rows: [Obesity].[AVG(Adult Obesity (% of pop))]
Columns: [Obesity].[AVG(Food Insecure (% of pop))]
([Obesity].[AVG(Physically Inactive (% of pop))]
[Obesity].[AVG(Adult Smokers (% of pop))]))
Slices: [Obesity].[Region]
[Obesity].[State]
Styles
Style: axis
[Obesity].[AVG(Food Insecure (% of pop))]
title: Food Insecure
auto-subtitle: true
height: 46
[Obesity].[AVG(Physically Inactive (% of pop))]
title: No Exercise
auto-subtitle: true
height: 46
[Obesity].[AVG(Adult Smokers (% of pop))]
title: Smokers
auto-subtitle: true
height: 46
[Obesity].[AVG(Adult Obesity (% of pop))]
title: Obesity Rate (% of pop)
auto-subtitle: true
width: 40
Style: label
[Obesity].[AVG(Adult Obesity (% of pop))]
text-format: p0%
[Obesity].[AVG(Physically Inactive (% of pop))]
text-format: p0%
[Obesity].[AVG(Food Insecure (% of pop))]
text-format: p0%
font-family: Tableau Regular
[Obesity].[AVG(Adult Smokers (% of pop))]
text-format: p0%
Style: table
Other
omit-on-special: false
break-on-special: false
show-null-value-warning: false
Style: worksheet
Other
color: #4f4f4f
font-family: Tableau Regular
Style: refline
refline0
fill-above: #00000000
fill-below: #00000000
line-pattern-only: dashed
stroke-size: 1
line-visibility: on
refline4
fill-above: #dfb5b5
fill-below: #ffe791
line-visibility: off
refline1
fill-above: #00000000
fill-below: #00000000
stroke-color: #d7d7d7
line-pattern-only: dashed
line-visibility: on
refline5
fill-above: #dfb5b5
fill-below: #ffe791
line-visibility: off
refline2
fill-above: #00000000
fill-below: #cde5bc
line-visibility: off
refline6
fill-above: #dfb5b5
fill-below: #ffe791
line-visibility: off
refline3
fill-above: #00000000
fill-below: #dfb5b5
line-visibility: off
refline7
fill-above: #cde5bc
fill-below: #ffe791
line-visibility: off
Other
stroke-size: 1
Style: gridline
Other
line-pattern-only: solid
stroke-color: #f0f0f0
line-visibility: on
Style: zeroline
Other
line-pattern-only: dashed
line-visibility: on
Style: title
Other
background-color: #f0f0f0
Style: legend
Other
background-color: #ffffff
Style: legend-title
Other
color: #686868
Style: map-layer
tab_base
enabled: true
pp2_line
enabled: false
pp2_adminlabels
enabled: true
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
181657
enabled: false
181658
enabled: false
181686
enabled: false
181708
enabled: false
181730
enabled: false
181732
enabled: false
181795
enabled: false
181796
enabled: false
181794
enabled: false
181866
enabled: false
181797
enabled: false
181793
enabled: false
181799
enabled: false
181798
enabled: false
182057
enabled: false
182484
enabled: false
182485
enabled: false
182486
enabled: false
181661
enabled: false
181662
enabled: false
181951
enabled: false
182071
enabled: false
182099
enabled: false
181665
enabled: false
181666
enabled: false
182041
enabled: false
182048
enabled: false
182002
enabled: false
182003
enabled: false
181943
enabled: false
light_adm0_lbl
enabled: true
light_adm0_bnd
enabled: true
light_pp2_statelabels
enabled: true
light_pp2_statebounds
enabled: true
Style: map
Other
wrap: true
Style: quick-filter
[Obesity].[State]
title: Select State:
[Obesity].[Region]
title: Select Region:
[Obesity].[County]
title: Type in Name of County:
Other
color: #00000000
border-style: none
Style: quick-filter-title
Other
color: #4f4f4f
Style: parameter-ctrl
Other
color: #000000
Worksheet: S&P Forward Returns
Visible: Yes
Used Datasources
Datasource: Economy
Discrete Dimension: Date
Remote Column: [Extract].[Date]
Discrete Dimension: Decade
Remote Column: [Extract].[Decade]
Discrete Dimension: Metric
Remote Column: [Extract].[Metric]
Continous Measure: Value
Remote Column: [Extract].[Value]
Marks
Mark: All
Type: Shape
Tooltip: <[Economy].[YEAR(Date)]>
<[Economy].[Metric]>: <[Economy].[Value]>
View
Rows: [Economy].[Metric]
Columns: [Economy].[Value]
Filters: [Economy].[Metric]
Slices: [Economy].[Metric]
Styles
Style: axis
[Economy].[Value]
Other
tick-color: #00000000
Style: header
[Economy].[Metric]
width: 172
Style: label
[Economy].[Value]
text-format: p0%
font-size: 9
[Economy].[Metric]
font-size: 8
Style: table
Other
omit-on-special: false
break-on-special: false
show-null-value-warning: false
Style: worksheet
rows
display-field-labels: false
Other
font-size: 11
font-weight: normal
Style: gridline
Other
line-pattern-only: solid
line-visibility: on
Style: zeroline
Other
stroke-color: #353535
line-pattern-only: solid
line-visibility: on
Style: table-div
rows
line-visibility: off
cols
line-visibility: off
Style: legend
Other
background-color: #ffffff
Worksheet: S&P Returns Vs Conditions
Visible: Yes
Used Datasources
Datasource: Economy
Discrete Dimension: Date
Remote Column: [Extract].[Date]
Discrete Dimension: Decade
Remote Column: [Extract].[Decade]
Discrete Dimension: Metric
Remote Column: [Extract].[Metric]
Continous Measure: Value
Remote Column: [Extract].[Value]
Marks
Mark: All
Type: Shape
Tooltip: <[Economy].[YEAR(Date)]>
<[Economy].[Metric]>: <[Economy].[AVG(Value)]>
View
Rows: [Economy].[Metric]
Columns: [Economy].[AVG(Value)]
Filters: [Economy].[Metric]
Manual Sorting: [Economy].[Metric] ASC
Slices: [Economy].[Metric]
Styles
Style: axis
[Economy].[AVG(Value)]
Other
tick-color: #00000000
line-visibility: off
Style: header
[Economy].[Metric]
width: 172
Style: label
[Economy].[AVG(Value)]
text-format: p0%
font-size: 9
[Economy].[Metric]
font-size: 8
Style: table
Other
omit-on-special: false
break-on-special: false
show-null-value-warning: false
Style: worksheet
rows
display-field-labels: false
Other
font-size: 11
font-weight: normal
Style: gridline
Other
line-pattern-only: solid
line-visibility: on
Style: zeroline
Other
stroke-color: #353535
line-pattern-only: solid
line-visibility: on
Style: table-div
rows
div-level: 0
line-visibility: off
cols
line-visibility: off
Style: header-div
rows
line-visibility: off
Style: legend
Other
background-color: #ffffff
Worksheet: S&P Returns by Decade
Visible: Yes
Used Datasources
Datasource: Economy
Discrete Dimension: Date
Remote Column: [Extract].[Date]
Discrete Dimension: Decade
Remote Column: [Extract].[Decade]
Discrete Dimension: Metric
Remote Column: [Extract].[Metric]
Continous Measure: Value
Remote Column: [Extract].[Value]
Marks
Mark: All
Type: Bar
Tooltip: <[Economy].[YEAR(Date)]>
<[Economy].[Metric]>: <[Economy].[AVG(Value)]>
View
Rows: [Economy].[Metric]
[Economy].[AVG(Value)]
Columns: [Economy].[Decade]
[Economy].[YEAR(Date)]
Filters: [Economy].[Set 1]
[Economy].[Metric]
[Economy].[YEAR(Date)]
Manual Sorting: [Economy].[Decade] ASC
[Economy].[YEAR(Date)] ASC
Slices: [Economy].[Metric]
[Economy].[YEAR(Date)]
[Economy].[Set 1]
Styles
Style: axis
[Economy].[AVG(Value)]
width: 52
Style: cell
[Economy].[AVG(Value)]
text-format: p0%
text-orientation: 0
text-align: auto
vertical-align: auto
font-size: 9
Style: header
[Economy].[Decade]
height: 21
Other
height-header: 13
Style: field-labels
Other
font-weight: bold
Style: label
[Economy].[YEAR(Date)]
display: false
[Economy].[Metric]
display: false
[Economy].[AVG(Value)]
text-format: p0%
font-size: 9
Style: table
Other
omit-on-special: false
break-on-special: false
show-null-value-warning: false
cols
band-size: 1
band-level: 1
Style: worksheet
rows
display-field-labels: false
cols
display-field-labels: false
Other
font-weight: normal
font-size: 11
Style: caption
Other
color: #686868
font-weight: bold
font-size: 8
Style: dropline
rows
line-pattern-only: solid
line-visibility: on
Style: refline
rows
line-pattern-only: solid
line-visibility: on
Style: gridline
Other
stroke-color: #d7d7d7
line-visibility: off
rows
line-pattern-only: solid
stroke-color: #f0f0f0
line-visibility: on
Style: zeroline
Other
stroke-color: #555555
line-pattern-only: solid
line-visibility: on
Style: table-div
rows
line-visibility: off
cols
line-visibility: off
Style: legend
[Economy].[Decade]
col-width: 50
Other
font-size: 7
font-weight: bold
border-width: 1
border-style: none
background-color: #f0f0f0
Style: legend-title
Other
font-size: 8
color: #1b1b1b
Style: legend-title-text
[Economy].[AVG(Value)]
color: Returns
Style: quick-filter
[Economy].[Decade]
title: Filter Decade:
[Economy].[AVG(Value)]
title: Return
[Economy].[YEAR(Date)]
title: Year Range
[Economy].[Metric]
title: Metric
Other
color: #353535
background-color: #f7f7f7
border-width: 4
border-style: solid
border-color: #f7f7f7
font-size: 9
Style: quick-filter-title
Other
color: #353535
Worksheet: Scatter
Visible: Yes
Used Datasources
Datasource: Global Temperatures
Discrete Dimension: Date
Discrete Dimension: Year
Remote Column: [Extract].[Year]
Discrete Measure: Above Median?
Continous Measure: Median
Remote Column: [Extract].[Median]
Marks
Mark: All
Type: Line
Tooltip: <[Global Temperatures].[MONTH(Date)]> <[Global Temperatures].[YEAR(Date)]>
<[Global Temperatures].[SUM(Median)]> <[Global Temperatures].[Above Median?]>
View
Rows: [Global Temperatures].[SUM(Median)]
Columns: [Global Temperatures].[ATTR(Date)]
Slices: [Global Temperatures].[MONTH(Date)]
Styles
Style: axis
[Global Temperatures].[SUM(Median)]
title: Difference from median temperature (°C)
auto-subtitle: true
width: 88
[Global Temperatures].[MONTH(Date)]
height: 28
[Global Temperatures].[ATTR(Date)]
height: 26
auto-subtitle: true
Style: header
Other
border-style: none
Style: label
[Global Temperatures].[SUM(Median)]
color: #898989
Style: pane
Other
border-style: none
Style: table
Other
background-color: #ffffff
Style: refband
refline0
fill-color: #f5eddc
Style: gridline
Other
line-visibility: off
Style: table-div
cols
line-visibility: off
rows
line-visibility: off
Style: legend-title
Other
text-align: center
Style: legend-title-text
[Global Temperatures].[SUM(Median)]
color: Difference from Median (°C)
Worksheet: Stocks
Visible: No
Used Datasources
Datasource: Stocks
Discrete Dimension: Company
Remote Column: [Extract].[Company]
Discrete Dimension: Date
Remote Column: [Extract].[Date]
Continous Measure: Close
Remote Column: [Extract].[Close]
Continous Measure: Volume
Remote Column: [Extract].[Volume]
Marks
Mark: All
Type: Automatic
Tooltip: <[Stocks].[Company]> on <[Stocks].[WEEK(Date)]>
Annual Return: <[Stocks].[AVG(Close)]>
Volume: <[Stocks].[AVG(Volume)]>
Mark: [Stocks].[AVG(Close)]
Type: Automatic
Tooltip: <[Stocks].[Company]> on <[Stocks].[WEEK(Date)]>
Annual Return: <[Stocks].[AVG(Close)]>
Volume: <[Stocks].[AVG(Volume)]>
Mark: [Stocks].[AVG(Volume)]
Type: Bar
Tooltip: <[Stocks].[Company]> on <[Stocks].[WEEK(Date)]>
Annual Return: <[Stocks].[AVG(Close)]>
Volume: <[Stocks].[AVG(Volume)]>
View
Rows: [Stocks].[AVG(Close)]
[Stocks].[AVG(Volume)]
Columns: [Stocks].[YEAR(Date)]
[Stocks].[WEEK(Date)]
Filters: [Stocks].[Exclusions (Company,WEEK(Date),YEAR(Date))]
[Stocks].[Company]
[Stocks].[YEAR(Date)]
Manual Sorting: [Stocks].[Company] ASC
Slices: [Stocks].[Company]
[Stocks].[YEAR(Date)]
[Stocks].[Exclusions (Company,WEEK(Date),YEAR(Date))]
Styles
Style: axis
[Stocks].[AVG(Close)]
title: Annual Return
auto-subtitle: true
[Stocks].[WEEK(Date)]
auto-subtitle: true
Style: worksheet
cols
display-field-labels: false
Style: legend
Other
font-size: 9
background-color: #00000000
color: #353535
Style: legend-title
Other
color: #353535
Style: quick-filter
[Stocks].[Company]
title: Select Company:
Other
font-weight: normal
font-size: 9
background-color: #ffffff
color: #353535
[Stocks].[WEEK(Date)]
title: Select Date:
[Stocks].[YEAR(Date)]
title: Select Year:
Style: quick-filter-title
Other
color: #353535
font-weight: bold