Filter on time dimensions

Matthieu Corbeau

unread,

Feb 1, 2016, 11:18:17 AM2/1/16

to airbnb_panoramix

Hi folks,

Thanks for panoramix, it matches most of my needs out of the box, love it !

I have a question nethertheless regarding filtering on time dimensions. I store tags on my raw data in an isodate format (eg. "2016-01-12T00:00:00.000") and would like to filter around that dimension using panoramix filters such as :

tag_dim > "2016-01-12T00:00:00.000"

However so far I figured out there is only "in" and "not in" operators available out of the box

Am i doomed to build my csv list of dates by hand ?

Best,
mco

Maxime Beauchemin

unread,

Feb 1, 2016, 11:53:22 AM2/1/16

to airbnb_panoramix

Is this on top of Druid or a SQL database? I'm guessing Druid since there's a pretty obvious "Custom WHERE clause" field on the SQL side...

If it's Druid, how would you write the JSON query? I haven't seen a `>=` type operator in the query API docs. I'm sure there's a way, and we'll support this very soon.

Max

steffe...@clark.de

unread,

Apr 10, 2016, 4:43:18 AM4/10/16

to airbnb_caravel, airbnb_p...@googlegroups.com

We are in a similar position and would also add a more flexible time filter on the Dashboard itself, cause some guys are more challenged in configuring the slices.

I have played around with the generic filter. It is working on a date field in Postgres, but the values are displayed as Epoche(?) i.e. large numbers not formatted as date.

Some widget that may know how to a apply a time hierarchy Month, Week, Day, Hour, Minute to a field would be nice to have. Ideally with a period.

Btw. I think Caravel is great!

Steffen

steffe...@clark.de

unread,

Apr 10, 2016, 4:43:25 AM4/10/16

to airbnb_caravel, airbnb_p...@googlegroups.com

We are in a similar position and would also add a more flexible time filter on the Dashboard itself, cause some guys are more challenged in configuring the slices.

I have played around with the generic filter. It is working on a date field in Postgres, but the values are displayed as Epoche(?) i.e. large numbers not formatted as date.

Some widget that may know how to a apply a time hierarchy Month, Week, Day, Hour, Minute to a field would be nice to have. Ideally with a period.

Btw. I think Caravel is great!

Steffen

Am Montag, 1. Februar 2016 17:53:22 UTC+1 schrieb Maxime Beauchemin:

Reply all

Reply to author

Forward