search

RandomFractals / vscode-data-preview

Data Preview 🈸 extension for importing 📤 viewing 🔎 slicing 🔪 dicing 🎲 charting 📊 & exporting 📥 large JSON array/config, YAML, Apache Arrow, Avro, Parquet & Excel data files
https://marketplace.visualstudio.com/items?itemName=RandomFractalsInc.vscode-data-preview
Apache License 2.0
553 stars 59 forks source link

Sum without Group By? #207

Open canadaduane opened 4 years ago

canadaduane commented 4 years ago

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 commented 4 years ago

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 commented 1 year ago

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.