python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - aggregate

Aggregating Data in R while retaining other fields

I have a data file with 7 fields. I am trying to aggregate the data based on one field (Individual) and summarize the data by another field (Diameter). My new data file gets rid of the other 5 fields ...
test-img

jbryzek

r

aggregate

Votes: 0

Answers: 0

Group by multiple columns : SQL

I have a table : I have a query which gives me And I want something like this : Query used for above result is : select ucountry,sum(Males) Males,sum(females ) Females from ( ...
test-img

Durvesh Patil

sql

group-by

aggregate

Votes: 0

Answers: 3

Latest Answer

If you're trying to count the number of males and females in each country: select ucountry, sum(case when gender = 'M' then 1 else 0 end) as males, sum(case when gender = 'F' then 1 else 0 end) as fem...
test-img

Zakaria

Foundry-workshop : add average value on a chart displaying parameter evolution

I'm looking for a way to display a line showing the average value of a parameter in a chart dedicated to this parameter's evolution. I have a dataset, let's take as an example the following structure ...
test-img

Christophe

charts

aggregate

palantir-foundry

foundry-workshop

Votes: 0

Answers: 2

Latest Answer

There are a few considerations at play here with regards to building your charts that lead to different approaches when it comes to deciding how to represent your data. One point up front about charti...
test-img

Logan Rhyne

MongoDB Aggregate Group Results Query by Common Fields

Looking to figure out how to perform a particular grouping of Mongo documents through a query, instead of transforming the results through code after getting the data. Sample mock data: [ { 'id': ...
test-img

Biso

mongodb

mongoose

aggregate

Votes: 0

Answers: 1

Latest Answer

Try this one: db.collection.aggregate([ { $unset: "_id" }, { $group: { _id: "$name", data: { $push: "$$ROOT" } } }, { $project: { da...
test-img

Wernfried Domscheit

Posts

Questions

Blogs

Jobs