Versions Compared

Old Version 1

changes.mady.by.user NIDHI BHANDARI

Saved on

compared with

New Version Current

changes.mady.by.user Sarabjeet Kaur

Saved on

Key

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

Applies to: (tick) Kyvos Enterprise  (tick) Kyvos Cloud (SaaS on AWS) (tick) Kyvos AWS Marketplace

(tick) Kyvos Azure Marketplace   (tick) Kyvos GCP Marketplace (tick) Kyvos Single Node Installation (Kyvos SNI)

...

Kyvos supports a Dynamic Measure format that can be applied to a worksheet or Dashboard. When the value of a dimension filter is changed, the measure format of the calculated measures will automatically update to reflect the selected value of the dimension filter. See the Filtering data in worksheets section for more details. 

...

  • Calculated measure: Displays the Measure value when the filter value is changed. 

  • Format measure: Displays the Measure format along with the Measure value. You can also reuse the Measure format 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 format of the calculated measure will change accordingly.

Consider an example where a Calculated Measure displays a dynamic format, i.e., DYNAMIC_FORMAT = [Measures].[FormatMeasure]

  • Following is the sample expression for a calculated measure

    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_FORMAT = [Measures].[FormatMeasure]

  • Following is the sample expression for a format measure

    Code Block
    iif([CalculationType].[CalculationType].currentmember is [CalculationType].[CalculationType].&[YOY],
"$#,##0.00",
iif([CalculationType].[CalculationType].currentmember is [CalculationType].[CalculationType].&[YTD],
"0.00% ",
iif([CalculationType].[CalculationType].currentmember is [CalculationType].[CalculationType].&[MTD],
"#,##0.000000" , “#,##0.00”)))

...

Aura tab collection
paramsJTdCJTIyZ2VuZXJhbCUyMiUzQSU3QiUyMnRhYlNwYWNpbmclMjIlM0EwJTJDJTIydGFiV2lkdGglMjIlM0ExMDAlMkMlMjJ0YWJIZWlnaHQlMjIlM0E1MCUyQyUyMmRpcmVjdGlvbiUyMiUzQSUyMmhvcml6b250YWwlMjIlN0QlMkMlMjJjb250ZW50JTIyJTNBJTdCJTIyYmFja2dyb3VuZENvbG9yJTIyJTNBJTdCJTIyY29sb3IlMjIlM0ElMjIlMjNmZmYlMjIlN0QlMkMlMjJib3JkZXIlMjIlM0ElN0IlMjJzdHlsZSUyMiUzQSUyMnNvbGlkJTIyJTJDJTIyd2lkdGglMjIlM0ExJTJDJTIydG9wJTIyJTNBdHJ1ZSUyQyUyMmJvdHRvbSUyMiUzQXRydWUlMkMlMjJsZWZ0JTIyJTNBdHJ1ZSUyQyUyMnJpZ2h0JTIyJTNBdHJ1ZSUyQyUyMmNvbG9yJTIyJTNBJTdCJTIybGlnaHQlMjIlM0ElMjIlMjNjY2NlY2YlMjIlN0QlN0QlMkMlMjJwYWRkaW5nJTIyJTNBJTdCJTIydG9wJTIyJTNBMTAlMkMlMjJyaWdodCUyMiUzQTEwJTJDJTIyYm90dG9tJTIyJTNBMTAlMkMlMjJsZWZ0JTIyJTNBMTAlN0QlN0QlMkMlMjJhY3RpdmUlMjIlM0ElN0IlMjJiYWNrZ3JvdW5kQ29sb3IlMjIlM0ElN0IlMjJjb2xvciUyMiUzQSU3QiUyMmxpZ2h0JTIyJTNBJTIyJTIzZjU4MjI3JTIyJTdEJTdEJTJDJTIydGV4dCUyMiUzQSU3QiUyMmZvbnRTaXplJTIyJTNBMTYlMkMlMjJjb2xvciUyMiUzQSU3QiUyMmxpZ2h0JTIyJTNBJTIyJTIzMDAwMDAwJTIyJTdEJTJDJTIydGV4dEFsaWduJTIyJTNBJTIybGVmdCUyMiUyQyUyMmZvbnRXZWlnaHQlMjIlM0ElMjJib2xkJTIyJTdEJTdEJTJDJTIyaG92ZXIlMjIlM0ElN0IlMjJiYWNrZ3JvdW5kQ29sb3IlMjIlM0ElN0IlMjJjb2xvciUyMiUzQSUyMiUyM2RmZTFlNiUyMiU3RCUyQyUyMnRleHQlMjIlM0ElN0IlMjJmb250U2l6ZSUyMiUzQTE4JTJDJTIyY29sb3IlMjIlM0ElMjIlMjM1ZTZjODQlMjIlMkMlMjJ0ZXh0QWxpZ24lMjIlM0ElMjJsZWZ0JTIyJTJDJTIyZm9udFdlaWdodCUyMiUzQSUyMmxpZ2h0ZXIlMjIlN0QlN0QlMkMlMjJpbmFjdGl2ZSUyMiUzQSU3QiUyMmJhY2tncm91bmRDb2xvciUyMiUzQSU3QiUyMmNvbG9yJTIyJTNBJTIyJTIzZjRmNWY3JTIyJTdEJTJDJTIydGV4dCUyMiUzQSU3QiUyMmZvbnRTaXplJTIyJTNBMTYlMkMlMjJjb2xvciUyMiUzQSUyMiUyMzVlNmM4NCUyMiUyQyUyMnRleHRBbGlnbiUyMiUzQSUyMmxlZnQlMjIlMkMlMjJmb250V2VpZ2h0JTIyJTNBJTIybGlnaHRlciUyMiU3RCUyQyUyMmJvcmRlciUyMiUzQSU3QiUyMnRvcCUyMiUzQXRydWUlMkMlMjJsZWZ0JTIyJTNBdHJ1ZSUyQyUyMnJpZ2h0JTIyJTNBdHJ1ZSUyQyUyMmJvdHRvbSUyMiUzQXRydWUlMkMlMjJ3aWR0aCUyMiUzQTElMkMlMjJzdHlsZSUyMiUzQSUyMnNvbGlkJTIyJTJDJTIyY29sb3IlMjIlM0ElN0IlMjJsaWdodCUyMiUzQSUyMiUyM2NjY2VjZiUyMiU3RCU3RCU3RCU3RA==
Aura tab
summaryTab 1 Expression for Calculated Measure
paramsJTdCJTIydGl0bGUlMjIlM0ElMjJUYWIlMjAxJTIwJTIyJTdE

These are the steps

  1. Step 1 for editing

  2. Step 2 for editing

JTdCJTIydGl0bGUlMjIlM0ElMjJFeHByZXNzaW9uJTIwZm9yJTIwQ2FsY3VsYXRlZCUyME1lYXN1cmUlMjIlN0Q=
image-20240214-113213.pngImage Added
Aura tab
summaryTab 2 Expression for Dynamic Format
paramsJTdCJTIydGl0bGUlMjIlM0ElMjJUYWIlMjAyJTIwJTIyJTdE

  • Step 1 for editing

    • Step 2 for editing
    JTdCJTIydGl0bGUlMjIlM0ElMjJFeHByZXNzaW9uJTIwZm9yJTIwRHluYW1pYyUyMEZvcm1hdCUyMiU3RA==
    image-20240214-113318.pngImage Added

    1. Click Validate to validate your criteria. 
      If you have made changes and don’t want to keep them, click Cancel.

    2. Click Save. The Dynamic Measure name and caption that you created are applicable to a Worksheet or a Dashboard.  

      Dynamic Format Measure- Worksheet 

      Dynamic Format Measure- Dashboard