How to add a "street" field for each constituent in Analytics?

I couldn't find it either.  Was this an oversight?

Hi Tom (and Brian),

Thanks so much for reaching out with this question!

Hi , I am also interested in this. Analytics provided me with a much faster way to pull all the info I need for our weekly donation letter mail merge, but I also need the street address field. 

Look up how to add a Custom Category in Analytics. You only get 10 of them.

You will have to figure out the SQL query that gets you the data you seek. You should generally use secured Views instead of tables. And finally, you have to use an aggregation, e.g. MAX, so that the result set only has one row (per constituent in your case).

After you attempt to add a Custom Category, If Analytics fails to refresh the next time it should, that means you didn’t write the query correctly to only get one row.

If you use where primary_ind = 'Y' address you should get one per constituent (?)
Actually bi.VT_CUSTOMER has primary street address built in

Hi Thanh, Michelle, Brian,

Andy covered it below, but I'm curious, given the available Output Elements for address information, what brings you to Analytics to pull these outputs rather than using List Outputs? 

Thanks,
Chris

Hi Chris, I am pulling the total amount contributed by constituent for 4 specific funds from the past week. A pivot table in analytics makes this very easy. I alsp need their contact info for our mail merge (name, address, email) to send our donation letters. I figured out a work-around for the Street field. I saved a list from the pivot table and then used an output set to pull Street. If the widget and output set are both sorted the same (i.e. Id ascending), I can easily copy and paste the street columns from one excel sheet to the other. This might sound like a lot of leg work, but it's actually MUCH easier then what I was doing before. 

I'm still quite unfamilar with SQL, but I've figured out a work around. Hoping to dive into SQL some day!