--- title: "Design" slug: "design-dashboard" updated: 2024-06-11T08:27:56Z published: 2024-06-11T08:27:56Z canonical: "help.symphonysummitai.com/design-dashboard" --- > ## Documentation Index > Fetch the complete documentation index at: https://help.symphonysummitai.com/llms.txt > Use this file to discover all available pages before exploring further. # Design In Apex, dashboard canvas allows you to design the dashboard as per the organizational needs. Multiple controls can be dragged and dropped on the canvas and bind data to them to configure dashboards. ## Create a Dashboard On the **Design** tab, Application Designer can add the data source and drag and drop the controls to design the dashboard. Different data sources, charts, maps, layouts, etc. exist to design the dashboard. A Data Source should be configured to start designing the dashboard. To configure the data source, perform the following steps: 1. On the **Design** tab, click on the menu to open the dashboard menu. ![](https://cdn.document360.io/62351b42-cfbd-43ad-8ce1-82b8f455337f/Images/Documentation/image-1696413639825.png?sv=2026-02-06&spr=https&st=2026-11-21T17%3A49%3A00Z&se=2026-11-21T18%3A49%3A00Z&sr=b&sp=r&sig=u5K9YISj6AKHPb2w4y4EHMHe4RDA1IzRXXg2%2BkyDw5c%3D)Figure: Dashboard menu 2. To add a new data source, click **Add** under **Used Data Sources**. ![](https://cdn.document360.io/62351b42-cfbd-43ad-8ce1-82b8f455337f/Images/Documentation/image-1718092715030.png?sv=2026-02-06&spr=https&st=2026-11-21T17%3A49%3A00Z&se=2026-11-21T18%3A49%3A00Z&sr=b&sp=r&sig=1Ue2h7vY1cNCUuC33Nse39DDzhq1EM8BkoIGutVVzQ4%3D)Figure: Add data source 3. On the Add Data Source page, click **Create data source** to create a new data source. ![](https://cdn.document360.io/62351b42-cfbd-43ad-8ce1-82b8f455337f/Images/Documentation/image-1696415103530.png?sv=2026-02-06&spr=https&st=2026-11-21T17%3A49%3A00Z&se=2026-11-21T18%3A49%3A00Z&sr=b&sp=r&sig=szeHWcHkD2%2FKp0GO18%2FSQLMQktQrN5iC29T3O0hknLg%3D)Figure: Create data source The Add Data Source window allows you to perform the following: | **Field** | **Description** | | --- | --- | | Add an existing data source | Select the listed data source and click **Add.** | | Create a new data source | Click create a new data source. It opens the dashboard data source wizard in which you can create a new data source based on the predefined data connection. | ### Dashboard Data Source Wizard The dashboard data source wizard allows you to configure a data source, retrieve data, and add the created data source to a dashboard. The dashboard data source wizard is displayed. ![](https://cdn.document360.io/62351b42-cfbd-43ad-8ce1-82b8f455337f/Images/Documentation/image-1718092603430.png?sv=2026-02-06&spr=https&st=2026-11-21T17%3A49%3A00Z&se=2026-11-21T18%3A49%3A00Z&sr=b&sp=r&sig=osQOtqneCGU9ubbMQdCrSFV%2F5j%2BJkuJagcYdDEdyAuc%3D)Figure: Dashboard data source wizard ### Select a Data Connection 1. Select **Database** on the start page and click **Next**. The Choose a data connection page is displayed. ![](https://cdn.document360.io/62351b42-cfbd-43ad-8ce1-82b8f455337f/Images/Documentation/image-1718092835251.png?sv=2026-02-06&spr=https&st=2026-11-21T17%3A49%3A00Z&se=2026-11-21T18%3A49%3A00Z&sr=b&sp=r&sig=2TvEC8vnUj9eePd2TyoOO34bEkmyPvbkjzAoihiiHnU%3D)Figure: Database 2. Select an existing connection from the list and click **Next**. ![](https://cdn.document360.io/62351b42-cfbd-43ad-8ce1-82b8f455337f/Images/Documentation/image-1718094152888.png?sv=2026-02-06&spr=https&st=2026-11-21T17%3A49%3A00Z&se=2026-11-21T18%3A49%3A00Z&sr=b&sp=r&sig=R1MejdVzvlJ3jFXJB4lSuiaQ2iIt9DARsjakgeIksKU%3D)Figure: Data connection ### Select Queries This page allows you to create/edit a query or select a Stored Procedure. 1. Select the **Query** option to create a new query. ![](https://cdn.document360.io/62351b42-cfbd-43ad-8ce1-82b8f455337f/Images/Documentation/image-1696848203984.png?sv=2026-02-06&spr=https&st=2026-11-21T17%3A49%3A00Z&se=2026-11-21T18%3A49%3A00Z&sr=b&sp=r&sig=NBDrv29NAZyitu3bLSOfPCyWh8Ae6H1NIBeAr9BGY3M%3D)Figure: Query 2. Click Run Query Builder to launch the query builder and select the required tables or views. Click **OK** after adding the query parameters. To know more about the query builder, refer to [Query Builder](https://help.symphonysummitai.com/summit-platform/docs/query-builder). ![](https://cdn.document360.io/62351b42-cfbd-43ad-8ce1-82b8f455337f/Images/Documentation/image-1713264533456.png?sv=2026-02-06&spr=https&st=2026-11-21T17%3A49%3A00Z&se=2026-11-21T18%3A49%3A00Z&sr=b&sp=r&sig=H1IJtOEr%2BLHO3cutxjLkCP%2FrCqQ5TxCI2vF9qSBDppY%3D)Figure: Query Builder 3. The SQL string now displays the selected query. Click **Finish**. ![](https://cdn.document360.io/62351b42-cfbd-43ad-8ce1-82b8f455337f/Images/Documentation/image-1713264621271.png?sv=2026-02-06&spr=https&st=2026-11-21T17%3A49%3A00Z&se=2026-11-21T18%3A49%3A00Z&sr=b&sp=r&sig=0VHS2RnnMR4HEELGZ7wil0GRWFwYwyniZ37L4WzPGKA%3D)Figure: SQL String 4. On the Add Data Source page, the selected query appears. Click **Add** to add the data source. ![](https://cdn.document360.io/62351b42-cfbd-43ad-8ce1-82b8f455337f/Images/Documentation/image-1713265141681.png?sv=2026-02-06&spr=https&st=2026-11-21T17%3A49%3A00Z&se=2026-11-21T18%3A49%3A00Z&sr=b&sp=r&sig=tl7%2BJ66EVEDK984ybvE5H6E%2FY%2FC%2BV86O9LZm4wRdEq4%3D)Figure: Add data source 5. On the data sources page, the added view appears. if you wish to add more data sources, click **Add** under the **Used Data Source** section. ![](https://cdn.document360.io/62351b42-cfbd-43ad-8ce1-82b8f455337f/Images/Documentation/image-1713265768344.png?sv=2026-02-06&spr=https&st=2026-11-21T17%3A49%3A00Z&se=2026-11-21T18%3A49%3A00Z&sr=b&sp=r&sig=bT48rHKKlLBvABR3ZGOpxnE19rORWivbflFZ4o9HmPA%3D)Figure: Data sources 6. Close the Dashboard Menu by clicking on X icon. 7. The data source is added to the dashboard. The toolbox items on the dashboard canvas can be dragged dropped and configured for the dashboard. To know more about the toolbox elements and its configuration, refer to [Toolbox Elements](https://help.symphonysummitai.com/summit-platform/docs/toolbox-elements). Data sources are critical components of report dashboards because they provide the information necessary for generating visualizations, charts, tables, and other elements within the dashboard. The choice of data source, its management, and the way data is transformed and integrated play a crucial role in the effectiveness and accuracy of the dashboard. A stored procedure is a precompiled and reusable set of one or more SQL statements and procedural logic that is stored in a database. Stored procedures are commonly used in database management systems like SQL Server, Oracle, MySQL, and PostgreSQL.