123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295 |
- <?xml version='1.0' encoding='utf-8' ?>
- <!-- build 20212.21.1214.2055 -->
- <workbook source-build='2021.2.6 (20212.21.1214.2055)' source-platform='win' version='18.1' xmlns:user='http://www.tableausoftware.com/xml/user'>
- <document-format-change-manifest>
- <_.fcp.AnimationOnByDefault.true...AnimationOnByDefault />
- <_.fcp.MarkAnimation.true...MarkAnimation />
- <_.fcp.ObjectModelEncapsulateLegacy.true...ObjectModelEncapsulateLegacy />
- <_.fcp.ObjectModelTableType.true...ObjectModelTableType />
- <_.fcp.SchemaViewerObjectModel.true...SchemaViewerObjectModel />
- <SheetIdentifierTracking />
- <WindowsPersistSimpleIdentifiers />
- </document-format-change-manifest>
- <preferences>
- <preference name='ui.encoding.shelf.height' value='24' />
- <preference name='ui.shelf.height' value='26' />
- </preferences>
- <_.fcp.AnimationOnByDefault.false...style>
- <_.fcp.AnimationOnByDefault.false..._.fcp.MarkAnimation.true...style-rule element='animation'>
- <_.fcp.AnimationOnByDefault.false...format attr='animation-on' value='ao-on' />
- </_.fcp.AnimationOnByDefault.false..._.fcp.MarkAnimation.true...style-rule>
- </_.fcp.AnimationOnByDefault.false...style>
- <datasources>
- <datasource caption='m3_0103' inline='true' name='federated.1en4l9j0z5yqpt1fw8raf1kz99ys' version='18.1'>
- <connection class='federated'>
- <named-connections>
- <named-connection caption='m3_0103' name='textscan.0erpzzc0a7kcbg12etxg11nmdoos'>
- <connection class='textscan' directory='C:/Users/User/Desktop/ssd-work/homeiot/preproc' filename='m3_0103.csv' password='' server='' />
- </named-connection>
- </named-connections>
- <_.fcp.ObjectModelEncapsulateLegacy.false...relation connection='textscan.0erpzzc0a7kcbg12etxg11nmdoos' name='m3_0103.csv' table='[m3_0103#csv]' type='table'>
- <columns character-set='UTF-8' header='yes' locale='ko_KR' separator=','>
- <column datatype='datetime' name='timestamp' ordinal='0' />
- <column datatype='real' name='hum' ordinal='1' />
- <column datatype='real' name='temp' ordinal='2' />
- <column datatype='real' name='door' ordinal='3' />
- <column datatype='real' name='motion' ordinal='4' />
- <column datatype='real' name='illum' ordinal='5' />
- </columns>
- </_.fcp.ObjectModelEncapsulateLegacy.false...relation>
- <_.fcp.ObjectModelEncapsulateLegacy.true...relation connection='textscan.0erpzzc0a7kcbg12etxg11nmdoos' name='m3_0103.csv' table='[m3_0103#csv]' type='table'>
- <columns character-set='UTF-8' header='yes' locale='ko_KR' separator=','>
- <column datatype='datetime' name='timestamp' ordinal='0' />
- <column datatype='real' name='hum' ordinal='1' />
- <column datatype='real' name='temp' ordinal='2' />
- <column datatype='real' name='door' ordinal='3' />
- <column datatype='real' name='motion' ordinal='4' />
- <column datatype='real' name='illum' ordinal='5' />
- </columns>
- </_.fcp.ObjectModelEncapsulateLegacy.true...relation>
- <metadata-records>
- <metadata-record class='capability'>
- <remote-name />
- <remote-type>0</remote-type>
- <parent-name>[m3_0103.csv]</parent-name>
- <remote-alias />
- <aggregation>Count</aggregation>
- <contains-null>true</contains-null>
- <attributes>
- <attribute datatype='string' name='character-set'>"UTF-8"</attribute>
- <attribute datatype='string' name='collation'>"ko"</attribute>
- <attribute datatype='string' name='currency'>"₩"</attribute>
- <attribute datatype='string' name='debit-close-char'>""</attribute>
- <attribute datatype='string' name='debit-open-char'>""</attribute>
- <attribute datatype='string' name='field-delimiter'>","</attribute>
- <attribute datatype='string' name='header-row'>"true"</attribute>
- <attribute datatype='string' name='locale'>"ko_KR"</attribute>
- <attribute datatype='string' name='single-char'>""</attribute>
- </attributes>
- </metadata-record>
- <metadata-record class='column'>
- <remote-name>timestamp</remote-name>
- <remote-type>135</remote-type>
- <local-name>[timestamp]</local-name>
- <parent-name>[m3_0103.csv]</parent-name>
- <remote-alias>timestamp</remote-alias>
- <ordinal>0</ordinal>
- <local-type>datetime</local-type>
- <aggregation>Year</aggregation>
- <contains-null>true</contains-null>
- <_.fcp.ObjectModelEncapsulateLegacy.true...object-id>[m3_0103.csv_DFECFB17718A4819B318F673AF8CFAEC]</_.fcp.ObjectModelEncapsulateLegacy.true...object-id>
- </metadata-record>
- <metadata-record class='column'>
- <remote-name>hum</remote-name>
- <remote-type>5</remote-type>
- <local-name>[hum]</local-name>
- <parent-name>[m3_0103.csv]</parent-name>
- <remote-alias>hum</remote-alias>
- <ordinal>1</ordinal>
- <local-type>real</local-type>
- <aggregation>Sum</aggregation>
- <contains-null>true</contains-null>
- <_.fcp.ObjectModelEncapsulateLegacy.true...object-id>[m3_0103.csv_DFECFB17718A4819B318F673AF8CFAEC]</_.fcp.ObjectModelEncapsulateLegacy.true...object-id>
- </metadata-record>
- <metadata-record class='column'>
- <remote-name>temp</remote-name>
- <remote-type>5</remote-type>
- <local-name>[temp]</local-name>
- <parent-name>[m3_0103.csv]</parent-name>
- <remote-alias>temp</remote-alias>
- <ordinal>2</ordinal>
- <local-type>real</local-type>
- <aggregation>Sum</aggregation>
- <contains-null>true</contains-null>
- <_.fcp.ObjectModelEncapsulateLegacy.true...object-id>[m3_0103.csv_DFECFB17718A4819B318F673AF8CFAEC]</_.fcp.ObjectModelEncapsulateLegacy.true...object-id>
- </metadata-record>
- <metadata-record class='column'>
- <remote-name>door</remote-name>
- <remote-type>5</remote-type>
- <local-name>[door]</local-name>
- <parent-name>[m3_0103.csv]</parent-name>
- <remote-alias>door</remote-alias>
- <ordinal>3</ordinal>
- <local-type>real</local-type>
- <aggregation>Sum</aggregation>
- <contains-null>true</contains-null>
- <_.fcp.ObjectModelEncapsulateLegacy.true...object-id>[m3_0103.csv_DFECFB17718A4819B318F673AF8CFAEC]</_.fcp.ObjectModelEncapsulateLegacy.true...object-id>
- </metadata-record>
- <metadata-record class='column'>
- <remote-name>motion</remote-name>
- <remote-type>5</remote-type>
- <local-name>[motion]</local-name>
- <parent-name>[m3_0103.csv]</parent-name>
- <remote-alias>motion</remote-alias>
- <ordinal>4</ordinal>
- <local-type>real</local-type>
- <aggregation>Sum</aggregation>
- <contains-null>true</contains-null>
- <_.fcp.ObjectModelEncapsulateLegacy.true...object-id>[m3_0103.csv_DFECFB17718A4819B318F673AF8CFAEC]</_.fcp.ObjectModelEncapsulateLegacy.true...object-id>
- </metadata-record>
- <metadata-record class='column'>
- <remote-name>illum</remote-name>
- <remote-type>5</remote-type>
- <local-name>[illum]</local-name>
- <parent-name>[m3_0103.csv]</parent-name>
- <remote-alias>illum</remote-alias>
- <ordinal>5</ordinal>
- <local-type>real</local-type>
- <aggregation>Sum</aggregation>
- <contains-null>true</contains-null>
- <_.fcp.ObjectModelEncapsulateLegacy.true...object-id>[m3_0103.csv_DFECFB17718A4819B318F673AF8CFAEC]</_.fcp.ObjectModelEncapsulateLegacy.true...object-id>
- </metadata-record>
- </metadata-records>
- </connection>
- <aliases enabled='yes' />
- <_.fcp.ObjectModelTableType.true...column caption='m3_0103.csv' datatype='table' name='[__tableau_internal_object_id__].[m3_0103.csv_DFECFB17718A4819B318F673AF8CFAEC]' role='measure' type='quantitative' />
- <column caption='Door' datatype='real' name='[door]' role='measure' type='quantitative' />
- <column caption='Hum' datatype='real' name='[hum]' role='measure' type='quantitative' />
- <column caption='Illum' datatype='real' name='[illum]' role='measure' type='quantitative' />
- <column caption='Motion' datatype='real' name='[motion]' role='measure' type='quantitative' />
- <column caption='Temp' datatype='real' name='[temp]' role='measure' type='quantitative' />
- <column caption='Timestamp' datatype='datetime' name='[timestamp]' role='dimension' type='ordinal' />
- <column-instance column='[timestamp]' derivation='Day' name='[dy:timestamp:ok]' pivot='key' type='ordinal' />
- <column-instance column='[timestamp]' derivation='Hour' name='[hr:timestamp:ok]' pivot='key' type='ordinal' />
- <column-instance column='[timestamp]' derivation='Month' name='[mn:timestamp:ok]' pivot='key' type='ordinal' />
- <column-instance column='[timestamp]' derivation='Quarter' name='[qr:timestamp:ok]' pivot='key' type='ordinal' />
- <column-instance column='[timestamp]' derivation='Year' name='[yr:timestamp:ok]' pivot='key' type='ordinal' />
- <group hidden='true' name='[포함(년(Timestamp),분기(Timestamp),시간(Timestamp),월(Timestamp),일(Timestamp))]' name-style='unqualified' user:auto-column='include'>
- <groupfilter function='crossjoin'>
- <groupfilter function='level-members' level='[yr:timestamp:ok]' />
- <groupfilter function='level-members' level='[qr:timestamp:ok]' />
- <groupfilter function='level-members' level='[hr:timestamp:ok]' />
- <groupfilter function='level-members' level='[mn:timestamp:ok]' />
- <groupfilter function='level-members' level='[dy:timestamp:ok]' />
- </groupfilter>
- </group>
- <layout _.fcp.SchemaViewerObjectModel.false...dim-percentage='0.5' _.fcp.SchemaViewerObjectModel.false...measure-percentage='0.4' dim-ordering='alphabetic' measure-ordering='alphabetic' show-structure='true' />
- <semantic-values>
- <semantic-value key='[Country].[Name]' value='"대한민국"' />
- </semantic-values>
- <_.fcp.ObjectModelEncapsulateLegacy.true...object-graph>
- <objects>
- <object caption='m3_0103.csv' id='m3_0103.csv_DFECFB17718A4819B318F673AF8CFAEC'>
- <properties context=''>
- <relation connection='textscan.0erpzzc0a7kcbg12etxg11nmdoos' name='m3_0103.csv' table='[m3_0103#csv]' type='table'>
- <columns character-set='UTF-8' header='yes' locale='ko_KR' separator=','>
- <column datatype='datetime' name='timestamp' ordinal='0' />
- <column datatype='real' name='hum' ordinal='1' />
- <column datatype='real' name='temp' ordinal='2' />
- <column datatype='real' name='door' ordinal='3' />
- <column datatype='real' name='motion' ordinal='4' />
- <column datatype='real' name='illum' ordinal='5' />
- </columns>
- </relation>
- </properties>
- </object>
- </objects>
- </_.fcp.ObjectModelEncapsulateLegacy.true...object-graph>
- </datasource>
- </datasources>
- <worksheets>
- <worksheet name='시트 1'>
- <table>
- <view>
- <datasources>
- <datasource caption='m3_0103' name='federated.1en4l9j0z5yqpt1fw8raf1kz99ys' />
- </datasources>
- <datasource-dependencies datasource='federated.1en4l9j0z5yqpt1fw8raf1kz99ys'>
- <column-instance column='[hum]' derivation='Avg' name='[avg:hum:qk]' pivot='key' type='quantitative' />
- <column-instance column='[illum]' derivation='Avg' name='[avg:illum:qk]' pivot='key' type='quantitative' />
- <column-instance column='[temp]' derivation='Avg' name='[avg:temp:qk]' pivot='key' type='quantitative' />
- <column caption='Door' datatype='real' name='[door]' role='measure' type='quantitative' />
- <column-instance column='[timestamp]' derivation='Day' name='[dy:timestamp:ok]' pivot='key' type='ordinal' />
- <column-instance column='[timestamp]' derivation='Hour' name='[hr:timestamp:ok]' pivot='key' type='ordinal' />
- <column caption='Hum' datatype='real' name='[hum]' role='measure' type='quantitative' />
- <column caption='Illum' datatype='real' name='[illum]' role='measure' type='quantitative' />
- <column-instance column='[timestamp]' derivation='Month' name='[mn:timestamp:ok]' pivot='key' type='ordinal' />
- <column caption='Motion' datatype='real' name='[motion]' role='measure' type='quantitative' />
- <column-instance column='[timestamp]' derivation='Quarter' name='[qr:timestamp:ok]' pivot='key' type='ordinal' />
- <column-instance column='[door]' derivation='Sum' name='[sum:door:qk]' pivot='key' type='quantitative' />
- <column-instance column='[motion]' derivation='Sum' name='[sum:motion:qk]' pivot='key' type='quantitative' />
- <column caption='Temp' datatype='real' name='[temp]' role='measure' type='quantitative' />
- <column caption='Timestamp' datatype='datetime' name='[timestamp]' role='dimension' type='ordinal' />
- <column-instance column='[timestamp]' derivation='Year' name='[yr:timestamp:ok]' pivot='key' type='ordinal' />
- </datasource-dependencies>
- <filter class='quantitative' column='[federated.1en4l9j0z5yqpt1fw8raf1kz99ys].[sum:motion:qk]' included-values='non-null' />
- <slices>
- <column>[federated.1en4l9j0z5yqpt1fw8raf1kz99ys].[sum:motion:qk]</column>
- </slices>
- <aggregation value='true' />
- </view>
- <style />
- <panes>
- <pane selection-relaxation-option='selection-relaxation-allow'>
- <view>
- <breakdown value='auto' />
- </view>
- <mark class='Automatic' />
- </pane>
- <pane id='2' selection-relaxation-option='selection-relaxation-allow' y-axis-name='[federated.1en4l9j0z5yqpt1fw8raf1kz99ys].[avg:hum:qk]'>
- <view>
- <breakdown value='auto' />
- </view>
- <mark class='Automatic' />
- </pane>
- <pane id='3' selection-relaxation-option='selection-relaxation-allow' y-axis-name='[federated.1en4l9j0z5yqpt1fw8raf1kz99ys].[avg:illum:qk]'>
- <view>
- <breakdown value='auto' />
- </view>
- <mark class='Automatic' />
- </pane>
- <pane id='5' selection-relaxation-option='selection-relaxation-allow' y-axis-name='[federated.1en4l9j0z5yqpt1fw8raf1kz99ys].[avg:temp:qk]'>
- <view>
- <breakdown value='auto' />
- </view>
- <mark class='Automatic' />
- </pane>
- <pane id='6' selection-relaxation-option='selection-relaxation-allow' y-axis-name='[federated.1en4l9j0z5yqpt1fw8raf1kz99ys].[sum:motion:qk]'>
- <view>
- <breakdown value='auto' />
- </view>
- <mark class='Automatic' />
- </pane>
- <pane id='7' selection-relaxation-option='selection-relaxation-allow' y-axis-name='[federated.1en4l9j0z5yqpt1fw8raf1kz99ys].[sum:door:qk]'>
- <view>
- <breakdown value='auto' />
- </view>
- <mark class='Automatic' />
- </pane>
- </panes>
- <rows>([federated.1en4l9j0z5yqpt1fw8raf1kz99ys].[avg:hum:qk] + ([federated.1en4l9j0z5yqpt1fw8raf1kz99ys].[avg:temp:qk] + ([federated.1en4l9j0z5yqpt1fw8raf1kz99ys].[avg:illum:qk] + ([federated.1en4l9j0z5yqpt1fw8raf1kz99ys].[sum:motion:qk] + [federated.1en4l9j0z5yqpt1fw8raf1kz99ys].[sum:door:qk]))))</rows>
- <cols>([federated.1en4l9j0z5yqpt1fw8raf1kz99ys].[yr:timestamp:ok] / ([federated.1en4l9j0z5yqpt1fw8raf1kz99ys].[qr:timestamp:ok] / ([federated.1en4l9j0z5yqpt1fw8raf1kz99ys].[mn:timestamp:ok] / ([federated.1en4l9j0z5yqpt1fw8raf1kz99ys].[dy:timestamp:ok] / [federated.1en4l9j0z5yqpt1fw8raf1kz99ys].[hr:timestamp:ok]))))</cols>
- </table>
- <simple-id uuid='{4A90872E-4A88-4F75-9E6E-8E5EE1648389}' />
- </worksheet>
- </worksheets>
- <windows source-height='30'>
- <window class='worksheet' maximized='true' name='시트 1'>
- <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='{BA70B236-50BE-4AAE-950A-8FDD2344AD27}' />
- </window>
- </windows>
- </workbook>
|