Document toolboxDocument toolbox

Formatting measure and attributes

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 offers various default number formats such as numbers, currency, percentage, scientific, and custom. At the worksheet level, you can format measures to modify the number format, like reporting in millions or percentages or adjusting the decimal places displayed. Additionally, you can alter the decimal places or date format for measure across multiple reports.

From Kyvos 2024.9 onwards, you can apply smart labels for date type attribute in XY family charts.

Changing the format

To change the format, perform the following steps. 

  1. From the Toolbox, select Workbooks, then select a workbook and worksheet. 

  2. Select Design if needed. 

  3. In the View type, right-click an element that you want to format. Click the i icon to learn more.

  4. To change the format, select Field Settings >Format.
    Optionally, you can click Options> Field Settings >Format. The Format dialog box is displayed.  

  5. Choose the desired format type from the list and enter relevant values.

  6. Click Apply.

For details on using the formatting options, see  Format types table .

Formatting date attributes 

To generate reports with the desired date format, you can format date attributes in the worksheet. You have the option of using either a predefined or a custom date format.

To format a date attribute, perform the following steps. 

  1. From the Toolbox, select  Workbooks, then select a workbook and worksheet. 

  2. Select Design if needed. 

  3. In the View type, right-click the date attribute that you want to format. Click the  i   icon to learn more.

  4. To change the format, select Field Settings >Format.
    Optionally, you can click Options> Field Settings >Format.
    The Format dialog box is displayed.

  5. Select the Predefined date format from the list or you can specify the Custom format. 

  6. Click Apply.  

Smart labels for date type attribute in XY family charts

Kyvos offers smart labeling for date-type attributes in XY family charts. These labels can display date values in various formats, such as showing only the month or year. For instance, if the data contains date values spans two years, the labels on the X-axis will display unique month-year combinations.

  • Smart labels dynamically adjust on zooming chart in and out, displaying values at the most relevant level of granularity. 

  • Display smart labels for date attribute or date level (custom time hierarchy).

  • You will not be able to display smart labels for predefined time hierarchy.

  • You can export PDF with smart X-axis labels for XY family chart.  

To set the smart label for date type attribute in XY family charts, perform the following steps: 

  1. From the Toolbox, select Workbooks, then select a workbook and worksheet. 

  2. Select Design if needed. 

  3. In the Properties pane, select Default or Smart lable option for X-Axis Label Type.

    1. Default: The date values are displayed exactly as retrieved from the semantic model.

    2. Smart: Date values are adjusted to display the most relevant level of detail. By enabling smart labels, you can see more succinct labels. Dates are grouped together, and labels show a greater level of detail.

      image-20240912-133644.png

 

Copyright Kyvos, Inc. All rights reserved.