# 78|ALTERYX – Tax Tool **URL:** https://www.techhub.training/t/78-alteryx-tax-tool/691 **Category:** Challenges **Tags:** absolute, effective-tax, tax-rate, beginner, alteryx, tax **Created:** [May 26, 2023, 5:32pm UTC](https://www.techhub.training/t/78-alteryx-tax-tool/691 "2023-05-26T17:32:54Z") **Posts on this page:** 20 **Page:** 3
### Author: ![Skyler\_Lucas](https://avatars.discourse-cdn.com/v4/letter/s/e9c0ed/32.png) [@Skyler\_Lucas](https://www.techhub.training/u/Skyler_Lucas) #### Post date: [November 4, 2023, 2:02am UTC](https://www.techhub.training/t/78-alteryx-tax-tool/691/42 "2023-11-04T02:02:40Z")
![Screenshot 2023-11-03 195653](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/8/800be16d573f4f7072e1bd06184009396233cec3.png) [ChickenCallenge1.yxmd](https://www.techhub.training/uploads/short-url/pCzuMXaKdjZYyEjosOFNMb5ejw7.yxmd) (28.9 KB) ---
### Author: ![Gabby\_Wilson](https://avatars.discourse-cdn.com/v4/letter/g/cdc98d/32.png) [@Gabby\_Wilson](https://www.techhub.training/u/Gabby_Wilson) #### Post date: [November 4, 2023, 2:09am UTC](https://www.techhub.training/t/78-alteryx-tax-tool/691/43 "2023-11-04T02:09:25Z")
![Challenge78_Wilson](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/f/fcb4f962eb184f75f49f319f73a42711388f4efa.png) Here’s my solution. It was some good practice. ---
### Author: ![Andrew\_Wilson](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/andrew_wilson/32/5487_2.png) [@Andrew\_Wilson](https://www.techhub.training/u/Andrew_Wilson) #### Post date: [November 4, 2023, 2:24am UTC](https://www.techhub.training/t/78-alteryx-tax-tool/691/44 "2023-11-04T02:24:44Z")
This was an interesting problem I appreciate the creativity of using the absolute function to find the row with the most data. ![image](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/8/8fcaee0ad3a9d6d2f3a1d1d15f9416aa2af14c24.png) ---
### Author: ![Kelty\_Dagley](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/kelty_dagley/32/1480_2.png) [@Kelty\_Dagley](https://www.techhub.training/u/Kelty_Dagley) #### Post date: [November 4, 2023, 3:44am UTC](https://www.techhub.training/t/78-alteryx-tax-tool/691/45 "2023-11-04T03:44:53Z")
This was a challenge because I struggled to figure out how to find the most complete row, but the video was super helpful! This taught me some new techniques to use as I keep practicing. ![image](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/d/d66b48e44a5b4033ef417ce22860a80a515e04eb.png) [Challenge78.yxmd](https://www.techhub.training/uploads/short-url/wm4p7JnSJiV2f88ybuG1v1x8byC.yxmd) (12.7 KB) ---
### Author: ![Colton\_Bullock](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/colton_bullock/32/1468_2.png) [@Colton\_Bullock](https://www.techhub.training/u/Colton_Bullock) #### Post date: [November 4, 2023, 3:44am UTC](https://www.techhub.training/t/78-alteryx-tax-tool/691/46 "2023-11-04T03:44:53Z")
![Screenshot 2023-11-03 214430](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/8/82743e2939f81b6cb6af039e8445c2c7e29a9011.png) I had a hard time, but the video helped me complete it! ---
### Author: ![Tyler\_Keller](https://avatars.discourse-cdn.com/v4/letter/t/bcef8e/32.png) [@Tyler\_Keller](https://www.techhub.training/u/Tyler_Keller) #### Post date: [November 4, 2023, 3:49am UTC](https://www.techhub.training/t/78-alteryx-tax-tool/691/47 "2023-11-04T03:49:04Z")
![Challenge 78 Solution Screen Shot](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/8/8e279c4807bbb64ef527a8d1657aaf97179c2b11.png) The solution was pretty difficult to figure out. I was pretty close on my own, but I did not clean the data properly to get the correct final answer. ---
### Author: ![Allison\_Fischer](https://avatars.discourse-cdn.com/v4/letter/a/13edae/32.png) [@Allison\_Fischer](https://www.techhub.training/u/Allison_Fischer) #### Post date: [November 4, 2023, 4:05am UTC](https://www.techhub.training/t/78-alteryx-tax-tool/691/48 "2023-11-04T04:05:16Z")
This was hard and I was frustrated at a few steps because I didn’t know what to do, but I got through. Thank you! ![Problem78TechHubScreenshot.PNG](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/7/7f9e35990fde9a0da0fa3f99183ba26e2d9ec4b8.jpeg) [78Problem.yxmd](https://www.techhub.training/uploads/short-url/yMT8NR84jKhpC7O505GScficHx9.yxmd) (12.2 KB) ---
### Author: ![Keilani\_Hess](https://avatars.discourse-cdn.com/v4/letter/k/a9a28c/32.png) [@Keilani\_Hess](https://www.techhub.training/u/Keilani_Hess) #### Post date: [November 4, 2023, 6:54am UTC](https://www.techhub.training/t/78-alteryx-tax-tool/691/49 "2023-11-04T06:54:38Z")
This challenge helped me learn what it meant by “most complete” and how to use the unique tool on Alteryx. Thank you! ![TechHub_TaxTool_Challenge_Screenshot](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/b/b3be715b34875ce4fdd60dadccd0b64ae094462d.png) [TechHub\_TaxTool\_Challenge.yxmd](https://www.techhub.training/uploads/short-url/yCzs2H5rSfmcCforksxaEJS63ks.yxmd) (12.5 KB) ---
### Author: ![Travis\_Fehlberg](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/travis_fehlberg/32/957_2.png) [@Travis\_Fehlberg](https://www.techhub.training/u/Travis_Fehlberg) #### Post date: [November 4, 2023, 8:12am UTC](https://www.techhub.training/t/78-alteryx-tax-tool/691/50 "2023-11-04T08:12:18Z")
The search to find the unique values by absolute value didn’t seem very intuitive to me (I probably wouldn’t have come up with it on my own) but I appreciated that I was able to understand it after I blindly trusted the data and just kept going. it was good to learn how to use the unique function! ![image](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/1/1eae41c38d3262b11bd1c3a255118482c817dab6.png) [Tax Tool.yxmd](https://www.techhub.training/uploads/short-url/lrtKV7T5Qpq0ThE33WvFMpt4i2Z.yxmd) (12.5 KB) ---
### Author: ![Michelle\_Semadeni](https://avatars.discourse-cdn.com/v4/letter/m/3ab097/32.png) [@Michelle\_Semadeni](https://www.techhub.training/u/Michelle_Semadeni) #### Post date: [November 4, 2023, 4:41pm UTC](https://www.techhub.training/t/78-alteryx-tax-tool/691/51 "2023-11-04T16:41:52Z")
Here is my solution! This taught me that it’s important to know what data type you have each field saved as. ![image](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/4/4a849d98d0dd3ef338ca51c2f539de28418893d2.jpeg) [TaxChallenge.yxmd](https://www.techhub.training/uploads/short-url/97k4D6T0OTcmzHAieeciEsRBfbh.yxmd) (15.2 KB) ---
### Author: ![Amy\_Blake](https://avatars.discourse-cdn.com/v4/letter/a/57b2e6/32.png) [@Amy\_Blake](https://www.techhub.training/u/Amy_Blake) #### Post date: [November 4, 2023, 4:54pm UTC](https://www.techhub.training/t/78-alteryx-tax-tool/691/52 "2023-11-04T16:54:30Z")
![Screenshot 2023-11-04 105241](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/3/3ba8a80387956275725f5c598a067f057a49617c.png) [Challenge78.yxmd](https://www.techhub.training/uploads/short-url/eZALP0w4xsQtisNkOLLNSQ132S1.yxmd) (12.4 KB) This was a simple but fun exercise that helped me learn about averages and group by functions! ---
### Author: ![jdwilliams4](https://avatars.discourse-cdn.com/v4/letter/j/eb8c5e/32.png) [@jdwilliams4](https://www.techhub.training/u/jdwilliams4) #### Post date: [November 4, 2023, 5:35pm UTC](https://www.techhub.training/t/78-alteryx-tax-tool/691/53 "2023-11-04T17:35:40Z")
[Techhub 1.yxmd](https://www.techhub.training/uploads/short-url/ebvMUoG590zTNWhVbQZogdgezGI.yxmd) (13.0 KB) ---
### Author: ![Patrick\_Hayden](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/patrick_hayden/32/1351_2.png) [@Patrick\_Hayden](https://www.techhub.training/u/Patrick_Hayden) #### Post date: [November 4, 2023, 5:58pm UTC](https://www.techhub.training/t/78-alteryx-tax-tool/691/54 "2023-11-04T17:58:05Z")
![2023-11-04](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/a/a33438f54922b649446d095d19735187e48b6fee.png) ---
### Author: ![Mason\_Lewis1](https://avatars.discourse-cdn.com/v4/letter/m/50afbb/32.png) [@Mason\_Lewis1](https://www.techhub.training/u/Mason_Lewis1) #### Post date: [November 4, 2023, 6:02pm UTC](https://www.techhub.training/t/78-alteryx-tax-tool/691/55 "2023-11-04T18:02:13Z")
![image](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/9/9cd2e3c826da23a2d9d1034dc064fde21f383360.png) [Challenge 78 Tax Tool.yxmd](https://www.techhub.training/uploads/short-url/rxZZsa6lCnInPAvOdOaCFQ1lmwY.yxmd) (13.0 KB) Thanks for the good practice with the absolute function! I enjoyed it. ---
### Author: ![Melissa\_Fales](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/melissa_fales/32/11144_2.png) [@Melissa\_Fales](https://www.techhub.training/u/Melissa_Fales) #### Post date: [November 4, 2023, 6:43pm UTC](https://www.techhub.training/t/78-alteryx-tax-tool/691/56 "2023-11-04T18:43:07Z")
[probs78techhub.yxmd](https://www.techhub.training/uploads/short-url/eLLBFrEYDkBJj42W7qjfoMiVAYi.yxmd) (12.2 KB) Good times solving! ![Screenshot 2023-11-04 at 12.40.34 PM](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/1/14ea09f0c1a50dfe1a1c366b553a49e7167f7be1.png) ---
### Author: ![Nicole\_Humpherys](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/nicole_humpherys/32/1084_2.png) [@Nicole\_Humpherys](https://www.techhub.training/u/Nicole_Humpherys) #### Post date: [November 4, 2023, 7:17pm UTC](https://www.techhub.training/t/78-alteryx-tax-tool/691/57 "2023-11-04T19:17:46Z")
![image](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/8/84b92a1799b769241812b05d7eba912b3a63b41a.png) Here is my submission for Class 11.6.23. I learned how to use the ABSOLUTE function with this exercise. ---
### Author: ![Young\_Lee](https://avatars.discourse-cdn.com/v4/letter/y/c2a13f/32.png) [@Young\_Lee](https://www.techhub.training/u/Young_Lee) #### Post date: [November 4, 2023, 8:02pm UTC](https://www.techhub.training/t/78-alteryx-tax-tool/691/58 "2023-11-04T20:02:23Z")
![Screenshot (20)](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/f/f6452bda82d7f983f02a6870603ff699fb5b9a81.png) [Challenge78.yxmd](https://www.techhub.training/uploads/short-url/yEyLcI7dppi6TIKT0Vr4uC3DI44.yxmd) (12.0 KB) ---
### Author: ![Liza\_Hladek](https://avatars.discourse-cdn.com/v4/letter/l/f05b48/32.png) [@Liza\_Hladek](https://www.techhub.training/u/Liza_Hladek) #### Post date: [November 4, 2023, 8:33pm UTC](https://www.techhub.training/t/78-alteryx-tax-tool/691/59 "2023-11-04T20:33:21Z")
Thanks for the challenge! [Tech Hub 2.yxmd](https://www.techhub.training/uploads/short-url/5ejxLr5dX7hmyXyUwo4s0i4UfQg.yxmd) (12.3 KB) ![Screenshot 2023-11-04 143143](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/d/dd71760bde2e00b07ac34fc64895a9a1263f352b.png) ---
### Author: ![Jaxon\_Floyd](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/jaxon_floyd/32/1600_2.png) [@Jaxon\_Floyd](https://www.techhub.training/u/Jaxon_Floyd) #### Post date: [November 4, 2023, 9:25pm UTC](https://www.techhub.training/t/78-alteryx-tax-tool/691/60 "2023-11-04T21:25:31Z")
This was actually a tough one but I learned a lot of new tools. I think it would have gone more smoothly if I did a rough draft on paper first before organizing the tools. ![Screenshot 2023-11-04 at 3.23.59 PM](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/a/a9d7e6e4907c796468d2859552be6244faea6db4.png) ---
### Author: ![Brayden\_Cook](https://avatars.discourse-cdn.com/v4/letter/b/c0e974/32.png) [@Brayden\_Cook](https://www.techhub.training/u/Brayden_Cook) #### Post date: [November 4, 2023, 10:07pm UTC](https://www.techhub.training/t/78-alteryx-tax-tool/691/61 "2023-11-04T22:07:44Z")
![Screenshot (2)](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/e/e9de7da6309c366ab3393414b287dc59f841b8b5.png) [Previous page](https://www.techhub.training/t/78-alteryx-tax-tool/691.md?page=2) [Next page](https://www.techhub.training/t/78-alteryx-tax-tool/691.md?page=4)