Skip to main content

4. Report on metrics with dashboard

Build a Reports dashboard that counts projects by category, owner, and start month.

Understand dashboards

A dashboard presents selected data from your application in one place. Use a pie chart to show each group’s share of the total, a column chart to compare groups, and a line chart to track a measure over time. Understand Dashboard


Take action: Report on metrics with dashboard

Continue with the Projects and Tasks lists from stage 2. This dashboard counts project records, including those added by the approval process in stage 3. Confirm that the project records you want to report have a Category, Owner, and Start Date. The approval example maps Owner and Start Date, so fill in Category for approved records that need a category. Create your data list · Automate your business process


Step 1: Create a new Dashboard

Open the application and select Add resource → Dashboard. Name it Reports and select OK. Open the new dashboard and select Edit Page to open its designer. Application resources · Dashboard designer

Step 2: Add a top banner on this page

Add a Section at the top of the canvas. From the controls panel, drag a Title into it and enter Reports of Projects. Add a short subtitle that tells readers what the charts count, such as “Project records by category, owner, and start month.”

If you use a colored banner, set the fill under Style → Background and add spacing under Advanced. Use Preview and the breakpoint buttons to check that the heading stays legible at narrow widths.

Step 3: Add Data Analytics controls

Add a section below the banner for charts. Open the first column’s menu and use + Add Column to add two more columns. From Data Analytics, add a Pie Chart, Column Chart, and Line Chart, one per column.

For each chart, open Content → Data Source, select the application, and set List to Projects. Use Data Filters if all charts should cover a specific set of records, and apply the same conditions to each chart you plan to compare. Set the measure to Id with Count to count project records.

Add and configure the Pie Chart

Under Content → Chart, set Category to the Category field and Value to Id → Count. Each slice shows the share of counted projects in that category. Turn on the chart title and name it Projects by Category. Pie Chart

Yeeflow Pie Chart settings with Projects selected as the list, Category as the group, and Id set to Count.

Add and configure the Column Chart

Select Clustered column. In Chart, set X-axis (Category) to Owner and Y-axis (Value) to Id → Count. Name the chart Projects by Owner. Each column compares the number of project records assigned to that owner. Column Chart

Add and configure the Line Chart

In Chart, set X-axis (Category) to Start Date, then select Month. Set Y-axis (Value) to Id → Count and name the chart Projects by Start Month. This tracks projects grouped by when they start. Line Chart

To show how many tasks are in each status, add a separate chart with Tasks as its data source and Status as the category. Use Id → Count there to count tasks.

Step 4: Access Dashboard

Select Submit in the designer to save and generate the charts. Close the designer and open Reports from the application navigation. Compare the charts against the same filtered records in Projects. For example, check a category and an owner with known counts, and confirm that a project’s start date places it in the expected month. If a category is blank, fill it in or filter it out as appropriate for the report.

Check the layout at narrow widths and confirm that an intended viewer can open the dashboard and see the expected data. Select Edit Page when you need to change the design.

Did this answer your question?