2124061437482410
<pack authentication='auth-none' author-locale='en_US' class='hyper' db-format='dataengine' dbname='Data/TableauTemp/0ub9dh4106vhhw12vjjnw0ahhpwx.tde' default-settings='yes' ec-abstract-query='&lt;aq-cache-key are-all-local-sorts-supported=&apos;true&apos; has-agg-measure-filters=&apos;false&apos; has-lod-calcs=&apos;false&apos; has-user-reference=&apos;false&apos; ind-join-semantics=&apos;false&apos; start-of-week=&apos;sunday&apos; version=&apos;18.1&apos;&gt;&#10;  &lt;query aggregation=&apos;true&apos; caching=&apos;normal&apos; hierarchize-rows=&apos;false&apos; include-empty=&apos;false&apos;&gt;&#10;    &lt;fields&gt;&#10;      &lt;field column=&apos;[excel-direct.01uepe41ltj00k147bmkc15szuyi].[Calculation_569986881335296000]&apos; /&gt;&#10;      &lt;field column=&apos;[excel-direct.01uepe41ltj00k147bmkc15szuyi].[Title]&apos; /&gt;&#10;      &lt;output column=&apos;[excel-direct.01uepe41ltj00k147bmkc15szuyi].[Calculation_569986881335296000]&apos; /&gt;&#10;      &lt;output column=&apos;[excel-direct.01uepe41ltj00k147bmkc15szuyi].[Title]&apos; /&gt;&#10;      &lt;output column=&apos;[excel-direct.01uepe41ltj00k147bmkc15szuyi].[avg:Calculation_285697154918600705:ok]&apos; /&gt;&#10;      &lt;output column=&apos;[excel-direct.01uepe41ltj00k147bmkc15szuyi].[avg:Salary Estimate:ok]&apos; /&gt;&#10;      &lt;output column=&apos;[excel-direct.01uepe41ltj00k147bmkc15szuyi].[cnt:Calculation_285697154918600705:ok]&apos; /&gt;&#10;      &lt;output column=&apos;[excel-direct.01uepe41ltj00k147bmkc15szuyi].[cnt:Salary Estimate:ok]&apos; /&gt;&#10;      &lt;output column=&apos;[excel-direct.01uepe41ltj00k147bmkc15szuyi].[sum:Calculation_285697154918600705:ok]&apos; /&gt;&#10;      &lt;output column=&apos;[excel-direct.01uepe41ltj00k147bmkc15szuyi].[sum:Number of Records:ok]&apos; /&gt;&#10;      &lt;output column=&apos;[excel-direct.01uepe41ltj00k147bmkc15szuyi].[sum:Salary Estimate:ok]&apos; /&gt;&#10;    &lt;/fields&gt;&#10;  &lt;/query&gt;&#10;  &lt;context-stack&gt;&#10;    &lt;context&gt;&#10;      &lt;filter class=&apos;categorical&apos; column=&apos;[excel-direct.01uepe41ltj00k147bmkc15szuyi].[Action (Position Level)]&apos; context=&apos;true&apos;&gt;&#10;        &lt;groupfilter function=&apos;member&apos; level=&apos;[Calculation_569986881339281409]&apos; member=&apos;&amp;quot;Unknown&amp;quot;&apos; user:ui-action-filter=&apos;[Action1]&apos; user:ui-domain=&apos;relevant&apos; user:ui-enumeration=&apos;inclusive&apos; user:ui-marker=&apos;enumerate&apos; /&gt;&#10;      &lt;/filter&gt;&#10;    &lt;/context&gt;&#10;  &lt;/context-stack&gt;&#10;  &lt;relation-xml&gt;&amp;lt;relation name=&amp;apos;Extract&amp;apos; table=&amp;apos;[Extract].[Extract]&amp;apos; type=&amp;apos;table&amp;apos; /&amp;gt;&amp;#10;&lt;/relation-xml&gt;&#10;  &lt;relation-names&gt;&#10;    &lt;relation-name key=&apos;[Agile]&apos; value=&apos;[Extract].[Agile]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Calculation_285697154918600705]&apos; value=&apos;[Extract].[Calculation_285697154918600705]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Calculation_569986881335296000]&apos; value=&apos;[Extract].[Calculation_569986881335296000]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Calculation_569986881339281409]&apos; value=&apos;[Extract].[Calculation_569986881339281409]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Company]&apos; value=&apos;[Extract].[Company]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[DB2]&apos; value=&apos;[Extract].[DB2]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[ETL]&apos; value=&apos;[Extract].[ETL]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Excel]&apos; value=&apos;[Extract].[Excel]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Hadoop]&apos; value=&apos;[Extract].[Hadoop]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Location - Split 1]&apos; value=&apos;[Extract].[Location - Split 1]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Location - Split 2]&apos; value=&apos;[Extract].[Location - Split 2]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Location]&apos; value=&apos;[Extract].[Location]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Matlab]&apos; value=&apos;[Extract].[Matlab]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Number of Records]&apos; value=&apos;[Extract].[Number of Records]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Oracle]&apos; value=&apos;[Extract].[Oracle]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Posted Salary]&apos; value=&apos;[Extract].[Posted Salary]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[PowerPoint]&apos; value=&apos;[Extract].[PowerPoint]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Python]&apos; value=&apos;[Extract].[Python]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Qlik]&apos; value=&apos;[Extract].[Qlik]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[SAS]&apos; value=&apos;[Extract].[SAS]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[SQL Server]&apos; value=&apos;[Extract].[SQL Server]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[SQL]&apos; value=&apos;[Extract].[SQL]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[SSRS]&apos; value=&apos;[Extract].[SSRS]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Salary Estimate]&apos; value=&apos;[Extract].[Salary Estimate]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Salary Per Year Max]&apos; value=&apos;[Extract].[Salary Per Year Max]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Salary Per Year Min]&apos; value=&apos;[Extract].[Salary Per Year Min]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[SearchURL]&apos; value=&apos;[Extract].[SearchURL]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[State (group) 1]&apos; value=&apos;[Extract].[State (group) 1]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[State (group)]&apos; value=&apos;[Extract].[State (group)]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Statistics]&apos; value=&apos;[Extract].[Statistics]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Teradata]&apos; value=&apos;[Extract].[Teradata]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[Title]&apos; value=&apos;[Extract].[Title]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[URL]&apos; value=&apos;[Extract].[URL]&apos; /&gt;&#10;    &lt;relation-name key=&apos;[jobDesc]&apos; value=&apos;[Extract].[jobDesc]&apos; /&gt;&#10;  &lt;/relation-names&gt;&#10;  &lt;bindings&gt;&#10;    &lt;binding key=&apos;[Calculation_569986881335296000]&apos; value=&apos;Calculation_569986881335296000&apos; /&gt;&#10;    &lt;binding key=&apos;[Title]&apos; value=&apos;Title&apos; /&gt;&#10;    &lt;binding key=&apos;[avg:Calculation_285697154918600705:ok]&apos; value=&apos;avg:Calculation_285697154918600705:ok&apos; /&gt;&#10;    &lt;binding key=&apos;[avg:Salary Estimate:ok]&apos; value=&apos;avg:Salary Estimate:ok&apos; /&gt;&#10;    &lt;binding key=&apos;[cnt:Calculation_285697154918600705:ok]&apos; value=&apos;cnt:Calculation_285697154918600705:ok&apos; /&gt;&#10;    &lt;binding key=&apos;[cnt:Salary Estimate:ok]&apos; value=&apos;cnt:Salary Estimate:ok&apos; /&gt;&#10;    &lt;binding key=&apos;[sum:Calculation_285697154918600705:ok]&apos; value=&apos;sum:Calculation_285697154918600705:ok&apos; /&gt;&#10;    &lt;binding key=&apos;[sum:Number of Records:ok]&apos; value=&apos;sum:Number of Records:ok&apos; /&gt;&#10;    &lt;binding key=&apos;[sum:Salary Estimate:ok]&apos; value=&apos;sum:Salary Estimate:ok&apos; /&gt;&#10;  &lt;/bindings&gt;&#10;  &lt;lod&gt;&#10;    &lt;column&gt;[excel-direct.01uepe41ltj00k147bmkc15szuyi].[Calculation_569986881335296000]&lt;/column&gt;&#10;    &lt;column&gt;[excel-direct.01uepe41ltj00k147bmkc15szuyi].[Title]&lt;/column&gt;&#10;  &lt;/lod&gt;&#10;  &lt;measure-filter-lod&gt;&#10;    &lt;column&gt;[excel-direct.01uepe41ltj00k147bmkc15szuyi].[Calculation_569986881335296000]&lt;/column&gt;&#10;    &lt;column&gt;[excel-direct.01uepe41ltj00k147bmkc15szuyi].[Title]&lt;/column&gt;&#10;  &lt;/measure-filter-lod&gt;&#10;  &lt;output&gt;&#10;    &lt;column&gt;[excel-direct.01uepe41ltj00k147bmkc15szuyi].[Calculation_569986881335296000]&lt;/column&gt;&#10;    &lt;column&gt;[excel-direct.01uepe41ltj00k147bmkc15szuyi].[Title]&lt;/column&gt;&#10;    &lt;column&gt;[excel-direct.01uepe41ltj00k147bmkc15szuyi].[avg:Calculation_285697154918600705:ok]&lt;/column&gt;&#10;    &lt;column&gt;[excel-direct.01uepe41ltj00k147bmkc15szuyi].[avg:Salary Estimate:ok]&lt;/column&gt;&#10;    &lt;column&gt;[excel-direct.01uepe41ltj00k147bmkc15szuyi].[cnt:Calculation_285697154918600705:ok]&lt;/column&gt;&#10;    &lt;column&gt;[excel-direct.01uepe41ltj00k147bmkc15szuyi].[cnt:Salary Estimate:ok]&lt;/column&gt;&#10;    &lt;column&gt;[excel-direct.01uepe41ltj00k147bmkc15szuyi].[sum:Calculation_285697154918600705:ok]&lt;/column&gt;&#10;    &lt;column&gt;[excel-direct.01uepe41ltj00k147bmkc15szuyi].[sum:Number of Records:ok]&lt;/column&gt;&#10;    &lt;column&gt;[excel-direct.01uepe41ltj00k147bmkc15szuyi].[sum:Salary Estimate:ok]&lt;/column&gt;&#10;  &lt;/output&gt;&#10;  &lt;aggregates /&gt;&#10;  &lt;slicers /&gt;&#10;  &lt;filtered /&gt;&#10;  &lt;local-filters /&gt;&#10;  &lt;unnamed-calcs /&gt;&#10;  &lt;calculations&gt;&#10;    &lt;calculation column=&apos;[excel-direct.01uepe41ltj00k147bmkc15szuyi].[Action (Position Level)]&apos; formula=&apos;&amp;lt;?xml version=&amp;apos;1.0&amp;apos; encoding=&amp;apos;utf-8&amp;apos; ?&amp;gt;&amp;#10;&amp;#10;&amp;lt;groupfilter function=&amp;apos;crossjoin&amp;apos;&amp;gt;&amp;#10;  &amp;lt;groupfilter function=&amp;apos;level-members&amp;apos; level=&amp;apos;[Calculation_569986881339281409]&amp;apos; /&amp;gt;&amp;#10;&amp;lt;/groupfilter&amp;gt;&amp;#10;&apos; /&gt;&#10;    &lt;calculation column=&apos;[excel-direct.01uepe41ltj00k147bmkc15szuyi].[Calculation_285697154918600705]&apos; formula=&apos;if not isnull([Salary Estimate]) then 1 else 0 end&apos; /&gt;&#10;    &lt;calculation column=&apos;[excel-direct.01uepe41ltj00k147bmkc15szuyi].[Calculation_569986881335296000]&apos; formula=&apos;if contains(lower(lower([Title])),&amp;quot;manager&amp;quot;) then &amp;quot;Manager&amp;quot;&amp;#13;&amp;#10;elseif contains(lower(lower([Title])),&amp;quot;data scientist&amp;quot;) then &amp;quot;Data Scientist&amp;quot;&amp;#13;&amp;#10;elseif contains(lower(lower([Title])),&amp;quot;architect&amp;quot;) then &amp;quot;Architect&amp;quot;&amp;#13;&amp;#10;elseif contains(lower(lower([Title])),&amp;quot;bi &amp;quot;) or contains(lower(lower([Title])),&amp;quot;business intelligence&amp;quot;) then &amp;quot;Business Intelligence&amp;quot;&amp;#13;&amp;#10;elseif contains(lower([Title]),&amp;quot;developer&amp;quot;) then &amp;quot;Developer&amp;quot;&amp;#13;&amp;#10;elseif contains(lower([Title]),&amp;quot;consultant&amp;quot;) then &amp;quot;Consultant&amp;quot;&amp;#13;&amp;#10;elseif contains(lower([Title]),&amp;quot;engineer&amp;quot;) then &amp;quot;Engineer&amp;quot;&amp;#13;&amp;#10;elseif contains(lower([Title]),&amp;quot;administrator&amp;quot;) or contains(lower([Title]),&amp;quot;dba&amp;quot;) then &amp;quot;Administrator&amp;quot;&amp;#13;&amp;#10;elseif contains(lower([Title]),&amp;quot;analyst&amp;quot;)&amp;#13;&amp;#10;        or contains(lower([Title]),&amp;quot;analysis&amp;quot;)&amp;#13;&amp;#10;        or contains(lower([Title]),&amp;quot;analytic&amp;quot;) then &amp;quot;Data or Business Analyst&amp;quot;&amp;#13;&amp;#10;else &amp;quot;Other&amp;quot;&amp;#13;&amp;#10;END&apos; /&gt;&#10;    &lt;calculation column=&apos;[excel-direct.01uepe41ltj00k147bmkc15szuyi].[Calculation_569986881339281409]&apos; formula=&apos;if contains([Title],&amp;quot;Director&amp;quot;) then &amp;quot;Director&amp;quot;&amp;#13;&amp;#10;elseif contains([Title],&amp;quot;Manager&amp;quot;) then &amp;quot;Manager&amp;quot;&amp;#13;&amp;#10;elseif contains([Title],&amp;quot;Lead&amp;quot;) then &amp;quot;Lead&amp;quot;&amp;#13;&amp;#10;elseif contains([Title],&amp;quot;Senior&amp;quot;) or contains([Title],&amp;quot;Sr&amp;quot;) then &amp;quot;Senior&amp;quot;&amp;#13;&amp;#10;elseif contains([Title],&amp;quot;Entry&amp;quot;) or contains([Title],&amp;quot;Junior&amp;quot;) then &amp;quot;Entry or Junior&amp;quot;&amp;#13;&amp;#10;else &amp;quot;Unknown&amp;quot;&amp;#13;&amp;#10;END&apos; /&gt;&#10;    &lt;calculation column=&apos;[excel-direct.01uepe41ltj00k147bmkc15szuyi].[Number of Records]&apos; formula=&apos;1&apos; /&gt;&#10;    &lt;calculation column=&apos;[excel-direct.01uepe41ltj00k147bmkc15szuyi].[Salary Estimate]&apos; formula=&apos;&apos; /&gt;&#10;    &lt;calculation column=&apos;[excel-direct.01uepe41ltj00k147bmkc15szuyi].[Title]&apos; formula=&apos;&apos; /&gt;&#10;    &lt;calculation column=&apos;[excel-direct.01uepe41ltj00k147bmkc15szuyi].[avg:Calculation_285697154918600705:ok]&apos; formula=&apos;AVG([Calculation_285697154918600705])&apos; /&gt;&#10;    &lt;calculation column=&apos;[excel-direct.01uepe41ltj00k147bmkc15szuyi].[avg:Salary Estimate:ok]&apos; formula=&apos;AVG([Salary Estimate])&apos; /&gt;&#10;    &lt;calculation column=&apos;[excel-direct.01uepe41ltj00k147bmkc15szuyi].[cnt:Calculation_285697154918600705:ok]&apos; formula=&apos;COUNT([Calculation_285697154918600705])&apos; /&gt;&#10;    &lt;calculation column=&apos;[excel-direct.01uepe41ltj00k147bmkc15szuyi].[cnt:Salary Estimate:ok]&apos; formula=&apos;COUNT([Salary Estimate])&apos; /&gt;&#10;    &lt;calculation column=&apos;[excel-direct.01uepe41ltj00k147bmkc15szuyi].[sum:Calculation_285697154918600705:ok]&apos; formula=&apos;SUM([Calculation_285697154918600705])&apos; /&gt;&#10;    &lt;calculation column=&apos;[excel-direct.01uepe41ltj00k147bmkc15szuyi].[sum:Number of Records:ok]&apos; formula=&apos;SUM([Number of Records])&apos; /&gt;&#10;    &lt;calculation column=&apos;[excel-direct.01uepe41ltj00k147bmkc15szuyi].[sum:Salary Estimate:ok]&apos; formula=&apos;SUM([Salary Estimate])&apos; /&gt;&#10;  &lt;/calculations&gt;&#10;  &lt;agg-types&gt;&#10;    &lt;agg-type column=&apos;[excel-direct.01uepe41ltj00k147bmkc15szuyi].[Calculation_569986881335296000]&apos; type=&apos;None&apos; /&gt;&#10;    &lt;agg-type column=&apos;[excel-direct.01uepe41ltj00k147bmkc15szuyi].[Title]&apos; type=&apos;None&apos; /&gt;&#10;    &lt;agg-type column=&apos;[excel-direct.01uepe41ltj00k147bmkc15szuyi].[avg:Calculation_285697154918600705:ok]&apos; type=&apos;Avg&apos; /&gt;&#10;    &lt;agg-type column=&apos;[excel-direct.01uepe41ltj00k147bmkc15szuyi].[avg:Salary Estimate:ok]&apos; type=&apos;Avg&apos; /&gt;&#10;    &lt;agg-type column=&apos;[excel-direct.01uepe41ltj00k147bmkc15szuyi].[cnt:Calculation_285697154918600705:ok]&apos; type=&apos;Count&apos; /&gt;&#10;    &lt;agg-type column=&apos;[excel-direct.01uepe41ltj00k147bmkc15szuyi].[cnt:Salary Estimate:ok]&apos; type=&apos;Count&apos; /&gt;&#10;    &lt;agg-type column=&apos;[excel-direct.01uepe41ltj00k147bmkc15szuyi].[sum:Calculation_285697154918600705:ok]&apos; type=&apos;Sum&apos; /&gt;&#10;    &lt;agg-type column=&apos;[excel-direct.01uepe41ltj00k147bmkc15szuyi].[sum:Number of Records:ok]&apos; type=&apos;Sum&apos; /&gt;&#10;    &lt;agg-type column=&apos;[excel-direct.01uepe41ltj00k147bmkc15szuyi].[sum:Salary Estimate:ok]&apos; type=&apos;Sum&apos; /&gt;&#10;  &lt;/agg-types&gt;&#10;  &lt;data-types&gt;&#10;    &lt;data-type column=&apos;[excel-direct.01uepe41ltj00k147bmkc15szuyi].[Action (Position Level)]&apos; type=&apos;tuple&apos; /&gt;&#10;    &lt;data-type column=&apos;[excel-direct.01uepe41ltj00k147bmkc15szuyi].[Calculation_285697154918600705]&apos; type=&apos;integer&apos; /&gt;&#10;    &lt;data-type column=&apos;[excel-direct.01uepe41ltj00k147bmkc15szuyi].[Calculation_569986881335296000]&apos; type=&apos;string&apos; /&gt;&#10;    &lt;data-type column=&apos;[excel-direct.01uepe41ltj00k147bmkc15szuyi].[Calculation_569986881339281409]&apos; type=&apos;string&apos; /&gt;&#10;    &lt;data-type column=&apos;[excel-direct.01uepe41ltj00k147bmkc15szuyi].[Number of Records]&apos; type=&apos;integer&apos; /&gt;&#10;    &lt;data-type column=&apos;[excel-direct.01uepe41ltj00k147bmkc15szuyi].[Salary Estimate]&apos; type=&apos;real&apos; /&gt;&#10;    &lt;data-type column=&apos;[excel-direct.01uepe41ltj00k147bmkc15szuyi].[Title]&apos; type=&apos;string&apos; /&gt;&#10;    &lt;data-type column=&apos;[excel-direct.01uepe41ltj00k147bmkc15szuyi].[avg:Calculation_285697154918600705:ok]&apos; type=&apos;real&apos; /&gt;&#10;    &lt;data-type column=&apos;[excel-direct.01uepe41ltj00k147bmkc15szuyi].[avg:Salary Estimate:ok]&apos; type=&apos;real&apos; /&gt;&#10;    &lt;data-type column=&apos;[excel-direct.01uepe41ltj00k147bmkc15szuyi].[cnt:Calculation_285697154918600705:ok]&apos; type=&apos;integer&apos; /&gt;&#10;    &lt;data-type column=&apos;[excel-direct.01uepe41ltj00k147bmkc15szuyi].[cnt:Salary Estimate:ok]&apos; type=&apos;integer&apos; /&gt;&#10;    &lt;data-type column=&apos;[excel-direct.01uepe41ltj00k147bmkc15szuyi].[sum:Calculation_285697154918600705:ok]&apos; type=&apos;integer&apos; /&gt;&#10;    &lt;data-type column=&apos;[excel-direct.01uepe41ltj00k147bmkc15szuyi].[sum:Number of Records:ok]&apos; type=&apos;integer&apos; /&gt;&#10;    &lt;data-type column=&apos;[excel-direct.01uepe41ltj00k147bmkc15szuyi].[sum:Salary Estimate:ok]&apos; type=&apos;real&apos; /&gt;&#10;  &lt;/data-types&gt;&#10;  &lt;current-user display-name=&apos;&apos; name=&apos;&apos; short-domain-qualified-name=&apos;&apos; type=&apos;user&apos; /&gt;&#10;&lt;/aq-cache-key&gt;&#10;' ec-data-ts='2124061524340000' sslmode='' updated-database='C:\Users\LUKASH~1\AppData\Local\Temp\TableauTemp\126010590\Data\TableauTemp\#TableauTemp_0yn41tw1cn021h1ert8041xfcxoo.tde' username='tableau_internal_user'>
</pack>
