Formatting Columns

Renaming Column

NOTE

For Microsoft SQL Server Analysis Services connection type, column renaming is not supported.

Rename the column, if required, through double clicking the respective column to enable the edit mode and typing the modified name. Press <Enter> key to commit the modification done.

The renamed column will be represented by (*) mark.

You can also rename the column through the Settings icon which will be displayed like below while hovering the respective column.

Click this icon to drop down the menu with Rename Column, clicking which the edit mode will be enabled in that column.

Handling Column Type Conversion

NOTE

For Microsoft SQL Server Analysis Services Connection type, type conversions can be handled only on string typed columns. The possible conversions are Text to Date Time and vice-versa.

The following table represents the column types and their equivalent convertible types that are supported in Dashboard Designer.

Column Data Type	Equivalent Convertible Types
Decimal	DateTime, Text
Integer	Decimal, DateTime, Text
Date Time	Decimal, Text
Text	DateTime, Decimal

Duplicate Column

You can get the copy of a column through the Settings icon which will be displayed like below while hovering the respective column.

Click Duplicate Column option. It will be consider as a expression column. So this column automatically added in Expression Designer.

Now duplicate column will display in preview grid as follows.

NOTE

Duplicate Column option will be enabled only for measure column.

Aggregation Functions

Using Aggregation Functions option, you can get aggregated result for a column in data design view. You can apply this option through the Settings icon which will be displayed like below while hovering the respective column. Click the Aggregation Functions, which displays the list of functions to choose.

Date Expressions

This option will enable only for Date type column(s). You can apply date expression for a column through Settings icon. Click Date Expressions, which displays date functions like Year, Month, Day.

Arithmetic Functions

Using Arithmetic Functions option, you can add/subtract/multiply/divide a specific value from a measure column. You can select this option as follows.

Now select the function to pass a specific value, Arithmetic Value Window will open as follows.

Enter the value in value text box and click Apply.

NOTE

When you use options like Duplicate Column, Aggregation Functions, Date Expressions, Arithmetic Functions, it will be consider as expression column. You can find these columns in Expression Designer.

Applying the Fiscal Year Start in data Source level

You can apply fiscal format to the date column through the Settings icon which will be displayed like below while hovering the respective date column. Click the Fiscal Year Star, which displays list of months to choose.