<_.fcp.ObjectModelEncapsulateLegacy.true...ObjectModelEncapsulateLegacy />
<_.fcp.ObjectModelTableType.true...ObjectModelTableType />
<_.fcp.SchemaViewerObjectModel.true...SchemaViewerObjectModel />
<_.fcp.ObjectModelEncapsulateLegacy.false...relation connection='excel-direct.0lad5au144tqkt16qnaz70tec6fn' name='Orders' table='[Orders$]' type='table'>
<_.fcp.ObjectModelEncapsulateLegacy.true...relation type='collection'>
0
[Orders]
Count
true
0
"A1:U10195:no:A1:U10195:0"
true
2
0
[People]
Count
true
0
"A1:B5:no:A1:B5:0"
true
6
0
[Returns]
Count
true
0
"A1:B801:no:A1:B801:0"
true
6
Row ID
20
[Row ID]
[Orders]
Row ID
0
integer
Sum
true
"I8"
<_.fcp.ObjectModelEncapsulateLegacy.true...object-id>[Orders_6D2EF74F348B46BDA976A7AEEA6FB5C9]
Order ID
130
[Order ID]
[Orders]
Order ID
1
string
Count
true
"WSTR"
<_.fcp.ObjectModelEncapsulateLegacy.true...object-id>[Orders_6D2EF74F348B46BDA976A7AEEA6FB5C9]
Order Date
7
[Order Date]
[Orders]
Order Date
2
date
Year
true
"DATE"
<_.fcp.ObjectModelEncapsulateLegacy.true...object-id>[Orders_6D2EF74F348B46BDA976A7AEEA6FB5C9]
Ship Date
7
[Ship Date]
[Orders]
Ship Date
3
date
Year
true
"DATE"
<_.fcp.ObjectModelEncapsulateLegacy.true...object-id>[Orders_6D2EF74F348B46BDA976A7AEEA6FB5C9]
Ship Mode
130
[Ship Mode]
[Orders]
Ship Mode
4
string
Count
true
"WSTR"
<_.fcp.ObjectModelEncapsulateLegacy.true...object-id>[Orders_6D2EF74F348B46BDA976A7AEEA6FB5C9]
Customer ID
130
[Customer ID]
[Orders]
Customer ID
5
string
Count
true
"WSTR"
<_.fcp.ObjectModelEncapsulateLegacy.true...object-id>[Orders_6D2EF74F348B46BDA976A7AEEA6FB5C9]
Customer Name
130
[Customer Name]
[Orders]
Customer Name
6
string
Count
true
"WSTR"
<_.fcp.ObjectModelEncapsulateLegacy.true...object-id>[Orders_6D2EF74F348B46BDA976A7AEEA6FB5C9]
Segment
130
[Segment]
[Orders]
Segment
7
string
Count
true
"WSTR"
<_.fcp.ObjectModelEncapsulateLegacy.true...object-id>[Orders_6D2EF74F348B46BDA976A7AEEA6FB5C9]
Country/Region
130
[Country/Region]
[Orders]
Country/Region
8
string
Count
true
"WSTR"
<_.fcp.ObjectModelEncapsulateLegacy.true...object-id>[Orders_6D2EF74F348B46BDA976A7AEEA6FB5C9]
City
130
[City]
[Orders]
City
9
string
Count
true
"WSTR"
<_.fcp.ObjectModelEncapsulateLegacy.true...object-id>[Orders_6D2EF74F348B46BDA976A7AEEA6FB5C9]
State/Province
130
[State/Province]
[Orders]
State/Province
10
string
Count
true
"WSTR"
<_.fcp.ObjectModelEncapsulateLegacy.true...object-id>[Orders_6D2EF74F348B46BDA976A7AEEA6FB5C9]
Postal Code
130
[Postal Code]
[Orders]
Postal Code
11
string
Count
true
"WSTR"
<_.fcp.ObjectModelEncapsulateLegacy.true...object-id>[Orders_6D2EF74F348B46BDA976A7AEEA6FB5C9]
Region
130
[Region]
[Orders]
Region
12
string
Count
true
"WSTR"
<_.fcp.ObjectModelEncapsulateLegacy.true...object-id>[Orders_6D2EF74F348B46BDA976A7AEEA6FB5C9]
Product ID
130
[Product ID]
[Orders]
Product ID
13
string
Count
true
"WSTR"
<_.fcp.ObjectModelEncapsulateLegacy.true...object-id>[Orders_6D2EF74F348B46BDA976A7AEEA6FB5C9]
Category
130
[Category]
[Orders]
Category
14
string
Count
true
"WSTR"
<_.fcp.ObjectModelEncapsulateLegacy.true...object-id>[Orders_6D2EF74F348B46BDA976A7AEEA6FB5C9]
Sub-Category
130
[Sub-Category]
[Orders]
Sub-Category
15
string
Count
true
"WSTR"
<_.fcp.ObjectModelEncapsulateLegacy.true...object-id>[Orders_6D2EF74F348B46BDA976A7AEEA6FB5C9]
Product Name
130
[Product Name]
[Orders]
Product Name
16
string
Count
true
"WSTR"
<_.fcp.ObjectModelEncapsulateLegacy.true...object-id>[Orders_6D2EF74F348B46BDA976A7AEEA6FB5C9]
Sales
5
[Sales]
[Orders]
Sales
17
real
Sum
15
true
"R8"
<_.fcp.ObjectModelEncapsulateLegacy.true...object-id>[Orders_6D2EF74F348B46BDA976A7AEEA6FB5C9]
Quantity
20
[Quantity]
[Orders]
Quantity
18
integer
Sum
true
"I8"
<_.fcp.ObjectModelEncapsulateLegacy.true...object-id>[Orders_6D2EF74F348B46BDA976A7AEEA6FB5C9]
Discount
5
[Discount]
[Orders]
Discount
19
real
Sum
15
true
"R8"
<_.fcp.ObjectModelEncapsulateLegacy.true...object-id>[Orders_6D2EF74F348B46BDA976A7AEEA6FB5C9]
Profit
5
[Profit]
[Orders]
Profit
20
real
Sum
15
true
"R8"
<_.fcp.ObjectModelEncapsulateLegacy.true...object-id>[Orders_6D2EF74F348B46BDA976A7AEEA6FB5C9]
Regional Manager
130
[Regional Manager]
[People]
Regional Manager
21
string
Count
true
"WSTR"
<_.fcp.ObjectModelEncapsulateLegacy.true...object-id>[People_37AF7429D04E4916914EED91681E5975]
Region
130
[Region (People)]
[People]
Region
22
string
Count
true
"WSTR"
<_.fcp.ObjectModelEncapsulateLegacy.true...object-id>[People_37AF7429D04E4916914EED91681E5975]
Returned
130
[Returned]
[Returns]
Returned
23
string
Count
true
"WSTR"
<_.fcp.ObjectModelEncapsulateLegacy.true...object-id>[Returns_11818460B7524AB795D23E763C65D6BC]
Order ID
130
[Order ID (Returns)]
[Returns]
Order ID
24
string
Count
true
"WSTR"
<_.fcp.ObjectModelEncapsulateLegacy.true...object-id>[Returns_11818460B7524AB795D23E763C65D6BC]
Was shipment early, ontime or late based on ship mode
A level of detail expression that calculates profitability for each Order
Used with "Sales Target" data source
<_.fcp.ObjectModelTableType.true...column caption='Orders' datatype='table' name='[__tableau_internal_object_id__].[Orders_6D2EF74F348B46BDA976A7AEEA6FB5C9]' role='measure' type='quantitative' />
<_.fcp.ObjectModelTableType.true...column caption='People' datatype='table' name='[__tableau_internal_object_id__].[People_37AF7429D04E4916914EED91681E5975]' role='measure' type='quantitative' />
<_.fcp.ObjectModelTableType.true...column caption='Returns' datatype='table' name='[__tableau_internal_object_id__].[Returns_11818460B7524AB795D23E763C65D6BC]' role='measure' type='quantitative' />
[Country/Region]
[Region]
[State/Province]
[City]
[Postal Code]
[Category]
[Sub-Category]
[Product Name]
"Actual"
"Estimate"
<_.fcp.ObjectModelEncapsulateLegacy.true...object-graph>