<?xml version="1.0"?>
<AlteryxDocument yxmdVer="2021.3">
<Nodes>
<Node ToolID="182">
<GuiSettings Plugin="AlteryxGuiToolkit.TextBox.TextBox">
<Position x="570" y="702" width="100" height="304" />
</GuiSettings>
<Properties>
<Configuration>
<Text>Sorting Based on Popularity and Revenue (for the last one)</Text>
<Font name="Arial" size="8.25" style="0" />
<TextColor name="White" />
<FillColor r="0" g="128" b="192" />
<Shape shape="0" />
<Justification Justification="4" />
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText />
<Left value="False" />
</Annotation>
</Properties>
</Node>
<Node ToolID="8">
<GuiSettings Plugin="AlteryxGuiToolkit.TextBox.TextBox">
<Position x="54" y="138" width="876" height="444" />
</GuiSettings>
<Properties>
<Configuration>
<Text><![CDATA[
Welcome to Hollywood!
Your production company just signed a contract to work with a very successful director on her next film. You met her for lunch to talk about the movie and took notes.
Use the dataset and your notes to figure out who the best choices are for the top three actors to cast in the movie, the ideal film location, and the expected revenue of the movie.
Notes
- Who is the most popular actor in the comedy that generated the most revenue?
- Who is the most popular actor in the action movie that generated the most revenue?
- Which actor appeared in the comedy or action movie that generated the most revenue? This will also give you the ideal film location.
- What is the expected revenue of this movie based on the average revenue of the last movie each of the three actors worked on?
Hints
- To be in this movie, the actor must have a diva score.
- The lower the diva score, the easier the actor is to work with.
- The higher the diva score, the more difficult the actor is to work with.
]]></Text>
<Font name="Microsoft Sans Serif" size="12" style="0" />
<TextColor name="Gray" />
<FillColor name="White" />
<Shape shape="0" />
<Justification Justification="0" />
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText />
<Left value="False" />
</Annotation>
</Properties>
</Node>
<Node ToolID="62">
<GuiSettings Plugin="AlteryxGuiToolkit.TextBox.TextBox">
<Position x="54" y="54" width="324" height="72" />
</GuiSettings>
<Properties>
<Configuration>
<Text />
<Font name="Segoe UI" size="8.25" style="0" />
<TextColor name="Black" />
<FillColor name="White" />
<Shape shape="3" />
<Justification Justification="4" />
<BG_Image>iVBORw0KGgoAAAANSUhEUgAAAXoAAAA0CAIAAAAL52RvAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAAScQAAEnEB89x6jgAAABJ0RVh0U29mdHdhcmUAR3JlZW5zaG90XlUIBQAADRxJREFUeF7tnd+OFccRh/0GzhvEb4DfwH4D+w3sN0jewFxxhxIpcGEJCS4s+WKJsYR9w14kYq8WIWE2CgqKMVqL4FUQ8kIisCVL5NtTvZXa6j/TZ2fm7J51fWqNTtdU93QPU7+pnjNneetNEATBSgi5CYJgRYTcBEGwIk5Gbv7y5D83Hu2nSrAOPHny5O7du7u7u6keBMuzarl5/OLn97/49q0/fUNJpmAdCLkJxrNSubn37NVvPv2baM2ycvPjT7+c395DqhCsZApWSMhNMJ6Vys0n2z+o1iwlN1anWIgla7BCQm6C8ayH3Lz96Y62Crk5EUJugvGsh9zYViE3J0LITTCekJugi5CbYDwhN0EXITfBeEJugi5CboLxhNwEXYTcBOMZkJsff/rlj988+3jz+/e/+Na+MkN59/OH2Nl779mr5D3EycoN4zy/vff72/9iLmz5/OWjF2lfMETITTCeAbn54KvvbKjXyjvXHhDAgy/gLSU3f7j3b3SBgq7ZVmgcSmHLoABdffDcaaUW7PSAqibXEuz965P/Skmmxe8wRLlEvJJ1AbvUv92zok2sdvNZ+0mmCnaEM70GGXITjGdAbj7a3HXx2SiEbmpWYSm5sZ7t8t6f/5naZBCHTq2KBZ+GLljNRQTxRGLUIiW5LrB2TmCy1kEN1f+31/6erEffNvrd7SfJmuHm2HPEYxByE4xnQG6463LRE8+EHGJhCxYbD1LaiQatrHOyVrCe7dKQm3Of/yN3luLsRGxqk2GdmXWeKLkBWHkalGCwg+QUJesiv1M7pXZuUSLrttbZzf7+PocAPiRTk9evX4s/JFOdTjdFBsMhUn3Bsp3s7e25TsTCNtVLFH0GW4GM2Z09LNYo1R7Ef0LGPip2CjKh3ORKUSs2RC3ucFRtCsNnF6i1fnJtcsUlFDce7du97d++ow7W2YmFPQmsWPMUjBOuDpTaFMYzq9wQCTdv3rx8+fIFA9XNzU0X7QLGra2tK1euJNdDsOzs7CSnDPG5detWqjd5+PCh+Lspi5HRpnqT27dvi7/t5LPPPsPCNtVLFH0WPV24f/9+qpeQI7JN9QXSUI1S7UFOwsWLFxsyxy5xvnPnTjLVGSs37nKfUG6UpQ6huDAmU0g7jmIVh3hO1qPkckNah8QwknvPXrHNVYA1kTq3Vzc2hXFZEtC/7qW4JRXHZcy6F21KO2ZgPrkhfuR6LcK1zkWfXBdwfWNMuxcQltaC6BTDI+2+cGEwR4BLly6Jc1FuYPBUoIk6qgnlph3808oNzoOjHXSwnFm5sTpiH4g4iFh1oxQ7d3JDVNsHukVc3pTrkWKF6eqD58lqcCfNjtAdZXBUY5hJbrglLi7sA4gHG0gciyQC+8bGRjId1Rr2Wn9SJHqQvcWYlFYwGBtWAWtyM9iJRL4wodwAelpM+kAOqsoiSCtnVBibOBT/cTmrsreYVemJaiig5czKjX2uVEttBKsmjDBZDdaBbnui2uVWRR0Bm7zQc02Viksqd1qKI5+QOeSGa1Qu1sYdG7sNLV1AuZRHwV8UB89kOgSjSlVjIpqVSILjPBetUz+NdU2jk5FyI93WVnOTyw1In6xtncbpHDvXp3A25ebYo/rgq++S1WDlJl/v1LAaUewWbHrSWHO56ciSyvZPitRIoCZhDrmRoILOe6PeS2uRI2j8ODkQI7HBluBJ1gyJLtxkeG7KB10sBsC20YnkZWzzTopS4ij6YAE9CUWxk4G58yP+tZOmp6vxjyui6XqQY6E4ToYanE25cd/pJGsFO6qimhxPbuzX25SiHNgUrD0vt2768OvHttpzTkYyudxoll67UedIatNzfTfCVe/JxXCVvXII6aQoN9pJMYZlajjwIe+kODZH0QcL8EG0DHKZFglwoxLn4lChR27UhxmJRf/5amlmkbMpN2QKtkmyVphJbtAXbUXJ11P2C6zG0yWB3uxTHlsk2ZmbyeVG79Kd1ysRLv498qSPhFJ9gVoat2WJZInMXCngoItFJzL+Y3RSlBJH0QcL8IEjivLmCxyZmlOWRbtRcgMbGxv4XL9+Xao9s8jpkhuu9S8fvTi/vcdNVd6j1eJeojslcmMFguLG7Ir9cmdCuQGrehwoWQ+xe3skw50HKStYRgmTy40EBnSupDQqamFjKYaQWORzcXUgd2x2SQxLRLkpH3RxtBP35EJTm1onPYFa9MEC8lkfUWn8C3JW3bwW7cbKDfOSI+KmTTTZ6WRAbh6/+Pnjze/dJd4op1Nu+su0cuNewLHv1Ljcx71uU8MtqSgr+w8t5pObVB9CL/Fa2FjU2Q5YLPJZcxMbMHID10VWrhRw0MVhJ3oU24m00pdQ8k6KUuIo+mCBVKk8yZKz6k5R7mYpnqsikjMyKhlezz+EoyU35P+1nxrVyhxy4x6CzCo3xee1x5YbsCsg+wWZndS57vdlnPL2vLI8FfPJTecdUqOi5yovhpBYUuUwpHVpJk1IWKQK4uCmfNBF1ommGD2diIVtqpco+mCBVFkgj71B+5ez6k6R+NTOm4wZ3EyL6DeDmgMuRVVuuN86rSEq0AsKd1Suey3Wh2pqX+J4cuNatQ8hWIFg2DrUwZLaH2WM3NjB299J2D7zxzo1mIu2kkL/ad/MzCc3nX2yfBD/HrmR12HBaplYUsWEmazmarrghrdo8f9OdFTiJk00P4Jat2xTvUTRBwukyiHu8fnccqMndqknxEpVbuwPf9ovm6gbpRaxwonIzfgUYIzcuBdwZNHkjJ0PX9x50DLr233K5HKjF26PfAjyrCR/oSZHbvs2y4DF0Y6Eq6yeiGpZmLjwlph3Uz7o4mgn8mAYZ4nbwU70oKleQlo5HyyQKoegp/JIRU7L3HKzlHNOVW7sBd1+Tc56nkK5oSTrcRkjN2Cby5m039M3Xrex2BcCXWn8uHRCJpcbkDhpvL3ikMAevNa5z0vPulASpG2qLCBWxSj+7qF1rhSwcPed6ETYOv+8E1EEmqR6CRHWomqkikGFG5FdS7khpO0F3Y7wfs+VyY1rMvK7m5FyYx/TyM+y7Jqo81mvbUKy6V4sYr7JbzbmkBuJDahFgkPVgTt548GBqpJdSYEYU+UQffzhtAk65QZ0Ii4fgbwTXX/ZNZdFQ9rJnxhT5Sg6C1lbrbfcJGsF67mU3BxvEdEjN278/Q9HioyUG6ZpX+ez6jP4uo3gxEVSJDsqytxLqjnkRtMQqP2emECyQqCBTVw5NQE6vH79ujjkHYo9VQ6RMUDeW7/cLNuJGPHPzycSg529uXIdHLgiNyB9CustN+0I7/c8hnCAC7aedMB9zZy/87IUI+UG3GuHWnpet3HP7HUA2K2Kzb2kmkNuQKMLWIygERxC4LMsT1wYa/ICiMvW1harCbbYtas8VQHZlSoGxAJSxdAvN7BUJ0xHh8oUdnZ2FjPe3dzcFCN7XWoDsitVMji69rlmcuOeFDSyA/fUs60g9sZO6Xxs4bSvs5WL8DEJzni5cVPQIk+O29ijoy+2STHrmYmZ5AaIK1kCFCFc88BjGSJPN3Kw1xYp4pAqHSwlNzWKnUBj1kwhnzLI3lQpoVqwZnID9s75zrUHeWAgSfkbgNxj5e8Hk1DkEZ4/78RTeiYfkReX80WBUzSK/l1ktv2tcCsu3xqHFsbLDeQ/QTjX8bqNE5T8GY0dG0mQnJY5mE9uBDIUUhKCk1s08cYHllHtw9GEENrY2MCZLZ+xpH0lcINU6YAB4O8if5JOFJSRkYvuMGs+17QSeg7NGcg7kYa1nhmbONQGaVnKOacqN/kLrCiI/AcGH3792L74XyvFb6BrP/zRMvib7GIpLiXc2k0KnjIR+UGGnUhtPTKJ3OSDGUy40A67jCrKk1PVkcvGBnPLTfBroCo33PMHpYGCT0ML8nyhtqzQUhSpPC3KS3I9Su2hSa0U059J5CbPtorHsrgTW0u+nJDNtKQKuQnGU5Ub4PrOX2O1hQyImCGQ7MpLi3vQoHBXL/pLqf1pmBuP9hutGguTPE1rlOKAJ5EbsP0MPoFyz7nQlLSjhP1nmmlJFXITjKclNwLXPRKgmQ4xT9hwC7U3Zz4TP+rD1U+QNy56/OmBbulKOqQQUbUbuFBsxYEGv6tiJAyvoVaMvDFgBiZt2Q6ugBowcj3i4JiZqUxQ5pisFThv6kxpn8bjEXITjGdYbs4SxCFxjnxIIaRZ3M2RC+RwFNUaZCtZ14eQm2A8vy65OUHsmm4wWzmFhNwE4wm5WQUsA+13TKvJp6Yl5CYYT8jNKmDhplrz3oiHzSdIyE0wnpCb2bn37JVNbdovXp9aQm6C8YTczAhrqPPbe1Zr1jS1gZCbYDwhNxODoCAr7x79i/FS3q7/x3Wnn5CbYDwhNxPjJEYLWjPH6zArI+QmGE/IzcQ4lZHy0ebu+uY1QshNMJ6Qm4nR957ZfrL9w9UHz9fxa++cly9fPn36NP/zUUHQT8hNEAQrIuQmCIIVEXITBMFKePPmf4GyDTAL6GK4AAAAAElFTkSuQmCC</BG_Image>
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText />
<Left value="False" />
</Annotation>
</Properties>
</Node>
<Node ToolID="63">
<GuiSettings Plugin="AlteryxGuiToolkit.TextBox.TextBox">
<Position x="750" y="66" width="180" height="40" />
</GuiSettings>
<Properties>
<Configuration>
<Text>Challenge #335</Text>
<Font name="Microsoft Sans Serif" size="16.2" style="0" />
<TextColor name="Gray" />
<FillColor name="White" />
<Shape shape="3" />
<Justification Justification="2" />
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText />
<Left value="False" />
</Annotation>
</Properties>
</Node>
<Node ToolID="72">
<GuiSettings Plugin="AlteryxGuiToolkit.TextBox.TextBox">
<Position x="54" y="606" width="204" height="132" />
</GuiSettings>
<Properties>
<Configuration>
<Text>Input</Text>
<Font name="Arial" size="8.25" style="0" />
<TextColor name="Black" />
<FillColor name="White" />
<Shape shape="0" />
<Justification Justification="4" />
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText />
<Left value="False" />
</Annotation>
</Properties>
</Node>
<Node ToolID="121">
<GuiSettings Plugin="AlteryxBasePluginsGui.BrowseV2.BrowseV2">
<Position x="186" y="642" />
</GuiSettings>
<Properties>
<Configuration>
<TempFile>C:\Users\ma1025\AppData\Local\Temp\1\Engine2_16852_713ce2766f950448adaf9208c5957c62_\Engine_16852_f3505f4a57826a42956a5f01a3085b87~.yxdb</TempFile>
<TempFileDataProfiling />
<Layout>
<ViewMode>Single</ViewMode>
<ViewSize value="100" />
<View1>
<DefaultTab>Profile</DefaultTab>
<Hints>
<Table />
</Hints>
</View1>
<View2 />
</Layout>
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText />
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxBrowseV2" />
</Node>
<Node ToolID="130">
<GuiSettings Plugin="AlteryxBasePluginsGui.DbFileInput.DbFileInput">
<Position x="66" y="642" />
</GuiSettings>
<Properties>
<Configuration>
<Passwords />
<File OutputFileName="" FileFormat="19" SearchSubDirs="False" RecordLimit="">Input335.yxdb</File>
<FormatSpecificOptions />
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText>Input335.yxdb</DefaultAnnotationText>
<Left value="False" />
</Annotation>
<MetaInfo connection="Output">
<RecordInfo>
<Field name="Actor Popularity" size="254" source="File: C:\Users\marie.couperier\OneDrive - alteryx.com\Weekly Challenge - GRP_Instructional Designers\_Week Challenges blitz June 2022\Beth\Movie Decisions\Hollywood database revbeth.csv" type="V_String" />
<Field name="Actor" size="254" source="File: C:\Users\marie.couperier\OneDrive - alteryx.com\Weekly Challenge - GRP_Instructional Designers\_Week Challenges blitz June 2022\Beth\Movie Decisions\Hollywood database revbeth.csv" type="V_String" />
<Field name="Genre" size="254" source="File: C:\Users\marie.couperier\OneDrive - alteryx.com\Weekly Challenge - GRP_Instructional Designers\_Week Challenges blitz June 2022\Beth\Movie Decisions\Hollywood database revbeth.csv" type="V_String" />
<Field name="Film Location" size="254" source="File: C:\Users\marie.couperier\OneDrive - alteryx.com\Weekly Challenge - GRP_Instructional Designers\_Week Challenges blitz June 2022\Beth\Movie Decisions\Hollywood database revbeth.csv" type="V_String" />
<Field name="Revenue" size="254" source="File: C:\Users\marie.couperier\OneDrive - alteryx.com\Weekly Challenge - GRP_Instructional Designers\_Week Challenges blitz June 2022\Beth\Movie Decisions\Hollywood database revbeth.csv" type="V_String" />
<Field name="Diva Score" size="254" source="File: C:\Users\marie.couperier\OneDrive - alteryx.com\Weekly Challenge - GRP_Instructional Designers\_Week Challenges blitz June 2022\Beth\Movie Decisions\Hollywood database revbeth.csv" type="V_String" />
</RecordInfo>
</MetaInfo>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxDbFileInput" />
</Node>
<Node ToolID="156">
<GuiSettings Plugin="AlteryxBasePluginsGui.Filter.Filter">
<Position x="258" y="786" />
</GuiSettings>
<Properties>
<Configuration>
<Expression>Contains([Genre], "Comedy") or Contains([Genre], "Action") and [Diva Score]!=Null()</Expression>
<Mode>Custom</Mode>
</Configuration>
<Annotation DisplayMode="1">
<Name />
<DefaultAnnotationText>Contains([Genre], "Comedy") or Contains([Genre], "Action") and [Diva Score]!=Nul...</DefaultAnnotationText>
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxFilter" />
</Node>
<Node ToolID="157">
<GuiSettings Plugin="AlteryxBasePluginsGui.Filter.Filter">
<Position x="366" y="774" />
</GuiSettings>
<Properties>
<Configuration>
<Expression>Contains([Genre], "Comedy")</Expression>
<Mode>Custom</Mode>
</Configuration>
<Annotation DisplayMode="1">
<Name />
<DefaultAnnotationText>Contains([Genre], "Comedy")</DefaultAnnotationText>
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxFilter" />
</Node>
<Node ToolID="158">
<GuiSettings Plugin="AlteryxBasePluginsGui.AlteryxSelect.AlteryxSelect">
<Position x="162" y="786" />
</GuiSettings>
<Properties>
<Configuration>
<OrderChanged value="False" />
<CommaDecimal value="False" />
<SelectFields>
<SelectField field="Revenue" selected="True" type="FixedDecimal" size="19.2" />
<SelectField field="*Unknown" selected="True" />
</SelectFields>
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText />
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxSelect" />
</Node>
<Node ToolID="159">
<GuiSettings Plugin="AlteryxBasePluginsGui.Sort.Sort">
<Position x="594" y="762" />
</GuiSettings>
<Properties>
<Configuration>
<SortInfo locale="1033">
<Field field="Actor Popularity" order="Descending" />
</SortInfo>
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText>Actor Popularity - Descending</DefaultAnnotationText>
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxSort" />
</Node>
<Node ToolID="160">
<GuiSettings Plugin="AlteryxBasePluginsGui.Sort.Sort">
<Position x="594" y="822" />
</GuiSettings>
<Properties>
<Configuration>
<SortInfo locale="1033">
<Field field="Actor Popularity" order="Descending" />
</SortInfo>
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText>Actor Popularity - Descending</DefaultAnnotationText>
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxSort" />
</Node>
<Node ToolID="162">
<GuiSettings Plugin="AlteryxBasePluginsGui.Sort.Sort">
<Position x="594" y="882" />
</GuiSettings>
<Properties>
<Configuration>
<SortInfo locale="1033">
<Field field="Revenue" order="Descending" />
</SortInfo>
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText>Revenue - Descending</DefaultAnnotationText>
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxSort" />
</Node>
<Node ToolID="163">
<GuiSettings Plugin="AlteryxBasePluginsGui.Sample.Sample">
<Position x="786" y="762" />
</GuiSettings>
<Properties>
<Configuration>
<Mode>First</Mode>
<N>1</N>
<GroupFields orderChanged="False" />
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText>First 1</DefaultAnnotationText>
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxSample" />
</Node>
<Node ToolID="164">
<GuiSettings Plugin="AlteryxBasePluginsGui.Sample.Sample">
<Position x="786" y="822" />
</GuiSettings>
<Properties>
<Configuration>
<Mode>First</Mode>
<N>1</N>
<GroupFields orderChanged="False" />
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText>First 1</DefaultAnnotationText>
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxSample" />
</Node>
<Node ToolID="165">
<GuiSettings Plugin="AlteryxBasePluginsGui.Sample.Sample">
<Position x="786" y="882" />
</GuiSettings>
<Properties>
<Configuration>
<Mode>First</Mode>
<N>1</N>
<GroupFields orderChanged="False" />
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText>First 1</DefaultAnnotationText>
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxSample" />
</Node>
<Node ToolID="166">
<GuiSettings Plugin="AlteryxBasePluginsGui.Union.Union">
<Position x="906" y="822" />
</GuiSettings>
<Properties>
<Configuration>
<ByName_ErrorMode>Warning</ByName_ErrorMode>
<ByName_OutputMode>All</ByName_OutputMode>
<Mode>ByName</Mode>
<SetOutputOrder value="True" />
<OutputOrder>
<Connection>#2</Connection>
<Connection>#1</Connection>
<Connection>#3</Connection>
</OutputOrder>
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText />
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxUnion" />
</Node>
<Node ToolID="167">
<GuiSettings Plugin="AlteryxBasePluginsGui.AlteryxSelect.AlteryxSelect">
<Position x="1170" y="822" />
</GuiSettings>
<Properties>
<Configuration>
<OrderChanged value="False" />
<CommaDecimal value="False" />
<SelectFields>
<SelectField field="Actor" selected="True" rename="Result" />
<SelectField field="Criteria" selected="True" />
<SelectField field="*Unknown" selected="False" />
</SelectFields>
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText />
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxSelect" />
</Node>
<Node ToolID="168">
<GuiSettings Plugin="AlteryxBasePluginsGui.Formula.Formula">
<Position x="1086" y="822" />
</GuiSettings>
<Properties>
<Configuration>
<FormulaFields />
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText><![CDATA[
]]></DefaultAnnotationText>
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxFormula" />
</Node>
<Node ToolID="169">
<GuiSettings Plugin="AlteryxBasePluginsGui.Formula.Formula">
<Position x="690" y="762" />
</GuiSettings>
<Properties>
<Configuration>
<FormulaFields>
<FormulaField expression=""Most popular actor in the comedy that generated the most revenue"" field="Criteria" size="1073741823" type="V_WString" />
</FormulaFields>
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText><![CDATA[Criteria = "Most popular actor in the comedy that generated the most revenue"
]]></DefaultAnnotationText>
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxFormula" />
</Node>
<Node ToolID="170">
<GuiSettings Plugin="AlteryxBasePluginsGui.Formula.Formula">
<Position x="690" y="822" />
</GuiSettings>
<Properties>
<Configuration>
<FormulaFields>
<FormulaField expression=""Most Popular actor in the action movie that generated the most revenue"" field="Criteria" size="1073741823" type="V_WString" />
</FormulaFields>
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText>Criteria = "Most Popular actor in the action movie that generated the most reven...</DefaultAnnotationText>
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxFormula" />
</Node>
<Node ToolID="171">
<GuiSettings Plugin="AlteryxBasePluginsGui.Formula.Formula">
<Position x="690" y="882" />
</GuiSettings>
<Properties>
<Configuration>
<FormulaFields>
<FormulaField expression=""Actor in the comedy or action movie that generated the most revenue movie"" field="Criteria" size="1073741823" type="V_WString" />
</FormulaFields>
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText>Criteria = "Actor in the comedy or action movie that generated the most revenue ...</DefaultAnnotationText>
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxFormula" />
</Node>
<Node ToolID="172">
<GuiSettings Plugin="AlteryxBasePluginsGui.Formula.Formula">
<Position x="1086" y="942" />
</GuiSettings>
<Properties>
<Configuration>
<FormulaFields>
<FormulaField expression=""Ideal film location"" field="Criteria" size="1073741823" type="V_WString" />
</FormulaFields>
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText><![CDATA[Criteria = "Ideal film location"
]]></DefaultAnnotationText>
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxFormula" />
</Node>
<Node ToolID="173">
<GuiSettings Plugin="AlteryxSpatialPluginsGui.Summarize.Summarize">
<Position x="1002" y="738" />
</GuiSettings>
<Properties>
<Configuration>
<SummarizeFields>
<SummarizeField field="Revenue" action="Avg" rename="Revenue" />
</SummarizeFields>
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText />
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxSpatialPluginsEngine.dll" EngineDllEntryPoint="AlteryxSummarize" />
</Node>
<Node ToolID="174">
<GuiSettings Plugin="AlteryxBasePluginsGui.AlteryxSelect.AlteryxSelect">
<Position x="1170" y="942" />
</GuiSettings>
<Properties>
<Configuration>
<OrderChanged value="False" />
<CommaDecimal value="False" />
<SelectFields>
<SelectField field="Film Location" selected="True" rename="Result" />
<SelectField field="Criteria" selected="True" />
<SelectField field="*Unknown" selected="False" />
</SelectFields>
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText />
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxSelect" />
</Node>
<Node ToolID="175">
<GuiSettings Plugin="AlteryxBasePluginsGui.Formula.Formula">
<Position x="1086" y="738" />
</GuiSettings>
<Properties>
<Configuration>
<FormulaFields>
<FormulaField expression=""Expected revenue"" field="Criteria" size="1073741823" type="V_WString" />
</FormulaFields>
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText><![CDATA[Criteria = "Expected revenue"
]]></DefaultAnnotationText>
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxFormula" />
</Node>
<Node ToolID="176">
<GuiSettings Plugin="AlteryxBasePluginsGui.AlteryxSelect.AlteryxSelect">
<Position x="1170" y="738" />
</GuiSettings>
<Properties>
<Configuration>
<OrderChanged value="False" />
<CommaDecimal value="False" />
<SelectFields>
<SelectField field="Revenue" selected="True" rename="Result" type="FixedDecimal" size="19.2" />
<SelectField field="Criteria" selected="True" />
<SelectField field="*Unknown" selected="False" />
</SelectFields>
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText />
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxSelect" />
</Node>
<Node ToolID="177">
<GuiSettings Plugin="AlteryxBasePluginsGui.Union.Union">
<Position x="1314" y="822" />
</GuiSettings>
<Properties>
<Configuration>
<ByName_ErrorMode>Warning</ByName_ErrorMode>
<ByName_OutputMode>All</ByName_OutputMode>
<Mode>ByName</Mode>
<SetOutputOrder value="True" />
<OutputOrder>
<Connection>#1</Connection>
<Connection>#3</Connection>
<Connection>#2</Connection>
</OutputOrder>
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText />
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxUnion" />
</Node>
<Node ToolID="178">
<GuiSettings Plugin="AlteryxBasePluginsGui.BrowseV2.BrowseV2">
<Position x="1410" y="822" />
</GuiSettings>
<Properties>
<Configuration>
<TempFile>C:\Users\ma1025\AppData\Local\Temp\1\Engine2_16852_713ce2766f950448adaf9208c5957c62_\Engine_16852_37239f62863ad948ab1154474a9d1320~.yxdb</TempFile>
<TempFileDataProfiling />
<Layout>
<ViewMode>Single</ViewMode>
<ViewSize value="100" />
<View1>
<DefaultTab>Profile</DefaultTab>
<Hints>
<Table />
</Hints>
</View1>
<View2 />
</Layout>
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText />
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxBrowseV2" />
</Node>
<Node ToolID="179">
<GuiSettings Plugin="AlteryxGuiToolkit.TextBox.TextBox">
<Position x="246" y="750" width="100" height="40" />
</GuiSettings>
<Properties>
<Configuration>
<Text>Filtering out Comedy or Action Genre</Text>
<Font name="Arial" size="8.25" style="0" />
<TextColor name="White" />
<FillColor r="0" g="128" b="192" />
<Shape shape="0" />
<Justification Justification="4" />
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText />
<Left value="False" />
</Annotation>
</Properties>
</Node>
<Node ToolID="180">
<GuiSettings Plugin="AlteryxGuiToolkit.TextBox.TextBox">
<Position x="342" y="702" width="100" height="40" />
</GuiSettings>
<Properties>
<Configuration>
<Text>Filtering out Comedy and Action Genre</Text>
<Font name="Arial" size="8.25" style="0" />
<TextColor name="White" />
<FillColor r="0" g="128" b="192" />
<Shape shape="0" />
<Justification Justification="4" />
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText />
<Left value="False" />
</Annotation>
</Properties>
</Node>
<Node ToolID="181">
<GuiSettings Plugin="AlteryxGuiToolkit.TextBox.TextBox">
<Position x="978" y="702" width="100" height="40" />
</GuiSettings>
<Properties>
<Configuration>
<Text>Averaging Revenue</Text>
<Font name="Arial" size="8.25" style="0" />
<TextColor name="White" />
<FillColor r="0" g="128" b="192" />
<Shape shape="0" />
<Justification Justification="4" />
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText />
<Left value="False" />
</Annotation>
</Properties>
</Node>
<Node ToolID="118">
<GuiSettings Plugin="AlteryxGuiToolkit.ToolContainer.ToolContainer">
<Position x="140" y="1988" width="656" height="84" />
</GuiSettings>
<Properties>
<Configuration>
<Caption>Alteryx Educational Asset - Terms and Conditions</Caption>
<Style TextColor="#ffffff" FillColor="#0d2345" BorderColor="#ffffff" Transparency="1" Margin="10" />
<Disabled value="False" />
<Folded value="False" />
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText />
<Left value="False" />
</Annotation>
</Properties>
<ChildNodes>
<Node ToolID="117">
<GuiSettings Plugin="AlteryxGuiToolkit.TextBox.TextBox">
<Position x="150" y="2022" width="636" height="40" />
</GuiSettings>
<Properties>
<Configuration>
<Text>Use of this Alteryx asset is for educational purposes only and bound by the conditions set forth on alteryx.com/terms-and-conditions. Alteryx Information may not be reproduced, transmitted or distributed without Alteryx, Inc.'s permission.”</Text>
<Font name="Times New Roman" size="8.25" style="0" />
<TextColor name="White" />
<FillColor name="White" />
<Shape shape="3" />
<Justification Justification="4" />
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText />
<Left value="False" />
</Annotation>
</Properties>
</Node>
</ChildNodes>
</Node>
</Nodes>
<Connections>
<Connection>
<Origin ToolID="130" Connection="Output" />
<Destination ToolID="121" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="130" Connection="Output" />
<Destination ToolID="158" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="156" Connection="True" />
<Destination ToolID="157" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="156" Connection="True" />
<Destination ToolID="162" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="157" Connection="True" />
<Destination ToolID="159" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="157" Connection="False" />
<Destination ToolID="160" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="158" Connection="Output" />
<Destination ToolID="156" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="159" Connection="Output" />
<Destination ToolID="169" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="160" Connection="Output" />
<Destination ToolID="170" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="162" Connection="Output" />
<Destination ToolID="171" Connection="Input" />
</Connection>
<Connection name="#2">
<Origin ToolID="163" Connection="Output" />
<Destination ToolID="166" Connection="Input" />
</Connection>
<Connection name="#1">
<Origin ToolID="164" Connection="Output" />
<Destination ToolID="166" Connection="Input" />
</Connection>
<Connection name="#3">
<Origin ToolID="165" Connection="Output" />
<Destination ToolID="166" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="165" Connection="Output" />
<Destination ToolID="172" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="166" Connection="Output" />
<Destination ToolID="168" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="166" Connection="Output" />
<Destination ToolID="173" Connection="Input" />
</Connection>
<Connection name="#1">
<Origin ToolID="167" Connection="Output" />
<Destination ToolID="177" Connection="Input" />
</Connection>
<Connection name="#3">
<Origin ToolID="174" Connection="Output" />
<Destination ToolID="177" Connection="Input" />
</Connection>
<Connection name="#2">
<Origin ToolID="176" Connection="Output" />
<Destination ToolID="177" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="168" Connection="Output" />
<Destination ToolID="167" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="169" Connection="Output" />
<Destination ToolID="163" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="170" Connection="Output" />
<Destination ToolID="164" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="171" Connection="Output" />
<Destination ToolID="165" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="172" Connection="Output" />
<Destination ToolID="174" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="173" Connection="Output" />
<Destination ToolID="175" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="175" Connection="Output" />
<Destination ToolID="176" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="177" Connection="Output" />
<Destination ToolID="178" Connection="Input" />
</Connection>
</Connections>
<Properties>
<Memory default="True" />
<GlobalRecordLimit value="0" />
<TempFiles default="True" />
<Annotation on="False" includeToolName="False" />
<ConvErrorLimit value="10" />
<ConvErrorLimit_Stop value="False" />
<CancelOnError value="False" />
<DisableBrowse value="False" />
<EnablePerformanceProfiling value="False" />
<RunWithE2 value="True" />
<PredictiveToolsCodePage value="1252" />
<DisableAllOutput value="False" />
<ShowAllMacroMessages value="False" />
<ShowConnectionStatusIsOn value="False" />
<ShowConnectionStatusOnlyWhenRunning value="False" />
<ZoomLevel value="0" />
<LayoutType>Horizontal</LayoutType>
<MetaInfo>
<NameIsFileName value="True" />
<Name>challenge_335_start_file Mahmood</Name>
<Description />
<RootToolName />
<ToolVersion />
<ToolInDb value="False" />
<CategoryName />
<SearchTags />
<Author />
<Company />
<Copyright />
<DescriptionLink actual="" displayed="" />
<Example>
<Description />
<File />
</Example>
<WorkflowId value="c898e863-1990-42eb-9e83-7e0e66aad796" />
<Telemetry>
<PreviousWorkflowId value="fbcc1899-4dc3-4af7-a74e-f3b893070de0" />
<OriginWorkflowId value="fbcc1899-4dc3-4af7-a74e-f3b893070de0" />
</Telemetry>
</MetaInfo>
<Events>
<Enabled value="True" />
</Events>
</Properties>
</AlteryxDocument>
