Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The following options are available in the General Options section:

 

 


Expand
titleTitle

 


The title will appear above the Single KPI area in your analysis sheet.

 

 

Please specify your desired title into the text field.

 

Next to the text field, a small pencil icon () appears.

This will open the area options, or display the title configuration directly under the text field:

You may edit your font, its size ,text highlighting, colors (font-, background - and border color) and your text orientation.


 


Expand
titleType

 


The Single KPI comes with 4 different types, that can be compared to skins.

 

Choose any type from the dropdown list.

Let's examine the types a little further:

Expand
titleGauge

Gauge is the default type of a Single KPI.

Your component will be displayed like a tachometer:

 


Expand
titleRadial

Your KPI will be aggregated to a circle line:

 


Expand
titleFill

Your component will be displayed as a vertical bar. 


Expand
titleNumber

Your component will be displayed as a single number.

 


 


Expand
titleKPI

 


Enter your PQL statement in the KPI section.

You can make use of the Formula Editor.

 

For the sample charts that are shown in the screenshot, the following PQL statement has been created with the formula editor to display the median time (in days) that a case in a Purchase-to-pay process needs from the Creation of a purchase order until the receiption of goods.

Code Block
languagesql
firstline1
titleAverage Purchase Time
linenumberstrue
MEDIAN(CALC_THROUGHPUT(FIRST_OCCURRENCE['Create Purchase Order'] TO FIRST_OCCURRENCE['Receive Goods'], REMAP_TIMESTAMPS("_CEL_P2P_ACTIVITIES"."_EVENTTIME", DAYS)))

 


 


Expand
titleUnits

 


 

In the Units field you can specify a custom unit, which will be displayed right after the aggregated number of the KPI.

 

 


 


Expand
titleSubtitle

 


 

To show a Subtitle under your component, you can use this text field:

 

 

Next to the text field, a small pencil icon () appears.

This will carry you on to the Formatting Options


 


Expand
titleColoring

 


As you can see, Single KPIs work with colors.

You can choose between a Single color or use color thresholds, to color your KPI according to a certain value area.

 

Single Color

Select Single Color and choose a color from the color palette.

Your whole component will be colored in this color.

 

Color Threshold

Select Threshold to make use of value area coloring.

The displayed numbers are our thresholds.

To edit them, click on any marked area in the color stripe:

Here, you can assign a threshold as a PQL statement or enter a static number.

Entering a PQL statement allows you to color your thresholds in a dynamic matter. Not only your aggregated KPI, but also your thresholds will adopt as soon as changes in the datamodel occur.

 

Additionally you can use the well known color palette to define a color.

This color will be applied to all values that are smaller or equal to the threshold.

 

To delete your threshold, click on Delete threshold.

Don't forget to save your settings with .

 

To add a new threshold, use the link next to the color stripe:

 

Threseholds are sorted automatically in an ascending order.

 

Please note, that all thresholds that exceed your aggregated KPI will be displayed in different grey colors.


 


Expand
titleText size


Note
titlePlease Note
This option is only available, when you have selected the type Number (see above).

By default, the text size is adapted to the size of the chart area. However, you can set a manual text size by selecting Manual.

Enter your desired Font size and your text-alignment.

 

If you activated a subtitle, these settings also apply for the subtitle.


Expand
titleComponent is not filtered with selections

If you don't want your component to be affected by any external selection, activate the Component is not filtered with selections checkbox.