← Files TableauARCHIVED FILE

skills/tableau-workbook-authoring/resources/templates/reference/control-chart-xmr.tbm

4.44 KB · Oct 3, 2026 · 06:23 UTC

↓ Download file

<?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='control-chart-xmr'>
  <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 datatype='date' name='[Order Date]' role='dimension' type='ordinal' />
        <column datatype='real' name='[Profit]' role='measure' type='quantitative' />
        <column caption='Out of Control' datatype='integer' name='[Calculation_20260705120000]' role='measure' type='quantitative'>
          <calculation class='tableau' formula='IF ABS(SUM([Profit]) - WINDOW_AVG(SUM([Profit]))) &gt; 3 * WINDOW_STDEV(SUM([Profit])) THEN 1 ELSE 0 END' />
        </column>
        <column-instance column='[Order Date]' derivation='MDY' name='[md:Order Date:ok]' pivot='key' type='ordinal' />
        <column-instance column='[Profit]' derivation='Sum' name='[sum:Profit:qk]' pivot='key' type='quantitative' />
        <column-instance column='[Calculation_20260705120000]' derivation='User' name='[usr:Calculation_20260705120000:ok]' pivot='key' type='ordinal' />
      </datasource-dependencies>
      <aggregation value='true' />
    </view>
    <style>
      <style-rule element='mark'>
        <encoding attr='color' field='[Sample - Superstore].[usr:Calculation_20260705120000:ok]' type='palette'>
          <map to='#e15759'>
            <bucket>1</bucket>
          </map>
          <map to='#4e79a7'>
            <bucket>0</bucket>
          </map>
        </encoding>
      </style-rule>
      <style-rule element='refline'>
        <format attr='fill-above' id='refline0' value='#00000000' />
        <format attr='fill-below' id='refline0' value='#00000000' />
        <format attr='line-visibility' id='refline0' value='on' />
        <format attr='line-pattern-only' id='refline0' value='dashed' />
        <format attr='stroke-color' id='refline0' value='#000000' />
      </style-rule>
      <style-rule element='refband'>
        <format attr='reverse-palette' id='refline1' value='false' />
        <format attr='fill-color' id='refline1' value='#f5f5f5' />
        <format attr='line-visibility' id='refline1' value='on' />
        <format attr='line-pattern-only' id='refline1' value='dashed' />
        <format attr='stroke-color' id='refline1' value='#e15759' />
      </style-rule>
    </style>
    <panes>
      <pane selection-relaxation-option='selection-relaxation-allow'>
        <view>
          <breakdown value='auto' />
        </view>
        <mark class='Automatic' />
        <mark-sizing mark-sizing-setting='marks-scaling-off' />
        <encodings>
          <color column='[Sample - Superstore].[usr:Calculation_20260705120000:ok]' />
        </encodings>
        <reference-line axis-column='[Sample - Superstore].[sum:Profit:qk]' enable-instant-analytics='true' formula='average' id='refline0' label-type='automatic' probability='95' scope='per-pane' value-column='[Sample - Superstore].[sum:Profit:qk]' z-order='1' />
        <reference-line axis-column='[Sample - Superstore].[sum:Profit:qk]' enable-instant-analytics='false' fill-above='false' fill-below='false' formula='stdev' id='refline1' label-type='automatic' scope='per-pane' symmetric='false' type='sample' value-column='[Sample - Superstore].[sum:Profit:qk]' z-order='2'>
          <reference-line-value factor='-3' />
          <reference-line-value factor='3' />
        </reference-line>
        <style>
          <style-rule element='mark'>
            <format attr='size' value='0.0099999997764825821' />
          </style-rule>
        </style>
      </pane>
    </panes>
    <rows>[Sample - Superstore].[sum:Profit:qk]</rows>
    <cols>[Sample - Superstore].[md:Order Date:ok]</cols>
  </table>
</bookmark>

SHA-256: bb85416c0711091f6a578203e5fea37582b4a1dc562dce17277105af12b7e0c5