Questions tagged [group-by]
The group-by tag has no usage guidance.
66
questions
0
votes
1answer
37 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 ...
0
votes
0answers
10 views
Report Group By Month in Year - Missing Month Label
I've created a report which is grouped by month in year, and calendar year as well.
As you can see in the screenshot below, the "March" label is missing, even if data are present in the row.
...
0
votes
0answers
12 views
Row-Level formula to show duplicates
I am trying to use a row level formula to mark duplicates in my report. Ultimately I am trying to group same loan number and same common ID. I was told I could use the row level field to compare 2 ...
0
votes
1answer
38 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 ...
0
votes
1answer
51 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 ...
0
votes
1answer
239 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 ...
0
votes
1answer
41 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
votes
1answer
33 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
0answers
88 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 ...
15
votes
1answer
301 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 ...
0
votes
1answer
176 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 ...
1
vote
1answer
160 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 ...
1
vote
2answers
998 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
...
1
vote
2answers
69 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'...
5
votes
3answers
2k 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 ...
3
votes
1answer
339 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 ...
2
votes
1answer
391 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 ...
0
votes
1answer
39 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 ...
1
vote
0answers
78 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 ...
1
vote
2answers
4k 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 ...
1
vote
1answer
843 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:
...
2
votes
2answers
7k 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 ...
2
votes
1answer
67 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 ...
1
vote
2answers
618 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 ...
0
votes
1answer
28 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
1answer
560 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 ...
5
votes
1answer
152 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,
...
1
vote
1answer
392 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 ...
2
votes
1answer
313 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 ...
0
votes
1answer
495 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 ...
1
vote
0answers
35 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 ...
1
vote
1answer
59 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 ...
0
votes
1answer
1k 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, ...
2
votes
1answer
747 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 ...
-1
votes
1answer
255 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 ...
0
votes
2answers
41 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, ...
1
vote
1answer
4k 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 ...
1
vote
2answers
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 ...
1
vote
1answer
58 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 ...
2
votes
1answer
6k 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>...
0
votes
1answer
405 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....
2
votes
2answers
298 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 = '...
4
votes
3answers
1k 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 ...
2
votes
1answer
240 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 ...
5
votes
1answer
874 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 ...
0
votes
1answer
72 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
vote
1answer
203 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
2answers
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/...
2
votes
0answers
188 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 ...
13
votes
1answer
331 views
Aggregate SOQL - How Many Fields Can Be Grouped?
As stated in the title, is there any maximum on the number of fields that can be passed into a GROUP BY clause? I can't find any documentation on it. For example, if I had the following query:
SELECT ...
