Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

sheet: add pivot table command (wrapper for SQL) #293

Open
liquidaty opened this issue Nov 19, 2024 · 1 comment
Open

sheet: add pivot table command (wrapper for SQL) #293

liquidaty opened this issue Nov 19, 2024 · 1 comment
Labels
enhancement New feature or request sheet issue related to sheet command

Comments

@liquidaty
Copy link
Owner

liquidaty commented Nov 19, 2024

How it works:

  1. User enters ":pivot-table" command
  2. User is prompted to provide SQL expressions defining:
    • the "group by" expression that defines the values that will be associated with each table row, which will be displayed in the first column of the output table
    • one or more aggregate "select" expressions that define additional columns
    • an optional "order by" expression
  3. From the above inputs, a SQL expression is constructed in the same form as can be used via zsv sql. The resulting table is shown in a new buffer

The new buffer should support drill-down links as described in #294

@liquidaty liquidaty added enhancement New feature or request sheet issue related to sheet command labels Nov 19, 2024
@liquidaty
Copy link
Owner Author

Basic form of this in mysheet_extension.c

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request sheet issue related to sheet command
Projects
None yet
Development

No branches or pull requests

1 participant