Configuring editable columns

In a write table, editable columns allow users to enter data on the fly during analysis. By saving changes to an editable column, a user writes changes to a change store, from which they can be retrieved by application developers and integrators.

Adding an editable column

Do the following:

1. Create a new write table and add dimension and measure columns.

   Creating write tables

2. In the properties panel, expand Data.

3. Click , and then select one of the following:

   • Create new editable column: Create a new, blank editable column.

   • Add existing editable columns: Use existing editable columns that match the primary keys defined for your write table.

After adding the editable column, you can configure its appearance and how users can interact with it. See Configuring editable columns.

Configuring editable columns

Do the following:

1. In the properties panel, under Data, click the editable column.

   The column properties open.

2. You can change any of the following properties:

   • Title: Change the default column title.

   • Show content: Change how users can edit data in the table. You can choose between:

     • Single selection: Specify a set of values that users can select for each cell when editing. For example, you could add two values for orders statuses: On Track and Late. Users can then select between these values when they comment on data records.

       For single selection, you can use either fixed or dynamic values:

       • Fixed: Define values manually by typing them into the entry box. These values are static and do not change with application data.

       • Dynamic: Use expressions to define input values that can change depending on the value of an expression. For example, you can link values to a data model field, or to application variables. You can specify values and labels, or just values.

         For more information about using expressions in visualizations, see Using expressions in visualizations.
         Tip note

         Syntax:

         Use | to separate values and ~ to separate value and label, like this: value1|value2 or value1~label1|value2~label2.

         Information note

         Up to 1000 values are supported. Values exceeding the limit will be ignored.

         Examples

         =Concat(Country, '|')

         =Concat(DISTINCT City & '~' & Upper(City), '|')

         ='Product A|Product B|Product C'

         ='$(vMyVariable)'

         ='ProductA-value~ProductA-label|ProductB-value~ProductB-label'

     Single selection

     • Manual user input: Users edit data by typing text manually into cells.

       Manual entry

   • Show column: Toggle whether the column is visible or hidden.

   • Column width: Set the width of the column.