Tableau: The Pace of Commitment and Expenditure Report

There are 4 different views of the Pace of Commitment and Expenditure Report in Tableau:

• Expenditures: includes all approved invoices (does not include pending or rejected invoices)
• Net Commitments: the aggregate total (actual commitments plus dis-encumbrances) of all signed contracts + contract pre-encumbrances
• Positive Commitments: includes actual commitments only
• Negative Commitments: includes disencumbrances only

These report views can be added to your Favorites in Tableau’s left-hand navigation pane. Reports saved to your Favorites are easily accessible from anywhere within Tableau. To save as a favorite, simply click the star icon below the report view.

Use the navigation tabs to switch between the different views of the report. The views listed are the same that appear on the main page of the Pace of Commitment and Expenditure Report.

Selected Grouping Parameters appear in this section as separate columns. Each successive Grouping Parameter selected will be displayed as a separate column to the right of the previous Grouping Parameter selected, creating a hierarchical structure to the data that helps you identify the inherent relationships you want reported.

 Allow you to define the time periods for data shown in the Data Display section.

These parameters control the sort and grouping of the data by different organizational and funding codes.  As parameters are set for each field in this section, they are displayed as separate columns in Parameter Display section and parsed to show the hierarchical data relationships. You are only able to select one parameter for each drop-down.

These 11 drop down fields relate to the Grouping Parameters and allow you to select which to include/exclude. If you make changes to any of the drop-down fields in this section, be sure to hit the Apply button at the bottom of the drop-down window to confirm and apply your selection.