Postgres SQL, Can filter on results less than 20 days but not results over 20 days

Asked Jun 27 '17 at 10:34

Active Jul 03 '17 at 17:42

Viewed 82 times

I have a dimension which I have declared called mystay_days_before_stay and I have created a tier to group this information. When I query for results over 19 days then the query crashes.

dimension: mystay_days_before_stay {
  label: "Days before Stay"
  view_label: "MyStay"
  type: number
  sql: cast(${TABLE}.properties ->> 'days_before_stay' as Int) ;;
}

dimension: mystay_days_before_stay_tier {
  type: tier
  tiers: [7,30,90]
  style: integer # the default value, could be excluded
  sql: ${mystay_days_before_stay} ;;
}

I am unsure as to why it only returns results up until 19 days on the filter.

edited Jul 03 '17 at 17:42

Will

4,299
5
32
50

asked Jun 27 '17 at 10:34

George123

2

What language is this ? – Oto Shavadze Jun 27 '17 at 11:02
Postgres SQL on Looker – George123 Jun 27 '17 at 11:25
1

Your LookML seems valid, if it runs when you're *not* filtering then it's mapping to your DB properly. When you say "the query crashes" what exactly happens, do you get an error or does it simply return an empty result? – Will Jul 03 '17 at 17:41
do yo have an error message to share? – Stephane Paquet Jul 03 '17 at 17:47
For those asking, the language is called [LookML](https://docs.looker.com/data-modeling/learning-lookml/what-is-lookml) – Will Jul 03 '17 at 18:32
Can you share the SQL query that Looker generates when you run the report that's failing? – nofinator Aug 01 '17 at 16:59

Postgres SQL, Can filter on results less than 20 days but not results over 20 days

0 Answers0