Ability to show funnels by date range group by day, hour. about rakam-api HOT 8 CLOSED

@kazim-i

We want the same functionality as "Segment->Time Period" that is available in Event explorer analysis in funnel. So requirements are:
a) Currently in funnel I cannot see the distribution of the funnel by day, hour, week etc.., We need to and this and support group by on these time buckets
b) We need to support multiple group by, e.g. I create a funnel group by "Mobile Platform" and then also see the distribution by different time buckets of day, hour, week, month

from rakam-api.

@rajivonat
It is possible to get the data as in the event explorer, but we can't display it as in the event explorer by nature. Unlike event explorer, funnel has multiple steps. Grouping by fields, time and funnel steps makes it 3 dimensional.

What we can propose is, let's say user started funneling and group by connection_type:

Then, they want to see further detail, here for example, in this image let's say they selected cable dsl

Here we can create another funnel by filtering with the selected column and make another funnel, easing the process. After user groups by one of the fields, we can add further grouping by time segments.

It is the same functionality, but this approach directs the user to the field of interest. User can repeat the process for all the fields they are interested in.

The same Please let me know if any further clarificaion needed.

from rakam-api.

Can you show a mock up how time bucketing is done on these funnels?

from rakam-api.

Hi Rajiv, I have done simple image editing, will try to explain step by step with a screenshot for each step.

Here in the first photo, user already made a simple funnel, they click group by to see the grouping on events by the returning_session property.

They got the results in this second photo, in order to make further analysis on events that are not returnin_session they click false.

Here the funnel gets repeated but this time sees the result filtered by false for the field returnin_session. In this subset they want to group by time.

A small time selector like this will be opened.

Assume they selected hour and the results are grouped in 2017-10-11 06:00:00.000000 and 2017-10-11 07:00:00.000000 , the result set user will see:

By doing this filtering we eliminated the impossibility of showing the results in all dimensions, creating a focused and clear result for the user.

from rakam-api.

The feature is implemented.

from rakam-api.

Group by time isnt working

from rakam-api.

Bug with group by time:

Steps to recreate the issue:
Group by time column and select any of the time options and query.
Now group by any other non-time column and try querying.

from rakam-api.

Thanks for the bug report @saloni2409 , I fixed it in master.

from rakam-api.