नोट
इस पेज तक पहुँच के लिए प्रमाणन की आवश्यकता होती है. आप साइन इन करने या निर्देशिकाओं को बदलने का प्रयास कर सकते हैं.
इस पेज तक पहुँच के लिए प्रमाणन की आवश्यकता होती है. आप निर्देशिकाओं को बदलने का प्रयास कर सकते हैं.
Chart reports are limited to 15 data points. The dataset must limit the result set to the top 15 rows for the charted value. Additionally, a 16th "other" data point value is optional. This value represents an aggregation of all other rows in the domain. The 16th value is always sorted to the bottom of the result set. This adds a level of complexity to reports that contain drill-through functionality that is appropriate for some reports.
Note
The number of data points and label length may have to be reduced to correctly display the contents of the chart.
Example
The following example demonstrates how to limit a number of data points shown in the table by using the FetchXML query. You have to provide two data sets with one FetchXML query per dataset. The results from the first dataset query are passed through the multi-valued parameters to the second dataset to filter the results of the query. Dataset1 retrieves the top 15 records ordered by revenue and Dataset2 retrieves the “TotalRevenue” aggregating all accounts except the accounts from DataSet1.
DataSet1:
<fetch count="15">
<entity name="account" >
<attribute name="accountid" />
<attribute name="name" />
<attribute name="revenue" />
<order attribute="revenue" descending="true" />
</entity>
</fetch>
DataSet2:
<fetch aggregate="true">
<entity name="account">
<attribute name="revenue" aggregate="sum" alias="TotalRevenue" />
<filter>
<condition attribute="accountid" operator="not-in" value="@TopAccountIds"/>
</filter>
</entity>
</fetch>
Report Parameter:
<ReportParameter Name=" TopAccountIds ">
...
<MultiValue>true</MultiValue>
<Hidden>true</Hidden>
<DefaultValue>
<DataSetReference>
<DataSetName>DataSet1</DataSetName>
<ValueField>accountid</ValueField>
</DataSetReference>
</DefaultValue>
</ReportParameter>
See also
Sample Reports
Sample: Display the Top X Values
Reporting and Analytics Guide