Milestone

Notes and Constraints

• Timeline-Time Dimension: Support only one field.
• Node Label-Dimension: If there are no metrics, up to three dimensions are supported. If there are metrics, up to one dimension is supported.
• Node Label-Metric: If there are no dimensions, up to three metrics are supported. If there are dimensions, up to one metric is supported.
• Status-Dimension: Only one field can be dragged to this area and it will be used in the condition format.
• Only the time type field (day, week, month, quarter, and year) can be dragged to the time dimension. The second, minute, and hour types are not supported.

Field

1. In the Data area on the right, select a dataset, and double-click or drag required dimension and metric fields to the corresponding areas on the Fields tab.
2. Set a filter.
   1. Find the data field you need in the dimension and metric lists within the data column.
   2. Click next to the field you wish to filter and you will be directed to the filter settings page.
   3. Click OK.

      Table 1 Filter parameters

      Type	Parameter	Description
      string	Condition	Filter Mode: The options are Condition and Enumeration. Condition Type: The options are And condition and Or condition. Filter Condition: The options are Exact match, Contain, Start with, End with, Not match, Not contain, Null, and Not null.
      	Enumeration	Query Mode: The options are Single-select and multi-select. Filter Condition: The options are >, ≥, <, ≤, =, ≠, Null, and Not null.
      Metric	Condition Type	The options are And condition and Or condition.
      	Filter Condition	The options are >, ≥, <, ≤, =, ≠, Null, and Not null. You can select Before aggregation and After aggregation for data. NOTE: If you select Before aggregation, data is filtered before aggregation. If you select After aggregation, data is filtered after aggregation. For aggregation concepts, see Creating a Dataset. You can click Create Filter Condition to set multiple filter criteria.
      Date	Range value	Select a time range for filtering.
      	Single value	Set a single time for filtering.
      	Condition	You can select And condition or Or condition as the condition type and select filter condition like >, ≥, <, ≤, and =. You can click Create Filter Condition to set multiple filter criteria.

3. Set sorting.
   1. Drag and drop required data fields from the Dimension and Metric (Indicator) areas under Data to the Sorting area.
   2. Click next to a field in the Sorting area and select a sorting mode. The sorting modes are Ascending, Descending, and Custom.
   3. To cancel sorting, click next to the sorting field.
4. Set the maximum number of query results.

   Enter the maximum number of records that can be returned in the text box. The default value is 1000.

5. Set automatic refresh.

   The auto refresh interval supports the following options: no refresh, 1 minute, 5 minutes, 15 minutes, and 30 minutes.

Style

This section describes the style parameters of a funnel chart.

• Size/Position
  • W: width of the target, in pixels.
  • H: height of the target, in pixels.
  • X: position of the target on the canvas, in pixels.
  • Y: position of the target on the canvas, in pixels.
  • Opacity: Adjust the transparency of the target on the canvas using a slider or by manually entering a percentage. A higher percentage means lower transparency.
  Figure 1 Size/Position
  
• Basic Chart Style
  • The chart switch type can be Milestone or Interval.
  • Node
    • Color Scheme: You can select Singel color or By node. The color can be customized.
    • Size: The node size can be customized. The value ranges from 8 to 48.
    • Distance: You can select Proportional or Equal division.
  • Line: width and color can be customized. The width of the line ranges from 1 to 48.
• Node label
  • Show Node Label: You can determine whether to display the node label.
  • Label
    • Label Layout: staggered, above-axis, and below-axis.
    • Alignment: left-aligned, center-aligned, and right-aligned.
    • Show Timeline Field: You can determine whether to display the timeline field on the chart.
    • Show Label Field: You can determine whether to display the node label on the chart.
    • Show Today: You can determine whether to display the label of the current day (today) on the milestone.
• Condition Format

  The series in Conditional Format is defined by the Status-Dimension on the Fields tab page. You can set the style of different states.

  • To set the condition format, perform the following steps:
    1. Select a series from the drop-down list.
    2. Select Custom Style and click the pen icon on the right of Custom Style. The Custom Style page is displayed.
    3. Click Add Rule, select a status, and set the node color, status icon, node icon size, line color, and line width.
    4. After setting the parameters, click OK. The condition format is set successfully.
    5. Click Preview in the upper right corner to view the configured condition format.

       The configured status will be displayed based on the condition format. The status that is not configured will be displayed based on the global demonstration.