@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 …
@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
-
-
-
@chrismetcalf@geek_nurse awesome, Chris. Super helpful! - Show replies
New conversation -
-
-
@skram@Geek_Nurse For the 1K limit, you can raise it up to 10K with the$limit parameter: https://www.runscope.com/public/bff63de8-1862-45a9-888d-2b10741eacfa/eeee35b7-4fbb-456c-b817-2cb248c4b536 …Thanks. Twitter will use this to make your timeline better. UndoUndo
-
-
-
@Geek_Nurse@skram FYI, the “cookbooks” are designed for community submissions, so if you’ve got tricks you like, I’m accepting PRs. :) -
@chrismetcalf@geek_nurse one more quick questions from your friends@SocialHealthIs — does SoQL support LIKE queries? thought it did - Show replies
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.