The chart component allows you to display your data in a bar chart, line graph or pie chart. Note that only the first 1000 records in a dataset will be charted - for this reason we advise that you use filters to reduce your dataset below that limit or create a custom resource to aggregate data first.
What data should this chart display? Select the data source, and then the resource whose data you want to chart.
Name this chart: Give this chart a name, this is displayed at the top of the chart in your Space.
What type of chart should this display? Choose from a line graph, bar chart or pie chart.
What should be displayed on the x-axis?
Select the attribute that you would like to use for the x-axis (usually this is the independent variable). Then, choose how you want the data to be grouped on the x-axis:
What should be displayed on the y-axis?
Should this chart have multiple lines/bars? This will allow you to graph multiple lines/bars on your chart.
What attribute should group the data?
Choose the attribute that will determine how the pie chart is segmented (which attribute determines the slices of the pie). You can choose to determine this based on the value of the attribute, or if the attribute is a date/time, you can also choose to have Internal group this into a day/week/month/year format.
How should your data be calculated? (determines size of each slice)
Filter your chart data
You can use filters to narrow down the data records that will be charted. Since only the first 1000 records will be charted, it's generally advisable to use filters to narrow down your dataset below this number so that your chart represents all of your intended data.
Click “+ Add filter” to add your first filter. You can use the trash can icon to delete a filter, and add more filters by using the button below. For each filter, you must define the field, operation, and value:
Field: In the first input, select the field that you want to filter on.
Operation: In the second input, you’ll choose how you want to compare values and select whether you are comparing against a fixed value or a dynamic value that comes from another component.
Operators - “equal to”, “is not equal to”, “greater than”, “greater than or equal to”, “less than”, “less than or equal to”, “is null” (preset filter-only), “is not null” (preset filter-only), and “contains” (string-only). For charts, you can select "is within last" to filter based on a prior time period.
Value: For a preset filter, input the comparison value here. In the case of a dynamic filter, you will see a dropdown list of other components in the space.
To filter your chart records based on the value a user inputs into a filter component, simply select the name of the filter component and then choose “Value”. Your chart will update whenever a user types new values into this filter component (to only show records based on the filter).
To filter your chart records based on a row selected in a table , select the name of the table component, then choose “Selected Row”, “Data'', and then finally the specific field to provide the comparison value (this can include hidden fields in that table). Whenever a user selects a row in the table, your chart will automatically be filtered to show those results.
To filter your chart records based on a detail component, select the name of the detail component, then choose "Data" and then finally the specific field to provide the comparison value.
How should the query for your data be ordered?
Choose an attribute (then ascending or descending) to determine the order for the data when queried. This comes into play when more than 1000 records can exist - this will determine what the "first" 1000 records charted will be. You can also leave this as "no default order".