This record of this object represents an individual dataset of a chart.
The dataset contains all the data, format, styling, and type of chart for the data. An individual Chart record can have multiple Chart Dataset records. A Chart record must have at least one Chart Dataset record.
API Name: Chart_Dataset__c
Fields
| Label | API | Type | Description |
|---|---|---|---|
| Dataset Name | Name | Auto Number | The name of the dataset record. |
| Dataset Label | Dataset_Label__c | Text | The label of the dataset that will be shown in the chartComponent. |
| Chart | Chart__c | Master-Detail | The lookup to Chart object. It represents the relationship between a chart and a dataset. |
| Chart Type | Chart_Type__c | Picklist | The type of Chart to render e.g. Pie, Bar, Line, etc. |
| Use Custom SOQL | Use_Custom_SOQL__c | Checkbox | If this is checked, then the user can write a custom SOQL query for the dataset. When checked, the fields in the sections Data Source, Filters, and Styling will be ignored. |
| Source Object | Source_Object__c | Text | This should contain the API name of the sObject, the records of which need to be shown in the chart. For example: If Account records need to be shown in the chart, then this field value should be ‘Account’. |
| Source Field | Source_Field__c | Text | This should contain the API name of the field, the values of which will be displayed in the chart. This field represents the value of an individual record on the chart. This field must be present in the mentioned Source Object. Supported Field Types Integer Currency Double Long Percent |
| Source Label | Source_Label__c | Text | This should contain the API name of the field, the values of which will be displayed in the chart. This field represents the label of an individual record on the chart. This field must be present in the mentioned Source Object. Supported Field Types String Picklist Integer Double Date ID |
| Earliest Date | Earliest_Date__c | Date | Once filled then only those records will be shown on the chart whose Created Date is more or equal to this value. |
| Latest Date | Latest_Date__c | Date | Once filled then only those records will be shown on the chart whose Created Date is less or equal to this value. |
| Records Limit | Records_Limit__c | Number | Limits the number of records to display on the chart. The value must be present and should be between 0 and 50,000. |
| Filter Requirements | Filter_Requirements__c | Picklist | Decides the requirement of filters. For example, all filters should be true, or if any of the filters is true, or a custom logic. This field only determines the logic for filters from the related list. The fields in the filter section if filled will always be considered required. |
| Custom Filters Logic | Custom_Filters_Logic__c | Text Area | Defines the custom filter requirement for the related Filters of the Dataset. Sample Value: 1 AND 2 OR (3 AND 4) While, 1, 2,3, and 4 are the Name fields of the Filter records. If the Filter Requirements value is Custom, then this field must be filled. |
| Sort By | Sort_By__c | Text | This should include the API name of the field by which the records should be sorted. This field must be present in the mentioned Source Object. |
| Sort Order | Sort_Order__c | Picklist | Represents the sort order of the records on the chart. it can be either Ascending or Descending. |
| Border Color | Border_Color__c | Text | Adds color to the border on the chart records. The value can be Hex, RGB, Color Name, etc. |
| Border Width | Border_Width__c | Number | Adds border to the chart records. The border may look different on different chart types. Greater value represents a thicker border. |
| Background Color | Background_Color__c | Text | Adds color to the chart records. The value can be Hex, RGB, Color Name, etc. |
Related Object(s)
Following is the related object of the Chart Dataset object.
Was this helpful?
Thanks for your feedback!
