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
Create summary table
Basic
100%
Basic Table
,
Crosstab vehicle type into columns
Crosstab vehicle type into columns
Avg price and count by type
Avg price and count by type
Warn
Transpose calcs into rows
Transpose calcs into rows
FirstRow
Warn
Rename using first row
Rename using first row
Add formatting
Value_formatted = if [Name] = 'Average Sale Price'
then '$' + tostring(tonumber...
Build into report
Error
PerRecord
V
Continuous
100%
0
Vertical Layout
Each Individual Record
C:\Users\Graham.Thompson\OneDrive - JLL\Business Technology\Alteryx\Adventure\218.pdf
Layout
Continuous
1
squeeze
warning
C:\ProgramData\Alteryx\Engine\Engine_15524_db085a9f67314c26b9a75f03de479e55_\Engine_14596_31c6d3cacc1d4752b650786c447db4d9_.yxdb
Single
Report
Create map
C:\ProgramData\Alteryx\Engine\Engine_15524_db085a9f67314c26b9a75f03de479e55_\Engine_14596_5884093ec23a4c7d916e918acb551051_.xml
20.3
15.24
5
Latest:DarkCarto
#fdfeff
False
Kilometers
10
0.5
IncomingConnection
#1
Type of Vehicle
Points
#1
#1
Base Layers - Points
Placeholder
Base Layers - Lines
Placeholder
Base Layers - Polygons
Placeholder
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_GT