rill icon indicating copy to clipboard operation
rill copied to clipboard

Pivot: Add pivot table to UI surface

Open djbarnwal opened this issue 1 year ago • 0 comments

Bugs

  • [ ] Expanding on a dimension without measure leads to a perpetual loading state

Pending Tasks (Sprint 3)

  • [x] P0: Add export button to the table (@ericpgreen2, https://github.com/rilldata/rill/pull/4414)
  • [ ] P0: Add styling to table as per mocks (@briangregoryholmes )
  • [ ] P0: Virtualize table columns (@briangregoryholmes )
  • [x] P0: Add infinite scrolling for rows (@djbarnwal )
  • [ ] P0: Add infinite scrolling for columns (@djbarnwal )

Later

  • [ ] P1: Add E2E test for all functionalities
  • [ ] P1: Query columns using IN instead of JOIN (@djbarnwal )
  • [ ] P1: Support Expand Visible to work on visible rows (@djbarnwal )
  • [ ] P1: Make table columns resizable (@briangregoryholmes)
  • [ ] P1: Support for transpose and metrics as rows
  • [x] P1: Column-width should not jump around when scrolling up/down and new pages are loaded
  • [ ] P2: Remove header for measure if only 1 measure is present in the table (@djbarnwal )

Out of scope

  • [ ] P1: Add subtotals for each column dimensions

Completed

  • [x] P0: Refactor table derived stores to work with multiple time dimensions (@djbarnwal )
  • [x] P0: Disable dragging of measures into rows (@briangregoryholmes )
  • [x] P0: Default sort time axes values by time instead of measure (@djbarnwal )
  • [x] P0: Integrate new filter system with Pivot tables (@AdityaHegde )
  • [x] P0: Add pivot state to proto (@AdityaHegde)
  • [x] P0: Integrate dimension threshold filters / having to pivot (@AdityaHegde )
  • [x] P0: Removing chips is buggy (@djbarnwal )
  • [x] P0: Row time dimensions are not restored on URL refresh (@AdityaHegde )
  • [x] P0: Add start pivot action button to TDD (@djbarnwal )
  • [x] P0: Support adding multiple time dimensions with different granularity (@briangregoryholmes )
  • [x] P0: Removing a column dimension after sorting crashes the app (@djbarnwal )
  • [x] P1: Format time dimension labels based on granularity as mentioned in mocks (@djbarnwal )
  • [x] P2: Update chip colors to new design system (@briangregoryholmes )
  • [x] P2: Add button to directly add measures/dimensions on pivot header (@briangregoryholmes )
  • [x] P2: Add search bar to the sidebar (@briangregoryholmes )

Deferred

  • [ ] P1: Make totals row, dimension columns and group totals column fixed (@briangregoryholmes )

djbarnwal avatar Jan 29 '24 21:01 djbarnwal