Hello Everyone, 

This error is occuring within this Trailhead - Create Reports and Dashboards for Sales and Marketing Managers 
Visualize Your Data

Does anyone have a solution to this following error? 


I have in fact completed the challenge.....

And I have insured that my 'Sales Rep Win Rates' report chart DOES use a vertical bar chart.


Does anyone have any bright ideas?

Hello Everyone, 

This error is occuring within this Trailhead - Create Reports and Dashboards for Sales and Marketing Managers 
Visualize Your Data

Does anyone have a solution to this following error? 


I have in fact completed the challenge.....

And I have insured that my 'Sales Rep Win Rates' report chart DOES use a vertical bar chart.


Does anyone have any bright ideas?

Hi,
I have created a validation rule with 4 conditions:  If the lead status reaches stage 5 SQL, then I want to make sure the picklist fields Platform Type (Platform_Type__c) and Platform Sub-type ( Platform_Sub_Type__c) have picklist selections, as well as the rich text field Company Description ( Organization__c) has company information in the field.   I wrote this data validation rule:

And(ISPICKVAL( Status ,"5-SQL"), 
Or( 
ISBLANK(Organization__c),ISPICKVAL( Platform_Type__c,""), ISPICKVAL( Platform_Sub_Type__c,"") 
))

I have tested the rule on the picklist values and it is working correctly.   However, on the rich text field, the rule is being skipped and not working so I can save the lead as a Lead Status "5-SQL" with the company description having no data in the field.  Can anyone explain why this validation rule is skipping the ISBLANK logic?

Thank you in advance for your help.   I very much appreciate your advice.
Thank you!!!

All,
I wrote a class and trigger to create a field that would display the most recent completed event for a Contact. I thought it worked well, but there seems to be one problem. If the Contact doesn't have a previous completed event and a User schedules a new event for sometime in the future, the field updates to the future Due Date. 

The line causing the problem is as follows:
if(Contact.Last_Completed_Event__c == null)
           Contact.Last_Completed_Event__c = Event.EndDateTime;

Now if I comment this out, it won't grab a future Due Date, but it also won't grab the most recent completed event if an OPEN event doesn't exist. Can somebody help me solve this so that it works properly?

public class LastCompletedEventDate{
    //Grab list of contacts
    protected final Contact[] contactNewList = new Contact[] {};
    protected final Contact[] contactOldList = new Contact[] {};
    
    public LastCompletedEventDate(Contact[] contactOldList, Contact[] contactNewList) {
        this.contactNewList.addAll(contactNewList == null ? new Contact[] {} : contactNewList);
        this.contactOldList.addAll(contactOldList == null ? new Contact[] {} : contactOldList);
    }
    
    public void execute() {
        // Find all events associated to contacts
        Event[] eventList = [select ActivityDate, WhoId, EndDateTime, Subject, ActivityDateTime from Event where WhoId in :contactNewList];
        
        Map<Id, Contact> contactMap = new Map<Id, Contact>(contactNewList);
                for(Contact contact : contactNewList) {
                    contact.Last_Completed_Event__c = null;
        }
        
        //create if else statement to display most current completed event date
        for(Event event : eventList) {
            Contact contact = contactMap.get(event.WhoId);
            
            if(contact == null)
                continue;
            //if(Contact.Last_Completed_Event__c == null)
                //Contact.Last_Completed_Event__c = Event.EndDateTime;
            if(Contact.Last_Completed_Event__c == null && Event.EndDateTime < Date.Today())
                Contact.Last_Completed_Event__c = Event.EndDateTime;
            if(Event.EndDateTime < Date.Today())
                Contact.Last_Completed_Event__c = Event.EndDateTime;
        }
    }
}

trigger LastCompletedEventDate on Contact (before update) {
    if(Contact_RollupTrades.inprog != true) {
        Set<ID> sID = new Set<ID>(trigger.newMap.keySet());
        new LastCompletedEventDate(trigger.old, trigger.new).execute();
    }
}

I m writiing a trigger to check the Billing address and Shipping address if the billing address is given and shipping address is not given than it matches shipping address with billing address.

I am not able to get access to Billingaddress or shipping address in account.

Throws a error:Compile Error: Data type not supported: Address at line 6 column 9

trigger AccountAddressTrigger on Account (after insert,after update)
 {
 
 for(Account a:Trigger.new)
 {
     if(a.BillingAddress!='')
     {
     
     }
     
          }
 
}