Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Data Analysis Data Analysis Basics Getting to Know Your Data Charting Our Data: Part 1

Posted by Hayder Morsel
Hayder Morsel
3,055 Points

There doesn't seem to be an 'aggregate column' option in the chart setup menu?

I've followed all the steps so far, selected the s column for official time and selected all the way down when I click chart I get the 3 options to switch rows/columns, use row 1 as headers, use column S as labels, but there isn't an option for aggregate column

2 Answers

Haben Gebremeskel
seal-mask
.a{fill-rule:evenodd;}techdegree
Haben Gebremeskel
Python Development Techdegree Student 2,692 Points
Haben Gebremeskel
.a{fill-rule:evenodd;}techdegree
Haben Gebremeskel
Python Development Techdegree Student 2,692 Points

You can easily fix this by "CHECKING" the Switch rows / columns box. After that you will see the Aggregate check box right under the bolded X-axis section, make sure to click that Aggregate box. After that re-click the Switch rows / columns box you clicked earlier. And your done!

Alex Ng
Alex Ng
11,245 Points
Alex Ng
Alex Ng
11,245 Points

Hi Hayder,

I'm not sure when the change was made, but I see the option has disappeared for me as well. I believe they removed the option because there are aggregate functions that would achieve that result and they may have considered it redundant. They may also have decided to break down the option into smaller pieces so that users would have more fine control over their sheets.

In the example in the video the initial chart displays no data. However, when I follow the step this time it shows me a chart with data in it. I'm guessing this is what you see too. Examining the data, we can see that it shows finishing times on the y-axis by default. But the example int he video indicates that we want the finishing times to be along the x-axis.

To try and achieve the same result, I selected the "switch rows and columns". At this point I noticed that it still did not achieve the same result as in the video. I did, however, notice that in the chart editor box there is a new set of options. One of those options is "aggregate". When that box is checked, it will show you a chart that is identical to the one shown in the example.

You should be able to continue with the section.

Warning: It seems the data that is currently available for download is different than the data being used in the example. For instance, in the next few sections the instructor will use "counties" to calculate the number of finishers in 10 minute intervals. When he runs the resultant equation he gets a result of "2" runners who finished between 2 hours and 2 hours 10 minutes. However, the result for the download in part 1 of this course that is available at the time I'm posting this indicates 14 runners who finished in that range. Keep in mind variations in the data you're examining and double check if you feel you've gotten a result that differs from eh example because your realists may not be wrong.

Good luck! Don't forget to mark this as the best answer if you feel it is. Thanks!