Page Comparison

Appanvil karma designer

summary

Format number numbers This article focuses on how you can format numbers and apply conditional formatting logic in the visualizations you create via the BI tool. You can customize the format of the numbers for the metrics you add to your visualizations. For example, you can round numbers, shorten large numbers, display fixed number of zeros, display currency symbols, add colors, and so on.For every metric, you can configure your own custom format using specific syntax or select from a variety of predefined formats. Select Predefined Number Formats in the Metric Editor Predefined formats for numbers are available when using the Metric Editor.Follow these steps:Select the dropdown next to Number format.Select a predefined format. Predefined Number Formats The following table shows the predefined number formats: Note:Analytical Designer (AD) uses the format specified in the metric definition by default. You can overwrite the format when you are building your visualization in AD. Create a Custom Number Format in the Metric Editor A custom number format enables to you do the following for your metric:Select a specific format from various formatting templatesDefine your own number formatAdjust an already selected format.Follow these steps:Select the dropdown next to Number format.Select Custom. The **Custom Format** menu opens. 3. Edit the definition: * Insert your own, custom definition. * Select a template from the **Templates** menu.<div class="embedded-image" data-toggle="modal" data-bs-toggle="modal" data-target="#custom-number-templates-png" data-bs-target="#custom-number-templates-png"><img src="/ad/metrics/custom_number_templates.png" alt="custom number format" /></div><div class="modal fade" id="custom-number-templates-png" tabindex="-1" role="dialog" aria-labelledby="custom-number-templates-png" aria-hidden="true"><div class="modal-dialog embedded-image-dialog" role="document"><button type="button" class="close" data-dismiss="modal" data-bs-dismiss="modal" aria-label="Close"><svg width="30" height="30" viewBox="0 0 30 30" fill="none" xmlns="http://www.w3.org/2000/svg"><circle cx="15" cy="15" r="14.5" stroke="#fff"/><path fill-rule="evenodd" clip-rule="evenodd" d="M7.74375 21.0774C7.41832 21.4028 7.41831 21.9305 7.74375 22.2559 8.06919 22.5814 8.59683 22.5814 8.92226 22.2559l6.66664-6.6666C15.833 15.3452 15.894 14.9874 15.772 14.6864 15.7313 14.5861 15.6703 14.4921 15.5889 14.4107 15.5888 14.4106 15.5886 14.4104 15.5884 14.4102L8.92226 7.74408C8.59683 7.41864 8.06919 7.41864 7.74375 7.74408S7.41831 8.59715 7.74375 8.92259L13.8212 15 7.74375 21.0774z" fill="#fff"/><path fill-rule="evenodd" clip-rule="evenodd" d="M22.2562 21.0774C22.5817 21.4028 22.5817 21.9305 22.2562 22.2559 21.9308 22.5814 21.4032 22.5814 21.0777 22.2559l-6.6666-6.6666C14.167 15.3452 14.106 14.9874 14.228 14.6864 14.2687 14.5861 14.3297 14.4921 14.4111 14.4107 14.4112 14.4106 14.4114 14.4104 14.4116 14.4102l6.6661-6.66612C21.4032 7.41864 21.9308 7.41864 22.2563 7.74408 22.5817 8.06952 22.5817 8.59715 22.2563 8.92259L16.1788 15l6.0774 6.0774z" fill="#fff"/></svg></button><img src="/ad/metrics/custom_number_templates.png" alt="custom number format" /></div></div>4. Select Apply.The format is applied to the metric. Digit Placeholders All number formats, whether predefined or custom, use the placeholders described in the following table: Preserve Extraneous ZeroesTo preserve extraneous zeros, use a 0 in place of the hash symbol (#) in the number formatting syntax.When # symbols are used in number formatting syntax, any zeros not holding a place value are removed. However, using a 0 in place of the # symbol in formatting syntax preserves extraneous zeros.Implications:#,##0.00: If the ones place is empty, a zero is displayed in its place.#,##0.00: If there are no tenths or hundredths places in a value, zeroes are displayed in those places.With this number formatting, the following are the results: Rounding to a Whole Number and Decimal PlacesThe number of hash symbols (#) to the right of the decimal point dictate the number of decimal place values to display. If the input number has more place values than specified by the formatting syntax, the final decimal place value is rounded. For example, #.# applied to 7.25 results in a display value of 7.3.To specify that decimal place values should be filled with zeros when null, use zeros in place of hash symbols for those decimal places in the number formatting syntax.Otherwise, zeros and hash symbols are interchangeable in number-formatting syntax. Separate Thousands, Millions, and so onInsert a comma between hash symbols in custom number formatting syntax to separate thousands in the sets of numbers (thousands, millions, billions, and so on). Truncating Large NumbersEvery comma added to the immediate left of the decimal point effectively truncates the number by another three place values, starting with the ones, tens, and hundreds places. You can provide context for truncated values by adding letters like K, M, and B (thousands, millions, and billions) to the custom number formatting syntax. These letters have no impact on the number’s value; the letter is just inserted in the output: Display Interpretable SymbolsYou can display symbols in your custom number formatting that might be otherwise interpreted by the GoodData Portal. To force the display of a literal in custom number formatting, precede the character with a backslash (\).Suppose you want to display percentage symbols in your formatting. However, the percent symbol (%) has special meaning in custom formatting; it indicates that a data value should be multiplied by 100. If you add this symbol to the formatting, the value 97 is displayed as 9700%, instead of 97%.To display the percent symbol without affecting the data value, use the following in your formatting: %Some examples are listed below: Text Font ColorsText color formatting is applicable to tables and headline reports only.You can display report metric values in one of the following colors by inserting the color, between brackets [ ], at the start of the custom number syntax. For example:[Blue]#,#.##Available color codes:BlackBlueCyanGreenMagentaRedYellowWhiteYou can also use hexadecimal color codes with the following syntax:[color=99AE00]#,#.##Note:Do not insert a hash (#) symbol before the hexadecimal value. This voids your color formatting.Cell Background ColorYou can use hexadecimals to change the background color of cells with the following syntax:[backgroundcolor=00FF00]#,#.##To combine background color and font color syntax:[color=99AAEE][backgroundcolor=000000]#,#.##OR[red][backgroundcolor=000000]#,#.## Conditional number formatting Use conditional formatting to define a number’s color or number format, contingent upon its value. Conditions define the range of number values to which a certain format should be applied.Conditions are formed using brackets and their numerical ranges are defined using the symbols for the following:greater than (>)greater than or equal to (>=)less than (<)less than or equal to (<=)equal to (=)Conditional rules can be inserted anywhere formatting syntax, but they may be most helpful to place before formatting rules. The following example can be read as: “For number values less than or equal to 400,000, format in the following way…”[<=400000][backgroundcolor=CCCCCC][red]$#,#.##Separating Conditional Rules with SemicolonsYou can set multiple formatting rules that define formatting for different value ranges by using semicolons ( ; ) to separate rules. Consider the following example:[<600000][red]$#,#.##;[=600000][yellow]$#,#.##;[>600000][green]$#,#.##This syntax breaks down into the following rules. For all values less than 600,000: values are displayed in red font:[<600000][red]$#,#.##;For all values equal to 600,000: values are displayed in yellow font:[=600000][yellow]$#,#.##;For all values greater than 600,000: values are displayed in green font:[>600000][green]$#,#.##Overlapping ConditionsNote:Rules are always applied left-to-right. When two or more rules apply to the same range of values, the first listed rule overrules any other rules.Consider the following example rules (line-breaks added) where conditional formatting is used to create a temperature scale effect.[<400000][red]$#,#.##;[<500000][magenta]$#,#.##;[<600000][yellow]$#,#.##;[>=600000][green]$#,#.##These rules are interpreted in the following sequence.All values less than 400,000 are red.All values greater than or equal to 400,000 and less than 500,000 are magenta.All values greater than or equal to 500,000 and less than 600,000 are yellow.All values greater than or equal to 600,000 are green.Note:A number whose value is not treated by a condition is displayed in the default syntax ### and is not displayed with a font or background color.Using Conditionals with Negative NumbersNote:For data sets that include negative values, you must insert a negative symbol (-)in the formatting to explicitly format negative numbers.The following example number format (#,#) applies to all values less than 100. In this case, the value –70,000 is displayed as 70,000.[<100]#,#The syntax could be modified to explicitly address this issue. In this example, all values less than zero are formatted in red and preceded by a negative symbol.[<0][red]-#,#You might also decide to use additional symbols, like parentheses, to denote negative data values:[<0][red](#,#)Using Conditionals with Null ValuesBy default, cells with NULL values are left blank. You can also apply conditional formatting to cells with NULL values with the [=NULL] tag. In the following example, cells of null values are displayed with gray background color and “No Value” written in red font.[=Null][backgroundcolor=DDDDDD][red]No Value;Example: Automatically Round NumbersYou can use conditional formatting to automatically round and truncate numbers according to their value.The following syntax applies different formatting rules to values greater than or equal to one billion, between one million and one billion, and between one thousand and one million, as well to negative values of each of these ranges (line breaks added). Note the order in which the formatting rules are specified.[>=1000000000]#,,,.0 B; [>=1000000]#,,.0 M; [>=1000]#,.0 K; [>=0]#,##0 [<=-1000000000]-#,,,.0 B; [<=-1000000]-#,,.0 M; [<=-1000]-#,.0 K; [<0]-#,##0 Unit Conversion in Metric FormattingUnit conversion allows you to implement simple arithmetics to format metrics into various display outputs such as duration or length.For example, an input of seconds can show an output of HH:MM by converting seconds into hours and remaining minutes and applying the correct format on the result.FormatArithmetic format blocks can be included anywhere in the custom format string but they cannot be nested.They have the following structure:{{{div|mod|format}}}These blocks receive the same input number as the main formatting string that they are part of.Format blocks can be parameterized in the following way:div: The argument that divides the input number.mod: The modulo calculated from the result of the div calculation.format: The displayed output of the format applied to the input number divided by div modulo mod.Note:If mod does not end with dot (.), the decimal part of the number is stripped (therefore not rounded). Otherwise, the decimal part is preserved.Example: Display fact input values of seconds in days, hours, minutes, and seconds{{{86400||#}}} days\, {{{3600|24|00}}}:{{{60|60|00}}}:{{{|60.|00.000}}} hoursGives the following results: Return to homepage

page

Versions Compared

Old Version 1

New Version 2

Key