Set up a data input interaction

Contents[Hide]

1. Overview

A data input interaction lets you append data to the Data Input transform in a data cube. The appended data is taken from the labels of various control, such as a view parameter, a selected checkbox, or the value of a slider. This article shows a basic example of how to set up this type of interaction.

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, select the prepared data cube.

Map the Data Input Column to the Input source:

  • 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.

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