@chrismetcalf any way to use @socrata API to
- group by MM/YY from a timestamp column?
- get rid of 1k limit on group qries?
cc @Geek_Nurse
-
-
Replying to @skram
@skram@Geek_Nurse For grouping, you can use the “date_trunc_ym” function. I’ll get that in the docs: https://www.runscope.com/public/bff63de8-1862-45a9-888d-2b10741eacfa/ec2bdde1-06ea-4d2a-a6e1-d6c74fc127d6 …1 reply 0 retweets 1 like -
Replying to @chrismetcalf
@chrismetcalf@geek_nurse awesome, Chris. Super helpful!1 reply 0 retweets 0 likes -
Replying to @skram
@skram@geek_nurse FYI, I put up a cookbook example for the date trunc aggregations: http://dev.socrata.com/consumers/cookbooks/aggregating-by-month-day-or-year.html …1 reply 0 retweets 0 likes
Replying to @chrismetcalf
@chrismetcalf @Geek_Nurse awesome. Thanks Chris
1:13 PM - 8 Sep 2014
0 replies
0 retweets
0 likes
Loading seems to be taking a while.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.