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.

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.

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

SparkLine = displays a sparkline chart to show a trend if the data for this column is multiple, numeric values. See Spark Charts, Bullet Graphs and Percentages for instructions.

SparkColumn = displays a spark column chart to show a trend if the data for this column is multiple, numeric values. See Spark Charts, Bullet Graphs and Percentages for instructions.

Spark Win/Loss = displays a spark win/loss column chart to show a trend if the data for this column is multiple, numeric values. See Spark Charts, Bullet Graphs and Percentages for instructions.

Discrete = displays a spark discrete column chart to show a trend if the data for this column is multiple, numeric values. See Spark Charts, Bullet Graphs and Percentages for instructions.

Bullet = displays a bullet graph chart to show progress compared to a target for columns with single numeric values. See Spark Charts, Bullet Graphs and Percentages for instructions.

Percentage = displays a percentage bar for columns with single numeric values. See Spark Charts, Bullet Graphs and Percentages for instructions.