...
Select the view type as KPI to use the Rich Text Editor on your worksheet.
From the properties on the right, select the Template as None, and then click the Customize Design link.
The Rich Text Editor is displayed, as shown in the following figure.
Inserting Measure Value, Filter Value, or Parameter Value in a KPI
...
On the worksheet design page, drag the measure onto the Y-axis shelf of the KPI and apply filters that you want to include in KPI
Select the Template as None, and click Customize Design.
On the Rich Text Editor dialog, click Insert and select the Measures, Filters, or Parameters as shown in the image. The corresponding placeholders are added to the dialog, which will be replaced with the actual value in KPI.
Inserting images in KPI
To insert an image in the KPI, perform the following steps.
On the Rich Text Editor, click the three-dot menu, and click the image icon to insert the image.
On the displayed Insert/Edit Image dialog, you can insert the image using any of the following:
If it is an online image, provide the image URL in the Source field.
If the image is placed at the Kyvos setup location, you can pick it from the Image list.
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
Note You can change the Width and Height of the image. To unlock sizing, click the lock icon. Only the images placed at client\themes\worksheet\images\custom\ location are displayed in the Images list. |
...
For this, click Insert > Conditions.
Select the conditions from If-Else, If-ElseIf, Complex If, or Complex If-else-ElseIfIf.
Let us consider an example where you want to highlight the KPI such that if the discount is greater than zero, it should be shown in Green; otherwise in Red.
...