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
  • 11.0.0
  • 10.1.0
  • 10.0.0
  • 9.2.0
  • 9.1.0
  • 9.0.0
  • 8.3.0
  • 8.2.0
  • 8.1.0
  • 8.0.0
  • 7.5.0
  • 7.4.0
  • 7.3.0
  • 7.2.0
  • 7.1.0
  • 7.0.0
  • 6.4.0
  • 6.3.0
  • 6.2.1
  • 6.2.0
  • 6.1.0
  • 6.0.0
  • 5.1.1
  • 5.1.0
  • 5.0.0
  • 4.0.0

Was this helpful?

  1. Introductions

Release Notes

Take a look at what's been changing in AuditBoard Analytics!

11.0.0

Behind the scenes: various bug fixes and improvements to stability and performance.

10.1.0

Release ability to handle larger data sizes without crashing the canvas

Behind the scenes: various bug fixes and improvements to stability and performance.

10.0.0

Behind the scenes: various bug fixes and improvements to stability and performance.

9.2.0

Behind the scenes: various bug fixes and improvements to stability and performance.

9.1.0

Behind the scenes: various bug fixes and improvements to stability and performance.

9.0.0

Behind the scenes: various bug fixes and improvements to stability and performance.

8.3.0

Behind the scenes: various bug fixes and improvements to stability and performance.

8.2.0

Increased the width of the pane in which you can write expressions

Behind the scenes: various bug fixes and improvements to stability and performance.

8.1.0

Behind the scenes: various bug fixes and improvements to stability and performance.

8.0.0

Updated import sample data tool to include more relevant datasets

Updates import sample data tool to bucket sample datasets

Behind the scenes: various bug fixes and improvements to stability and performance.

7.5.0

Behind the scenes: various bug fixes and improvements to stability and performance.

7.4.0

Increased workflow timeout to 30 minutes.

Behind the scenes: various bug fixes and improvements to stability and performance.

7.3.0

Behind the scenes: various bug fixes and improvements to stability and performance.

7.2.0

Released Import from API tool

Behind the scenes: various bug fixes and improvements to stability and performance.

7.1.0

Behind the scenes: various bug fixes and improvements to stability and performance.

7.0.0

Released Python Code tool.

Behind the scenes: various bug fixes and improvements to stability and performance.

6.4.0

Updates to Import from File tool.

Enabled the ability to change workflow run mode

Behind the scenes: various bug fixes and improvements to stability and performance.

6.3.0

Added WORKDAYS() expression.

Released Parse JSON tool.

Added "Does not contain" reference check to validate tool.

Enabled users to rename pass fail labels in validate tool.

Behind the scenes: various bug fixes and improvements to stability and performance.

6.2.1

Hotfix - Clone template modal showing duplicate templates within listing

6.2.0

Two finger swipe navigation disabled

Block the ability to run or publish a workflow if a cyclical dependency is created

6.1.0

6.0.0

Added Euro and Pound support to data inference engine

5.1.1

Added support for Canada, UK, and Ireland

Added basic keyboard support to interact with the canvas

5.1.0

5.0.0

4.0.0

Last updated 26 days ago

Was this helpful?

📓