I am trying to query two related objects in Field Service Lightning. Ideally I would return the same results as in the report below, namely:

Show Name, Skill__c, and Territories__c from Service Resources, with this cross filter:

Service Resources WITHOUT Assigned Resources
  with a Start Date less than 2/28/2019
and
 an End Date less than 2/1/2019

Currently, my query looks like this:

SELECT Id,Name,Skill__c,Territory__c FROM ServiceResource
 where (Id NOT in (select Service_Resource__c from Request_Resource__c where Start_Date__c < 2019-02-28 and End_Date__c > 2019-02-01))

but it is returning too many records.

I am trying to query two related objects in Field Service Lightning. Ideally I would return the same results as in the report below, namely:

Show Name, Skill__c, and Territories__c from Service Resources, with this cross filter:

Service Resources WITHOUT Assigned Resources
  with a Start Date less than 2/28/2019
and
 an End Date less than 2/1/2019

Currently, my query looks like this:

SELECT Id,Name,Skill__c,Territory__c FROM ServiceResource
 where (Id NOT in (select Service_Resource__c from Request_Resource__c where Start_Date__c < 2019-02-28 and End_Date__c > 2019-02-01))

but it is returning too many records.

I am trying to query two related objects in Field Service Lightning. Ideally I would return the same results as in the report below, namely:

Show Name, Skill__c, and Territories__c from Service Resources, with this cross filter:

Service Resources WITHOUT Assigned Resources
  with a Start Date less than 2/28/2019
and
 an End Date less than 2/1/2019

Currently, my query looks like this:

SELECT Id,Name,Skill__c,Territory__c FROM ServiceResource
 where (Id NOT in (select Service_Resource__c from Request_Resource__c where Start_Date__c < 2019-02-28 and End_Date__c > 2019-02-01))

but it is returning too many records.

I am get this error: "Challenge Not yet complete... here's what's wrong: 
The 'Opp Stage by Adventure' report does not appear to be configured correctly. Make sure it has the correct report type, groupings, filters and chart type".

I believe i configured the report according to the instructions but it is still showing and error. Any assistance or insight would be apreciated.