Add the Grid widget to the dashboard

1. Drag and drop the Grid widget into the design panel.
2. Select the Properties icon.
3. Go to the ASSIGN DATA tab and select the API data source that you manually added to the dashboard from the dropdown.

   For example, the CoreconAPI_Overview.

   

4. Drag and drop fields listed in the Dimensions and Measures section into the Column field.

   For example, dimensions are the ProjectNumber, PrimeContractNumber, JobCostCode, and JobCostCodeDescription. Measures are quantity or currency fields, such as RevenueBudget_Prime_Total.

   

5. Optionally, select the Properties icon next to the dimension or measure and select Rename to change the name of the column.

   This is recommended, especially for currency fields that have long names.

   

6. Optionally, in the widget Properties change the math function and the number format for a measure as needed.

   For example, from Sum to Avg.

   Sum is the most common math function used in dashboards.
7. Select the PROPERTIES tab to rename the widget, adjust the font size, and configure the attributes as follows:
   1. Select the Customize in the Column Settings section to specify the header alignment, content alignment, and width for each column.
   2. Select the options in the Container Actions section as needed.

      The Show Header and Allow Maximize View options are particularly beneficial for grids.

   3. Modify the rest of the attributes as needed.
8. Adjust the width and height of the Grid widget as needed.
   The 48x24 dashboard canvas adjusts to the user's page size, so you might need to re-adjust the widget's dimensions after previewing.