Report

1<?xml version="1.0" encoding="UTF-8"?>
2<Package xmlns="http://soap.sforce.com/2006/04/metadata">
3    <types>
4        <members>MyDBFolder/MyDBName</members>
5        <name>Dashboard</name>
6    </types>
7    <types>
8        <members>MyDocumentFolder/MyDocumentName</members>
9        <name>Document</name>
10    </types>
11    <types>
12        <members>unfiled$public/MarketingProductInquiryResponse</members>
13        <members>unfiled$public/SalesNewCustomerEmail</members>
14        <name>EmailTemplate</name>
15    </types>
16    <types>
17        <members>MyReportFolder/MyReportName</members>
18        <name>Report</name>
19    </types>
20    <version>58.0</version>
21</Package>

1<crossFilters>
2        <criteriaItems>
3            <column>Status</column>
4            <operator>notequal</operator>
5            <value>Closed</value>
6        </criteriaItems>
7        <operation>with</operation>
8        <primaryTableColumn>ACCOUNT_ID</primaryTableColumn>
9        <relatedTable>Case</relatedTable>
10        <relatedTableJoinColumn>Account</relatedTableJoinColumn>
11    </crossFilters>

1<?xml version="1.0" encoding="UTF-8"?>
2<Report xmlns="http://soap.sforce.com/2006/04/metadata">
3    <aggregates>
4        <acrossGroupingContext>CRT_Object__c$Id</acrossGroupingContext>
5        <calculatedFormula>PREVGROUPVAL(CRT_Object__c.Currency__c:AVG, CRT_Object__c.Id) *
6                PARENTGROUPVAL(CRT_Object__c.Number__c:MAX, CRT_Object__c.CreatedBy.Name, 
7                COLUMN_GRAND_SUMMARY)/RowCount</calculatedFormula>
8        <datatype>number</datatype>
9        <developerName>FORMULA1</developerName>
10        <downGroupingContext>CRT_Object__c$CreatedBy</downGroupingContext>
11        <isActive>true</isActive>
12        <masterLabel>CurrCSF</masterLabel>
13        <scale>2</scale>
14    </aggregates>
15    <aggregates>
16        <acrossGroupingContext>CRT_Object__c$LastModifiedDate</acrossGroupingContext>
17        <calculatedFormula>IF(RowCount&gt;10, 
18                BLANKVALUE(ROUND(PREVGROUPVAL(CRT_Object__c.Currency__c:SUM, 
19                CRT_Object__c.LastModifiedDate),3), 
20                PARENTGROUPVAL(CRT_Object__c.Number__c:SUM, ROW_GRAND_SUMMARY, 
21                CRT_Object__c.Id))  , 1000)</calculatedFormula>
22        <datatype>number</datatype>
23        <developerName>FORMULA2</developerName>
24        <downGroupingContext>GRAND_SUMMARY</downGroupingContext>
25        <isActive>true</isActive>
26        <masterLabel>numCSF</masterLabel>
27        <scale>2</scale>
28    </aggregates>
29    <buckets>
30        <bucketType>number</bucketType>
31        <developerName>BucketField_BusinessSize</developerName>
32        <masterLabel>NumericBucket</masterLabel>
33        <nullTreatment>z</nullTreatment>
34        <sourceColumnName>SALES</sourceColumnName>
35        <values>
36            <sourceValues>
37                <to>10000</to>
38            </sourceValues>
39            <value>low</value>
40        </values>
41        <values>
42            <sourceValues>
43                <from>10000</from>
44                <to>25000</to>
45            </sourceValues>
46            <value>mid</value>
47        </values>
48        <values>
49            <sourceValues>
50                <from>25000</from>
51            </sourceValues>
52            <value>high</value>
53        </values>
54    </buckets>
55    <buckets>
56        <bucketType>text</bucketType>
57        <developerName>BucketField_Region</developerName>
58        <masterLabel>TextBucket</masterLabel>
59        <nullTreatment>n</nullTreatment>
60        <otherBucketLabel>Other</otherBucketLabel>
61        <sourceColumnName>ADDRESS1_STATE</sourceColumnName>
62        <values>
63            <sourceValues>
64                <sourceValue>CA</sourceValue>
65            </sourceValues>
66            <value>west</value>
67        </values>
68        <values>
69            <sourceValues>
70                <sourceValue>NY</sourceValue>
71            </sourceValues>
72            <sourceValues>
73                <sourceValue>Ontario</sourceValue>
74            </sourceValues>
75            <value>east</value>
76        </values>
77    </buckets>
78    <chart>
79        <backgroundColor1>#FFFFFF</backgroundColor1>
80        <backgroundColor2>#FFFFFF</backgroundColor2>
81        <backgroundFadeDir>Diagonal</backgroundFadeDir>
82        <chartSummaries>
83            <axisBinding>y</axisBinding>
84            <column>FORMULA1</column>
85        </chartSummaries>
86        <chartSummaries>
87            <axisBinding>y</axisBinding>
88            <column>FORMULA2</column>
89        </chartSummaries>
90        <chartSummaries>
91            <aggregate>Maximum</aggregate>
92            <axisBinding>y</axisBinding>
93            <column>CRT_Object__c$Number__c</column>
94        </chartSummaries>
95        <chartSummaries>
96            <axisBinding>y</axisBinding>
97            <column>RowCount</column>
98        </chartSummaries>
99        <chartType>VerticalColumn</chartType>
100        <groupingColumn>CRT_Object__c$LastModifiedDate</groupingColumn>
101        <legendPosition>Right</legendPosition>
102        <location>CHART_TOP</location>
103        <size>Medium</size>
104        <summaryAxisRange>Auto</summaryAxisRange>
105        <textColor>#000000</textColor>
106        <textSize>12</textSize>
107        <titleColor>#000000</titleColor>
108        <titleSize>18</titleSize>
109    </chart>
110    <columns>
111        <field>CRT_Object__c$Name</field>
112    </columns>
113    <columns>
114        <aggregateTypes>Average</aggregateTypes>
115        <field>CRT_Object__c$Currency__c</field>
116    </columns>
117    <columns>
118        <aggregateTypes>Maximum</aggregateTypes>
119        <field>CRT_Object__c$Number__c</field>
120    </columns>
121    <columns>
122        <field>BucketField__Region</field>
123    </columns>
124    <format>Matrix</format>
125    <groupingsAcross>
126        <dateGranularity>Day</dateGranularity>
127        <field>CRT_Object__c$Id</field>
128        <sortOrder>Asc</sortOrder>
129    </groupingsAcross>
130    <groupingsAcross>
131        <dateGranularity>Year</dateGranularity>
132        <field>CRT_Object__c$LastModifiedDate</field>
133        <sortOrder>Asc</sortOrder>
134    </groupingsAcross>
135    <groupingsDown>
136        <dateGranularity>Day</dateGranularity>
137        <field>CRT_Object__c$CreatedBy</field>
138        <sortOrder>Asc</sortOrder>
139    </groupingsDown>
140    <groupingsDown>
141        <dateGranularity>Day</dateGranularity>
142        <field>CRT_Object__c$Currency__c</field>
143        <sortOrder>Desc</sortOrder>
144    </groupingsDown>
145    <name>CrtMMVC</name>
146    <reportType>CRT1__c</reportType>
147    <scope>organization</scope>
148    <showDetails>false</showDetails>
149    <timeFrameFilter>
150        <dateColumn>CRT_Object__c$CreatedDate</dateColumn>
151        <interval>INTERVAL_CUSTOM</interval>
152    </timeFrameFilter>
153</Report>

1<?xml version="1.0" encoding="UTF-8"?>
2<Report xmlns="http://soap.sforce.com/2006/04/metadata">
3<!-- This is a cross-block custom summary formula. Note that the calculated formula reference for a blocks reference uses the BlockId#Aggregate. -->
4    <aggregates>
5        <calculatedFormula>B1#AMOUNT:SUM+B2#EMPLOYEES:SUM</calculatedFormula>
6        <datatype>number</datatype>
7        <developerName>FORMULA</developerName>
8        <isActive>true</isActive>
9        <isCrossBlock>true</isCrossBlock>
10        <masterLabel>Cross-Block CSF Example</masterLabel>
11        <scale>2</scale>
12    </aggregates>
13<!-- This is a standard custom summary formula. Note that the calculated formula reference does not have block reference but just the aggregate name of the report type associated (Opportunity).-->
14    <aggregates>
15        <calculatedFormula>AMOUNT:SUM</calculatedFormula>
16        <developerName>FORMULA2</developerName>
17        <isActive>true</isActive>
18        <isCrossBlock>false</isCrossBlock>
19        <masterLabel>Standard CSF Example</masterLabel>
20        <reportType>Opportunity</reportType>
21        <scale>2</scale>
22    </aggregates>
23    <block>
24      <blockInfo>
25<!-- This is how the block defines that the custom summary formula should be referenced. In this example, it’s the in standard FORMULA 2 defined above. This block report has blockID B1.-->
26        <aggregateReferences>    
27          <aggregate>FORMULA2</aggregate>
28        </aggregateReference>
29        <blockId>B1</blockId>
30        <joinTable>a</joinTable>
31      </blockInfo>
32      <columns>
33        <field>TYPE</field>
34      </columns>
35      <format>Summary</format>
36      <name>Opportunities BLock 3</name>
37      <params>
38        <name>role_territory</name>
39        <value>role</value>
40      </params>
41      <params>
42        <name>terr</name>
43        <value>all</value>
44      </params>
45      <params>
46        <name>open</name>
47        <value>all</value>
48      </params>
49      <params>
50        <name>probability</name>
51        <value>0</value>
52      </params>
53      <params>
54        <name>co</name>
55        <value>1</value>
56      </params>
57      <reportType>Opportunity</reportType>
58      <scope>organization</scope>
59      <timeFrameFilter>
60        <dateColumn>CLOSE_DATE</dateColumn>
61        <interval>INTERVAL_CUSTOM</interval>
62      </timeFrameFilter>
63    </block>
64    <block>
65      <blockInfo>
66<!-- This is how the block defines that the custom summary formula should be referenced. In this example, it’s the cross-block custom summary formula FORMULA 1 defined above. This block report has blockId B2.-->
67        <aggregateReferences>
68          <aggregate>FORMULA1</aggregate>
69        </aggregateReferences>
70        <blockId>B2</blockId>
71        <joinTable>a</joinTable>
72      </blockInfo>
73      <columns>
74        <field>USERS.NAME</field>
75      </columns>
76      <columns>
77        <field>TYPE</field>
78      </columns>
79      <columns>
80         <field>DUE_DATE</field>
81      </columns>
82      <columns>
83        <field>LAST_UPDATE</field>
84      </columns>
85      <columns>
86        <field>ADDRESS1_STATE</field>
87      </columns>
88      <format>Summary</format
89      <name>Accounts block 5</name>
90      <params>
91        <name>terr</name>
92        <value>all</value>
93      </params>
94      <params>
95        <name>co</name>
96        <value>1</value>
97      </params>
98      <reportType>AccountList</reportType>
99      <scope>organization</scope>
100      <timeFrameFilter>
101        <dateColumn>CREATED_DATE</dateColumn>
102        <interval>INTERVAL_CUSTOM</interval>
103      </timeFrameFilter>
104    </block>
105    <blockInfo>
106      <blockId xsi:nil="true"/>
107      <joinTable>a</joinTable>
108    </blockInfo>
109<chart>
110        <backgroundColor1>#FFFFFF</backgroundColor1>
111        <backgroundColor2>#FFFFFF</backgroundColor2>
112        <backgroundFadeDir>Diagonal</backgroundFadeDir>
113        <chartSummaries>
114            <axisBinding>y</axisBinding>
115<!-- This is how chart aggregates are designed in multiblock. We're using RowCount from Block 1.-->
116            <column>B1#RowCount</column>
117        </chartSummaries>
118        <chartType>HorizontalBar</chartType>
119        <enableHoverLabels>false</enableHoverLabels>
120        <expandOthers>true</expandOthers>
121        <groupingColumn>ACCOUNT_NAME</groupingColumn>
122        <location>CHART_TOP</location>
123        <showAxisLabels>true</showAxisLabels>
124        <showPercentage>false</showPercentage>
125        <showTotal>false</showTotal>
126        <showValues>false</showValues>
127        <size>Medium</size>
128        <summaryAxisRange>Auto</summaryAxisRange>
129        <textColor>#000000</textColor>
130        <textSize>12</textSize>
131        <titleColor>#000000</titleColor>
132        <titleSize>18</titleSize>
133    </chart>
134    <format>MultiBlock</format>
135    <groupingsDown>
136        <dateGranularity>Day</dateGranularity>
137        <field>ACCOUNT_NAME</field>
138        <sortOrder>Asc</sortOrder>
139    </groupingsDown>
140    <name>mb_mbapi</name>
141    <reportType>Opportunity</reportType>
142    <showDetails>true</showDetails>
143</Report>