https://community.alteryx.com/t5/Weekly-Challenges/Challenge-288-Client-s-Rating-Analysis/m-p/830372#M67974 <LI-SPOILER><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Kenda_0-1633374693788.png" style="width: 400px;"><img src="https://community.alteryx.com/t5/image/serverpage/image-id/205311i169432E0AC89E272/image-size/medium?v=v2&amp;px=400" role="button" title="Kenda_0-1633374693788.png" alt="Kenda_0-1633374693788.png" /></span><P>&nbsp;</P></LI-SPOILER> Mon, 04 Oct 2021 19:12:16 GMT Kenda 2021-10-04T19:12:16Z https://community.alteryx.com/t5/Weekly-Challenges/Challenge-288-Client-s-Rating-Analysis/m-p/830054#M67921 <P><SPAN>A solution for last week's challenge can be found&nbsp;</SPAN><A href="https://community.alteryx.com/t5/Weekly-Challenge/Challenge-287-Find-My-Pet-US/td-p/827204" target="_blank" rel="noopener">here<SPAN>.</SPAN></A></P> <P>&nbsp;</P> <P>For this&nbsp; week's challenge, you are provided two datasets:</P> <P style="line-height: 1.42857; font-family: Lato, 'Helvetica Neue', Helvetica, Arial, sans-serif;"><span class="lia-inline-image-display-wrapper lia-image-align-right" image-alt="image_288.PNG" style="width: 329px;"><img src="https://community.alteryx.com/t5/image/serverpage/image-id/205209i4941AABBB3E54E4F/image-size/medium?v=v2&amp;px=400" role="button" title="image_288.PNG" alt="image_288.PNG" /></span></P> <P>&nbsp;</P> <P>- The first one (Clients) contains each client's information including their Client ID<BR />- The second one (Request &amp; Evaluation) contains the client's Request number (which is the same as the Client ID), &nbsp;"Status" which indicates if the request has been processed, "Status2" provides a comment, and the "Professional" <SPAN>&nbsp;field is the name of the customer.</SPAN></P> <P>&nbsp;</P> <P>Your tasks are to determine:</P> <P>- For a "Status" of Evaluated, the number of customers ("Professional") who commented "Below Expectations",&nbsp;"Exceeded Expectations", or "Met Expectations" for "Status2"<BR />- The three customers ("Professional") who provided the highest average rating</P> Tue, 13 Sep 2022 15:02:34 GMT https://community.alteryx.com/t5/Weekly-Challenges/Challenge-288-Client-s-Rating-Analysis/m-p/830054#M67921 AYXAcademy 2022-09-13T15:02:34Z https://community.alteryx.com/t5/Weekly-Challenges/Challenge-288-Client-s-Rating-Analysis/m-p/830061#M67922 <P>mySolution</P> Mon, 04 Oct 2021 12:06:45 GMT https://community.alteryx.com/t5/Weekly-Challenges/Challenge-288-Client-s-Rating-Analysis/m-p/830061#M67922 JITHINPR 2021-10-04T12:06:45Z https://community.alteryx.com/t5/Weekly-Challenges/Challenge-288-Client-s-Rating-Analysis/m-p/830067#M67925 <P>Here is my submission.</P><LI-SPOILER><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="workflow.png" style="width: 999px;"><img src="https://community.alteryx.com/t5/image/serverpage/image-id/205214i19C7133759550DAF/image-size/large?v=v2&amp;px=999" role="button" title="workflow.png" alt="workflow.png" /></span></LI-SPOILER> Mon, 04 Oct 2021 12:11:47 GMT https://community.alteryx.com/t5/Weekly-Challenges/Challenge-288-Client-s-Rating-Analysis/m-p/830067#M67925 JasonHu 2021-10-04T12:11:47Z https://community.alteryx.com/t5/Weekly-Challenges/Challenge-288-Client-s-Rating-Analysis/m-p/830070#M67926 <P>Solution attached,</P><P>&nbsp;</P><LI-SPOILER><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="PhilipMannering_0-1633349821483.png" style="width: 603px;"><img src="https://community.alteryx.com/t5/image/serverpage/image-id/205215iD2D8A08837DCFC29/image-dimensions/603x368?v=v2" width="603" height="368" role="button" title="PhilipMannering_0-1633349821483.png" alt="PhilipMannering_0-1633349821483.png" /></span><P>&nbsp;</P></LI-SPOILER> Mon, 04 Oct 2021 12:17:15 GMT https://community.alteryx.com/t5/Weekly-Challenges/Challenge-288-Client-s-Rating-Analysis/m-p/830070#M67926 philipmannering 2021-10-04T12:17:15Z https://community.alteryx.com/t5/Weekly-Challenges/Challenge-288-Client-s-Rating-Analysis/m-p/830088#M67928 <P>Solution in Python Tool</P><P>&nbsp;</P><LI-SPOILER><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="PhilipMannering_0-1633350878677.png" style="width: 609px;"><img src="https://community.alteryx.com/t5/image/serverpage/image-id/205222i9B747D227F63629F/image-dimensions/609x378?v=v2" width="609" height="378" role="button" title="PhilipMannering_0-1633350878677.png" alt="PhilipMannering_0-1633350878677.png" /></span><P>&nbsp;</P><BR /><P>&nbsp;</P></LI-SPOILER> Mon, 04 Oct 2021 12:35:01 GMT https://community.alteryx.com/t5/Weekly-Challenges/Challenge-288-Client-s-Rating-Analysis/m-p/830088#M67928 philipmannering 2021-10-04T12:35:01Z https://community.alteryx.com/t5/Weekly-Challenges/Challenge-288-Client-s-Rating-Analysis/m-p/830090#M67929 <LI-SPOILER><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="binuacs_0-1633350839255.png" style="width: 400px;"><img src="https://community.alteryx.com/t5/image/serverpage/image-id/205221i6FF95A33BA7831B3/image-size/medium?v=v2&amp;px=400" role="button" title="binuacs_0-1633350839255.png" alt="binuacs_0-1633350839255.png" /></span><P>&nbsp;</P></LI-SPOILER> Mon, 04 Oct 2021 12:34:11 GMT https://community.alteryx.com/t5/Weekly-Challenges/Challenge-288-Client-s-Rating-Analysis/m-p/830090#M67929 binu_acs 2021-10-04T12:34:11Z https://community.alteryx.com/t5/Weekly-Challenges/Challenge-288-Client-s-Rating-Analysis/m-p/830113#M67931 <P>My solution.</P><P>&nbsp;</P><LI-SPOILER><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="AkimasaKajitani_0-1633352592292.png" style="width: 506px;"><img src="https://community.alteryx.com/t5/image/serverpage/image-id/205231i07AFA84D9877FB23/image-dimensions/506x276?v=v2" width="506" height="276" role="button" title="AkimasaKajitani_0-1633352592292.png" alt="AkimasaKajitani_0-1633352592292.png" /></span><P>&nbsp;</P></LI-SPOILER> Mon, 04 Oct 2021 13:03:53 GMT https://community.alteryx.com/t5/Weekly-Challenges/Challenge-288-Client-s-Rating-Analysis/m-p/830113#M67931 AkimasaKajitani 2021-10-04T13:03:53Z https://community.alteryx.com/t5/Weekly-Challenges/Challenge-288-Client-s-Rating-Analysis/m-p/830117#M67932 <P>Here is my solution.&nbsp;</P> Mon, 04 Oct 2021 13:04:37 GMT https://community.alteryx.com/t5/Weekly-Challenges/Challenge-288-Client-s-Rating-Analysis/m-p/830117#M67932 nickhernigle 2021-10-04T13:04:37Z https://community.alteryx.com/t5/Weekly-Challenges/Challenge-288-Client-s-Rating-Analysis/m-p/830136#M67935 <LI-SPOILER><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="challenge_288_solution_jdavis.PNG" style="width: 999px;"><img src="https://community.alteryx.com/t5/image/serverpage/image-id/205239i106CFF9656FB06B9/image-size/large?v=v2&amp;px=999" role="button" title="challenge_288_solution_jdavis.PNG" alt="challenge_288_solution_jdavis.PNG" /></span></LI-SPOILER> Mon, 04 Oct 2021 13:31:04 GMT https://community.alteryx.com/t5/Weekly-Challenges/Challenge-288-Client-s-Rating-Analysis/m-p/830136#M67935 justindavis 2021-10-04T13:31:04Z https://community.alteryx.com/t5/Weekly-Challenges/Challenge-288-Client-s-Rating-Analysis/m-p/830140#M67936 <P>Here is my solution!</P><P>&nbsp;</P><LI-SPOILER><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Maskell_Rascal_0-1633354527192.png" style="width: 400px;"><img src="https://community.alteryx.com/t5/image/serverpage/image-id/205240i8EF394FD02CEECA5/image-size/medium?v=v2&amp;px=400" role="button" title="Maskell_Rascal_0-1633354527192.png" alt="Maskell_Rascal_0-1633354527192.png" /></span><P>&nbsp;</P></LI-SPOILER><P>Cheers!</P><P>Phil</P> Mon, 04 Oct 2021 13:35:43 GMT https://community.alteryx.com/t5/Weekly-Challenges/Challenge-288-Client-s-Rating-Analysis/m-p/830140#M67936 Maskell_Rascal 2021-10-04T13:35:43Z https://community.alteryx.com/t5/Weekly-Challenges/Challenge-288-Client-s-Rating-Analysis/m-p/830142#M67937 <P>This challenge "Exceeded expectations"!&nbsp;<span class="lia-unicode-emoji" title=":beaming_face_with_smiling_eyes:">😁</span></P><P>&nbsp;</P><LI-SPOILER><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="challenge_288_solution_DeanWest.png" style="width: 985px;"><img src="https://community.alteryx.com/t5/image/serverpage/image-id/205241i63C448C0C49D8B70/image-size/large?v=v2&amp;px=999" role="button" title="challenge_288_solution_DeanWest.png" alt="challenge_288_solution_DeanWest.png" /></span></LI-SPOILER> Mon, 04 Oct 2021 13:36:32 GMT https://community.alteryx.com/t5/Weekly-Challenges/Challenge-288-Client-s-Rating-Analysis/m-p/830142#M67937 DeanWest 2021-10-04T13:36:32Z https://community.alteryx.com/t5/Weekly-Challenges/Challenge-288-Client-s-Rating-Analysis/m-p/830143#M67938 <P>My results.</P><LI-SPOILER><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="dYoast_0-1633354563576.png" style="width: 400px;"><img src="https://community.alteryx.com/t5/image/serverpage/image-id/205242i22D2125BA1D4099D/image-size/medium?v=v2&amp;px=400" role="button" title="dYoast_0-1633354563576.png" alt="dYoast_0-1633354563576.png" /></span><P>&nbsp;</P></LI-SPOILER> Mon, 04 Oct 2021 13:36:37 GMT https://community.alteryx.com/t5/Weekly-Challenges/Challenge-288-Client-s-Rating-Analysis/m-p/830143#M67938 dYoast 2021-10-04T13:36:37Z https://community.alteryx.com/t5/Weekly-Challenges/Challenge-288-Client-s-Rating-Analysis/m-p/830174#M67940 <P>My solution attached</P><LI-SPOILER><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="challenge_288_start_file_Alex Abi-Najm.PNG" style="width: 679px;"><img src="https://community.alteryx.com/t5/image/serverpage/image-id/205251i1E5FC47870F3F590/image-size/large?v=v2&amp;px=999" role="button" title="challenge_288_start_file_Alex Abi-Najm.PNG" alt="challenge_288_start_file_Alex Abi-Najm.PNG" /></span></LI-SPOILER> Mon, 04 Oct 2021 13:59:22 GMT https://community.alteryx.com/t5/Weekly-Challenges/Challenge-288-Client-s-Rating-Analysis/m-p/830174#M67940 alexnajm 2021-10-04T13:59:22Z https://community.alteryx.com/t5/Weekly-Challenges/Challenge-288-Client-s-Rating-Analysis/m-p/830179#M67942 <P>Good Morning and Happy Monday, I attached my solution</P><P>&nbsp;</P><LI-SPOILER><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jferrone_0-1633356259341.png" style="width: 400px;"><img src="https://community.alteryx.com/t5/image/serverpage/image-id/205253i270E0AFF939007C9/image-size/medium?v=v2&amp;px=400" role="button" title="jferrone_0-1633356259341.png" alt="jferrone_0-1633356259341.png" /></span><P>&nbsp;</P></LI-SPOILER> Mon, 04 Oct 2021 14:04:33 GMT https://community.alteryx.com/t5/Weekly-Challenges/Challenge-288-Client-s-Rating-Analysis/m-p/830179#M67942 jferrone 2021-10-04T14:04:33Z https://community.alteryx.com/t5/Weekly-Challenges/Challenge-288-Client-s-Rating-Analysis/m-p/830195#M67946 <P>&nbsp;</P><LI-SPOILER><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.PNG" style="width: 400px;"><img src="https://community.alteryx.com/t5/image/serverpage/image-id/205256iEAB4C8CC49DDEB9E/image-size/medium?v=v2&amp;px=400" role="button" title="Capture.PNG" alt="Capture.PNG" /></span><P> </P></LI-SPOILER> Mon, 04 Oct 2021 14:21:27 GMT https://community.alteryx.com/t5/Weekly-Challenges/Challenge-288-Client-s-Rating-Analysis/m-p/830195#M67946 Jbone 2021-10-04T14:21:27Z https://community.alteryx.com/t5/Weekly-Challenges/Challenge-288-Client-s-Rating-Analysis/m-p/830206#M67948 <LI-SPOILER><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Luke_C_0-1633358173453.png" style="width: 400px;"><img src="https://community.alteryx.com/t5/image/serverpage/image-id/205258i7E725F47306B0103/image-size/medium?v=v2&amp;px=400" role="button" title="Luke_C_0-1633358173453.png" alt="Luke_C_0-1633358173453.png" /></span><P>&nbsp;</P></LI-SPOILER> Mon, 04 Oct 2021 14:36:43 GMT https://community.alteryx.com/t5/Weekly-Challenges/Challenge-288-Client-s-Rating-Analysis/m-p/830206#M67948 Luke_C 2021-10-04T14:36:43Z https://community.alteryx.com/t5/Weekly-Challenges/Challenge-288-Client-s-Rating-Analysis/m-p/830221#M67951 <LI-SPOILER><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="WC288.jpg" style="width: 400px;"><img src="https://community.alteryx.com/t5/image/serverpage/image-id/205262i90FA8FAC43220187/image-size/medium?v=v2&amp;px=400" role="button" title="WC288.jpg" alt="WC288.jpg" /></span><P> </P></LI-SPOILER><P>My Solution <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Mon, 04 Oct 2021 14:48:08 GMT https://community.alteryx.com/t5/Weekly-Challenges/Challenge-288-Client-s-Rating-Analysis/m-p/830221#M67951 J-Bensh 2021-10-04T14:48:08Z https://community.alteryx.com/t5/Weekly-Challenges/Challenge-288-Client-s-Rating-Analysis/m-p/830242#M67957 <P>Below My solution</P> <P>&nbsp;</P> <LI-SPOILER><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="messi007_0-1633360963089.png" style="width: 400px;"><img src="https://community.alteryx.com/t5/image/serverpage/image-id/205269iD7CDE0248173DB00/image-size/medium?v=v2&amp;px=400" role="button" title="messi007_0-1633360963089.png" alt="messi007_0-1633360963089.png" /></span> <P>&nbsp;</P> </LI-SPOILER> <P>Attached the workflow,</P> <P>Regards</P> Mon, 04 Oct 2021 15:23:20 GMT https://community.alteryx.com/t5/Weekly-Challenges/Challenge-288-Client-s-Rating-Analysis/m-p/830242#M67957 messi007 2021-10-04T15:23:20Z https://community.alteryx.com/t5/Weekly-Challenges/Challenge-288-Client-s-Rating-Analysis/m-p/830274#M67963 <LI-SPOILER>Solution Attached<BR /><BR /><BR /><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="balajilolla_0-1633363065583.png" style="width: 400px;"><img src="https://community.alteryx.com/t5/image/serverpage/image-id/205278i5AD951B4F14EDC79/image-size/medium?v=v2&amp;px=400" role="button" title="balajilolla_0-1633363065583.png" alt="balajilolla_0-1633363065583.png" /></span><P>&nbsp;</P></LI-SPOILER> Mon, 04 Oct 2021 15:57:54 GMT https://community.alteryx.com/t5/Weekly-Challenges/Challenge-288-Client-s-Rating-Analysis/m-p/830274#M67963 balajilolla 2021-10-04T15:57:54Z https://community.alteryx.com/t5/Weekly-Challenges/Challenge-288-Client-s-Rating-Analysis/m-p/830291#M67965 <LI-SPOILER><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="288.jpg" style="width: 999px;"><img src="https://community.alteryx.com/t5/image/serverpage/image-id/205284i6D031F7F6C947BD2/image-size/large?v=v2&amp;px=999" role="button" title="288.jpg" alt="288.jpg" /></span></LI-SPOILER> <P>My solution.</P> Mon, 04 Oct 2021 16:09:21 GMT https://community.alteryx.com/t5/Weekly-Challenges/Challenge-288-Client-s-Rating-Analysis/m-p/830291#M67965 RolandSchubert 2021-10-04T16:09:21Z