Mark Silverberg

@chrismetcalf such as having examples like this on each dataset's foundry "page"?

@chrismetcalf not sure I understand the issue. The custom dimensions should be able to be added like this to https://github.com/socrata/labs-common/blob/master/js/lib/ga-tracking.js#L11 ``` javascript var regexMatches = /#\/(.*)\/([a-z0-9]{4}-[a-z0-9]{4})/.exec(location.hash) vargaCustomDimensions = {} gaCustomDimensions.dimension1...

Right - I could be wrong but I think the solution is to just put them right before the `send` like this example: https://support.google.com/analytics/answer/2709828?hl=en#collection

Hi @marklar423 - it seems like the part of your query that is having issues is the `$group`. What are you trying to do so maybe I or someone else...

Hey @marklar423 - Yes, I do think an aggregate function is required with `$group` but when I try `https://data.cityofnewyork.us/resource/8h5j-fqxa.json?$select=document_id,count(document_id)&$group=document_id` it doesnt work either. Sorry but it looks like there might...

@marklar423 - Please try `https://data.cityofnewyork.us/resource/8h5j-fqxa.json?$where=(street_name+=+%27EAST+15%27)&$select=document_id,count(document_id)&$$pipe=false&$group=document_id` -- the `$$pipe=false` has been explained to me as necessary for a bug we have identified in our stack. Thanks and let me know how...

seems as easy as `=ImportData("https://soda.demo.socrata.com/api/views/4tka-6guv/rows.csv?accessType=DOWNLOAD"` -- should I try to write up a blog post with narrative and animated GIF?

@adamajm you should be able to pass your username and password in the URL in HTTP Basic Auth fashion Example here: http://stackoverflow.com/questions/2716990/http-basic-authentication-credentials-passed-in-url-and-encryption

@gmichaud @adamajm it looks like Google Sheets' `importData(...)` does _not_ support HTTP Basic Auth. Luckily, others have needed this and documented how to do it at https://www.redfin.com/devblog/2012/04/when_importdata_isnt_good_enough_retrieving_csv_files_behind_basic_auth_with_a_google_apps_script.html LMK if you...

@philippkueng - nevermind.. apparently package_provision.sh is used, not provision.sh. What's the difference? Thanks!