Set up a data input interaction

Contents[Hide]

1. Overview

A data input interaction lets viewers of dashboards or other views append data to the Data Input transform in a data cube. This article walks through an example of how you can set up this type of interaction.

Data can be entered by a viewer through a variety of input controls available, which can be combined together into a form for users to fill out. It can also come from an interaction with existing data or from script by using a view parameter.

Note
This interaction can't be added directly to a data visualization.

2. Create a data cube

First, create a simple data cube using the Data Input transform.

Add three data input columns:

  • Textbox (containing the String data type)
  • Number (containing the Integer data type)
  • DropDown (containing the String data type)

Create a data input data cube
Create a data input data cube

3. Create a dashboard

We can create a simple user input form on a dashboard to append data to these columns.

From the toolbar, add a Textbox filter:

  • Change the label text to Textbox.
  • Enable the Manual Items property.
  • Select Hide Token Menu.

Add a Textbox with Manual Items to the dashboard
Add a Textbox with Manual Items to the dashboard

Add a Single Number filter:

  • Change the label text to Number.
  • Enable the Manual Items property.
  • Select Hide Token Menu.

Add a Number filter with Manual Items to the dashboard
Add a Number filter with Manual Items to the dashboard

Add a Drop Down List component:

  • Adjust the Items list to have Item 1, Item 2, and Item 3.
  • Set the Value of each item to be the same as the caption.
  • Add a label component with the text Drop Down above.

Add a Drop Down List component to the dashboard
Add a Drop Down List component to the dashboard

Add a Button component and change the button text to Data Input.

Add a Button component to the dashboard
Add a Button component to the dashboard

4. Set up an interaction

With the button selected, click Set Up Interactions from the toolbar and select Data Input.

Click Set Up Interactions and select Data Input
Click Set Up Interactions and select Data Input

In the Set Up Data Input dialog, tick the Clear Input Sources checkbox and select the prepared data cube.

For each column in the Data Input transform in the cube, choose an input source. These can be either an input control such as a textbox, or a view parameter.

For our example, set up the following mappings given the default names identifying our input controls:

  • Textbox – parameterTextBox 1
  • Number – parameterNumeric 1
  • DropDown – dropDownList 1

Map the data input columns to the input source
Map the data input columns to the input source

Click Submit.

5. Test the interaction

Switch to View mode, fill out the form, and click the button. 

Fill out the form and click the button
Fill out the form and click the button

Then, go to the data cube and open the Data Preview panel.

Open the Data Preview panel of the data cube
Open the Data Preview panel of the data cube

6. Notes

  • The appended data is always a single value. In the case of a range or collection, the input is the beginning or first value respectively.
  • Users require the Data Input privilege to be able to input data.

7. See also

Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours:
Phone: 9am-6pm, ET, Mon-Fri
Email: 7am-6pm, ET, Mon-Fri