The Data Correction module of WriteBackExtreme supports you in changing existing data directly from your Tableau dashboard. Your dashboard users can perform data corrections directly from the dashboards where they detect the inconsistencies. With the full audit trails of the extension your changes to the data are secure and governed.
A possible use case for the Data Correction module is working with sensor data. When using sensor data, you often don’t have a source system to edit or correct existing data. The Data Correction module lets you change/correct data directly from your Tableau dashboards.
You can use Data Corrections for a lot of use cases like:
- Correcting wrong or missing sensor data
- Typo corrections in a dimension
- Any other data quality related challenges
Please take note of the fact that the Data Correction module will overwrite the existing data. The module will maintain an audit trail of all changes.
We will discuss the usage of the Data Correction extension and assume you already know how to configure a dashboard that uses Data Correction. If you don’t know how to do this, you can take a look at the documentation for the Management Console (backend) or the Dashboard setup (frontend).
You can follow along using the Data Correction dashboard in the demo workbook for Write Back Extreme. This is the dashboard we will be using in the documentation examples below.
To correct data, select the marks on your dashboard you want to alter. In the example below, we select a row from a table containing sensor data. The row is missing a value for the column “water”. When we click on the row, the Data Correction extension container displays a form which allows us to edit the data; in this case add a value for “water”. We can also add a reason for the correction. The changes will overwrite the existing datasource. Any changes made by a user will be stored in the audit datasource.
If you want to edit multiple records at once, you can drag to select multiple fields. The Data Correction extension container will show all of the selected rows and allows you to edit them. In our example, we use this feature to select three empty “gas” fields and add the missing data for all three fields to the datasource in one action.
Bulk edit using calculations
You can also edit multiple values at one using a calculation. Simply click on the calculator icon above a column and select “Bulk Edit”. A number of calculation options can be performed on the data. Select the operator and enter a value. When you hit “Update” the calculation will be performed and the values can be previewed. When you’re happy with the result, hit “Save”. The datasource data will be updated to reflect your calculations.
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.
We use linear interpolation method of curve fitting using linear polynomials to construct new data points within the range of a discrete set of known data points.
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.
Add data through the Data Correction module
It’s now possible to add data for non-existing rules with data-correct. Connect your Data Correct schema to your partially filled table, linking the field product_name from your schema to another database with the same product_name field for example.
Pagination on overview
The overview of Data Correction module can hold lots of rows of data, so to give users a clearer view of the data the extension will automatically paginate. Use the arrow keys to scan through the pages.
New template: Vertical Layout
This can be super handy if you want to do easy 1 – 1 edits like a correct form for a certain row. The default form will be displayed horizontally but if your use case best suits a vertical form layout, then here we have you covered. Open the configure screen within WriteBackExtreme to change, open the ‘Worksheet schema’ tab you will see ‘Use vertical layout’ turn this to on and save.
Follow our demonstration to see the change in action.
With Dynamic filtering the extension will only show the data that matches the filters present on your dashboard. Enable this feature by toggling the ‘Show only relevant values’ option in the configuration. This option is only available when Data Correction is configured to show all data by default.