During the widget creation process, you can specify the widget type as chart. In addition, you can select a chart type that supports either a single data set or multiple data sets
On the Add Widget page of the Create Dashboard menu, click Create Widget. The Connection & Data Model page is displayed.
From the connection drop-down list, select the connection. The database name is automatically populated in the Database text box and the data models are displayed in the Select Data Model(s) section
If you need to increase the number of records retrieved from the database during widget design, do one of the following:
Modify the number of records in the Max. Records for Preview text box. The default number of records (1000) indicates that the first 1000 records returned by the data model are used during the widget creation process.
-Or-
Select the All Records check box
|
Note: During widget design, data is retrieved from the database for determining the columns available and for use in presenting a preview of the widget. The Max. Records for Preview text box and the All Records check box define the number of records that are retrieved during widget design. Selecting the All Records check box loads all records. This may delay widget design time. You cannot enter a value in the Max. Records for Preview text box if the All Records check box is selected. You must clear the check box to enter the value. |
Select the Sort Columns check box, if you want to list the columns in alphabetical order.
|
Note: The columns are displayed in the order they are returned from the database. Listing the columns in alphabetic order makes it easy for you to find the column you need from the column listing, even if you are not familiar with the database. |
In the Select Data Model(s) section, click next to the data model to select it. The selected data model appears on the right.
|
Note: You can select only one data model while creating a chart type widget with a single data set. For chart types with one/multiple data sets, you can select a maximum of six data models |
Click Chart as the widget type. Selection is denoted by a mark that appears next to Chart.
Select the chart type in the Chart type with one/multiple data sets or Chart type with single data set section
|
Note: The charts listed under Chart type with one/ multiple data sets support the Series column in addition to the X and Y column. These charts support the use of a single data set or multiple data sets. Chart types to represent one or multiple data sets include column, bar, area, line, and dual Y-axis. The charts listed under Chart type with single data set support the use of the X and Y column but not the Series column. These charts support only one data set. Pie, doughnut, funnel, gauge, and waterfall are chart types that represent only a single data set. |
|
Note: Working with Multiple Data Sets If you use only one data set in the chart widget design, the data set you use is mapped to one data model If you use more than one data set in the chart design, each data set can be mapped as follows:
For example, if you want to compare sales data retrieved from the Sales Transactions data model with sales target data retrieved from the Sales Targets data model, side by side in a chart; you can do so using the multiple data set functionality. You can map the first data set to the Sales Transactions data model, add the second data set, and map it to the Sales Targets data model. Ideally, you must have at least one column that is common to both the data sets to present data in the chart in a meaningful way
In this case, each unique data set represents a different sub set of data from the same data model
For example, if your data set has sales transaction data for multiple product categories and if you want to isolate only Smart phone sales data to compare it with Mp3 Player sales data and analyze if Smart Phone sales are affecting MP3 player sales, you can do so using the multiple data set functionality. You can map the first data set to the sales transactions data model and filter it from smart phones. You can add the second data set, map it to the sales transactions data model again, and in this data set filter it for mp3 players
|
Click Next. The Select Columns page is displayed