QPR ProcessAnalyzer Graphs: Difference between revisions

From QPR ProcessAnalyzer Wiki
Jump to navigation Jump to search
Line 109: Line 109:
== Conditional Formatting ==
== Conditional Formatting ==


Conditional formatting can be used to define data point (column, bar, point depending on chart type) colors for individual series. The following JSON settings are stored in the measure/dimension settings:
Conditional formatting can be used to define data point colors (i.e. color for column, bar, circle etc. depending on chart type). The conditional formatting is defined for each measure/dimension separately that is mapped to the y-axis.
 
Conditional formatting example:
<pre>
<pre>
{
{
Line 126: Line 128:
}
}
</pre>
</pre>
See more examples from the [[QPR_ProcessAnalyzer_Table#Conditional_Formatting|table conditional formatting]] how to define conditional formatting for graphs. Note that graphs only support the '''color''' property.
[[Category: QPR ProcessAnalyzer]]
[[Category: QPR ProcessAnalyzer]]

Revision as of 19:23, 9 November 2020

Graph Functionalities

Graph has the following functionalities:

Chart Colors

Series colors in charts are based on following settings:

  • Series colors come by default from a color palette.
  • Custom color palette can be defined.
  • Series colors can be overridden for individual measures/dimensions.

If defined, the data point colors override series colors for individual data points. Data point colors can be defined using following rules:

  • Data point colors can be defined for all series using a measure/dimension that is mapped to a data point color.
  • Conditional formatting can be used to define rules for data point colors for individual series. This will override the previous.

Customization Examples

Example for hiding legend.

{
  "legend": {
    "enabled": false
  }
}

Example for forcing a minimum value for the first (left side) Y-axis.

{
  "yAxis": [
    {
      "min": 0,
      "max": 100
    }
  ]
}

Example for forcing a minimum value for two Y-axes (left and right side).

{
  "yAxis": [
    {
      "min": 0,
      "max": 100
    },
        {
      "min": 0,
      "max": 10000
    }
  ]
}

Example for forcing a minimum and maximum value for the second (right side) Y-axis without forcing a maximum value on the first (left side) Y-axis and giving custom titles for the two Y-axes.

{
  "yAxis": [
    {
      "min": 0,
      "title": {
        "text": "Left Y-axis"
      }
    },
    {
      "min": 0,
      "max": 100,
      "title": {
        "text": "Right Y-axis"
      }
    }
  ]
}

Example for hiding the second Y-axis.

{
 "yAxis": [
   {
     "visible": true
   },
   {
     "visible": false
   }
 ]
}

Example for forcing a minimum value for the X-axis.

{
  "xAxis": {
    "min": 0,
    "max": 10
  }
}

Example for reversing order for the Y-axis.

{
  "yAxis": [
    {
      "reversed": true
    }
  ]
}

Conditional Formatting

Conditional formatting can be used to define data point colors (i.e. color for column, bar, circle etc. depending on chart type). The conditional formatting is defined for each measure/dimension separately that is mapped to the y-axis.

Conditional formatting example:

{
	"color": {
		"rules": [
			{
				"value": 100,
				"comparison": ">",
				"color": "#36d475"
			},
			{
				"color": "#EF5254"
			}
		]
	}
}

See more examples from the table conditional formatting how to define conditional formatting for graphs. Note that graphs only support the color property.