Ability to show funnels by date range group by day, hour.
Closed this issue · 8 comments
As an analysts, i created a funnel by selecting the collection, related fields and date range from date picker. Once the base funnel is created i want to group by dimensions like OS, Platform etc and then further see the distribution by day, hour.
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
@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.
Can you show a mock up how time bucketing is done on these funnels?
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.
The feature is implemented.
Group by time isnt working
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.
Thanks for the bug report @saloni2409 , I fixed it in master.