Adding visualizations

After you have loaded data into your app, you can start adding visualizations to it to expose the data in a way that is understandable to users.

The following steps will help you to add two different visualizations; a filter pane and a bar chart.

Edit sheet

If the sheet is already open and editable you can skip this step and start by creating a new dimension.

Do the following:

1. From the app overview, click 4 to open the sheets area.
2. Click on a sheet to open it.
3. Click @Edit in the toolbar.

A panel with assets is opened on the left side.

Create a new dimension (master)

Do the following:

1. In the left panel, click - to open Fields.

   Here you will find all the fields in all the tables that you have loaded from your Excel file.

2. Click the field Date.

3. In the popup, select Add to master items and As dimension.

   The Create new dimension dialog appears with the dimension name already filled in.

4. Click Add dimension.

5. Click Done.

The new dimension Date is saved as a master item (é).

Create a new measure (master)

Do the following:

1. In the left panel, click é to open Master items.

2. Click Measures and Create new to open the Create new measure dialog.

   Use the expression editor to enter an expression for the measure.

3. Click 3 in the Expression field.

   The Add expression dialog is opened.

4. In the Field list, select Sales.

5. In the aggregation list below Sales, select Sum.

6. Click Insert.

   The expression is inserted into the expression editor.

7. Click Apply.

   You are back to the measure dialog.

8. Enter Sales as the measure name. Click Create.

The new measure Sales is saved as a master item (é).

Add a filter pane

Do the following:

1. In the left panel, click 5 to open the Charts section.
2. Drag the chart type Filter pane onto the sheet.
3. Click Add dimension and select Date from the Dimensions section of the list.

The filter pane is complete and shows all the values from the Date dimension.

Add a bar chart

Do the following:

1. Drag a second chart type, Bar chart onto the sheet.
2. Click Add dimension and select Date from the Dimensions section of the list.
3. Click Add measure and select Sales from the Measures section of the list.

The bar chart is complete and shows the data values from the new dimension and measure as the X-axis and Y-axis of the bar chart.

The app is ready for discoveries

You now have an app with one sheet containing two visualizations and can start using the app.

See: Discovering and analyzing