Show As: Change the Column Format for Different Types Data
Select a column in the preview area or use the Column list. Use Show As to apply other formats based on the type of data in this column:
Date = expects a string with a date, time or date and time. It converts this string to a date and optionally a time for sorting purposes.
You choose the format to display the date in the Date Format property.
Note: In previous releases, you could also conditionally apply color formatting or arrow icons to dates and numbers. With this release,
Use KPI Cell Formatting instead.
Color and arrow formatting in views created in previous releases is supported. To edit this, update the view to use KPI Rules.
HTML = for data that contains HTML tags.
Image = shows images in this column when the data is URLs to image files.
You can also determine the Height or Width to use for all images in this column. Both default to auto which uses the actual size of each image. To set a size, enter the number of pixels for each dimension.
Link = creates a link for this column when the data is URLs.
By default, Click here displays as the text of the link. Set the Show link text option to change this to:
A single phrase of your own choosing. Simply enter the phrase in the field below
If this field has a list of columns, click
to return to edit mode where you can enter a value.
The dynamic value of a column that you select for each row. To set dynamic values, click
to get different values from another column. Then select the column to use from the list of available columns.
Number = allows you to apply common numeric formats if the data is numeric. See
Number Formatter for details.
Note: In previous releases, you could also conditionally apply color formatting or arrow icons to dates and numbers. With this release,
Use KPI Cell Formatting instead.
Color and arrow formatting in views created in previous releases is supported. To edit this, update the view to use KPI Rules.
Text = displays the data as is. This is the default.
You can also limit the number of characters to show in this column and append an ellipsis (...). Set the Show only option and enter the maximum number of characters.
Text (Show...) = limits the text to 80 characters and appends an ellipsis (...) to indicate that there is more content. You can also get limited character content using
Text and the
Show only option