Skip to main content Skip to complementary content

Example: Building a sheet

This example shows you how to quickly build a sheet. If you want to follow along to replicate the example, the base app and data used are available from the business logic tutorial. For the business logic tutorial, see Tutorial – Customizing how Insight Advisor interprets data.

The sheet edit mode allows you to quickly develop useful visualizations. When you create a sheet, you should have an idea of the kinds of information you want to see. In this case, from the Tutorial - Business logic app we want to create a sheet that lets us exploration sales by different points of time. This sheet should let us see: 

  • A geographic representation of sales by country and city.

  • Gross profits by sales office.

  • Employee sales figures.

  • The breakdown of specific products and categories.

  • A filter so users can filter data by year, quarter, month, and week.

Example sheet

Creating the first visualization

For the first visualization, we will make a bar chart.

  1. In the Tutorial - Business logic app, create a new sheet.

  2. From Assets, in Charts, drag and drop a bar chart into the sheet.

  3. From Assets, in Fields, drag and drop SalesOffice on the bar chart and select Add "SalesOffice".

  4. From Assets, in Fields, drag and drop Gross Profit on the bar chart and select Add as measure > Sum([Gross Profit]).

  5. In the properties panel, click Sorting.

  6. Drag Sum([Gross Profit]) to the top of the sorting list.

  7. Click AppearancePresentation.

  8. Select Horizontal.

  9. In the properties panel, click AppearanceColors and legend.

  10. Under Colors, select to Custom.

  11. Select By dimension.

    First visualization

    Completed bar chart

Adding a map

With the bar chart made, we can next make a map that visualizes both countries and cities.

  1. From Assets, in Charts, drag and drop a map into the sheet.

  2. In the properties panel, click LayersAdd layer.

  3. Select Area layer.

  4. Under Dimensions, click Add and a select Country.

  5. Under Colors, select Custom, select By measure, and color by Avg(Sales).

  6. Click Back to return to Layers.

  7. Click Add layer and select Point layer.

  8. Under Dimensions, click Add and select City.

  9. Under Colors, select Custom, select By measure, and color by Sum(Sales).

  10. Under Color scheme, select Diverging classes.

    Sheet with map

Adding a filter pane and rearranging the row

Next, we will add a filter pane so we can explore the data in our visualizations by specific periods of time. We will also rearrange our row of visualizations.

  1. From Assets, in Charts, drag and drop a filter pane to the right of the map.

  2. Click Add dimension > click OrderDateYear.

  3. Click OrderDate.autoCalendar.Year and under Title, enter Year.

  4. In the properties panel, click Add fieldOrderDateQuarter.

  5. Click OrderDate.autoCalendar.Quarter and under Title, enter Quarter.

  6. Click Add fieldOrderDateMonth.

  7. Click OrderDate.autoCalendar.Month and under Title, enter Month.

  8. Click Add fieldOrderDateWeek.

  9. Click OrderDate.autoCalendar.Week and under Title, enter Week.

  10. Click and drag the borders of the map and filter pane to resize them.

    Adding a filter pane

    Sheet with resized map and filter pane.

Adding a new row with a table

We will add a new row of visualizations beneath the current row, starting with a table.

Filtered table

  1. From Assets, in Charts, drag and drop a table into the sheet.

  2. Click Add dimensionEmployeeName.

  3. From Assets, drag and drop SalesOffice onto the table and select Add "SalesOffice".

  4. From Assets, drag and drop Sales onto the table and select Add as measureAvg(Sales).

  5. Select Avg(Sales) and under Number formatting, select Money.

  6. Under Format pattern, enter $ #,##0.00;-$ #,##0.00.

  7. From Assets, drag and drop Sales onto the table and select Add as measureSum(Sales).

  8. Select Sum Sales and under Number formatting, select Money.

  9. Under Number formatting, select Money.

  10. Under Format pattern, enter $ #,##0.00;-$ #,##0.00.

  11. In the properties panel, in Data, under Filters, click AddSales.

  12. Select Sales and select Condition as the filter type.

  13. Select Compare.

  14. Under condition, select > and Fixed value.

  15. Under Greater than, enter 0.

Adding a treemap

Now, we will add a treemap, so we can explore both our product categories but also the products within those categories.

New treemap

  1. From Assets, in Charts, drag and drop a treemap into the sheet.

  2. In the properties panel, in Data, under Dimensions click AddCategoryName.

  3. Click Add > ProductName

  4. Under Measures, click Add  > Gross Profit.

  5. Click and drag the on the borders of the table and treemap.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!