Ask Search:
Francesco FerraraFrancesco Ferrara 
I created 2 Custom Object A and B.
Between A and B there is a N:N relationship, than I created a Junction Object JO_AB.

In A there is a Currency Field : "TO_SUMMURIZE"
In B there are 2 Field : "CATEGORY","SUB_CATEGORY"

A_ID1 | 5
A_ID2 | 7
A_ID3 | 10

B_ID1 | CAT_1   | SUBCAT_1_1
B_ID2 | CAT_1   | SUBCAT_1_2
B_ID3 | CAT_2   | SUBCAT_2_1
B_ID4 | CAT_2   | SUBCAT_2_2
B_ID5 | CAT_2   | SUBCAT_2_3

ID_A    |    ID_B    
A_ID1   |    B_ID1
A_ID1   |    B_ID2
A_ID1   |    B_ID3
A_ID2   |    B_ID1
A_ID3   |    B_ID1
A_ID3   |    B_ID3
A_ID3   |    B_ID4

In Wave I created the following Data Set:
Root: JO_AB
Relationship: A
Relationship: B

A_ID1   |    B_ID1   |  CAT_1       |  SUBCAT_1_1  |     5
A_ID1   |    B_ID2   |  CAT_1       |  SUBCAT_1_2  |     5
A_ID1   |    B_ID3   |  CAT_2       |  SUBCAT_2_1  |     5
A_ID2   |    B_ID1   |  CAT_1       |  SUBCAT_1_1  |     7
A_ID3   |    B_ID1   |  CAT_1       |  SUBCAT_1_1  |     10
A_ID3   |    B_ID3   |  CAT_2       |  SUBCAT_2_1  |     10
A_ID3   |    B_ID4   |  CAT_2       |  SUBCAT_2_2  |     10

Then I created a chart with:
Count Of A | Group By B.CATEGORY | Sum Of A.TO_SUMMURIZE

The result is the following:

CAT_1              |     3      |         27  
CAT_2              |     2      |         25

but the expected result is

CAT_1              |     3      |         22  
CAT_2              |     2      |         15

The problem is that the count work correctly because it executes a distinct on A, the sum instead does not execute a distinct on A and sums multiple times the same A record.

Is there a workaround to achieve the expected result, and use a distinct on aggregate operation?

Best Answer chosen by Francesco Ferrara
Giuseppe CarboneGiuseppe Carbone
Your Dataset is incorret. CATEGORY and SUB_CATEGORY need to be MultiValue Field.
When you create the dataset, in the augment Transformation (you have to modify the JSON), use the 'operation': 'LookupMultiValue', as described in the document
Wave Analytics returns results from all matched rows.
Let’s look at an example. You apply the augment transformation on the following datasets, set the relationship to "Price," set the
operation to LookupMultiValue, and match the records based on the Id and ProdId fields.
Because the lookup returns multiple rows for Prod3, the dimension Price.Pricebook field in the resulting dataset becomes
a multi-value field, showing all dimension values. The measure field Price.UnitPrice contains 1500, which is the sum of 800
and 700. Here’s the resulting dataset after the augment.

Saulo BravimSaulo Bravim 
Does anyone know if it is possible to generate reports using emails that leave directly from the salesforce, for example email going when we send a quote.
Best Answer chosen by Saulo Bravim
Pritam ShekhawatPritam Shekhawat

How to track outbound emails sent by each user in Salesforce?
Knowledge Article Number000002666
DescriptionI would like to know that: Can I track No. of outbound emails sent by each user in Salesforce?
ResolutionHow to track outbound emails sent by each user in Salesforce?

1) Navigate to the task "Type" picklist field: Click Your Name | Setup | Customize | Activities | Task Fields | Type
2) Click "New" and create a new picklist value called "Outbound Email".
3) As soon as the "Outbound Email" value is created, edit it and make the "Send Email: Make this value the default for sending an email" checkbox ticked.
Note: Make sure that it is not the "Default" value, just the "Send Email Default".
4) The next step is to navigate to Reports Tab | Click "Create New Custom Report" | Select Category: Activities | Select Report Type: Tasks and Events | Create
5) The last step is to select filters:

- Show: All Activities
- Show: Completed Activities
- Show: Tasks
- No "From" or "To" dates
- Add the following field filter: Activity Type | equals | Outbound Email | OK
6) Run the report and Save it to a report folder.

Barry PetersBarry Peters 
I had a Salesforce login at a former employer and I used that login for my own personal account and profile in the Salesforce Success Community (and the Power of Us Salesforce Hub for nonprofits).  That employer's domain name was in my login.

Now, I no longer work with that employer and I have a new Salesforce login with my new Salesforce org.  How do I merge my old Success Community login and profile and memberships in various topic groups into my current Salesforce login. 
Best Answer chosen by Barry Peters
Bill GreenhawBill Greenhaw
Here is it. Just keep reading down the comments
Matthew PiazzaMatthew Piazza 
I've been spending a lot more time configuring in Lightning, as well as testing the creating/updating of records in Lightning (all in our company's Full Sandbox) -- and I've noticed that page loads in both admin/config screens, as well as when saving on record detail screens is much, much more sluggish than in Salesforce Classic.  It's actually almost unbearable in contrast to how speedy things are in Classic.

Not necessarily a "fix" to this, per se...but has anyone else encountered this, as well?

From a UX perspective, I'm a little nervous about a full conversion to Lighting for a few reasons, not the least of which is ensuring a quick and responsive system when Users interact with records.

Thanks in advance for your feedback!

Best Answer chosen by Matthew Piazza
Mayank SrivastavaMayank Srivastava
Matthew, I share the sentiments related to Lightning and your observations. The best that we could do at this stage is wait for it to be faster.

The page load times are really slow, there's lots of white space which goes unused and there are too many clicks needed to perform the desired function and these are just a fraction of my grievances with Lightning. I hope it all gets resolved soon. For now, let's vote on this idea:
Tom CreedTom Creed 
Does anyone know if it's possible to update the name field on a custom obejct? I'm trying with the dataloader and not seeing 'name' as a field to update. It's an auto number field. Thanks.

User-added image
Best Answer chosen by Tom Creed
Susan ThayerSusan Thayer
You can change the "Data Type" from Auto-Number to Name and then update it that way. If it is auto-number then there is no way to update it.

If you want to change it back to Auto-Number when you are finished with your changes you can; just be sure to set a new 'starting' number so you don't run into any duplicates.
Karley FetterKarley Fetter 


I am looking to add a field in the Opportunities search layout on the search page. Attached is a word doc of images associated. 

ThTop image is the page associated, bottom image is the Opp details - I would like to add a field beside circled fieldanks! 

Best Answer chosen by Karley Fetter
Martin KeatingMartin Keating
Hi Karley,

We can't see any word doc attachment (just the image), but you can follow this click path to find where you can customize this.

Setup | Customize | Opportunities | Search Layouts
Daniel BraultDaniel Brault 
Is there a way to modify the page layout for the Add Products page that displays for Opportunity Products and Quote Line Items when adding products? The default fields are:

Product   Quantity   Sales Price    Line Item Description

I am trying to assign a new page layout that replaces these and cannot figure out if it can be done.

Best Answer chosen by Daniel Brault
Deepak AnandDeepak Anand
What you're looking for is called a "Multi-Line Layout". You can edit the same by:
  1. Go to Setup | Customize | Opportunities | Oportunity Products | Page Layouts
  2. Hit Edit
  3. You should see the "Edit Multi-Line Layout" as shown below: User-added image
Koen VermachelenKoen Vermachelen 
Ok, so here is my situation.
I have a visualforce page that both appears for Salesforce classic users as embedded on the account detail page as well as on a lightning page for my lightning experience users.

One link that is on there is a link to create a new contact.
Following the documentation, I use the URLFOR new $Action.

This is how the link looks now:
<a href="{!URLFOR($Action.Contact.NewContact, null)}">New Contact</a>
The problem is, if I don't specify the "target" attribute on the link, for the classic users on the detail page, the link obviously opens in the iframe that Salesforce puts the VF page in.

However, if I add the target="_blank" or target="_top" in there, in lightning experience, indeed a new tab opens, but the page is not in lightning experience but in classic.

Anyone has an idea how to solve this one? I know I could put some logic in the visualforce to render the link one way or the other depending on the UITheme (classic vs lightning experience) but I'm not in favor of having to do that.
Especially since Salesforce mentions that in visualforce markup links using the URLFOR should work in both UI's (classic & lightning.
Best Answer chosen by Koen Vermachelen
rohit sfdcrohit sfdc
Koen Vermachelen ,

All your developer queries should be posted in developer forums of salesforce or stackexchange.

This forum is more on admin related queries
Andrew KuharichAndrew Kuharich 
Can the Activities component be added to the homepage in Lightning Experience?
Best Answer chosen by Miglena ( 
Shekhar GawaliShekhar Gawali
Hi Andrew,
Activities are combination tasks and events. Since homepage in LEX have today's task and upcoming events, you can add them as activity.
But, there is no standard component called as activity for home page. It is only available for record pages.

Nicholas MandikosNicholas Mandikos 
What is the rationale with not providing what you scored on cetification exams. Whether pass or fail I would like to know what percentage of the material I have mastered. 
Best Answer chosen by Nicholas Mandikos
Mayank SrivastavaMayank Srivastava
Ya I can absolutely understand. Unrelated to this post but I do pro bono study groups for ADM 201 and ADM 211 in the tri state area so feel free to let me know if you are in CT, NY or NJ and wish to join.