Challenge #91: Getting into the Weeds

[kelly_gilbert]

Whew, this one was a doozy! I got some good practice on interface tools and reporting tools!

I did a few things differently than the solution in prepping the data:

Spoiler

* Grouped on year based on DATE (not on filename), since the 2012 file contains 2011 and 2012 data
* Stacked the primary and secondary weed types (the solution uses only the primary weed)

* I wasn't sure how to summarize the data, since there were multiple records per route and weed type. I tried looking around the CDOT website, but couldn't get a detailed explanation of the fields. I summarized by route and weed two ways:
    1) max coverage across the route -- OR --
    2) weighted average coverage using the coverage upper bound and length of road (for example, if the total route is 10 miles,and 2 miles had 0-20% coverage and 8 miles had 20-40% coverage, then the weighted average would be (2 * 20% + 8 * 40%) / 10 = 36% weighted coverage)

Interface:

Spoiler

Output:

Spoiler

Workflow:

Spoiler

Data prep



Inputs/interface prep


Chart output:




Table and map output:

[ipeng]

My app is pretty basic but it does the work

[RichoBsJ]

Hi! Here my solution :)

[JoshuaGostick]

Struggled to recreate the chart using the Interactive Chart tool so decided to produce another table instead.

Spoiler

[HuwHallam]

My solution - finally got there!

[TimothyManning]

Spoiler

Used the new interactive chart tool! Not super intuitive, but I managed it in the end

[RolandSchubert]

Again a chance to practice reporting tools ... and some other, I don't use daily

Spoiler

[RWvanLeeuwen]

I spent too much time figuring out that I can't build that side-by-side bar graph in Alteryx. Unless anyone figured out how to do it, I will stick with Tableau for visualisations. At least, I tried to batch build line charts (more suitable  in my opinion) and the percentages are from centered values from within the ranges.

Here's my take

Spoiler

[Eleonora]

Nice practice off interface and reporting tools

Spoiler