← Files TableauARCHIVED FILE
skills/tableau-workbook-authoring/resources/templates/reference/ww-ou-diff.tbm
16.7 KB · Oct 3, 2026 · 06:23 UTC
<?xml version='1.0' encoding='utf-8' ?>
<bookmark version='18.1' xmlns:user='http://www.tableausoftware.com/xml/user' source-platform='mac'>
<window class='worksheet' name='ww-ou-diff'>
<cards>
<edge name='left'>
<strip size='160'>
<card type='pages' />
<card type='filters' />
<card type='marks' />
</strip>
</edge>
<edge name='top'>
<strip size='2147483647'>
<card type='columns' />
</strip>
<strip size='2147483647'>
<card type='rows' />
</strip>
<strip size='31'>
<card type='title' />
</strip>
</edge>
</cards>
<viewpoint>
<zoom type='entire-view' />
</viewpoint>
<simple-id uuid='{00000000-0000-0000-0000-000000000002}' />
</window>
<table>
<view>
<datasources>
<datasource name='Sample - Superstore' />
</datasources>
<datasource-dependencies datasource='Sample - Superstore'>
<column caption='Total Score' datatype='integer' name='[Calculation_3985421010944000]' role='measure' type='quantitative'>
<calculation class='tableau' formula='[Final - Split 1 - Split 2]+[Final - Split 2]' />
</column>
<column caption='Over/Under Binary' datatype='integer' name='[Calculation_3985421012422657]' role='measure' type='quantitative'>
<calculation class='tableau' formula='sign(([Calculation_3985421010944000])-([Profit]))' />
</column>
<column caption='SB #' datatype='string' name='[Calculation_3985421141106695]' role='dimension' type='nominal'>
<calculation class='tableau' formula='"SB "+CASE int([Super Bowl - Split 1]) WHEN 2 THEN "II" WHEN 3 THEN "III" WHEN 4 THEN "IV" WHEN 5 THEN "V" WHEN 6 THEN "VI" WHEN 7 THEN "VII" WHEN 8 THEN "VIII" WHEN 9 THEN "IX" WHEN 10 THEN "X" WHEN 11 THEN "XI" WHEN 12 THEN "XII" WHEN 13 THEN "XIII" WHEN 14 THEN "XIV" WHEN 15 THEN "XV" WHEN 16 THEN "XVI" WHEN 17 THEN "XVII" WHEN 18 THEN "XVIII" WHEN 19 THEN "XIX" WHEN 20 THEN "XX" WHEN 21 THEN "XXI" WHEN 22 THEN "XXII" WHEN 23 THEN "XXIII" WHEN 24 THEN "XXIV" WHEN 25 THEN "XXV" WHEN 26 THEN "XXVI" WHEN 27 THEN "XXVII" WHEN 28 THEN "XXVIII" WHEN 29 THEN "XXIX" WHEN 30 THEN "XXX" WHEN 31 THEN "XXXI" WHEN 32 THEN "XXXII" WHEN 33 THEN "XXXIII" WHEN 34 THEN "XXXIV" WHEN 35 THEN "XXXV" WHEN 36 THEN "XXXVI" WHEN 37 THEN "XXXVII" WHEN 38 THEN "XXXVIII" WHEN 39 THEN "XXXIX" WHEN 40 THEN "XL" WHEN 41 THEN "XLI" WHEN 42 THEN "XLII" WHEN 43 THEN "XLIII" WHEN 44 THEN "XLIV" WHEN 45 THEN "XLV" WHEN 46 THEN "XLVI" WHEN 47 THEN "XLVII" WHEN 48 THEN "XLVIII" WHEN 49 THEN "XLIX" WHEN 50 THEN "L" WHEN 51 THEN "LI" WHEN 52 THEN "LII" WHEN 53 THEN "LIII" WHEN 54 THEN "LIV" WHEN 55 THEN "LV" WHEN 56 THEN "LVI" WHEN 57 THEN "LVII" WHEN 58 THEN "LVIII" WHEN 59 THEN "LIX" END' />
</column>
<column aggregation='Sum' caption='Winning Score' datatype='integer' name='[Final - Split 1 - Split 2]' role='dimension' type='ordinal' user:SplitFieldIndex='8' user:SplitFieldOrigin='[Sample - Superstore].[Final - Split 1]'>
<calculation class='tableau' formula='INT( SPLIT( [Final - Split 1], " ", 2 ) )' />
</column>
<column caption='Final - Split 1' datatype='string' name='[Final - Split 1]' role='dimension' type='nominal' user:SplitFieldIndex='5' user:SplitFieldOrigin='[Sample - Superstore].[Product Name]'>
<calculation class='tableau' formula='TRIM( SPLIT( [Product Name], "-", 1 ) )' />
</column>
<column caption='Losing Score' datatype='integer' name='[Final - Split 2]' role='dimension' type='ordinal' user:SplitFieldIndex='6' user:SplitFieldOrigin='[Sample - Superstore].[Product Name]'>
<calculation class='tableau' formula='int(TRIM( SPLIT( [Product Name], "-", 2 ) ))' />
</column>
<column datatype='string' name='[Product Name]' role='dimension' type='nominal' />
<column caption='Over/Under Diff' datatype='real' name='[Over/Under Binary (copy)_3985421014155269]' role='measure' type='quantitative'>
<calculation class='tableau' formula='([Calculation_3985421010944000])-([Profit])' />
</column>
<column caption='Super Bowl #' datatype='string' name='[Super Bowl - Split 1]' role='dimension' type='nominal' user:SplitFieldIndex='3' user:SplitFieldOrigin='[Sample - Superstore].[Customer Name]'>
<calculation class='tableau' formula='TRIM( SPLIT( [Customer Name], "(", 1 ) )' />
</column>
<column caption='Season' datatype='integer' name='[Super Bowl - Split 2]' role='dimension' type='ordinal' user:SplitFieldIndex='4' user:SplitFieldOrigin='[Sample - Superstore].[Customer Name]'>
<calculation class='tableau' formula='int(TRIM( SPLIT( SPLIT( [Customer Name], "(", 2 ), ")", 1 ) ))-1' />
</column>
<column datatype='string' name='[Customer Name]' role='dimension' type='nominal' />
<column caption='O/U Line' datatype='real' name='[Profit]' role='measure' type='quantitative' />
<column-instance column='[Calculation_3985421141106695]' derivation='None' name='[none:Calculation_3985421141106695:nk]' pivot='key' type='nominal' />
<column-instance column='[Super Bowl - Split 2]' derivation='None' name='[none:Super Bowl - Split 2:ok]' pivot='key' type='ordinal' />
<column-instance column='[Calculation_3985421010944000]' derivation='Sum' name='[sum:Calculation_3985421010944000:qk]' pivot='key' type='quantitative' />
<column-instance column='[Calculation_3985421012422657]' derivation='Sum' name='[sum:Calculation_3985421012422657:ok]' pivot='key' type='ordinal' />
<column-instance column='[Over/Under Binary (copy)_3985421014155269]' derivation='Sum' name='[sum:Over/Under Binary (copy)_3985421014155269:qk]' pivot='key' type='quantitative' />
<column-instance column='[Profit]' derivation='Sum' name='[sum:Profit:ok]' pivot='key' type='ordinal' />
<column-instance column='[Profit]' derivation='Sum' name='[sum:Profit:qk]' pivot='key' type='quantitative' />
</datasource-dependencies>
<filter class='categorical' column='[Sample - Superstore].[:Measure Names]'>
<groupfilter function='union' user:op='manual'>
<groupfilter function='member' level='[:Measure Names]' member='"[Sample - Superstore].[sum:Calculation_3985421010944000:qk]"' />
<groupfilter function='member' level='[:Measure Names]' member='"[Sample - Superstore].[sum:Profit:qk]"' />
</groupfilter>
</filter>
<filter class='categorical' column='[Sample - Superstore].[none:Super Bowl - Split 2:ok]'>
<groupfilter function='except' user:ui-domain='relevant' user:ui-enumeration='exclusive' user:ui-marker='enumerate'>
<groupfilter function='level-members' level='[none:Super Bowl - Split 2:ok]' />
<groupfilter function='union'>
<groupfilter function='member' level='[none:Super Bowl - Split 2:ok]' member='1966' />
<groupfilter function='member' level='[none:Super Bowl - Split 2:ok]' member='2025' />
</groupfilter>
</groupfilter>
</filter>
<shelf-sorts>
<shelf-sort-v2 dimension-to-sort='[Sample - Superstore].[none:Super Bowl - Split 2:ok]' direction='DESC' measure-to-sort-by='[Sample - Superstore].[none:Super Bowl - Split 2:ok]' shelf='rows' />
</shelf-sorts>
<hide-sort-controls />
<slices>
<column>[Sample - Superstore].[:Measure Names]</column>
<column>[Sample - Superstore].[none:Super Bowl - Split 2:ok]</column>
</slices>
<aggregation value='true' />
</view>
<style>
<style-rule element='axis'>
<format attr='title' class='0' field='[Sample - Superstore].[Multiple Values]' scope='cols' value='Points scored vs O/U' />
<encoding attr='space' class='0' field='[Sample - Superstore].[sum:Calculation_3985421010944000:qk]' field-type='quantitative' fold='true' scope='cols' synchronized='true' type='space' />
<format attr='display' class='0' field='[Sample - Superstore].[sum:Calculation_3985421010944000:qk]' scope='cols' value='true' />
<format attr='title' class='0' field='[Sample - Superstore].[sum:Over/Under Binary (copy)_3985421014155269:qk]' scope='cols' value='O/U Diff' />
<format attr='display' class='0' field='[Sample - Superstore].[Multiple Values]' scope='cols' value='true' />
<format attr='display' class='0' field='[Sample - Superstore].[sum:Over/Under Binary (copy)_3985421014155269:qk]' scope='cols' value='true' />
<encoding attr='space' class='1' field='[Sample - Superstore].[sum:Over/Under Binary (copy)_3985421014155269:qk]' field-type='quantitative' fold='true' scope='cols' type='space' />
<format attr='title' class='0' field='[Sample - Superstore].[sum:Calculation_3985421010944000:qk]' scope='cols' value='Did they beat the O/U?' />
<format attr='title' class='1' field='[Sample - Superstore].[sum:Over/Under Binary (copy)_3985421014155269:qk]' scope='cols' value='O/U Diff' />
</style-rule>
<style-rule element='header'>
<format attr='width' field='[Sample - Superstore].[none:Calculation_3985421141106695:nk]' value='88' />
<format attr='width' field='[Sample - Superstore].[none:Super Bowl - Split 2:ok]' value='60' />
<format attr='width' field='[Sample - Superstore].[sum:Profit:ok]' value='52' />
<format attr='height-header' value='10' />
</style-rule>
<style-rule element='field-labels'>
<format attr='text-decoration' value='none' />
<format attr='font-family' value='Tableau Light' />
</style-rule>
<style-rule element='label'>
<format attr='font-weight' field='[Sample - Superstore].[none:Super Bowl - Split 2:ok]' value='bold' />
<format attr='font-weight' field='[Sample - Superstore].[none:Calculation_3985421141106695:nk]' value='bold' />
<format attr='color' field='[Sample - Superstore].[none:Super Bowl - Split 2:ok]' value='#666666' />
<format attr='color' field='[Sample - Superstore].[none:Calculation_3985421141106695:nk]' value='#666666' />
<format attr='font-weight' field='[Sample - Superstore].[sum:Profit:ok]' value='bold' />
<format attr='text-align' field='[Sample - Superstore].[sum:Profit:ok]' value='right' />
<format attr='font-size' field='[Sample - Superstore].[none:Calculation_3985421141106695:nk]' value='10' />
<format attr='font-size' field='[Sample - Superstore].[sum:Profit:ok]' value='10' />
<format attr='font-size' field='[Sample - Superstore].[none:Super Bowl - Split 2:ok]' value='10' />
</style-rule>
<style-rule element='table'>
<format attr='band-size' scope='rows' value='1' />
<format attr='band-level' scope='rows' value='2' />
<format attr='background-color' value='#00000000' />
</style-rule>
<style-rule element='refline'>
<format attr='fill-above' id='refline0' value='#00000000' />
<format attr='fill-below' id='refline0' value='#00000000' />
</style-rule>
<style-rule element='refband'>
<format attr='fill-color' id='refline1' value='#00000000' />
</style-rule>
<style-rule element='gridline'>
<format attr='line-pattern-only' value='solid' />
<format attr='stroke-size' value='0' />
<format attr='line-visibility' value='off' />
</style-rule>
<style-rule element='table-div'>
<format attr='div-level' scope='rows' value='1' />
<format attr='stroke-size' scope='rows' value='0' />
<format attr='line-visibility' scope='rows' value='off' />
<format attr='stroke-size' scope='cols' value='0' />
<format attr='line-visibility' scope='cols' value='off' />
</style-rule>
<style-rule element='header-div'>
<format attr='stroke-size' scope='cols' value='0' />
<format attr='line-visibility' scope='cols' value='off' />
</style-rule>
</style>
<panes>
<pane id='6' selection-relaxation-option='selection-relaxation-allow' x-axis-name='[Sample - Superstore].[sum:Over/Under Binary (copy)_3985421014155269:qk]'>
<view>
<breakdown value='auto' />
</view>
<mark class='Bar' />
<mark-sizing mark-sizing-setting='marks-scaling-off' />
<reference-line axis-column='[Sample - Superstore].[sum:Over/Under Binary (copy)_3985421014155269:qk]' enable-instant-analytics='true' formula='constant' id='refline1' label-type='none' paired-id='refline2' scope='per-table' symmetric='false' tooltip-type='none' value='-43.0' value-column='[Sample - Superstore].[sum:Over/Under Binary (copy)_3985421014155269:qk]' z-order='1' />
<reference-line axis-column='[Sample - Superstore].[sum:Over/Under Binary (copy)_3985421014155269:qk]' enable-instant-analytics='true' formula='constant' id='refline2' label-type='none' paired-id='refline1' scope='per-table' symmetric='false' tooltip-type='none' value='43.0' value-column='[Sample - Superstore].[sum:Over/Under Binary (copy)_3985421014155269:qk]' z-order='1' />
<style>
<style-rule element='mark'>
<format attr='mark-labels-show' value='false' />
<format attr='size' value='0.59270715713500977' />
<format attr='mark-transparency' value='255' />
<format attr='mark-color' value='#c0c0c0' />
</style-rule>
<style-rule element='pane'>
<format attr='minheight' value='-1' />
<format attr='maxheight' value='-1' />
<format attr='minheight' value='-1' />
<format attr='maxheight' value='-1' />
</style-rule>
</style>
</pane>
<pane id='7' selection-relaxation-option='selection-relaxation-allow' x-axis-name='[Sample - Superstore].[sum:Over/Under Binary (copy)_3985421014155269:qk]' x-index='1'>
<view>
<breakdown value='auto' />
</view>
<mark class='Circle' />
<mark-sizing mark-sizing-setting='marks-scaling-off' />
<style>
<style-rule element='mark'>
<format attr='mark-labels-show' value='false' />
<format attr='size' value='0.53773480653762817' />
<format attr='mark-transparency' value='255' />
<format attr='mark-color' value='#c0c0c0' />
</style-rule>
<style-rule element='pane'>
<format attr='minheight' value='-1' />
<format attr='maxheight' value='-1' />
<format attr='minheight' value='-1' />
<format attr='maxheight' value='-1' />
</style-rule>
</style>
</pane>
</panes>
<rows>([Sample - Superstore].[none:Super Bowl - Split 2:ok] / ([Sample - Superstore].[none:Calculation_3985421141106695:nk] / [Sample - Superstore].[sum:Profit:ok]))</rows>
<cols>([Sample - Superstore].[sum:Over/Under Binary (copy)_3985421014155269:qk] + [Sample - Superstore].[sum:Over/Under Binary (copy)_3985421014155269:qk])</cols>
</table>
</bookmark>
SHA-256: a831d3228f137d9182008123fed389e11c9cfba17222a52a443eb90792dfd936