@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
-
@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 …
-
-
@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 … -
@chrismetcalf@Geek_Nurse awesome. Thanks Chris
End of conversation
New conversation -
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.