cube-js/cube

Funnels: add sorting by steps order

Open

#3,764 opened on Dec 3, 2021

View on GitHub
 (3 comments) (8 reactions) (0 assignees)Rust (1,965 forks)batch import
backend:serverhelp wanted

Repository metrics

Stars
 (19,563 stars)
PR merge metrics
 (Avg merge 5d 16h) (138 merged PRs in 30d)

Description

Currently funnels return results in unspecified order. Clients generally prefer to show results in accordance with steps order defined in the data schema. This is not currently possible without workarounds.

It would be nice to have a way to define sorting as 'steps ordering' and may be 'steps backwards ordering'. Funnels are most useful with natural steps ordering so this option should probably be enabled by default.

If step names alphabetical order corresponds to their logical order then it is possible to order them by name achieving the same effect. Usually this is not the case so step names should be changed accordingly which leads to additional processing on client to map step names to something more user friendly.

Contributor guide

Research direction
Explore the funnel query processing code to understand how results are currently returned without ordering. Identify the point where sorting by steps order can be applied. Consider implementing a parameter to choose between natural and reverse order.
Tech stack
rust
Domain
backend
Issue type
Feature
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
3
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
1-2 days
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
Active
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
Clear
Prerequisites
RustGit
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
60