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 how to set up this type of interaction.

The appended data could be entered by a viewer through any input control, or it could come from an interaction or from script through a view parameter.

Note
This interaction is not available on data visualizations.

2. Create a data cube

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

Create three Data Input Columns:

  1. Textbox (containing the string data type)
  2. Number (containing the integer data type)
  3. DropDown (containing the string data type)

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

3. Create a dashboard

Create a simple user input form on a dashboard.

From the toolbar, add a Textbox filter:

  • Change the label text to Textbox
  • Enable the Manual Items property
  • Hide the 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
  • Hide the 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 the label 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:

  • Textbox – parameterTextBox 1
  • Number – parameterNumberic 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: 7am-6pm, ET, Mon-Fri