Overview: Formats

HOW TO

How to access Formats

The Format field can be found in the Advanced Settings window. Learn more here

How to use Formats

In this section, we'll update the Datablock above to show how different Formats affect the Metric value that is displayed. The  Format is currently set to Auto, meaning it automatically formatted by Databox based on any formatting information that was synced with the Metric. 

When your  Format is set to $ Currency, the Metric value will have a dollar sign. However, no backend conversions are taking place. 

In Databox, "#" acts as a digit placeholder. Your Metric value will replace the "#" symbol with the corresponding digit if one is present. Otherwise, no digit appears on your Datablock.

Similarly, "0" acts as a zero placeholder. Your Metric value will replace the zero with the corresponding digit if one is present. Otherwise, zero appears on your Datablock. 

If your  Format is set to #,###, then "31,486" will be displayed as 31,486 on your Datablock.

If your  Format is set to #,###.0, then "31,486" will be displayed as 31,486.0 on your Datablock.

If your Format is set to $#,###.0, then "31,486" will be displayed as $31,486.0 on your Datablock.

If your Format is set to $#,###.00, then "31,486" will be displayed as $31,486.00 on your Datablock.

If your Format is set to Relative time, then your Metric value will be displayed in terms of days, months, and years. In many cases (like for "31,486") the resulting value may not be meaningful. 

If your  Format is set to Duration, then your Metric value will be displayed in terms of hours, minutes, and seconds. In many cases (like for "31,486") the resulting value displayed on your Datablock may not be meaningful. 

If your  Format is set to Prefixed unit, then any unit that was synced with your Metric will be displayed before the Metric value. However, no backend conversions are taking place. 

If your  Format is set to Postfixed unit, then any unit that was synced with your Metric will be displayed after the Metric value. However, no backend conversions are taking place. 

If your  Format is set to Prefix currency, then any currency formatting that was synced with your Metric will be displayed before the Metric value. However, no backend conversions are taking place. 

If your  Format is set to Postfixed currency, then any currency formatting that was synced with your Metric will be displayed after the Metric value. However, no backend conversions are taking place. 

If your  Format is set to Postfixed %, then the percentage sign (%) will be displayed after the Metric value. However, no backend conversions are taking place. 

If your Format is set to Percentage, then your Metric will be converted to a percentage. This includes multiplying your Metric value by 100 and displaying a percentage sign (%) after the Metric value.

Pro Tip: Custom Formats can be directly entered into the Format field. Enter your Format and click the corresponding option in the drop-down list to select it for your Datablock.

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us