I think this will actually help me a lot with speeding up future reports. For this particular chart, I don't think I need to join any tables. I am almost illiterate when it comes to SQL, but here is what I pared this down to -

SELECT If_no_products_floored_why_not__c, Max (Date__c) as 'maxDate', Store_Name__c,
FROM Call_Report_Entry__c

It's not working and I'm guessing it's a simple syntax error, but I can't figure out what it is.

I'm trying to attach a picture, but can't figure out how to do it! It says 'Failed to retrieve data from the database......syntax error near 'SELECT........as 'maxDate'<<<???>>>, Store_Name_c......'

GAAA!!! Now I have a new error! I'm definitely going to need to take some SQL training. Any suggestions?

Anyway, the new error says - 'Failed to retrieve data from database.
Details: 42000:[Simba][SQLEngine] (31430) Column 'datasource.If_no_products_floored_why_not_c' is neither in an aggregate function nor from the GROUP BY clause. [Database Vendor Code: 31430]

Any idea what that means?

Getting closer...I was able to get the data in now, but I'm still getting all of the visits instead of just the most recent to each store. Do I need something else in the Max function to tell it to only include the most recent visit to each store?

Ok, you're getting the extra details because of the differences in data in If_no_products_floored_why_not__c.

You have two options for this query, depending on whether SalesForce will allow you to join to a sub-query.

Option 1 - This is faster at the database level:

SELECT cre.If_no_products_floored_why_not__c, cre.Date__c as maxDate, cre.Store_Name__c
FROM Call_Report_Entry__c as 'cre'
inner join (
      Select Store_Name__c, Max(Date__c) as maxDate
      from Call_Report_Entry__c
      group by Store_Name__c
) as maxDates
on cre.Store_Name__c = maxDates.Store_Name__c
    and cre.Date__c = maxDates.maxDate

Option 2 - If it won't left you use the subquery in a join, try this:

SELECT cre.If_no_products_floored_why_not__c, cre.Date__c as maxDate, cre.Store_Name__c
FROM Call_Report_Entry__c as 'cre'
WHERE cre.Date__c =
(
      Select Max(Date__c) as maxDate
      from Call_Report_Entry__c as 'tmp'
      where tmp.Store_Name__c = cre.Store_Name__c
) as maxDates

-Dell