← Files TableauARCHIVED FILE
skills/tableau-workbook-authoring/resources/templates/reference/deviation-gain-loss-chart.tbm
9.63 KB · Oct 5, 2026 · 18: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='deviation-gain-loss-chart'>
<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='Difference in sales' datatype='real' name='[Calculation_44402728363008000]' role='measure' type='quantitative'>
<calculation class='tableau' formula='ZN(SUM([Profit])) - LOOKUP(ZN(SUM([Profit])), -1)'>
<table-calc ordering-type='Field'>
<order field='[Sample - Superstore].[Category]' />
<order field='[Sample - Superstore].[Order Date]' />
</table-calc>
</calculation>
</column>
<column caption='Difference if negative' datatype='real' name='[Calculation_44402728363352065]' role='measure' type='quantitative'>
<calculation class='tableau' formula='if [Calculation_44402728363008000] < 0 then [Calculation_44402728363008000] END'>
<table-calc ordering-type='Rows' />
</calculation>
</column>
<column caption='Difference if positive' datatype='real' name='[Calculation_44402728363454466]' role='measure' type='quantitative'>
<calculation class='tableau' formula='if [Calculation_44402728363008000] >= 0 then [Calculation_44402728363008000] END'>
<table-calc ordering-type='Rows' />
</calculation>
</column>
<column caption='Rank of difference if negative' datatype='integer' name='[Calculation_44402728363560963]' role='measure' type='quantitative'>
<calculation class='tableau' formula='RANK_UNIQUE([Calculation_44402728363352065])'>
<table-calc ordering-field='[Sample - Superstore].[Category]' ordering-type='Field' />
</calculation>
</column>
<column caption='Rank of difference if positive' datatype='integer' name='[Calculation_44402728363651076]' role='measure' type='quantitative'>
<calculation class='tableau' formula='RANK_UNIQUE([Calculation_44402728363454466],'asc')'>
<table-calc ordering-field='[Sample - Superstore].[Category]' ordering-type='Field' />
</calculation>
</column>
<column caption='y-axis' datatype='integer' name='[Calculation_44402728364228614]' role='measure' type='quantitative'>
<calculation class='tableau' formula='if [Calculation_44402728363008000] >= 0
then [Calculation_44402728363651076]
else -[Calculation_44402728363560963]
END'>
<table-calc ordering-type='Rows' />
</calculation>
</column>
<column datatype='string' name='[Category]' role='dimension' type='nominal' />
<column datatype='date' name='[Order Date]' role='dimension' type='ordinal' />
<column datatype='real' name='[Profit]' role='measure' type='quantitative' />
<column datatype='string' name='[Customer Name]' role='dimension' type='nominal' />
<column-instance column='[Order Date]' derivation='Month' name='[mn:Order Date:ok]' pivot='key' type='ordinal' />
<column-instance column='[Customer Name]' derivation='None' name='[none:Customer Name:nk]' pivot='key' type='nominal' />
<column-instance column='[Profit]' derivation='Sum' name='[sum:Profit:qk]' pivot='key' type='quantitative' />
<column-instance column='[Calculation_44402728363008000]' derivation='User' name='[usr:Calculation_44402728363008000:qk:5]' pivot='key' type='quantitative'>
<table-calc ordering-type='Field'>
<order field='[Sample - Superstore].[Customer Name]' />
<order field='[Sample - Superstore].[yr:Order Date:ok]' />
</table-calc>
</column-instance>
<column-instance column='[Calculation_44402728363352065]' derivation='User' name='[usr:Calculation_44402728363352065:qk:1]' pivot='key' type='quantitative'>
<table-calc ordering-type='Rows' />
<table-calc field='[Sample - Superstore].[Calculation_44402728363008000]' ordering-type='Field'>
<order field='[Sample - Superstore].[Customer Name]' />
<order field='[Sample - Superstore].[yr:Order Date:ok]' />
</table-calc>
</column-instance>
<column-instance column='[Calculation_44402728363454466]' derivation='User' name='[usr:Calculation_44402728363454466:qk:1]' pivot='key' type='quantitative'>
<table-calc ordering-type='Rows' />
<table-calc field='[Sample - Superstore].[Calculation_44402728363008000]' ordering-type='Field'>
<order field='[Sample - Superstore].[Customer Name]' />
<order field='[Sample - Superstore].[yr:Order Date:ok]' />
</table-calc>
</column-instance>
<column-instance column='[Calculation_44402728364228614]' derivation='User' name='[usr:Calculation_44402728364228614:qk:22]' pivot='key' type='quantitative'>
<table-calc ordering-type='Rows' />
<table-calc field='[Sample - Superstore].[Calculation_44402728363352065]' ordering-type='Rows' />
<table-calc field='[Sample - Superstore].[Calculation_44402728363651076]' ordering-field='[Sample - Superstore].[Customer Name]' ordering-type='Field' />
<table-calc field='[Sample - Superstore].[Calculation_44402728363008000]' ordering-type='Field'>
<order field='[Sample - Superstore].[Customer Name]' />
<order field='[Sample - Superstore].[yr:Order Date:ok]' />
</table-calc>
<table-calc field='[Sample - Superstore].[Calculation_44402728363454466]' ordering-type='Rows' />
<table-calc field='[Sample - Superstore].[Calculation_44402728363560963]' ordering-field='[Sample - Superstore].[Customer Name]' ordering-type='Field' />
</column-instance>
<column-instance column='[Order Date]' derivation='Year' name='[yr:Order Date:ok]' pivot='key' type='ordinal' />
</datasource-dependencies>
<aggregation value='true' />
</view>
<style>
<style-rule element='axis'>
<format attr='subtitle' class='0' field='[Sample - Superstore].[usr:Calculation_44402728364228614:qk:22]' scope='rows' value='' />
<format attr='auto-subtitle' class='0' field='[Sample - Superstore].[usr:Calculation_44402728364228614:qk:22]' scope='rows' value='true' />
<format attr='title' class='0' field='[Sample - Superstore].[usr:Calculation_44402728364228614:qk:22]' scope='rows' value='<- Sub-Category Declining Sub-Cetegory Improving ->' />
</style-rule>
<style-rule element='worksheet'>
<format attr='display-field-labels' scope='cols' value='false' />
</style-rule>
</style>
<panes>
<pane selection-relaxation-option='selection-relaxation-allow'>
<view>
<breakdown value='auto' />
</view>
<mark class='Shape' />
<mark-sizing mark-sizing-setting='marks-scaling-off' />
<encodings>
<color column='[Sample - Superstore].[usr:Calculation_44402728363008000:qk:5]' />
<lod column='[Sample - Superstore].[none:Customer Name:nk]' />
<tooltip column='[Sample - Superstore].[sum:Profit:qk]' />
<tooltip column='[Sample - Superstore].[usr:Calculation_44402728363352065:qk:1]' />
<tooltip column='[Sample - Superstore].[usr:Calculation_44402728363454466:qk:1]' />
</encodings>
<customized-tooltip show-buttons='false'>
<formatted-text>
<run bold='true' fontsize='14'><[Sample - Superstore].[mn:Order Date:ok]></run>
<run fontsize='14'>, </run>
<run bold='true' fontsize='14'><[Sample - Superstore].[yr:Order Date:ok]></run>
<run fontsize='14'>Æ </run>
<run>Æ
</run>
<run fontsize='14'><[Sample - Superstore].[none:Customer Name:nk]> : </run>
<run bold='true' fontsize='14'><[Sample - Superstore].[sum:Profit:qk]></run>
<run>Æ
</run>
<run fontsize='14'>Sales : </run>
<run bold='true' fontsize='14'><[Sample - Superstore].[usr:Calculation_44402728363008000:qk:5]></run>
<run fontsize='14'> Difference : </run>
<run bold='true' fontcolor='#ba4c23' fontsize='14'><[Sample - Superstore].[usr:Calculation_44402728363352065:qk:1]></run>
<run bold='true' fontcolor='#659ac6' fontsize='14'><[Sample - Superstore].[usr:Calculation_44402728363454466:qk:1]></run>
</formatted-text>
</customized-tooltip>
<style>
<style-rule element='mark'>
<format attr='shape' value='Custom/noun_585136.png' />
<format attr='size' value='2.2872927188873291' />
</style-rule>
</style>
</pane>
</panes>
<rows>[Sample - Superstore].[usr:Calculation_44402728364228614:qk:22]</rows>
<cols>([Sample - Superstore].[mn:Order Date:ok] / [Sample - Superstore].[yr:Order Date:ok])</cols>
</table>
</bookmark>
SHA-256: a681dbe8905d303c24aa3feec78f45a5e9516382223e325c0f3976bf1874e15c