Summarize_Try_It Target Solutions

*Posted the wrong file! Just updated the attachment*

Hey everyone! I'm cruising through the "Getting Started" learning path and I thought that I was hitting a roadblock while completing the "Summarize Try It" hands module. However, after reviewing the solutions, I realized that my answers were correct. That being said, two of the target outputs are either incorrect or are based off of old data (maybe they just need to be updated?).

I mainly wanted to flag this because I can't be the only person that had this issue, especially for us newbies. I've attached a copy of my workflow, making note of which target outputs are incorrect. I also triple-checked to make sure that I didn't accidentally make a mistake, lol.

summarize_try_it.yxmd

Workflow

Help

Accepted answers

BrianR

Hi @AllyW86 - for the Aggregations involving Median - try sorting the data first...for example, on the example where the Target is expecting 54777.165 as the Median_Total Pay, if you throw a Sort (Ascending) on Total Pay prior to the Summarize tool, you should get the matching answer. Slightly different for the example where it's asking for Total Pay by Agency. It looks like the Target was derived by performing the aggregations, and then sorting by Agency. Good find however, you are correct in your assumptions that this example could be worded a bit better, perhaps with a few more qualifying "hints". My guess is that when building these examples, a sort was applied to the source data.

All comments

binu_acs

@AllyW86 can you upload the csv file as well?

Done!

Hey @BrianR ! That does make sense and I originally tried to do that and for some reason it still didn't work 🤔. It's possible that I sorted on the wrong column - thanks!

AllyW86

@BrianR The addition of the Sort tool for one of them worked, but for whatever reason, the other one just will not sort in ascending order. Oh well, the troubleshooting was fun, but this is not the hill I want to die on 😁

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703