{"id":234,"date":"2017-08-19T00:25:01","date_gmt":"2017-08-19T00:25:01","guid":{"rendered":"https:\/\/www.datahasbyte.com\/?p=234"},"modified":"2017-08-19T00:25:01","modified_gmt":"2017-08-19T00:25:01","slug":"234","status":"publish","type":"post","link":"https:\/\/www.a-j-c.com\/welcome\/2017\/08\/19\/234\/","title":{"rendered":""},"content":{"rendered":"<p><a href=\"http:\/\/www.vizwiz.com\/2017\/08\/home-prices.html\">Week 33<\/a> brought forth the challenge of moving the reference date for a Percent Change calculation based on a parameter. Along the way, <a href=\"https:\/\/twitter.com\/VizWizBI\">VizWizBI<\/a> put in the usual hidden gems and stumpers. The <a href=\"http:\/\/themarkscard.com\/2017\/06\/15\/how-has-your-home-price-changed\/\">inspiration<\/a> came from <a href=\"https:\/\/twitter.com\/Harris7Curtis\">Curtis Harris<\/a>.<\/p>\n<p>For me, it&#8217;s nice to see when I get to the end result and I&#8217;ve achieved the same result as the designer of the challenge via different means\/methods. I&#8217;m not always as efficient, but it certainly proves I&#8217;ve not just copied someone else&#8217;s work!<\/p>\n<p>First, I needed to figure out the value at the selected parameter date. Here&#8217;s where I fumbled the most to start. Eventually I landed on an LOD that got this for me.<\/p>\n<p id=\"kNWDKpU\"><img loading=\"lazy\" decoding=\"async\" width=\"268\" height=\"148\" class=\"alignnone size-full wp-image-236 \" src=\"https:\/\/www.a-j-c.com\/wp-content\/uploads\/2017\/08\/img_59978444d0089.png\" alt=\"\" \/><\/p>\n<p>From there, some simple math to get the Percent Change<\/p>\n<p id=\"IEExsSr\"><img loading=\"lazy\" decoding=\"async\" width=\"423\" height=\"94\" class=\"alignnone size-full wp-image-237 \" src=\"https:\/\/www.a-j-c.com\/wp-content\/uploads\/2017\/08\/img_599784684a808.png\" alt=\"\" srcset=\"https:\/\/www.a-j-c.com\/wp-content\/uploads\/2017\/08\/img_599784684a808.png 423w, https:\/\/www.a-j-c.com\/wp-content\/uploads\/2017\/08\/img_599784684a808-300x67.png 300w\" sizes=\"auto, (max-width: 423px) 100vw, 423px\" \/><\/p>\n<p>Reference lines gave me the intersection lines, and I got the dot at that point with this<\/p>\n<p id=\"RYpvERL\"><img loading=\"lazy\" decoding=\"async\" width=\"506\" height=\"88\" class=\"alignnone size-full wp-image-239 \" src=\"https:\/\/www.a-j-c.com\/wp-content\/uploads\/2017\/08\/img_599784afe0f8e.png\" alt=\"\" srcset=\"https:\/\/www.a-j-c.com\/wp-content\/uploads\/2017\/08\/img_599784afe0f8e.png 506w, https:\/\/www.a-j-c.com\/wp-content\/uploads\/2017\/08\/img_599784afe0f8e-300x52.png 300w\" sizes=\"auto, (max-width: 506px) 100vw, 506px\" \/><\/p>\n<p>And here it is!<\/p>\n<p><iframe loading=\"lazy\" src=\"https:\/\/public.tableau.com\/views\/WorkoutWednesday2017Week33\/ww33?:showVizHome=no&amp;:device=tablet&amp;:embed=true&amp;:toolbar=no&amp;:tabs=no\" width=\"600\" height=\"985\"><\/iframe><\/p>\n<p>Cheers!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Week 33 brought forth the challenge of moving the reference date for a Percent Change&#8230;<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[4],"tags":[15,19],"class_list":["post-234","post","type-post","status-publish","format-standard","hentry","category-viz","tag-tableau","tag-workout-wednesday"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/www.a-j-c.com\/welcome\/wp-json\/wp\/v2\/posts\/234","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.a-j-c.com\/welcome\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.a-j-c.com\/welcome\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.a-j-c.com\/welcome\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.a-j-c.com\/welcome\/wp-json\/wp\/v2\/comments?post=234"}],"version-history":[{"count":0,"href":"https:\/\/www.a-j-c.com\/welcome\/wp-json\/wp\/v2\/posts\/234\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.a-j-c.com\/welcome\/wp-json\/wp\/v2\/media?parent=234"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.a-j-c.com\/welcome\/wp-json\/wp\/v2\/categories?post=234"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.a-j-c.com\/welcome\/wp-json\/wp\/v2\/tags?post=234"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}