Weekly Challenges
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
Challenge accepted!
Nice quick one, but good to work on graphing skills as I move away from Excel....
Good points from @ChristinaFPE (on "Split" under "Transforms") and from
(on "Offset" and "Stepsize" under "Spacing"). I hadn't noticed either of those before. Likes for both of you.
Spoiler
Process
- Join tables on field "State"
- Convert field "high.value" to number
- If "Region" is null, then rename as "Federal"
- GroupBy "Region" and "Year" and take average of "high.value"
- Cross-tab so that Year is in rows and Region in columns
- Create line chart with each region as its own layer
- Render so can display (below) full chart
Process
- Join tables on field "State"
- Convert field "high.value" to number
- If "Region" is null, then rename as "Federal"
- GroupBy "Region" and "Year" and take average of "high.value"
- Cross-tab so that Year is in rows and Region in columns
- Create line chart with each region as its own layer
- Render so can display (below) full chart
