Skip to content
Workout Wednesday
  • Tableau Challenges
    • Challenge Insights
  • Power BI Challenges
  • Track & Review
    • Participant Overview
    • Track
  • Contributors
  • Meet The Community
  • Search
Workout Wednesday
  • Tableau Challenges
    • Challenge Insights
  • Power BI Challenges
  • Track & Review
    • Participant Overview
    • Track
  • Contributors
  • Meet The Community
  • Search

2019 Week 2: Order Sales Spread by Region

4 Comments / Tableau, Workout Wednesday / By Ann Jackson

Happy New Year!  It’s time for my first Workout Wednesday of 2019 and I hope you’re ready for a challenge.  This week I’ve decided to take inspiration from a trick or two from past workouts and combine them with some recent work I’ve been doing.  To be more specific, one thing about Tableau that I like is that you can set independent axes for continuous measures if you’ve got headers on the same shelf (rows or columns).  But what if you wanted to have independent axes and headers aren’t on the same shelf?  The workout this week explores that idea and puts it to the test – I’ll be honest, the jury is still out for me on if this works well with the Superstore data set, but I can absolutely see value in this if we were to have a similar metric with extremely varied ranges.

In addition to exploring how to get over that obstacle, I also wanted to play around with date filtering.  This week you’ll be exposed to a user-friendly calendar that doubles as a filter OR highlighter.  I’ve found that it represents a great way for end users to freely pick a single date, multiple dates, date ranges, random individual dates – pretty much any combination that they would like.  Calendars are also familiar visualizations of dates, so I think it’s quite comforting – and additionally it serves as another layer of information – when there isn’t any data, there isn’t a square for the date.

 

click to view on Tableau Public

Requirements

  • Dashboard size: 1200 x 800, jitterplots must be one sheet, everything else is up to you
  • Create a jitterplot that shows sales by order ID (no need to worry if your jitter isn’t exactly the same as mine)
    • Ensure that each plot behaves as if it has an “independent axis” and spans the extent of data within each region
  • Create a calendar view that can be used as a filter or a highlighter
    • When used as a filter, chosen dates will filter the jitterplot
    • When used as a highlighter, chosen dates will change to a darker color in jitterplot
  • Create a footnote that is responsive to the date selection
  • Create average line & callout that are responsive to date selection
  • Match colors & tooltips please 🙂

Dataset

This week uses the superstore dataset for Tableau 2018.3.  You can get it here at data.world

Attribute

When you publish your solution on Tableau Public make sure to take the time and include a link to the original inspiration.

Share

After you finish your workout, share on Twitter using the hashtag #WorkoutWednesday2019 and tag @AnnUJackson, @LukeStanke, @lorna_eden, and @curtisharris_!

Track your progress

Also, don’t forget to track your progress using this Workout Wednesday form.

Post navigation

← Previous Post
Next Post →

4 thoughts on “2019 Week 2: Order Sales Spread by Region”

  1. MARCO DEGOLA
    January 22, 2019 at 5:22 pm

    Hi Ann,
    this was Extraordinary Interesting!!!!!

    I figured out almost everything but i HAD to look to your workbook for the damned INDEX() – i was using random()

    here’s my shot!

    https://public.tableau.com/profile/marcodegola#!/vizhome/ItalianWorkoutWednesday2019/2019w02-ww?publish=yes

    Reply
  2. Hatem Kotb
    January 27, 2019 at 4:28 pm

    Took me so much time to finish this. It was really worth it! The calendar filter/highlighter works beautifully with the scatter plot, will definitely use it more in the future! Thanks Ann!!

    Here’s mine: https://public.tableau.com/views/OrderSalesSpreadbyRegionWorkoutWednesday2019W2/OrderSalesSpreadbyRegionW2?:embed=y&:display_count=yes&publish=yes

    Reply
  3. Faisal Akbar
    February 15, 2019 at 9:12 pm

    Here is mine:
    https://public.tableau.com/views/WorkoutWednesday2019Week2_OrderSalesSpreadbyRegion/WorkoutWednesday2019Week2OrderSalesSpreadbyRegion?:embed=y&:display_count=yes&publish=yes

    Reply
  4. Jeremy Link
    February 25, 2019 at 3:51 pm

    Does anyone have a version of this that I could open (I am on Tableau 10.5.2). I have been trying a bunch of different things, but i am unable to figure out how to add the toggle that switches between the calendar acting as a filter vs highlighter. Thanks!

    Reply

Leave a Comment Cancel Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

#WOW2021

sarajlic_asimAnto Barić@sarajlic_asim·
2h

"Non paper" me podsjeća na ono kad nestane tariguza, a i česma pokvarena, pa kontaš daj šta daš, samo spasi. #BiH #Raspad #wow2021

Reply on Twitter 1381597090510475267Retweet on Twitter 1381597090510475267Like on Twitter 13815970905104752671
vinkaranvinodh venkatraman@vinkaran·
3h

#wow2021 #week12 #powerbi #customsorting
#PowerBI @JSBaucke, @MMarie, @shan_gsd @dataveld

Reply on Twitter 1381585622746419202Retweet on Twitter 1381585622746419202Like on Twitter 13815856227464192021
sue_bayessusan bayes@sue_bayes·
4h

#WOW2021 Week 10 #PowerBI Inspired by and motivated by @alexdupler , here's my week 10 submission. One and day and I'll be back on track @JSBaucke @MMarie @shan_gsd @dataveld. In my defence, had to learn about #paginatedreports which are very cool.
https://app.powerbi.com/view?r=eyJrIjoiYmMzZjkwYWUtNTA2NC00YzIxLWE5MTItYzVmNjEwNzFhYmQ5IiwidCI6IjIxNjk0MzYyLTI0ODItNDlhNC1iNjk1LThiODM2Y2ViMDg4MyJ9

Reply on Twitter 1381565474023047170Retweet on Twitter 1381565474023047170Like on Twitter 13815654740230471702
KAO79922715KAO@KAO79922715·
5h

My practice for #WOW2021 Week 6 | Tableau: Can you build a Fancy Text Table?

https://public.tableau.com/profile/christine.kao2744#!/vizhome/WorkoutWednesday2021Week6TableauCanyoubuildaFancyTextTable_16182217270020/1_1?publish=yes

#tableaupublic
thank you
#WOW2021 and @AnnUJackson, @ItsCandraM, @LukeStanke, @_Lorna_Brown and @HipsterVizNinja

Reply on Twitter 1381548780781068290Retweet on Twitter 1381548780781068290Like on Twitter 13815487807810682901
belinda_wetBelinda de Wet@belinda_wet·
6h

#WoW2021 W12 https://public.tableau.com/views/WoW2021W12/Dashboard?:language=en&:display_count=y&publish=yes&:origin=viz_share_link via @tableaupublic I learnt a lot on this one thank you @HipsterVizNinja :) @AnnUJackson @ItsCandraM @lukestanke @_Lorna_Brown

Reply on Twitter 1381535160991154180Retweet on Twitter 1381535160991154180Like on Twitter 13815351609911541801
Load More...

Recent Posts

  • 2021 Week 14 | Power BI: Accessibility Enhancements
  • 2021 Week 14 | Tableau: Can You Recommend Profitable Return Customer Bundles?
  • 2021 Week 13 | Tableau: What percentage of sub-orders are profitable?
  • 2021 Week 13 | Power BI: Create a Bubble Chart with a Custom Overlay
  • Week 12: Can you do Comparative Quantity Analysis?

Categories

  • community
  • Power BI
  • Solution
  • Tableau
  • Uncategorized
  • Workout Wednesday
April 2021
M T W T F S S
 1234
567891011
12131415161718
19202122232425
2627282930  
« Mar    

Tags

Actions bar chart calculations chart types cluster cohort Color Dates Distance dual axis emoji Extension formatting histogram Index KPI labels Level of Detail lods Log measure names Mobile parameter parameter actions Parameters pareto pictogram Power BI reference line Relationship retention set actions sets sheet swapping Small Multiples Solution sort sorting Spatial Tableau data model table calculation table calculations union window_sum workout
Supported By:




Copyright © 2021 Workout Wednesday
Scroll to Top