Select Columns

  1. In the Available Column List section, select the check box corresponding to the column to be included in the widget design.  

 

Select_Columns_-_New.jpg


note.jpg Note:

You can select any number of columns. The new_image_1.jpg  sign next to a column name denotes a numeric column. The  new_image_2.jpg sign denotes text. The new_image_3.jpg sign indicates a date column.

Any date column is automatically split into the Year, Month & Year, Quarter, Month, Week, Day, and Weekday sub columns. These columns are available for use in defining data sets and in designing the widget


  1. If needed, type an alias name for the selected column in the Alias Name text box and click Apply Name.

 

PT_-_select_column.jpg

 


note.jpg Note:

The need to assign an alias name may arise because the column name defined in the database is not descriptive. An alias name is applied only within the widget where you make the change. It does not reflect in other widgets or in the database.

You can select a column name to format its text style. Selection of numeric columns allows formatting of numbers.

To format a column:

  1. Select the column name that you want to format. The Style section appears.

  2. Specify the font, size, and style from the Font, Size, and Style drop-down lists respectively.  

  3. Click Apply. A message box confirming that the changes have been saved successfully is displayed. You can apply the format to all columns by clicking Apply All.


  1. Click Next. The Define Data Set (s) page is displayed

 


note.jpg Note:

 Click Back to go to the Select Columns page. Click Cancel to exit creation of widget


 

 

top.jpg

<<Connections & Data Models | Define Data Set(s)>>