QPR ProcessAnalyzer Graphs: Difference between revisions

From QPR ProcessAnalyzer Wiki
Jump to navigation Jump to search
Line 11: Line 11:
If defined, the data point colors override series color for individual data points. Data point colors can be defined using following rules:
If defined, the data point colors override series color for individual data points. Data point colors can be defined using following rules:
* For entire graph, data point colors can be defined using a measure/dimension that is mapped to a '''data point color''' (available in the measure/dimension settings).
* For entire graph, data point colors can be defined using a measure/dimension that is mapped to a '''data point color''' (available in the measure/dimension settings).
* For individual series, '''[[QPR_ProcessAnalyzer_Chart#Measure.2C_Dimension_and_Column_Settings|color mappings]]''' can be used to define a specific color to specific value.
* For individual series, '''[[QPR_ProcessAnalyzer_Chart#Measure.2C_Dimension_and_Column_Settings|color mappings]]''' can be used to define a specific color to specific value. This will override the previous one.
* For individual series, '''[[#Conditional_Formatting|conditional formatting]]''' can be used to define rules for data point colors (in the measure/dimension settings). This will override the previous.
* For individual series, '''[[#Conditional_Formatting|conditional formatting]]''' can be used to define rules for data point colors (in the measure/dimension settings). This will override the previous ones.


== Conditional Formatting ==
== Conditional Formatting ==

Revision as of 10:32, 11 January 2021

Graphs are general term for column, bar, line, area, etc. charts.

Graph Colors

In graphs, colors can be defined for series (i.e. all data points of the series) and individual data points. Data point colors will have priority over the series colors.

Series colors can be defined using the following settings:

  • By default, series colors come from a default color palette.
  • Custom color palette can be defined overriding the default color palette.
  • Series color can be set for individual measures/dimensions in the measure/dimension settings (overriding the palette color).

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

  • For entire graph, data point colors can be defined using a measure/dimension that is mapped to a data point color (available in the measure/dimension settings).
  • For individual series, color mappings can be used to define a specific color to specific value. This will override the previous one.
  • For individual series, conditional formatting can be used to define rules for data point colors (in the measure/dimension settings). This will override the previous ones.

Conditional Formatting

Conditional formatting can be used to define colors for each data point (i.e. color for column, bar, circle etc. depending on chart type). The conditional formatting is defined in the settings of the measure/dimension 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 in the top level in the JSON.

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
    }
  ]
}