Questions? We have answers.

Pivot and filter on the Prior period comparison dashboard

  • Updated

Summary

The Prior period comparison dashboard lets you pivot the data and apply filters to quickly slice-and-dice the ledger data to compare accounts period-over-period and gain more insights.

Learn about pivoting and applying filters on the Prior period comparison dashboard.


Go to the Prior period comparison tab

  1. Select the logo in the MindBridge sidebar.
    You will go to the Organizations page.
  2. Select View in line with the desired organization.
    You will go to the Engagements page.
  3. Select View in line with the desired engagement.
    You will go to that engagement's Data page.
  4. Select View Analysis on the desired analysis.
  5. Once within an analysis, select Prior period comparison at the top of the page.
    You will go to the Prior period comparison tab.

Tip: If you are already in an analysis, use the sidebar ( Sidebar open and close icon ) to open the Analyze ( Analyze menu icon ) menu, then select the name of the analysis you want to see and go to the Prior period comparison tab.


Overview

Pivot options are based on the imported dataset, whereas the options for filtering are created during column mapping.

Pivot options

The 2 main pivots for this dashboard allow you to select the group and the account you want to compare period-over-period.

For example, if you select the "Transaction structure" group and the "Revenue" account, the Prior period comparison dashboard will update the visualizations and tables below to display all Revenue accounts with transactions that contain a similar structure.

Filter options

Filters may be generated by MindBridge (such as Source) or created by adding columns for filtering during column mapping (such as Region and Department) and allow you to select multiple values to filter on. 

  1. Enter or select a filter from the available menu(s).
  2. Apply the filter to update the dashboard.


Anything else on your mind? Chat with us or submit a request for further assistance.


Related articles

Was this article helpful?