C:\Users\jqiu\AppData\Local\Temp\Engine_1276_6ae07554ec6f443ea25f7705d6009d4e_\Engine_7208_28caecc4c32e4fe18275d28ad03c0daf_.yxdb
Single
Report
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 #261
A car dealership is looking to offer coupons for their new and regular customers at their service shop. Identify customers that have not had their car serviced in at least 90 days and send them an email with a $5 off coupon encouraging them to have their car serviced. (expected output using March 29, 2021 as the current date) Additionally, include the following suggestions and incentives as applicable:
For cars predicted to top 30000, 60000, or 90000 miles at their next appointment suggest the Comprehensive Car Maintenance Service. (these are vehicles within 4000 miles of the threshold at their last service)
For cars whose last service cost over $200, offer 10% off their next appointment up to $20.
For cars with over $2000 in charges over their history, offer a free oil change at their next appointment.
C:\Users\jqiu\AppData\Local\Temp\Engine_1276_6ae07554ec6f443ea25f7705d6009d4e_\Engine_7208_64bd3db9aba04e95975c45416c2736d5_.yxdb
Single
Profile
Car Service Dataset.yxdb
Car Service Dataset.yxdb
Output.yxdb
Output.yxdb
DaysfromLastService = DateTimeDiff('2021-03-29',[Date of Service],'Days')
Thresh...
Simple
>=
DaysfromLastService
True
fixed
2021-03-30 16:38:46
0
90
2021-03-30 16:38:46
2021-03-30 16:38:46
[DaysfromLastService] >= 90
=(30000-[Threshold]) and [Mileage at Service] <=(30000+[Threshold])) or
([Mileage at Service] >=(60000-[Threshold]) and [Mileage at Service] <=(60000+[Threshold])) or
([Mileage at Service] >=(90000-[Threshold]) and [Mileage at Service] <=(90000+[Threshold])) ]]>
Custom
([Mileage at Service] >=(30000-[Threshold]) and [Mileage at Service] <=(30000+[T...
Customer ID - Ascending
Date of Service - Descending
First
1
First 1
Simple
>=
Cost of Service
True
fixed
2021-03-30 16:48:07
0
200
2021-03-30 16:48:07
2021-03-30 16:48:07
[Cost of Service] >= 200
Simple
>=
Sum_Cost of Service
True
fixed
2021-03-30 17:06:08
0
2000
2021-03-30 17:06:08
2021-03-30 17:06:08
[Sum_Cost of Service] >= 2000
CarMaintenanceService = "* Please consider taking advantage of our Comprehensive...
OilChange = "* As a thank you for being a loyal customer, get a free oil change ...
Allow
iVBORw0KGgoAAAANSUhEUgAAAP0AAAD9CAMAAABA64HOAAAAAXNSR0IArs4c6QAAAARnQU1BAACx
jwv8YQUAAAAzUExURQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAKMFRskAAAAQdFJOUwAQIDBAUGBwgI+fr7/P3+8jGoKKAAAACXBIWXMAAA7DAAAOwwHH
b6hkAAAG2klEQVR4Xu2d7ZaiMAyGB0EBBTv3f7WrkpmJ0ACzmzcpZ/P8VI5tbJs3TT/4CIIgCIIg
CIIgCIIgCIIg+H+ozl3fX2/XrqnoEyNOl64f7vfbo+iaPjKm6cfPH+79iT6Hc+p4wZ+pP9MXZlTN
Ww1eDBf6Ekpzo+IYo0nJ32RsfzLC27/qE5X1zmg3AKqeylzS0yMgmrztT1p6BE19pwJzjEj/18rG
PwYePYSlXqsCtPdfqQiBu4HwbBj/8MGoIdhRASIjPYjjtGX8w3x6VJmWfn4FdOevMnqz4EYPq7Li
8H4AO93N3vcCEH5UeY2dAxW+Hf3+SWov2mx4vC+gQ39nHRwBRr3VldG/cP0/7lMdOB1V1Yh94xGD
VXwnc6KaOGAT3a3j1/cbqoEnFdXFHEhY8Wv2xQDqwCLq31GtzflwGHt3kTPVxxSLGd0+PFTPNpm1
Rk01MqQEtSMcNL8Mh/9iz7RXmzI8/gMXr4dP5Oxj59Rbm0Lc3o6UEwJQAu2XVPsyHvoUEe7ISxtg
ktnKocxmhhvHlargyEBV8cBW9U6UYmQ4TfAmhnYBMq/nM5v7DciMx864JlGKUZGdMQU2AN5XCcCS
yr5ul7DJrl2zOcgqdkM/vgo6ybuj74MaYEdcgZfAzbg2odzu5kwSunOC2Mhgw4zfLHkwyXWtSjzQ
+I3Ob2P8anAL3rUlD7vUmmU5K6EP4qsglTyYBr11phbpZjHpqjMTi8F8Tau+vvf/wWzH7Kl9i3zS
zSfF17TD+KhIGgfrzcL1pRvu4zgO/cXH9B/M3E0QBEEQBEEQBEEQBEEQBCCq+tzSmrsqXdsUsEtp
leqC3bl4LfgPqDr8zpZbCYdxcqyey9ejlDMZ75ht3Ctoa/43u85I61Ce+TvPJ+tQ0NGEiY19Fcp4
L97NMD6gcKdiy8D8gEI5J7IeXKhSEwkB/TZRxtEEgu+nuNWYJe3mzbUU1Ph8HyWwWryYUg4lPWD7
CKG3nvDWLybiZ1qPPS3CD7sXcDBjgm1fBMchrPFLOJXzhG8eB8/AeOP7X7rxgkU6cF/EPEwhosfk
Dq5DRuqyH3ZgIeE3r7FRVoToMU9kkHjgUWUBfo8fRDWoTmGiZyd3E2yPvsFA24DLHfJgwjdFiZ6l
3E3wiIc+coPJnVGylR+KcxY9W7mbYGPNOb/JfJCZBy5G9LjcmS2ycEfrKnrWcjfBRY8+csFa7ia4
6Dn6PSZ3ppd+lSF6bL5purbIb7ZyW9PlcmfrfNnygZvf8/F5TwoQPRe5I5i7Bd+dLcGa3jzRwI4j
O/k9NvjMdcdd9JjcOUy0mei5LOh6yd0Eb3yH1XyuuR6bCdif7yB6fnI3wXPb5qLH5c4wxGcw0TMf
eSzecNpGwmpgLnpM7hx83hNH0fOVuwk2zTfufr4ed4I3vqnf43sT/bYNs4jHtAmY3DmmVXlu27Dx
eV7RM6XOqmG0rFM17dtrYm70AhkPmPCkawe/fKZqBjbiiwP7ck7hhZAlAct1SDd8lQXoZsddL4cr
AYQDdLon/m8AyNBRWv6Jeudn8U35aE893C7J/zuUA99DNf0DVd0/WNMr5xzYdP4YqGZ7juTwJzS7
/nG0/gtNzWdTyYOgGfDRTx4IRbfHM2jE0NanGWcTWdxZsKLiL63PXxldwV+gkvI9ul44JqT10m/D
4wJp+r54Rx3SelFP+JYSAHIAP79cHmi9vFWDp1kByAnkeTwGtF6uxNJDqCLnreZdH2i9vGQd1gMJ
6/OE9RwX6+eVUEa2fi42QOvl2TNY8eS/3VDx5GgHHOrLf/u8YKT1Uhu4RbqLa66Q1gsTSIPlnnzW
YvkaGaj1n2Pb0Pzym6azyH0Ol+UMt18WjLW+dMJ6JcL6gxHWKxHWH4ywXomw/mCE9UqE9QcjrFci
rD8YYb0SYf3BCOuVCOsPRlivRFh/MMJ6JQ5ovbzS/3ssFuh00TyecLwd6pp3gRztWI7uqazDDXzN
YX+4gznaNz3C956ron0DEL9uoXh0+/2LQ5w/f5Igdz8ZvfvwH0lX5TH/TdN1tycr8v/6Hob8/6fX
99f+grL9hxUFoCdAsAslZxjethTWC9ATIML6PGG9EWG9AD0BIqzPE9YbEdYL0BMgwvo8Yb0RYb0A
PQEirM8T1hsR1ucBV0Iu2PC9JfJJa3AlZOsNr3SWF7bkQ9IqyAUDUvgiYm4f/RoFMalreZc5f2kF
B/6mNKnr295lPr/ch8C3QP6Ud7J9a0t+Wc9g8OVP+Fu/GLfJ1GLAr6PkBx3Y12ZY3Kqd8veuqbO4
4iC5XOF/4b0/DXZDr+X9Lg3IW+PXaC5d/6I927T7F24FB0EQBEEQBEEQBEEQBIXw8fEHOYacMoaA
/4MAAAAASUVORK5CYII=
\lang1033\f0\par
}
]]>
Hi [First Name:A] [Last Name:A...
C:\Users\jqiu\AppData\Local\Temp\Engine_1276_6ae07554ec6f443ea25f7705d6009d4e_\Engine_7208_f6fb2d1ec5de43d28e28a448f4601132_.yxdb
Single
Report
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_261_start_file