You’re offline. This is a read only version of the page.
I have created a FetchXML Schema :
<?xml version="1.0" encoding="utf-8"?>
<fetch distinct="false" mapping="logical" output-format="xml-platform" version="1.0" aggregate='true' >
<entity name="lead">
<!--<attribute name="modifiedon" alias='Modified_In_Current_Fiscal_Year' groupby='true' dategrouping='year' />-->
<attribute name="modifiedon" alias='Modified_On_Date' groupby='true' dategrouping='day' />
<attribute name="new_leadstage" alias='MQL_Leads' aggregate='count' />
<attribute name="new_leadstage" alias='SAL_Leads' aggregate='count' />
<attribute name="new_lgmeetingstatus" alias='LG_Meetings' aggregate='count' />
<filter type="and">
<filter type="or" >
<condition attribute="new_leadstage" operator="eq" value="100000002" />
<condition attribute="new_leadstage" operator="eq" value="100000004" />
<filter type="and">
<condition attribute="new_lgmeetingstatus" operator="eq" value="100000000" />
</filter>
</filter>
</filter>
<link-entity name="opportunity" from="originatingleadid" to="leadid" alias="Opportunities" link-type="outer">
<attribute name='actualvalue' alias='Revenue' aggregate='sum'/>
</link-entity>
</entity>
</fetch>
But, Not getting desired results :
I want this Result :
| Daily Sales Report | |||||||||||
| Date | 17th July | 14th July | 13th July | 12th July | 11th July | 10th July | 7th July | 6th July | 5th July | 4th July | 3rd July |
| Revenue | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ |
| July Revenue | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ |
| SAL | # | # | # | # | # | # | # | # | # | # | # |
| MQL | # | # | # | # | # | # | # | # | # | # | # |
Please help me in this matter, if somebody has done a similar task like this.
Thanks in advance.
*This post is locked for comments
I have the same question (0)
Share
Report
All responses (
Answers (
2