Format types table

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

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

Note

Kyvos supports naming semantic model entities in the ENTITY_ format, such as DIMENSION_, DIM_, and MEASURE_, and so on.

Kyvos provides a selection of default formats. For example, you can format numbers, currency, dates, times, network IDs, and text. You can also set up a custom format.To format the selected item, perform the following steps:

Do one of the following:
1. When a measure in a semantic model is selected, click the Actions menu (...) next to the Format property.
2. When editing a format action in a dataset, in the Field Format Properties, click the ... in the Input Format column for the selected field.
3. Select the format type, for example, Number.
Follow the instructions in the table below, then click Apply.

Format	Description

Format	Description
Number	The format box shows the results of the current settings. Enter the number of decimal places. Specify how negative values are displayed –for example with a minus sign and parentheses (-1234). Click the checkbox to include thousands separators.
Currency	The format box shows the results of the current settings. Enter the number of decimal places. Specify how negative values are displayed –for example with a minus sign and parentheses (-1234). Select a unit type: None, Rs, $, or euros. Click the checkbox to include thousands separators.
Date	The format box shows the results of the current settings. Select a predefined format from the list. The number of letters indicates the number of values that will be shown. For example, yy or yyyy both indicate year, for example, 19 or 2019. M is month, d is day, y is year, q is quarter, H is hours, m is minutes, s is seconds, and a indicates am or pm. If you choose Custom, enter a custom format.
Time	The format box shows the results of the current settings. Select a predefined format from the list. The number of letters indicates the number of values that will be shown. H is hours, m is minutes, s is seconds, and a indicates am or pm. If you choose Custom, enter a custom format.
Duration	The format box shows the results of the current settings. Select a predefined format from the list. The number of letters indicates the number of values that will be shown. H is hours, m is minutes, and s is seconds. If you choose Custom, enter a custom format.
Percentage	The format box shows the results of the current settings. Enter the number of decimal places.
Scientific	The format box shows the results of the current settings. Enter the number of decimal places.
Text	The format box shows the results of the current settings. Select a format type from the list: None, lower case, or upper case. Note: Applicable for datasets only. Datasets are now deprecated.
Network ID	The format box shows the results of the current settings. Select a format from the list: IP Address (IPv4) or MAC Address. Note: Applicable for datasets only. Datasets are now deprecated.
Custom	Enter the format of the custom type.

Related topics

Formatting measures