Applies to: 
Kyvos Enterprise Kyvos Cloud (SaaS on AWS) Kyvos AWS Marketplace
Kyvos Azure Marketplace Kyvos GCP Marketplace Kyvos Single Node Installation (Kyvos SNI)
...
Kyvos supports a Dynamic Measure title that can be applied to a worksheet or Dashboard. When the value of a dimension filter is changed, the measure title will automatically update to reflect the selected value of the dimension filter. See the Filtering data in worksheets section for more details.
...
Measure value: Displays the M easure value when the filter value is changed.
Measure title: Displays the Measure title along with the Measure value. You can also reuse the Measure title for other Measure values.
Sample Expression
For example, you have a semantic model with a dimension called 'Calculation Type,' and this dimension has members such as MTD, YOY, YTD, and so on. Multiple calculated measures are created in the semantic model, and their values depend on the Calculation Type filter selected in the view. When you modify the filter value, the title of the measure will change accordingly.
Consider an example where a Calculated Measure displays a dynamic title, i.e., 'Dynamic Caption'.
Following is the sample expression for a dynamic Measure value
| Code Block |
|---|
iif([CalculationType].[CalculationType].currentmember is [CalculationType].[CalculationType].&[YOY],
"YOY ",
iif([CalculationType].[CalculationType].currentmember is [CalculationType].[CalculationType].&[YTD],
"YTD ",
iif([CalculationType].[CalculationType].currentmember is [CalculationType].[CalculationType].&[MTD],
"MTD " ,null))) |
Following is the sample expression for a dynamic Measure title
| Code Block |
|---|
iif([CalculationType].[CalculationType].currentmember is [CalculationType].[CalculationType].&[YOY],
[Measures].[YOY Sales],
iif([CalculationType].[CalculationType].currentmember is [CalculationType].[CalculationType].&[YTD],
[Measures].[YTD Sales],
iif([CalculationType].[CalculationType].currentmember is [CalculationType].[CalculationType].&[MTD],
[Measures].[MTD Sales],null))), DYNAMIC_CAPTION = [Measures].[Dynamic Caption] + "On Sales" |
...
| Panel |
|---|
| panelIconId | atlassian-note |
|---|
| panelIcon | :note: |
|---|
| bgColor | #DEEBFF |
|---|
|
Note The changes are specific to the Kyvos Visualization layer and will not impact any third-party BI tool. When the filter is not applied to the Calculation Type Hierarchy or is applied to multiple members of the hierarchy, the Measure Name (also referred to as the static caption), as displayed in the above example (such as 'On Sales'), will be shown. However, if the filter is applied to a single member of the Calculation Type Hierarchy, the Measure value you have set by using the DYNAMIC_CAPTION function will be displayed on the KPIs, charts, labels, titles, axes, tooltips, and legends. Kyvos supports naming semantic model entities in the ENTITY_ format, such as DIMENSION_, DIM_, MEASURE_, and so on.
|
...
In the Measures column, select the measure.
In Measure Properties, select Expression.
On the Expression dialog box, specify the expression as per your requirement. Click the i icons to learn more.
| Aura tab collection |
|---|
| params | JTdCJTIyZ2VuZXJhbCUyMiUzQSU3QiUyMnRhYlNwYWNpbmclMjIlM0EwJTJDJTIydGFiV2lkdGglMjIlM0ExMDAlMkMlMjJ0YWJIZWlnaHQlMjIlM0E1MCUyQyUyMmRpcmVjdGlvbiUyMiUzQSUyMmhvcml6b250YWwlMjIlN0QlMkMlMjJjb250ZW50JTIyJTNBJTdCJTIyYmFja2dyb3VuZENvbG9yJTIyJTNBJTdCJTIyY29sb3IlMjIlM0ElMjIlMjNmZmYlMjIlN0QlMkMlMjJib3JkZXIlMjIlM0ElN0IlMjJzdHlsZSUyMiUzQSUyMnNvbGlkJTIyJTJDJTIyd2lkdGglMjIlM0ExJTJDJTIydG9wJTIyJTNBdHJ1ZSUyQyUyMmJvdHRvbSUyMiUzQXRydWUlMkMlMjJsZWZ0JTIyJTNBdHJ1ZSUyQyUyMnJpZ2h0JTIyJTNBdHJ1ZSUyQyUyMmNvbG9yJTIyJTNBJTdCJTIybGlnaHQlMjIlM0ElMjIlMjNjY2NlY2YlMjIlN0QlN0QlMkMlMjJwYWRkaW5nJTIyJTNBJTdCJTIydG9wJTIyJTNBMTAlMkMlMjJyaWdodCUyMiUzQTEwJTJDJTIyYm90dG9tJTIyJTNBMTAlMkMlMjJsZWZ0JTIyJTNBMTAlN0QlN0QlMkMlMjJhY3RpdmUlMjIlM0ElN0IlMjJiYWNrZ3JvdW5kQ29sb3IlMjIlM0ElN0IlMjJjb2xvciUyMiUzQSU3QiUyMmxpZ2h0JTIyJTNBJTIyJTIzZjU4MjI3JTIyJTdEJTdEJTJDJTIydGV4dCUyMiUzQSU3QiUyMmZvbnRTaXplJTIyJTNBMTYlMkMlMjJjb2xvciUyMiUzQSU3QiUyMmxpZ2h0JTIyJTNBJTIyJTIzMDAwMDAwJTIyJTdEJTJDJTIydGV4dEFsaWduJTIyJTNBJTIybGVmdCUyMiUyQyUyMmZvbnRXZWlnaHQlMjIlM0ElMjJib2xkJTIyJTdEJTdEJTJDJTIyaG92ZXIlMjIlM0ElN0IlMjJiYWNrZ3JvdW5kQ29sb3IlMjIlM0ElN0IlMjJjb2xvciUyMiUzQSUyMiUyM2RmZTFlNiUyMiU3RCUyQyUyMnRleHQlMjIlM0ElN0IlMjJmb250U2l6ZSUyMiUzQTE4JTJDJTIyY29sb3IlMjIlM0ElMjIlMjM1ZTZjODQlMjIlMkMlMjJ0ZXh0QWxpZ24lMjIlM0ElMjJsZWZ0JTIyJTJDJTIyZm9udFdlaWdodCUyMiUzQSUyMmxpZ2h0ZXIlMjIlN0QlN0QlMkMlMjJpbmFjdGl2ZSUyMiUzQSU3QiUyMmJhY2tncm91bmRDb2xvciUyMiUzQSU3QiUyMmNvbG9yJTIyJTNBJTIyJTIzZjRmNWY3JTIyJTdEJTJDJTIydGV4dCUyMiUzQSU3QiUyMmZvbnRTaXplJTIyJTNBMTYlMkMlMjJjb2xvciUyMiUzQSUyMiUyMzVlNmM4NCUyMiUyQyUyMnRleHRBbGlnbiUyMiUzQSUyMmxlZnQlMjIlMkMlMjJmb250V2VpZ2h0JTIyJTNBJTIybGlnaHRlciUyMiU3RCUyQyUyMmJvcmRlciUyMiUzQSU3QiUyMnRvcCUyMiUzQXRydWUlMkMlMjJsZWZ0JTIyJTNBdHJ1ZSUyQyUyMnJpZ2h0JTIyJTNBdHJ1ZSUyQyUyMmJvdHRvbSUyMiUzQXRydWUlMkMlMjJ3aWR0aCUyMiUzQTElMkMlMjJzdHlsZSUyMiUzQSUyMnNvbGlkJTIyJTJDJTIyY29sb3IlMjIlM0ElN0IlMjJsaWdodCUyMiUzQSUyMiUyM2NjY2VjZiUyMiU3RCU3RCU3RCU3RA== |
|---|
|
| Aura tab |
|---|
| summary | Tab 1Expression for Dynamic Value |
|---|
| params | JTdCJTIydGl0bGUlMjIlM0ElMjJUYWIlMjAxJTIyJTdE |
|---|
|
These are the steps Step 1 for editing Step 2 for editing| JTdCJTIydGl0bGUlMjIlM0ElMjJFeHByZXNzaW9uJTIwZm9yJTIwRHluYW1pYyUyMFZhbHVlJTIyJTdE |
|
 Image Added| Aura tab |
|---|
| summary | Tab 2 Expression for Dynamic Title |
|---|
| params | JTdCJTIydGl0bGUlMjIlM0ElMjJUYWIlMjAyJTIwJTIyJTdE |
|---|
|
Step 1 for editing Step 2 for editing| JTdCJTIydGl0bGUlMjIlM0ElMjJFeHByZXNzaW9uJTIwZm9yJTIwRHluYW1pYyUyMFRpdGxlJTIwJTIyJTdE |
|
 Image Added |
Click Validate to validate your criteria.
If you have made changes and don’t want to keep them, click Cancel.
Click Save. The Dynamic Measure name and caption that you created are applicable to a Worksheet or a Dashboard.
Worksheet
Dashboard
