October 13, 2020
#WorkoutWednesday 2020 Week 42: Can you build a Strava Workout Calendar?
Introduction
Requirements
- Dashboard size: 1680 x 1020
- Max 3 sheets
- Max 1 text box
- Joins are not permitted
- Data model is not permitted
- They MUST be separate data sources.
- No annotations
- No text boxes on the main chart
- No floating objects
- No Level of Detail expressions
- Remove highlighting from anything you can click
- Match formatting and tooltips
- The blue hex code is #0070A0.
- The blue bars on the upper right are the weekly number of hours spent exercising.
- The black bars in the main chart are the daily hours spent exercising.
- Any days when I did not exercise should have zero hours displayed.
- Allow scrolling through the years
Dataset
Attribution
Share
Solution
May 2, 2013
Tableau Tip: Creating a primary group from a secondary data source
Mike Roberts, our Tableau consultant from InterWorks was helping one of our users last week and sent along a great tip for creating a field in your PRIMARY data source with a field in your SECONDARY data source.
Step 1: Add ‘Helper’ sheet and drag desired field from your PRIMARY source on to the ROWS shelf.
Step 2: Add matching field from SECONDARY data source and nest it next to the existing field on the ROWS shelf.
Step 3: Right-click the SECONDARY field on the ROWS shelf and select ‘Create Primary Group’.
NOTE: make sure you check the Include ‘Other’ check box
Step 4: Verify the group is now in your PRIMARY data source.
That’s it! You no longer need to blend or use the SECONDARY SOURCE field.
There is one gotcha to be aware of: If a record is added to the dimension you’re grouping in the primary data source, a new person in this example, you will have to regenerate the group or the new person will automatically get put into the “Other” group. Creating a primary group does not dynamically update.
April 18, 2012
Live Webinar: Atlanta Tableau User Group – April 26th 1-4pm
This month we will be making the ATUG meeting available as a webinar. The agenda includes:
- Blend This – Paul Lisborg, Newnan Utilities
- Parameter Madness – Andy Piper, Norfolk Southern
- Interactive Data Blending
- Dynamic Path Coloration
- Dynamic Table Creation
This will be a hands-on session, so have your laptop and Tableau ready to go.
Webinar details
Meeting Number: 715 959 099
Meeting Password: atug
To join this meeting (Now from mobile devices!)
- Go to https://nsc.webex.com/nsc/j.php?J=715959099
- If requested, enter your name and email address.
- If a password is required, enter the meeting password: atug
- Click "Join".
- Follow the instructions that appear on your screen.
Audio conference information
1-866-672-6771
User code 02 56 577#
April 14, 2012
Join us for the next ATUG meeting–April 26th, 1-4pm @ Norfolk Southern
Location
Norfolk Southern
1200 Peachtree NE, Peachtree Room - 2nd floor
Atlanta, GA 30309
Google Maps
RSVP: http://www.tableausoftware.com/learn/usergroups/atlanta-apr26-12
Agenda
- Blend This – Paul Lisborg, NetDirect
- Parameter Madness – Andy Piper, Newnan Utilities
- Interactive Data Blending
- Dynamic Path Coloration
- Dynamic Table Creation
++ Bring your laptop with Tableau, because this will be a hands-on session. ++
For more information, please contact John Hoover.
November 8, 2011
Batch Geocoding: Convert addresses or locations into latitude-longitude coordinate pairs
I’ve been adding customers to the Penetration Reporting I presented at TCC11 (word is spreading and people love it!), but there are often records in our internal systems that do not match up with the master address list for our customers from Nielsen Spectra.
One of the great features of Tableau is data blending and this project is a perfect example of how you might use it. I have my sales and internal customer list in SQL server, but the location information, including latitude/longitude are in an Excel file. Tableau allows me to integrate these data sources via a key field, store number in this case.
As I referred to earlier, this works perfectly for ~95% of the records, but there are ALWAYS stores in our internal system that do not exist in Spectra. Here’s a sample of missing stores:
To prepare the data to address this problem I take the following steps:
- Concatenate the address fields together in Excel with the formula CONCATENATE(TRIM(Address)," ,",TRIM(City),",",TRIM(State)," ",TRIM(Zip))
- Copy all of the rows in the new “Full Address” column
Now the fun and magical part begins. A colleague led me to the tool Batch Geocoding, which basically takes text strings and returns the latitude/longitude coordinates. Here’s how it works:
- In the “Input” box, paste the data you copied from Excel above
- Choose your output format and click the “geocode” button
- Watch the magic as the tool populates the Output box.
- Copy all records from the Output box and paste into Notepad
- Save the Notepad file in txt format
- Open the TXT file in Excel
- Copy the records from the TXT file and append to the end of the master customer list from Spectra
That’s it! So simple! I have no idea how it works, but it does. Of course, it’s not going to be 100% accurate, because the addresses may not exist, but it does tell you how well it was able to match the records.
Definitely keep this link in your toolkit. I’ve also added a link on the right side of this blog under “Useful Data Sources”.
