I opened you book - you have species on rows and that is why it is creating all the individual charts
place species on filter and then show filter and select what you want to see
Tableau has a complete video tutorial on line at Tableau Training: View Training Courses
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
I tried going back to the original non-transposed chart which had species
as columns, but that prevents me from creating an individual chart that
shows trends in bird numbers over time. Instead, I get one chart for each
year that shows the population for each species in that year.
Right now, each species shows up as a Measure and Year shows up as a
Dimension. Do I flip all the species into the Measures box or something?
On Fri, Jan 4, 2019 at 1:54 PM Jim Dehner <firstname.lastname@example.org>
Thanks, I think I figured it out after I watched the tutorial and realized
just how snazzy that pivot function was.
I also had this crazy idea to try and scrape a bird profile from another
website and have it pop up a picture of each bird when you click on it. Any
good way to do that? I'm guessing I could grab a bunch of picts, put them
in some kind of spreadsheet and put the spreadsheet on the thing?
Also, if I ever go back and update the excel file, do I have to reimport it
into Tableau for the new data to show up?
On Fri, Jan 4, 2019 at 5:24 PM Jim Dehner <email@example.com>
A few things here ....
- Fusion tables disappear at the end of the year, so use something else (even Google Sheets) for the data instead
- Pivotting is a good idea, so you have 1 column for Year, 1 column for Speces/Bird name and 1 column for Count/Sightings
- You don't have to download images, you just need the URL for the image and use that in the pic.
- Because you're using an extract, when you change the Excel data you just need to refresh the extract again.
Okay, I think I got something that's hideous and functional. (
Is there a better way to do the little species selection menu thing? All I
did was create a sheet with the species name field and link it to the line
graph. Also, how can i have it not show those ABCs after the names?
Yeah, I'm doing this in tableau since fusion tables is blowing up.
Thanks for your continued support!
On Sat, Jan 5, 2019 at 10:54 PM Chris McClellan <
Use a filter instead of another sheet
Check my attached workbook, You can select which birds to see and if you choose the Bald Eagel, Boreal Owl, or Common Raven you get the image of the bird - you have to click on the line in the graph for this to work.
You would usually have the URL in your input data as well.
For some reason when I open the attached book and click on the lines for
the birds you mentioned I don't get a picture. Also, not sure how to get
the big list of bird names to show up as a filter rather than a sheet.
(I've been using Tableau for all of a day at this point if it matters.)
So for pictures I'm guessing I add a new column to the data source, throw
in a URL for each species pict, and then drag the pictures column onto
I'll keep digging through tutorials to see if I can find answer there. (For
some reason the vids on teh Tableau Training site show up blank; no vid but
I got sound?)
On Sun, Jan 6, 2019 at 12:29 AM Chris McClellan <