Dashboard Stats

Dashboard stats allow you to display the summed value of number fields and display time elapsed details of date & time fields from a Status Board on the Dashboard. 

Displaying Total Numbers

1. Go to the Admin Area
2. Expand Templates
3. Click the Edit icon on the status board you wish to edit
4. Scroll to the bottom of the page and click +Advanced Options
5. Click Add next to Dashboard stats
6. In this article's example to display the summed value for both Shelter Capacity and Shelter Occupancy on the dashboard you must obtain the field IDs for both of the number fields
7. Click the ⋮ more options menu icon and copy the Field ID, you can also click on the double paper icon to copy
8. The field IDs for Shelter Capacity is shelter_capacity_Fxd9LCYq and the field name for Shelter Occupancy is shelter_occupancy_fQS9eJ91

9. To sum the total number for Shelter Capacity and display it on the dashboard, enter the following in Value expression:
   1. {{items | map:'data.shelter_capacity_Fxd9LCYq' | add}}
10. Click Add
11. To sum the total number for Shelter Occupancy and display it on the dashboard, enter the following in Value expression:
    1. {{items | map:'data.shelter_occupancy_fQS9eJ91' | add}}
12. This is what it should look like in your account. Whatever you enter in the Label box will appear as the label on the dashboard

13. Click Save
14. Select OK to confirm save

Filtering by Status

To calculate the total number of entries based on a selected status field.

1. Go to the Admin Area
2. Expand Templates
3. Click the Edit icon on the status board you wish to edit
4. Scroll to the bottom of the page and click +Advanced Options
5. Click Add next to Dashboard stats
6. In the example from this article, to display the total entries for Road Closures based on the selected Status on the dashboard, you’ll need to obtain the field IDs for the status field
7. Click the ⋮ more options menu icon and copy the Field ID, you can also click on the double paper icon to copy

8. To sum the total entries for Roads that are Closed and display it on the dashboard, enter the following in Value expression:
   1. {{(items | filterBy:['data.current_status_k4Mnbx1N']:'closed').length}}
9. Click Add
10. To sum the total entries for Roads that are Open, One Lane and display it on the dashboard, enter the following in Value expression:
    1. {{(items | filterBy:['data.current_status_k4Mnbx1N']:'open_one_lane'').length}}
11. This is what it should look like in your account. Whatever you enter in the Label box will appear as the label on the dashboard

8. Enter in true under the expression to showcase the color on the dashboard (green=success, amber=warning and/or danger=red
9. Click Save
10. Select OK to confirm save

Displaying Time Last Reported

Show the minutes since the last update based on what is entered into a date and time field.

1. Go to the Admin Area
2. Expand Templates
3. Click the Edit icon on the status board you wish to edit
4. Scroll to the bottom of the page and click +Advanced Options
5. Click Add next to Dashboard stats
6. In this article's example to display the time elapsed for Flood Zones/Risk Last Reported Time on the dashboard you must obtain the field IDs for both of the number fields
7. Click the ⋮ more options menu icon and copy the Field ID, you can also click on the double paper icon to copy
8. The field ID for Time Reported is report_date_and_time_YE6DtZgd

9. To display the number of minutes elapsed since the last Road Damage was reported, enter the following in Value expression:
   1. Time Since Last Update: {{items | pick:'data.report_date_and_time_YE6DtZgd != null' | max:'data.report_date_and_time_YE6DtZgd' | getProp:'data.report_date_and_time_YE6DtZgd' | minutesSince}} minutes ago
10. Click Add
11. This is what it should look like in your account. Whatever you enter in the Label box will appear as the label on the dashboard
12. Click Save
13. Select OK to confirm save

Dashboard Views

Display configured Default Sorting/Grouping/Filtering Status Board items on the dashboard.

1. Go to the Admin Area
2. Expand Templates
3. Click the Edit icon on the status board you wish to edit
4. Scroll to the bottom of the page and click +Advanced Options
5. Click +Add next to Dashboard views
6. Select one of the options from the drop down
7. Click Save
8. Select OK to confirm save
9. Repeat steps to create multiple sorting/grouping/filtering views on the dashboard

Display Modes

Depending on configured the Default Sorting/Grouping/Filtering on your status board template, the dashboard display will differ.

• Option 1: Grouping view; will display the group name and count. The progress bar on the dashboard widget indicates the proportion of all items that this grouping represents.

• Option 2: No grouping view; will display a list of the first ten items according to the configured sorting order and the grid columns.