Questions tagged [group-by]
The group-by tag has no usage guidance.
66
questions
0
votes
1
answer
39
views
SOQL check if unique value exists and throw error message
I want to check if all the records have the same values for "Group__c" field and throw a message if the values are different.
Example data:
If all the records are of the same group(Group-A ...
- 15
0
votes
0
answers
15
views
issue with dates when add dataset to dashboard and group by date
I have dashboard, which I built based on one dataset. Data is grouped by date (year-month), so measures are presented as 2021-01, 2021-02, 2021-03 etc. and all the history is available (2018-2021). ...
- 1
1
vote
0
answers
45
views
Visualforce table for aggregate result grouped by CreatedBy.Name
I'm trying to create a custom report table in Visualforce based on an aggregate result retrieved by the SOQL:
SELECT CreatedBy.Name, Description, SUM(Value1), SUM(Value2), SUM(Value3) FROM Object__c ...
- 11
0
votes
1
answer
248
views
Group By in SOQL query using calendar week from Sunday to Saturday
I have a query that I'm working on where I need to group by in a calendar week that starts on Sunday and ends on Saturday.
I was trying this: GROUP BY WEEK_IN_YEAR(Start_Time__c)
This was close, but ...
- 2,325
0
votes
1
answer
458
views
Using SAQL to place total at bottom of results instead of alphabetically ordered
I have a SAQL Query which takes a list and attempts to display a total row at the bottom.
However, the way that my code is written is causing the Total column to be alphabetically rearranged so that ...
- 5
0
votes
1
answer
148
views
marketing cloud - how to join my audience with subscribers having a distinct value [closed]
I have an audience in a table called wtab which contains a column mail,
and I want to join it with the subscribers data view without duplicates.
when I have one 1 column I can use the DISTINCT keyword ...
- 271
0
votes
1
answer
700
views
How to include a row with subtotals by second level group in Einstein Analytics using SAQL?
I would like to add a subtotal row at the bottom of a compare table in an Einstein Analytics dashboard. The table is made up of sums of measures grouped by two dimensions. The subtotals needed are ...
- 1
0
votes
1
answer
93
views
another GROUP and ORDER SOQL question
Honestly, I have never understood how the GROUP keyword works, I actually read many articles in the salesforce site; however, I still cannot really use this keyword properly, especially when it comes ...
- 1,410
-1
votes
1
answer
38
views
Apex TOP 20 Accounts grouped by text field
I would need support with my Apex Code.
I want to get the TOP 20 Accounts ordered by a Number field "Total Quantity" grouped by a text field "Country".
I need to get all the IDs of those accounts. ...
0
votes
0
answers
229
views
SOQL count number of grouped rows
Here's the gist of my query:
Select count(Id) from OBJECT where (yada yada) GROUP By Field1, Field2
It's returning 43 rows of Count(Id). Instead, I need it to return 43. I've seen others answer ...
- 1
15
votes
1
answer
423
views
Is Salesforce SOQL GROUP BY case sensitive for different locales?
Lets say I have records with values like 'TEST DATA' and 'test data' in some field. When I run SOQL (in Developer Console or from Apex) by user with EN locale, it arranges records with 'TEST DATA' and ...
- 153
0
votes
1
answer
317
views
Can you include only top 10 records in SOQL group?
I have the following Query
[Select Supplier__c, Avg(Total_Sales__c) from Submittal group by Supplier__c order by Purchase_Date__c DESC]
The issue is that I only want to include the latest 10 records ...
- 333
1
vote
1
answer
369
views
SOQL: Aggregate, Grouping By and WHERE Clauses not working
This query
SELECT Reason, COUNT(Id)
FROM Case
WHERE RecordType.DeveloperName = 'Problem' AND AccountId = 'xxxx'
AND GROUP BY Reason
is giving me
Unknown parsing error:
But when I run the ...
- 405
1
vote
2
answers
2k
views
Marketing Cloud -SQL Group BY
I have a table and I need to run some calculations on it for reporting purposes.
I want to add a row that measures counts by that month. And I'm attempting to use the following statement:
SELECT
...
- 13
1
vote
2
answers
137
views
Access SOQL results by grouped field
I'm attempting to aggregate all ObjectPermissions at the user level for a user access review (audit) application. This application's central function is to show an end-user (a reviewer) their reviewee'...
- 490
5
votes
3
answers
3k
views
What types of fields are groupable in a SOQL `GROUP BY` clause?
The Salesforce documentation is notably terse in describing Considerations When Using GROUP BY. The guidance provided for determining which fields can be grouped is simply:
The Field object ...
- 86.2k
3
votes
1
answer
518
views
error thrown while trying to do a group by
I'm trying to write a query that gives me the name of users and the total number of ids assigned to them.
Here I've Daily_Task__c a custom object with a lot of fields, here I'm trying to get the ...
- 31
2
votes
1
answer
673
views
Do custom metadata types not support COUNT(fieldName) with a GROUP BY?
Question title covers most of it. Here's a sample query and the error I receive in response:
SELECT COUNT(Id) FROM MyCustom__mdt GROUP BY MyField__c
field Id does not support aggregate operator ...
- 932
0
votes
1
answer
76
views
How do I create a chart with two lines, using grouping?
What I have: revenue data, summarized by calendar month. I have created a custom summary formula that totals the revenue for that month.
Over all data, I have created a second grouping, based on a ...
- 3,230
1
vote
0
answers
92
views
Group by, Complex query
I am trying to do a query that engloves two different querys, the idea is spend just one soql query instead two but I don´t find the way.
AggregateResult[] results = [
SELECT ...
- 355
1
vote
2
answers
6k
views
Formula field cannot be grouped in SOQL GROUP BY query call
I have a Pipeline__c object with fields Segment__c, Status__c, and Sales_Date__c (among many other fields).
I also have a Sub_Pipeline__c object which is related to Pipeline__c. Inside I have the ...
- 185
2
votes
1
answer
1k
views
SOQL aggregate functions do not work with Task.ActivityDate
When I try the following in the Query Editor of the Developer Console:
SELECT WhoID, COUNT(Id), MIN(ActivityDate), MAX(ActivityDate)
FROM Task
GROUP BY WhoID
LIMIT 1000
I get the following error:
...
- 424
3
votes
2
answers
13k
views
How to read field values from AggregateResult
I need to use group by cube to display the count of added services for each group for each package. I get an error on line 18: method does not exist or incorrect signature: void get(String) from the ...
- 81
2
votes
1
answer
78
views
Group By Cube on Related List
I need to do a group by cube on a related list. What I want is to display a list of added services groups and the distinct count across all completed inspections by package, and the matrix should have ...
- 81
1
vote
2
answers
816
views
CPQ - Template Section - Group Field - Sorting
I am in the process of using the Group Field in the Template Section object to Group a Line Items section, and am hitting an issue.
It seems to be grouping in alphabetical order of the picklist ...
- 11
0
votes
1
answer
36
views
List has more than 1 row for assignment to SObject error
Help please, I test the SOQL query in developer Console, and work as expected But, i get error message in the VF
My Controller is:
public class InventoryReport {
public List<...
2
votes
1
answer
787
views
Use SOQL aggregation result to count number of related objects
I have a fun puzzle here, and would like to see if anyone has a better solution. There are 3 objects: Account, Infusion__c, Patient__c. Infusion__c is a child of Accounts, and Infusion__c has a ...
- 101
5
votes
1
answer
172
views
Group By Child Objects
I'm facing some trouble to GROUP BY a SELECT with 2 Child Objects.
This is the following SELECT:
[SELECT
Id AtendId, BI_BR_Adabas__c, BI_BR_Adabas__r.BI_BR_Parceiro__c, BI_BR_Cliente__c,
...
- 166
1
vote
1
answer
611
views
SOQL record with highest value, GROUP BY not working
We have an object called "Compensation__c". This object contains the compensation a partner receives for selling a "Product2".
"Compensation__c" has a start date. Before this date this compensation ...
- 399
2
votes
1
answer
421
views
Group by part of string in SOQL
Is there any way to Group By part of string in SOQL.
For example something like:
Select Id, Name from Object__c group by Name.substringBetween('.','.')
So query by part of a string field and not ...
- 145
0
votes
1
answer
632
views
SOQL Group By Query
I am trying to include an additional currency field in the below Group By query, but receive SOQL error.
"Field must be grouped or aggregated".
Is it possible to add a Currency Field to a Group By ...
- 89
1
vote
0
answers
37
views
Salesforce google charts group by aggregate query not pulling appropriate results
Set<Id> realBy = new Set<Id>();
for (Projects__c vP1 : [SELECT Id,Name,(SELECT Id, Total_Value__c FROM Proj_Upd__r
WHERE ...
- 43
1
vote
1
answer
99
views
Report Grouping by Date
I'm relatively new to SF but gaining steam quickly. I've got Opportunities that include a contract start date and contact end date and I am trying to create a report that summarizes who we have ...
- 11
0
votes
1
answer
2k
views
Group By in Soql
I need to group data on the basis of two fields "description" and "createdDate" in soql.
Select Subject, WhatId, what.name, Owner.name, Owner.Id, IsVisibleInSelfService, ActivityDate, ...
- 902
2
votes
1
answer
1k
views
SOQL: Get most recent amount grouped by a parent and a type
Should be simple had it been SQL. But. I would like to get the amount field value that belongs to the most recent month available for that parent and that type.
Data:
Parent_Id__c Type__c ...
- 3,266
-1
votes
1
answer
318
views
Too Many Records in salesforce
I have More amount of Records in salesforce, i have created field as not Unique.So for account Records is created with duplicate Records also,I want to check how many Records contain dulplicate ...
- 648
0
votes
2
answers
43
views
Query error when use group by
can anyone explain it to me, why my query is error?
here my query :
PYEMPELEMENT__c[] VFLDLSTEmpSeparated = [SELECT Employee_No__c, Period__c FROM PYEMPELEMENT__c GROUP BY Employee_No__c, ...
- 67
1
vote
1
answer
6k
views
How to get unique values of two fields in one SOQL?
I have a custom object named "Performance" in which there are two text fields named "Main Category" and "Sub Category". Here, I would like to first extract the unique values of Main Category from all ...
- 187
1
vote
2
answers
2k
views
Displaying month/year from createdDate in SOQL query
I am very new to Salesforce and struggling to get a query to return the data in the format I require - i.e pushing the results through Conga composer to feed a chart in a powerpoint template. The ...
- 13
1
vote
1
answer
63
views
StandardSetConnector Aggregate query grouping
I have a pageblock table with the following columns:
Company, Package, Type, Revenue, Age, Users, Total Usage Actions, Top 3 Modules.
All of the fields apart from "Total usage actions" and "Top 3 ...
- 11
3
votes
1
answer
9k
views
how to use group by in soql with lists
Hi friends i'm new to sfdc development I wrote a sample query to fetch opportunities related to account with some conditions try to group i getting error.
my code is:
List<Opportunity_Trial__c>...
- 1,420
0
votes
1
answer
619
views
Open rate by domain over time - SQL
I'm trying to figure out open rate over time based on domain however, it seems to error or timeout every time I run it. I've limited it to just gmail, yahoo, and AOL for now.
SELECT
o.domain
, s....
- 27
2
votes
2
answers
420
views
Salesforce group by
I want to use group by from salesforce query :
SELECT Candidat__c, Commande__c,Statut__c,IsDeleted, TypeContrat__c
FROM Candidature__c
WHERE Candidat__c = '0032000001GAPoXAAX'
AND Statut__c = '...
- 123
4
votes
3
answers
2k
views
Why am I getting group by aggregate errors in this query
I need to count the total number of orgs. Why won't this query work? I get errors not matter what I group or not group. I only put in Group by to try to placate the compiler but he's in a very bad ...
- 1,206
2
votes
1
answer
261
views
split before GROUP BY soql
I have a field which has the values in the format [5 digits-3 digits]
12345-123
34646-345
12345-133
I want to Group BY this field with the just the 5 digit number only (not the complete field). How ...
- 3,954
5
votes
1
answer
1k
views
group by soql query
I have records with same values in custom field, Unique_Name__c. On a Visualforce Page, I have to display records grouped by Unique_Name__c.
Unique_Name__c is custom field on OpportunityLineItem ...
- 2,146
0
votes
1
answer
87
views
Consideration of fields to be used in SOQL Group By [duplicate]
I have come to know that a few fields in Salesforce.com are not groupable and that we can make sure whether field is group-able or not with getDescribeSObject.
I would like to know what are the ...
- 1,400
1
vote
1
answer
250
views
SOQL query aggregation
I need to provide statistics to the users in my VF Page, showing the total of records they own where the status is New, In progress, Approved, Pending, Converted
I have tried the below query in my ...
0
votes
2
answers
1k
views
Grouping a VisualForce list by Account
I have created a list in visualforce but it's quite boring. I would like to group by Account so it would look like
HgCapital
Month Subject Activity Date
Feb blah blah blah 01/02/...
- 390
2
votes
0
answers
226
views
GROUP BY Clause in SOSL (FIND instead of SELECT)
I am looking for the equivalent of the GROUP BY statement but then for a FIND query.
I want to do a search on all fields of ContentVersion by a keyword and I want it to return a list of all values in ...
- 534