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
Weekly Challenge #218
Arnold at Platinum Motors would like to get a better picture of his car sales from the last month. Using the provided dataset, create a report that shows the locations of the buyers, color-coded by the type of car purchased, with a legend. Underneath the report, put a table that shows the number of sales and average sale price by car type.
{ "type": "Point", "coordinates": [ -105.026550, 39.872858 ] }
Compact
5478.06
{ "type": "Point", "coordinates": [ -104.948273, 39.718807 ] }
Sedan
16107.3
{ "type": "Point", "coordinates": [ -104.826050, 39.735706 ] }
SUV
24430.79
{ "type": "Point", "coordinates": [ -104.972992, 39.874966 ] }
SUV
19987.01
{ "type": "Point", "coordinates": [ -105.074615, 39.796931 ] }
SUV
13474.28
{ "type": "Point", "coordinates": [ -105.021057, 39.823304 ] }
Sedan
13714.46
{ "type": "Point", "coordinates": [ -105.196838, 39.746266 ] }
Compact
8450.56
{ "type": "Point", "coordinates": [ -104.989471, 39.697678 ] }
Minivan
13556.37
{ "type": "Point", "coordinates": [ -104.907074, 39.678655 ] }
Sedan
17377.7
{ "type": "Point", "coordinates": [ -104.994965, 39.788489 ] }
Sedan
10805.83
{ "type": "Point", "coordinates": [ -105.047150, 39.717751 ] }
SUV
23815.75
{ "type": "Point", "coordinates": [ -104.929047, 39.783213 ] }
SUV
22553.79
{ "type": "Point", "coordinates": [ -105.011444, 39.788489 ] }
Sedan
19332.32
{ "type": "Point", "coordinates": [ -104.970245, 39.846504 ] }
Minivan
11964.03
{ "type": "Point", "coordinates": [ -104.993591, 39.628961 ] }
Compact
15386.68
{ "type": "Point", "coordinates": [ -104.894714, 39.795876 ] }
Minivan
22168.05
{ "type": "Point", "coordinates": [ -105.043030, 39.659628 ] }
Sedan
17901.3
{ "type": "Point", "coordinates": [ -105.060883, 39.850721 ] }
Compact
7131.66
{ "type": "Point", "coordinates": [ -105.000458, 39.751545 ] }
SUV
17542.6
{ "type": "Point", "coordinates": [ -104.896088, 39.624730 ] }
Minivan
12265.09
{ "type": "Point", "coordinates": [ -104.854889, 39.800096 ] }
Compact
11400.83
{ "type": "Point", "coordinates": [ -105.102081, 39.731482 ] }
Compact
8666.44
{ "type": "Point", "coordinates": [ -105.029297, 39.769492 ] }
SUV
17158.91
{ "type": "Point", "coordinates": [ -105.030670, 39.714582 ] }
Sedan
14352.08
{ "type": "Point", "coordinates": [ -105.133667, 39.945542 ] }
Minivan
21971.32
{ "type": "Point", "coordinates": [ -104.997711, 39.865480 ] }
Minivan
15201.92
{ "type": "Point", "coordinates": [ -104.977112, 39.751545 ] }
SUV
22696.05
{ "type": "Point", "coordinates": [ -104.849396, 39.700847 ] }
Sedan
10903.45
{ "type": "Point", "coordinates": [ -104.908447, 39.740986 ] }
Compact
16171.49
{ "type": "Point", "coordinates": [ -105.165253, 39.743098 ] }
Sedan
15231.81
{ "type": "Point", "coordinates": [ -105.132294, 39.729370 ] }
Sedan
18244.2
{ "type": "Point", "coordinates": [ -105.119934, 39.789544 ] }
SUV
18845.75
{ "type": "Point", "coordinates": [ -105.074615, 39.764214 ] }
Minivan
24204.66
{ "type": "Point", "coordinates": [ -104.951019, 39.801151 ] }
SUV
24018.2
{ "type": "Point", "coordinates": [ -104.972992, 39.833850 ] }
Sedan
11562.98
{ "type": "Point", "coordinates": [ -104.977112, 39.603572 ] }
Minivan
16623.58
{ "type": "Point", "coordinates": [ -105.070496, 39.603572 ] }
Minivan
12953.85
{ "type": "Point", "coordinates": [ -105.099335, 39.691337 ] }
Compact
11280.81
{ "type": "Point", "coordinates": [ -105.091095, 39.669142 ] }
SUV
18990.46
{ "type": "Point", "coordinates": [ -104.955139, 39.674427 ] }
Sedan
8444.07
{ "type": "Point", "coordinates": [ -104.854889, 39.775825 ] }
Compact
17443.22
{ "type": "Point", "coordinates": [ -104.801331, 39.712469 ] }
Compact
9447.11
{ "type": "Point", "coordinates": [ -104.804077, 39.660685 ] }
Minivan
23763.89
{ "type": "Point", "coordinates": [ -105.049896, 39.792710 ] }
Sedan
13827.46
{ "type": "Point", "coordinates": [ -105.070496, 39.718807 ] }
SUV
25634.78
{ "type": "Point", "coordinates": [ -105.016937, 39.689224 ] }
Sedan
19862.54
{ "type": "Point", "coordinates": [ -104.945526, 39.772659 ] }
SUV
22924.59
{ "type": "Point", "coordinates": [ -104.945526, 39.644825 ] }
Compact
11854.21
{ "type": "Point", "coordinates": [ -105.133667, 39.712469 ] }
Minivan
17349.99
{ "type": "Point", "coordinates": [ -105.045776, 39.761047 ] }
Minivan
20184.12
Warn
,
C:\Users\Biju\AppData\Local\Temp\Engine_17916_8b41535ce83f477b898967b14cd6e53c_\Engine_2464_e457bcdb5d8149b5afcc6128361b52a0_.xml
8
6
5
Latest:CloudMade
#fdfeff
False
Miles
10
0.5
IncomingConnection
#1
SpatialObjCombine_Buyer's Location
Type of Vehicle
Points
#1
#1
Base Layers - Points
Placeholder
Base Layers - Lines
Placeholder
Base Layers - Polygons
Placeholder
pdf
PDF
Letter (8.5in x 11in)
0.5in
{"#1":"C:\\Users\\Biju\\AppData\\Local\\Temp\\Engine_17916_8b41535ce83f477b898967b14cd6e53c_\\Engine_2464_57d8a2f37eb6485cb04965e8dea899bf_.yxdb","#2":"C:\\Users\\Biju\\AppData\\Local\\Temp\\Engine_17916_8b41535ce83f477b898967b14cd6e53c_\\Engine_2464_d4eec1d1392a4415a23ede9b35fb2f82_.yxdb"}
{"#1":{"Table":["C:\\Users\\Biju\\AppData\\Local\\Temp\\Alteryx_2464_b1bee5b5-585d-4293-a036-e248ed211202_\\Alteryx_2464_7889ebd2-9af8-46bb-9857-82f4535f433e_.html"]},"#2":{"Map":["C:\\Users\\Biju\\AppData\\Local\\Temp\\Alteryx_2464_b1bee5b5-585d-4293-a036-e248ed211202_\\Alteryx_2464_cb3a6782-dcd6-4726-aef1-a23338426ed8_.html"],"Field_3":["C:\\Users\\Biju\\AppData\\Local\\Temp\\Alteryx_2464_b1bee5b5-585d-4293-a036-e248ed211202_\\Alteryx_2464_61fa0ee1-2adb-46d6-a33d-965f814d1793_.html"]}}
{"#1":{"Table":["C:\\Users\\Biju\\AppData\\Local\\Temp\\Alteryx_2464_b1bee5b5-585d-4293-a036-e248ed211202_\\Alteryx_2464_14e13ae7-5503-4cc1-8b89-90c4d55362ee_.html"]},"#2":{}}
true
false
C:\Users\Biju\AppData\Local\Temp\Alteryx_2464_b1bee5b5-585d-4293-a036-e248ed211202_
0
0
0
0
2
Basic
100%
Basic Table
Platinum Motors - Car Sales Re...
pdf
Layout
Continuous
1
squeeze
warning
Alteryx Educational Asset - Terms and Conditions
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.”
Horizontal
challenge_218_sol_devi_updated