Enabling queries like DAY_OF_WEEK, WEEK_OF_MONTH etc

[akansal1]

Hi,

Currently Turnilo enables time split at intervals like P1D, P1W etc. but there are another type time bucketing that is enabled by plywood, under timepart category.

Such queries as are useful in creating insights at granularity such as hour_of_day, day_of_week etc.

[adrianmroz]

Sorry, I don't follow what's the issue/proposal? timePart is operator on time values, not dimension. You want to group by "day_of_week" and aggregate all mondays in one bucket and all tuesdays in another?

[akansal1]

it is a proposal, and yes I want to do something like that.

[adrianmroz]

Sounds interesting, but I don't think it aligns with what Split is, right now. This is more like dimension transformation, from time -> number. Of course, we could assign labels for numbers, but still this is some categorical value, with no date time meaning. It will certainly break a lot of assumptions inside turnilo right now - from conditions on continuous dimensions to time shift.

For start, I would experiment with this idea as separate dimension definition. If it works and proves to be useful, we could think about how to integrate in UI, so you won't need to define this in configuration and/or change "granularity".

[akansal1]

In that case, you may have to look at using virtual columns, that allow you to treat inferred or derived value as a dimension.

[mkuthan]

Interesting, you can configure additional dimension in the configuration file using Plywood formula like: formula: $time.timePart('DAY_OF_WEEK')

As a result there is a new numeric column with day of week :) Unfortunately it does not work for example dataset only for data from real Druid cluster.