The Pie Chart Control offers numerous options to display at-a-glance data on your Dashboard.
Basic information about creating Controls is found in Dashboard Controls. This topic describes the fields and options available to create Pie Charts for your WebTMA Dashboard.
Pie Chart Configuration Fields
Using the Configuration Section for a Pie Chart, you can add or select options that determine the appearance of your Pie Chart.
Name – the label that appears at the top of the control (required).
Comments – free-form information for the person who adds the Control. It does not display on the Control itself.
Query Method – the type of query you want to use. The Window Query looks to the Base Window and Base Query described below. The Custom Query is restricted to SQL Custom Queries.
Base Window – used to select the module where your data Query is stored such as Work Order, Equipment, and Vehicle. Queries are created and saved using the Find flyout for the module.
Base Query – used to select a saved Query from the selected window.
Label Format – select the way you want labels displayed – if at all.
Show Labels – check this box to display the labels.
Show Tooltips – mark this check box to determine whether you can see the related information in a tooltip popup when you move the cursor over a bar in the chart.
Show Legend – exclusive to the Pie Chart, this check box determines whether the text legends for each data segment are displayed
Aggregate Column – the attribute you want to segment in the chart. If the aggregate column is numeric, you can sum, average, get the minimum value, get the maximum value, or count the number of records. If the aggregate column is text, you can only aggregate with a count of the return results.
Aggregate Operator – the action you want to apply to the Aggregate Column.
Group By Column – the column within the query to use as an additional segment.
Click the Legacy Query Builder button to set up multiple queries per Pie Chart.
How to Add Pie Chart Controls
Follow the initial steps outlined in How to Add Dashboard Controls.
- Select the Pie Chart icon.
- Select the desired Color Palette block.
- Enter a Name for the chart.
- Select the Query Method
- Select other options defined in Pie Chart Configuration Fields.
- Click the Preview button to see if the Pie Chart meets your expectations.
- Click the Save button on the Add Item flyout.
On the underlying Tab, rearrange and re-size the Controls with the standard MS Windows click-and-drag and resizing arrows.
Want to Know More?
Visit the WebTMA Help Page