Line Chart
Produces a line chart for a user-specified X-axis and Y-axis, and aggregates the values in the Y-axis.
Information at a Glance
Category | Explore |
Data source type | HD |
Sends output to other operators | Yes |
Data processing tool | Spark SQL |
Line Chart takes the parameters you specify and charts the aggregated X-axis column(s) and Y-axis columns, using Plotly to display an interactive chart. You can choose multiple columns to graph as long as they all use the same aggregation method.
Input
A single tabular data set.
- Bad or Missing Values
- Line Chart filters data on the Y-axis selector to select numeric values only, because this column has numeric operations performed on it. The operator cannot automatically convert dates that are put in as character arrays, so conversion is the user's responsibility. The operator handles null values by skipping fully null data points, but it also can manage them in aggregations.
Configuration
Parameter | Description |
---|---|
Notes | Any notes or helpful information about this operator's parameter settings. When you enter content in the Notes field, a yellow asterisk is displayed on the operator. |
X-Axis Values | The column by which to group or aggregate and display on the x-axis. |
Y-Axis Values | The column used on the y-axis of the chart. These are the numeric values that are aggregated based on the x-axis value or category. |
Aggregation Method | The type of aggregation to perform on the numeric y-axis values. The options are the following. |
Maximum Number of Plot Points | The maximum number aggregations that are plotted on the line.
For example, if you have 100 values, and you aggregate the sum according to each value and set the parameter to 90, then Line Chart plots only the first 90 aggregated values and ignores the last 10 aggregated values. |
Output Directory | The location to store the output files. |
Output Name | The name to contain the results. |
Overwrite Output | Specifies whether to delete existing data at that path. |
Advanced Spark Settings Automatic Optimization |
|
Copyright © Cloud Software Group, Inc. All rights reserved.