WriteBackExtreme
WebsiteAll products
V5.0
V5.0
  • Prologue
    • WriteBackExtreme v5
    • Release Notes
    • Changelogs
    • Architecture
      • Data Handling and Security in WriteBackExtreme (SaaS)
  • Installation guide
    • Requirements
      • Windows
      • Linux
    • Getting started
      • Windows
      • Linux
      • Containerization
        • Docker standalone
        • Docker compose
        • Repository database
        • ODBC connections
    • Installation wizard
      • License
      • Repository database
        • SQL Server
        • MySQL
        • PostgreSQL
        • SQLite
      • Create a user
      • URL & SSL Certificate
      • Run as a service
      • Summary
        • Running on Linux
    • Configuration panel
      • Home page
      • Domain & SSL Management
      • Repository Database
      • License Management
      • User Management
      • Ip Whitelisting
      • Primary keys in Data Add
    • Upgrade
      • Upgrade from 2.x
    • Update license
    • Moving to production
  • Product Guide
    • Getting started
    • Tableau Extension
      • Getting started
        • Create a worksheet with Username()
        • Add the Extension to your dashboard
        • Ready to start
      • Configuration
        • General
          • Schemas
          • Authentication
          • Popup
          • Theming
          • Tabs
          • Mapping
          • Tableau
          • Import/Export
          • Tableau Datasource
        • Schemas
          • General
            • Editable Conditions
          • Field Formatting
            • Single line text
            • Paragraph text
            • Number
            • Boolean
            • Dropdown select
              • Dynamic Populated content
              • Cascading dropdown
            • Date/DateTime
          • Form Builder
            • Features
            • Dynamic Values
              • Troubleshoot | values
        • Changelog
      • End-user
        • Features
          • Dynamic Filtering
          • Bulk Import
          • Audits (History)
          • Bulk Edit
          • Duplicate rows
        • Add Data
          • Overview
          • Add rows
          • Edit rows
        • Collaboration
          • Overview
          • Add / Edit
          • Reply
        • Data Helper
          • Overview
          • Add rows
          • Edit rows
        • Data Correction
          • Add records
          • Edit records
          • Remove records
          • Interpolate
          • Calculations
          • Vertical layout
        • SSO/SAML or Oauth authentication
    • Management console
      • Setup security
        • OAuth Setup
          • Microsoft Entra
          • Auth0
          • Google
        • SSO Setup
          • OKTA Example
          • PingOne Example
          • Azure Example
          • Troubleshooting SSO
      • Connections
      • Schemas
        • Permissions
        • Audits
        • Import/export
        • Row Level Security
        • Schema data
        • Workflows
          • Stored procedures
          • Tutorial (video)
      • Tableau sync
      • User management
      • Group management
      • Info & License
    • Database Connections
      • DataBricks
        • Windows
        • Linux
      • Snowflake
        • Using ODBC
          • Windows
          • Linux
        • OAuth Authentication
        • Key Pair
    • NEW: InputTables
  • Support
    • Troubleshoot
      • Errors
    • FAQ
Powered by GitBook
On this page

Was this helpful?

  1. Product Guide
  2. Tableau Extension
  3. End-user
  4. Data Correction

Interpolate

PreviousRemove recordsNextCalculations

Was this helpful?

You need to enable PowerTools in the configuration for this feature.

Data Correction can be used to clean data, enable power tools to bulk edit your values. There’s possibilities such as adding, subtracting, dividing and multiplying with a chosen value. If there are empty values use our powerful Interpolate tool! Sometimes you want to fill in the missing data points automatically, based on related data. This is something the build-in interpolation function can help you with. Interpolation is a method of constructing new datapoints within the range of a set of known datapoints. To use the interpolation function of the Data Correction module, select multiple fields. You must provide data that can be used to interpolate, i.e. the datapoint prior and the datapoint latter to the missing datapoints. When you selected the correct datapoints, you can use the calculator icon above the column and select “Interpolate” to fill in the missing datapoints.

Interpolation

Sometimes you want to fill in the missing data points automatically, based on related data. This is something the build-in interpolation function can help you with. Interpolation is a method of constructing new datapoints within the range of a set of known datapoints.

To use the interpolation function of the Data Correction module, select multiple fields. You must provide data that can be used to interpolate, i.e. the datapoint prior and the datapoint latter to the missing datapoints. When you selected the correct datapoints, you can use the calculator icon above the column and select “Interpolate” to fill in the missing datapoints.

We use linear interpolation method of using to construct new data points within the range of a discrete set of known data points.

WriteBackExtreme Interpolation
WriteBackExtreme Product Guide Modules modules
curve fitting
linear polynomials