Questions tagged [aggregate]
Aggregate refers to the process of summarizing grouped data, commonly used in Statistics.
aggregate
8,378
questions
0
votes
0
answers
13
views
How to write a Case() SQL expression with an aggregated field (Sum) using Django's query builder
I am trying to recreate this SQL statement using Django's query builder:
CASE
WHEN sum(imps) = 0 THEN NULL
ELSE SUM(total_expenses) / (sum(imps) / 1000)
END as "cpm"
I have tried:
...
0
votes
3
answers
78
views
In excel I want to write a formula that when a number is presented its translated to text
I want a formula to do aggregate score between columns a,b,and c and when the aggregate is determined I want this to show different text depending on the number. 10 = Effective 8-9.9 = Needs ...
0
votes
0
answers
20
views
GeoLocation Data Processing
I am working on application related to GeoFencing software.I am recieiving realtime location Coordinates data from mobile GPS,which I am processing in Backend server and storing in Database server.I ...
2
votes
5
answers
112
views
How to optimise an aggregation function with conditions?
I have an aggregation function that sums groups of data then creates a flag based on a set of conditions and assigns that to the group. The issue is that there is a large number of groups to aggregate ...
0
votes
1
answer
40
views
Calculate multiple aggregations on several variables
I use to calculate a short summary table this way:
library(data.table)
library(tidyverse)
mtcars.dt <- data.table(mtcars)
mtcars_grby <- mtcars.dt %>%
# group by cyl
group_by(cyl) %>%...
0
votes
0
answers
37
views
mongodb query $match if tenary to field
i have a query in mongodb, i want to get from collection by specific field the field is "private.group" and its boolean.
i want the $match will be dynamic to pass is as varible (pass is true ...
0
votes
1
answer
19
views
KafkaStream aggregations with progressively restricting keys
I'm struggling with the logic behind kafkastream on the aggregations.
I have records with string keys in the form of A_B_C and values that are basically a int value and i want to progressively ...
0
votes
0
answers
25
views
PostgreSQL Partial and Parallel Aggregation
I am writing custom aggregation. I have written it in C with internal data type and PL/Pgsql. It seems that aggregate written in C is significantly faster than one written in PL/Pgsql. For me, I would ...
0
votes
1
answer
24
views
$filter is not allowed or the syntax is incorrect
I have some customers details. The schema is as below:
const CustSchema=new Schema({
cust_name:{
type:String,
required:true
},
email:{
type:String,
...
1
vote
2
answers
46k
views
ClickHouse Column xxx is not under aggregate function and not in GROUP BY keys
I had an instance of ClickHouse 24.1.1.2408 and recently founded another instance 24.3.2.23 for transferring, found difference behavior processing column alias of aggregation, I was wondering if i ...
1
vote
0
answers
33
views
Citus Scaling Custom Aggregation
I have implemented custom aggregation in regular PostgreSQL, which is partially aggregates and is parallelized. It also runs on the whole table. Now, I am trying to use citus to distribute the table ...
0
votes
2
answers
52
views
Aggregate filtered data from column in dataset in R
I have a dataset in R similar to this
df
day team data
1 A 5
1 B 2
1 C 1
2 A 2
2 B 3
2 C 1
3 A 0
3 B 2
3 C 1
... ....
0
votes
1
answer
24
views
Django models - How to Aggregate Many-to-Many Related Objects into Arrays?
so I started working with Django recently, I'm having a case of many-to-many relationship between Book and Author -as simple example- a book could have multiple authors.
class Book(models.Model):
...
0
votes
1
answer
21
views
Grouping a dataframe in R by multiply columns and performing calculations on grouped data
I have a dataframe df in R of sports teams, including a column Season, Date, and Goals for every match, like so:
Season Date Home Away Goals
1 2013 06/04/2013 Arsenal Chelsea ...
0
votes
0
answers
19
views
Kendo Grid UI getting sum to remain in same place on screen
I am wanting to create a table that calls an API and generate values. IT will then calculate a sum that will be at the bottom of the table. The grid has a horizontal scroll and I am wanting it to when ...