Multi Series Dual Y Combo Chart

Multi-Series Dual Y Combo Chart is combination chart similar to multi-series charts that enable you to plot multiple datasets on the same chart. The advantage with using combination charts is that you can also plot multiple chart types on the same chart. Multi-Series Dual Y Combo Chart can have dual y-axes. For detailed information on the different chart types provided by Canvas, refer App Designer - Analytical Charts. To create a multi-series dual Y combo chart app, perform the following steps in Canvas Studio:

1. On the home page of Canvas Studio, click App Designer.
   
   
   
   
2. Clickicon to create a new app.
   
   
   
   
3. Enter an appropriate name in the App Display Name field, e.g. Multi Series Dual Y Chart.
   
   1. Enter an appropriate ID in the App ID and View ID fields, e.g. MULTI_SERIES_DUAL_Y_CHART_APP.
   2. In the App Resource Bundle field, enter the name of the bundle key associated with the property file, e.g. common.
   3. Select the appropriate Product, Sub-Product and Function Codes. For detailed information on Product, Sub-Product and Function Codes, refer Configuring Entitlements and Creating Product, Sub-Product and Function Codes.

   On entering the App ID, the View ID gets filled automatically. However, you can still apply changes to the View ID. No blank spaces and special characters should be used in the App ID and View ID fields. The underscore symbol can be used. During the creation of an app, you can edit the App ID and View ID fields. However, while editing an app, you cannot apply changes to the App ID and View ID fields.

   
   
   
   

4. Select the MSCOMBIDY chart view type.
   
   1. Click the Datasource tab to select the relevant data source for the multi-series dual Y combo chart widget.
      
      
   
   
   

5. Click the Data Src ID field and type the name of the Data Source to select it.

   You can uncheck the Use Existing Data Source and Use Default instruction Class checkboxes to connect to any data source using SQL Param Map ID. For detailed information on using the SQL Map and the instruction class to display data on the app, refer Adding the SQL Map and Instruction Class with App.

   1. Click Proceed to design the app.
      
      
      
      
6. Click Columns tab.
   
   
   
   
7. Drag and Drop the ACCOUNT_NAME column to X-Axis.
   
   1. Drag and Drop the AVAI_BALANCE and OVER_DRAFT_LMT columns to Y-Axis.
      
      
   
   
   
8. Click theicon to use the additional available configurations.
   
   
   
   
9. Click Configure to change the column properties. Each column will have the default properties already set.
   
   1. After applying changes to the column properties, click Apply.
      
      
      
      
   On clicking Apply, the chart designer area will get displayed, where you can view the temporary preview of the chart.
   
   
   
   
10. Clickicon to save the app.
    
    
    
    A confirmation message, indicating a successful save appears.
    
    
    
    
11. Click Ok.
    
    Let's assume that the Multi Series Dual Y Chart app is mapped to the Account Summary Details workspace. The following screen shot serves as a good illustration of the output in the functional application, Modelhouse: