About Guy_Srinivasan

Guy_Srinivasan · 10-27-2020

I’m trying to construct a query dynamically in Python and provide a link to it as part of some output. I’m posting to [url]/api/3.1/queries with body equivalent to{'model': 'company_investigations', 'view': 'investigations', 'fields': ['a_bunch.of_fi...

Guy_Srinivasan · 03-03-2020

I’m trying to add a custom dimension to bucket days by groups of three and still have the column values be dates, not a number. add_days(-round(diff_days(${investigations.created_date}, now()) / 3, 0) * 3, now()) This produces the following sql (for ...

Guy_Srinivasan · 10-27-2020

Answer: we want the dynamic_fields value to be a _string_ which can be parsed as json, rather than being a json object itself.dynamic_fields = [ { 'dimension': 'cheap', 'label': 'Cheap', 'expression': '${a_table.dollar_value} <= 25', '_kind_hint': 'd...

Guy_Srinivasan · 10-27-2020

From the logs: Java::JavaSql::SQLSyntaxErrorException: (conn=112875697) Unknown column 'dimension' in 'field list': INSERT INTO `query` (`view`, `fields`, `filters`, `limit`, `dynamic_fields`, `query_timezone`, `model`, `hash`, `slug`, `created_at`) ...

My Stats

EliasP's Bio

Badges Guy_Srinivasan Earned

Recent Activity

How to create a query with custom dimensions via the API?

add_days produces erroring DATEADD

Re: How to create a query with custom dimensions via the API?

Re: How to create a query with custom dimensions via the API?