Analytics
  • Introductions
    • 👋Hello Analytics!
    • 👩‍🎓Workflow Philosophy
    • 📹Build a Workflow
    • 🖨️Start from a Template
      • 3 Way Match
      • Accounts Payable - Analytical Review
      • Accounts Payable - Debt Aging and Approval
      • Accounts Receivable - Analytical Review
      • Accounts Receivable - Completeness, Write-Offs, and Manual Adjustment Testing
      • Account Receivable - Credit Aging and Approval
      • Accounts Receivable - Credit Limits and Balance Testing
      • Account Reconciliation
      • Automated Sampling
      • Benford's Law
      • CutOff Testing
      • Change Management Review
      • Disbursement Analysis
      • Fictitious Vendor Testing
      • Financial Account Variance Analysis
      • Fixed Assets - Depreciation Recalculation
      • Fixed Assets - Duplicate Identification
      • Fixed Assets - Negative NBV Check
      • Journal Entries - Analytical Review
      • Journal Entries - Anomaly Detection
      • Journal Entries - Approval and Suspicious Posting Testing
      • Journal Entries - Balanced and Suspicious Amount Testing
      • Journal Entries - Duplicates and Sequence Testing
      • Missing Data Check
      • New User Access Testing
      • Numerical Outlier Detection
      • Payroll - Ghost Employees, Analysis, and Duplicates
      • Payroll - Inactivity and Salary Confirmation
      • Procure to Pay - Duplicates and Suspicious Posting Testing
      • Procure to Pay - Mismatched Documents & Vendor Spend
      • Procure to Pay - Payments Remitted to Employees
      • Procure to Pay - Payment Timing and Terms Test
      • Procure to Pay - Vendor Master File Review
      • Risk Scoring
      • Segregation of Duties
      • Terminated User Access Testing
      • Travel & Expense Testing
      • User Access Review
    • 📓Release Notes
  • Workflows
    • 🎨The Canvas
    • 📏Setting Up
    • 👆Drag & Drop
      • 🖱️Click to Add
    • 🧰Tools
    • 🧮Expression Builder
      • Operators
      • Functions
        • Aggregate Functions
          • AVERAGE
          • CORR
          • COUNT
          • COUNTD
          • COUNTBY
          • COUNTIF
          • COUNTIFS
          • COVAR
          • COVARP
          • COVARS
          • MAX
          • MEDIAN
          • MIN
          • MAXBY
          • MINBY
          • PERCENTILE
          • RUNNINGTOTALBY
          • SIGN
          • SIN
          • SQRT
          • SQUARE
          • STDEV
          • STDEVP
          • STDEVS
          • SUM
          • SUMBY
          • SUMIF
          • TAN
          • VAR
          • VARP
          • VARS
          • ZN
        • Conversion Functions
          • TIMESTAMPTODATE
          • TODATE
          • TODECIMAL
          • TOINT
        • Date/Time Functions
          • DATEADD
          • DATEDIF
          • DATENAME
          • DATENORMALIZE
          • DATEPART
          • DATETRUNC
          • DAY
          • DAYS
          • WORKDAYS
          • HOUR
          • ISDATE
          • ISOWEEKDAY
          • ISOWEEK
          • ISOQUARTER
          • ISOYEAR
          • MAKEDATE
          • MAKEDATETIME
          • MINUTE
          • MONTH
          • NOW
          • QUARTER
          • SECOND
          • TODAY
          • WEEK
          • WEEKDAY
          • YEAR
        • Logical Functions
          • AND
          • BETWEEN
          • CASE
          • CHOOSE
          • CONTAINSWITHIN
          • IF
          • IFS
          • IIF
          • IN
          • IFNULL
          • ISBOOLEAN
          • ISDECIMAL
          • ISDURATION
          • ISINTEGER
          • ISNULL
          • ISNUMBER
          • ISSTRING
          • ISUNIQUE
          • NOT
          • NULL
          • OR
          • SWITCH
          • ALL
            • TOSTRING
          • ANY
        • Math Functions
          • ABS
          • ACOS
          • ASIN
          • ATAN
          • ATAN2
          • CEILING
          • COS
          • COT
          • COSEC
          • DEGREES
          • DIV
          • EVEN
          • EXPONENTIAL
          • FILLINFINITY
          • FLOOR
          • HAVERSINE
          • LOG
          • LN
          • ODD
          • MODULO
          • PERCENTILEOFVALUE
          • PERCENTILEVALUE
          • PI
          • POWER
          • RADIANS
          • RANDOM
          • ROUND
          • SEC
        • Table Functions
          • ENCODE
          • INDEX
          • INDEXBY
          • FILLNULL
          • FIRSTBY
          • GENERATEUNIQUEID
          • LASTBY
          • LOOKUP
          • MATCH
          • NTH
          • OFFSET
          • OFFSETBY
          • PREVIOUSVALUE
          • RANK
          • RANKBY
          • RECORDID
          • ROLLINGAVERAGE
          • ROW
          • RUNNINGAVERAGE
          • RUNNINGMAX
          • RUNNINGMIN
          • RUNNINGSTDEV
          • RUNNINGTOTAL
          • WINDOWAVERAGE
          • WINDOWMAX
          • WINDOWMIN
          • WINDOWCOUNT
          • WINDOWSUM
          • SEQUENCE
          • WINDOWMEDIAN
          • WINDOWSTDEV
          • WINDOWSTDEVP
          • WINDOWSTDEVS
          • WINDOWVAR
          • WINDOWVARP
          • WINDOWVARS
          • WINDOWCORR
          • WINDOWCOVAR
          • WINDOWCOVARP
          • WINDOWCOVARS
          • SMOOTHEDAVERAGE
        • Text Functions
          • ASCII
          • CHAR
          • CONCAT
          • CONTAINS
          • ENDSWITH
          • FIND
          • FINDNTH
          • ISEMPTY
          • JSONPARSE
          • LEFT
          • LENGTH
          • LOWER
          • LTRIM
          • MID
          • PROPER
          • RIGHT
          • RTRIM
          • SPACE
          • SPLIT
          • STARTSWITH
          • TRIM
          • SUBSTITUTE
          • UPPER
        • Window Functions
    • 🔗Parameters
      • File Input Parameters
      • Sample Tool Parameters
      • System Parameters
  • Tools
    • 🗃️Import
      • Import File
      • Import From API
      • Import From Integration
        • GitHub
        • Snowflake
      • Import Sample Data
      • New Table
    • ✨Clean
      • Find Replace
      • ParseJSON
      • Sample
      • Text to Columns
      • Validate
    • 💻Code
      • PythonCode
        • Fuzzy Match
    • 🤝Merge
      • Append
      • Join
    • 🧙Transform
      • Edit Columns
      • Add Columns
      • Select Columns
      • Filter
      • Sort
      • Deduplicate
      • Pivot
      • Unpivot
    • 📊Visualize
      • Chart
        • Bar
        • Line
        • Combo
        • Scatter
        • Histogram
        • Box
        • Pie
        • Area
        • Funnel
    • 📬Publish
      • Publish to Toolkit
      • Publish via Email
  • 📚Dictionary
Powered by GitBook
On this page
  • The Tool Menu
  • Drag and Drop Tools
  • Tool Configuration
  • Tool Preview
  • Rename Tools
  • Sticky Notes
  • Tool Groups
  • Ungroup

Was this helpful?

  1. Workflows

Drag & Drop

Last updated 9 months ago

Was this helpful?

The Tool Menu

Tools are grouped in the tool menu based on common functionality. These groupings include , , , , , and . When dropped onto the canvas, a tool’s color is defined by the functional group it came from to easily interpret different functions within workflows.

Drag and Drop Tools

Drag a tool from the tool menu. Then drop it onto the canvas to start building your workflow. To add a subsequent tool, drag and drop another from the tool menu to the canvas.

Tool Configuration

The tool configuration allows users to customize the settings of each tool.

The wrench icon indicates when a tool requires configuration before being incorporated into a workflow. To open the tool configuration, simply click on it once. To modify a tool that has already been configured, or if the tool does not need to be configured, double click on it.

Alternatively, you can select ‘Configure Tool’ from the tool preview panel.

Once you have finished customizing the tool, save your changes by pressing the ‘Save’ button. If you wish to discard your changes made to the tool configuration, press ‘Cancel’ and confirm your decision by selecting ‘Abandon’.

Tool Preview

Gaining insight into the data processing of your workflow is effortless and straightforward with the data-preview panel. Simply click on any tool to inspect the data output, and hover over a column header for profiling. This enables users to quickly survey the structure of their data and identify any patterns or anomalies.

Rename Tools

Renaming tools is an awesome way to document your workflow. It not only creates a system for organization, but also enables users to remember actions taken and why. Renaming tools provides a straightforward way to quickly identify where certain steps in your data logic occur, and aids in maintenance and transparency.

You can rename a tool either from the data-preview panel or a tool configuration.

Sticky Notes

Sticky notes in AuditBoard Analytics are essential for any collaborative effort and make workflows easier to understand, remember, and manage. Not only do they provide clarity and context, but they also alert users to any risks or issues associated with the workflow - making them a critical part of the collaborative process! So, if you're looking to build well documented workflows, sticky notes are the way to go.

Right-click anywhere on your canvas to add a sticky note. The color picker, duplicate, and save buttons provide you with the resources to customize your sticky notes with ease and record your entire workflow effortlessly.

Tool Groups

Grouping tools together within a workflow can be a great way to improve organization, readability, and the overall understanding of the workflow from start to finish. It allows users to swiftly identify and troubleshoot any potential issues, while also decreasing the chances of errors due to the improved clarity and accessibility of the tools. By putting the pieces together in a logical manner, one can quickly comprehend the order of operations and the purpose of each component.

To group multiple tools together:

  1. Hold down the shift key while selecting the desired tools.

  2. Once highlighted, right-click on one of the tools, and

  3. Select ‘Group Selected’.

This will bind the tools in a cluster, allowing you to move them together as one unit. Reposition the tools within the group to attain your preferred aesthetic.

Ungroup

If you wish to ungroup the tools, select the tool group and use the popup toolbar to ungroup the tools. Alternatively, you can right-click on the tool group and select ‘Ungroup’. This will separate the tools and free them from the cluster.

👆
Import
Clean
Merge
Transform
Visualize
Publish