Challenge #91: Getting into the Weeds

[Carolyn]

Solved. I changed all the 2011 dates to 2012.... not sure if that was correct

Spoiler

Workflow (sorry it's so small - on a tiny laptop screen)

App selection:

App Results:

[Erin]

Spoiler

Yay Batch Reporting!

[JBevan89]

Great Challenge.

With the interactive chart tool I struggled to have it grouped by year in the x-axis.  It is a fine bar chart tho.

[RebekaMazuchova]

:)

[Will_Condon]

Prepping for Advanced Cert.

Significant differences from ChristineB solution:

-Used Date_ field for year instead of last 4 of input file name. Changed 2011 to 2012 in formula.

-Created external source Name-Value files for Route and **bleep** Drop down lists.

-Did not create a cross tab for Route search report..  Summary sufficed.

-Used Multi-Field tool to Rename Year Coverage heading instead of Table tool.

-Rendered HTML for output.

-Could not tilt Year on Bar Chart at same degrees.

App Workflow

Spoiler

 

Interface and Report Spoiler

Spoiler