Generate Charts
Description
Use the step to generate the chart as per input data.
Notes:
- All rows with valid data are required to generate the chart. And if even if a single value in the row is missing or invalid, then you will see an error.
- Input colors must be in the format [r,g,b] where r, g, and b are integers in the range 0 to 255.
Limitation: There is no error handling hop available for this step
Configurations
| No. | Field Name | Description |
|---|---|---|
| 1 | Step Name | Specify a unique step name for a single workflow. The field is mandatory. |
| 2 | Chart Type | Select the type of chart from the list: - Bar - Pie - Line - Mixed Chart - Pareto - Scatter The field is mandatory. |
| 3 | X-Axis | Select or specify a value for the X-axis of the chart. The field is mandatory. |
| 4 | Chart Title | Specify the title to display at the top of the chart. The field is mandatory. |
| 5 | Maximum Value On First Y-Axis | Specify the maximum value to display on the first Y-Axis. The value determines the upper limit of the axis range. Note: The field is available if the chart type is Pareto or Mix Chart. |
| 6 | Maximum Value On Second Y Axis | Specify the maximum value to display on the second Y-Axis. The value determines the upper limit of the axis range. Note: The field is available if the chart type is Pareto or Mix Chart. |
| 7 | X-Axis Title | Specify the title to display on the X-Axis of the chart. The title describes the data represented along the horizontal axis. Note: The field is not available for the chart type Pie The field is mandatory. |
| 8 | Y-Axis Title | Specify the title to display on the Y-Axis of the chart. The title describes the data represented along the vertical axis. Note: The field is not available for the Chart type Pie. The field is mandatory. |
| 9 | Y-Axis 2Title | Specify the title to display on the second Y-Axis of the chart. The title describes the data represented along the second vertical axis. Note: The field is available for the Chart type Pareto and Mix Chart. The field is mandatory. |
| 10 | Canvas Background | Specify the color value in RGB format for the canvas background. For example, use [0,0,255] for blue or [255,255,255] for white. Note: The field is not available for Chart Type Pareto. The field is mandatory. |
| 11 | Graph Background | Specify the color value in RGB format for the graph background. For example, use [0,0,255] for blue or [255,255,255] for white. Note: The field is not available for Chart Type Pareto. The field is mandatory. |
| 12 | Output File Name | Specify the full file path of the output file, including the file extension,for example,/path/to/output/filename.png or, /path/to/output/filename.jpeg Supported file types: PNG and JPEG. The field is mandatory. |
| 13 | Height | Specify the height of the generated image in pixels. Note: The value must be a positive integer. The field is mandatory. |
| 14 | Width | Specify the width of the generated image in pixels. Note: The value must be a positive integer. The field is mandatory. |
| 15 | Tick Interval of X-Axis | Specify the tick interval value for the X-axis. The value determines the spacing between labels on the X-Axis. Note: - The field is available only if the X-Axis is numerical and not categorical. - The value must be a positive integer. - The field is not available for the Chart Type Bar, Pie, Pareto, and Mix Chart - If you provide an invalid tick interval (anything other than a positive integer), the system skips the exception and internally uses an automated value instead |
| 16 | Tick Interval of Y-Axis | Specify the tick interval value for the first Y-axis. The value determines the spacing between labels on the Y-Axis. Note: - The value must be a positive integer. - If you provide an invalid tick interval (anything other than a positive integer), the system skips the exception and internally uses an automated value instead - The field is not available for the Chart Type Pie. |
| 17 | Tick Interval of Y-Axis 2 | Specify the tick interval value for the second Y-axis. The value determines the spacing between labels on the axis. Note: - The value must be a positive integer. - If you provide an invalid tick interval (anything other than a positive integer), the system skips the exception and internally uses an automated value instead - The field is available for the Chart Type of Pareto and Mix Chart. |
| 18 | Rotation of Labels | Enter the rotation angle in degrees for the X-axis labels. Labels will be rotated anticlockwise to avoid overlap if the length is too large. Note: - The value must be a positive integer. - The field is not available for Pie, Line and Scatter chart types. |
| 19 | Include Bar Values | Select Include Bar Values, to print the numerical value on top of bars in the bar chart for better readability. Note: - The checkbox is available only for chart type Bar. |
| 20 | Include filename in result | Select Include filename in result, to include output filename in the result. If selected, the generated chart file path will be included in the result files for further processing or reference. The file will be available for download on the AutomationEdge web portal under the Request Tab. |
| 21 | Y-Axis | Specify the series data for Y-Axis. The field is mandatory. |
| 21.a | Name | Select the field name for series data. |
| 21.b | Label In Legend | Specify the title for series data. |
| 21.c | Color | Specify the color value in RGB format. For example [0,0,255] for blue, or [255,255,255] for white Or [255,255,255], [255,0,255], [0,255,255] for specifying multiple colors. Note: - If no value is specified, an automated color is assigned to this field. - For Chart Type Pie with six quadrants, if only one color is specified, for the remaining five segments automated colors are assigned. |
| 21.d | Series Type | Select the series type from the list: - Bar - Line Note: The field is available if the Chart type is Mix Chart. |
| 21.e | Y-Axis Choice | Select the choice for Y-axis for the series data. - 1 - 2 Note: The field is available only if the Chart type is Mix Chart. |
| 22 | Get Fields | Click Get Fields, to fetch the series data. |