{"id":168,"date":"2017-04-22T22:29:32","date_gmt":"2017-04-22T22:29:32","guid":{"rendered":"https:\/\/www.datahasbyte.com\/?p=168"},"modified":"2017-04-22T22:29:32","modified_gmt":"2017-04-22T22:29:32","slug":"workout-wednesday-week-16-bollinger-bands","status":"publish","type":"post","link":"https:\/\/www.a-j-c.com\/welcome\/2017\/04\/22\/workout-wednesday-week-16-bollinger-bands\/","title":{"rendered":"Workout Wednesday Week 16: Bollinger Bands"},"content":{"rendered":"<p>Ahhh, <a href=\"http:\/\/www.womanindata.co.uk\/2017\/04\/workoutwednesday-should-i-buy-tableau.html\">week 16&#8217;s challenge<\/a>\u00a0takes me back to my early days with Tableau. My eagerness to master Tableau had me watching all of the Tableau-provided training videos. I&#8217;d recalled the Bollinger Bands charts from the advanced charting section. I do a bit of financial analysis at my day job, but I&#8217;d not yet put one of these to use within Tableau. Knowing fully how well Tableau handles moving averages with table calcs, I figured this to be a breeze.<\/p>\n<p>&nbsp;<\/p>\n<p><iframe loading=\"lazy\" src=\"https:\/\/public.tableau.com\/views\/WorkoutWednesday2017Week16\/OriginalDb?:showVizHome=no&amp;:device=tablet&amp;:embed=true&amp;:toolbar=no&amp;:tabs=no&amp;:tooltip=no\" width=\"600\" height=\"960\"><\/iframe><\/p>\n<p><!--more--><\/p>\n<p>Turns out, I was actually right. This didn&#8217;t take me too much, and here I spent time just making sure I&#8217;d matched correctly each element of Emma&#8217;s workbook. I&#8217;ll admit, I had a little trouble making sure that I matched the switching from days to weeks properly, but this was sorted out in short order. Here&#8217;s how I achieved this:<\/p>\n<ol>\n<li>Created a custom date part for the just the week. Tableau makes this incredibly easy, not even a calculation to write.<br \/>\n<img loading=\"lazy\" decoding=\"async\" width=\"427\" height=\"263\" class=\"alignnone size-full wp-image-170 \" src=\"https:\/\/www.a-j-c.com\/wp-content\/uploads\/2017\/04\/img_58fbcfc6dbab7.png\" alt=\"\" srcset=\"https:\/\/www.a-j-c.com\/wp-content\/uploads\/2017\/04\/img_58fbcfc6dbab7.png 427w, https:\/\/www.a-j-c.com\/wp-content\/uploads\/2017\/04\/img_58fbcfc6dbab7-300x185.png 300w\" sizes=\"auto, (max-width: 427px) 100vw, 427px\" \/><\/p>\n<p id=\"HvlaWWq\"><img loading=\"lazy\" decoding=\"async\" width=\"318\" height=\"168\" class=\"alignnone size-full wp-image-171 \" src=\"https:\/\/www.a-j-c.com\/wp-content\/uploads\/2017\/04\/img_58fbcff67ff04.png\" alt=\"\" srcset=\"https:\/\/www.a-j-c.com\/wp-content\/uploads\/2017\/04\/img_58fbcff67ff04.png 318w, https:\/\/www.a-j-c.com\/wp-content\/uploads\/2017\/04\/img_58fbcff67ff04-300x158.png 300w\" sizes=\"auto, (max-width: 318px) 100vw, 318px\" \/><\/p>\n<\/li>\n<li>From here, just a short calculation to control the Parameter for Daily\/Weekly\n<p id=\"hMIAKBj\"><img decoding=\"async\" class=\"alignnone size-full wp-image-172 \" src=\"https:\/\/www.a-j-c.com\/wp-content\/uploads\/2017\/04\/img_58fbd188dc088.png\" alt=\"\" \/><\/p>\n<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<p>I like that this gives an answer to &#8216;should i buy or sell?&#8217;\u00a0But, I felt it&#8217;s still a bit of exploration to figure out the buy\/sell &#8211; both are red; I&#8217;d like the decision to really stand out for the user. Here&#8217;s what I quickly came up with as an alternative:<br \/>\n<iframe loading=\"lazy\" src=\"https:\/\/public.tableau.com\/views\/WorkoutWednesday2017Week16\/ModifiedDb?:showVizHome=no&amp;:device=tablet&amp;:embed=true&amp;:toolbar=no&amp;:tabs=no&amp;:tooltip=no\" width=\"600\" height=\"960\"><\/iframe><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ahhh, week 16&#8217;s challenge\u00a0takes me back to my early days with Tableau. My eagerness to&#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-168","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\/168","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=168"}],"version-history":[{"count":0,"href":"https:\/\/www.a-j-c.com\/welcome\/wp-json\/wp\/v2\/posts\/168\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.a-j-c.com\/welcome\/wp-json\/wp\/v2\/media?parent=168"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.a-j-c.com\/welcome\/wp-json\/wp\/v2\/categories?post=168"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.a-j-c.com\/welcome\/wp-json\/wp\/v2\/tags?post=168"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}