FAQ: Making Visualizations in Tableau - Dimensions & Measures in Action: Drag+Drop

[discourse-admin]

This community-built FAQ covers the “Dimensions & Measures in Action: Drag+Drop” exercise from the lesson “Making Visualizations in Tableau”.

Paths and Courses
This exercise can be found in the following Codecademy content:

[Beta] Learn Tableau for Data Visualization

FAQs on the exercise Dimensions & Measures in Action: Drag+Drop

There are currently no frequently asked questions associated with this exercise – that’s where you come in! You can contribute to this section by offering your own questions, answers, or clarifications on this exercise. Ask or answer a question by clicking reply () below.

If you’ve had an “aha” moment about the concepts, formatting, syntax, or anything else with this exercise, consider sharing those insights! Teaching others and answering their questions is one of the best ways to learn and stay sharp.

Join the Discussion. Help a fellow learner on their journey.

Ask or answer a question about this exercise by clicking reply () below!
You can also find further discussion and get answers to your questions over in #get-help.

Agree with a comment or answer? Like () to up-vote the contribution!

Need broader help or resources? Head to #get-help and #community:tips-and-resources. If you are wanting feedback or inspiration for a project, check out #project.

Looking for motivation to keep learning? Join our wider discussions in #community

Learn more about how to use this guide.

Found a bug? Report it online, or post in #community:Codecademy-Bug-Reporting

Have a question about your account or billing? Reach out to our customer support team!

None of the above? Find out where to ask other questions here!

[facundosagle]

I don’t understand the data in the .csv file, in the “Dimensions & Measures in Action : Drag+Drop” section refers to the Rotten Tomatoes % and Genre fields, which do not exist as stories in the dataset.

[lisalisaj]

If you take a look at the csv file, here, you’ll see that those two columns do exist.

[facundosagle]

Now that I have seen the .csv file, it does exist, but when I connect the data with Tableau it reads it to me incorrectly, as shown in the image. I don’t know what is the reason, if I connect it as a text file.

[lisalisaj]

I see genre there, but I can’t really tell from the image you provided as it’s cut off/incomplete.

[facundosagle]

Genre is present, but there is no field called “genre”, instead there is one called “Film,Genre,Lead”

[lisalisaj]

The commas (csv= comma separated values) denote the columns:

Film   Genre   Lead Studio   Audience score%  Profitability  Rotten Tomatoes %  Worldwide Gross  Year

27 Dresses Comedy Fox 71 5.3436218  40 160.308654 2008

(500) Days of Summer  Comedy  Fox 81  8.096  87  60.72  2009

etc.

One thing I’d do, is if you have access to Excel, open the file in Excel, clean it up and then “Save As” both a csv file and Excel file. You can load either into Tableau Public.

To save as Excel, Highlight all values in that web address:
1.)

2.) In Excel, select Paste Special, as Text, which will put all values in one column,

3.) With that whole column highlighted, go to the Data tab, choose “Text to columns”,
Select, Delimited, (next screen) Delimiter: Comma, (next screen): “General” as the data type in the cols, then finish.

It should look like this:

[facundosagle]

It worked for me! Thank you very much for the help