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

Sum without Group By? #207

Open
canadaduane opened this issue Jul 12, 2020 · 2 comments
Open

Sum without Group By? #207

canadaduane opened this issue Jul 12, 2020 · 2 comments
Labels
enhancement New feature or request UX User Experience enhancement

Comments

@canadaduane
Copy link

canadaduane commented Jul 12, 2020

Thank you for this great tool!

I'd like to see the summation of a column without grouping it by any particular column. Is this possible in grid view?

image

i.e. Is there a way to see the sum total of the "Hours" column?

Similar to #193 I think, but without grouping.

@RandomFractals RandomFractals added enhancement New feature or request UX User Experience enhancement labels Aug 3, 2020
@RandomFractals
Copy link
Owner

This would require summary rows display. I am not sure the latest v. of perspective js lib I am using for the data grid display has that option, but I'll look into it.

Thanks for your feedback.

@texastoland
Copy link

texastoland commented Jun 2, 2023

It looks like finos/perspective#1208 is still open. I found a workaround if you're interested. You could add a hidden column with no data. Then render a second table that groups by that column. Its columns would expose the aggregate functions like normal.

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

No branches or pull requests

3 participants