Intuitive Dashboard

An intuitive dashboard affords end-users with a large learning curve that is non-existent in most brand name business intelligence applications. Users possessing minimal technical abilities will be able to take advantage of in analytic depth features while they are first learning to use the program. View the example here to learn how InetSoft's Style Intelligence can increase your business intelligence knowledge just by using it.

A Data Tip displays information about the current region using another Viewsheet component, such as a chart or a gauge. The data tip component displays data only for the particular region over which the user hovers the mouse.

In this example, you will create a map that displays quantity purchased by state. When the user hovers the mouse over a given state, the map will display a chart as a Data Tip. This chart will break down the quantity purchased by the individual companies within that state.

#1 Ranking: Read how InetSoft was rated #1 for user adoption in G2's user survey-based index.
  1. Create a new Viewsheet based on the sample US Sales Worksheet.
  2. Drag a Chart element onto the Viewsheet grid. (This will be the Data Tip chart.)
  3. Click the center of the Chart (or click the Edit button at the topright). This opens the Chart Editor. Make the following selections:
    1. From the Dimensions node of the Data Source panel, drag the Company field to the X region of the Data panel.
    2. From the Measures node of the Data Source panel, drag the Quantity Purchased field to the Y region of the Data panel. This creates a chart that displays the quantity purchased for each company.
    3. Right-click the Chart, and select Properties from the context menu. This opens the Chart Properties dialog box.
    4. In the Name field, type DataTip Chart, and click OK.
  4. Drag a map element onto the Viewsheet grid.
  5. Right-click the map, and select Properties. This opens the Map Properties dialog box. Make the following settings:
    1. Under the General tab, select the Data Tip View option. From the adjacent menu, select the chart (DataTip Chart).
    2. Under the Data tab, select Sales from the Table menu.
    3. Select Quantity Purchased from the Value Column menu.
    4. Under the Hierarchy tab, add State and City in the Geography Columns box.
    5. In the Predefined Location box, specify North America and United States as the Continent and Nation, respectively.
    6. Click the Check button to open the Geographical Feature Names dialog box and automatically resolve the geographical names. Click OK to exit.
    7. Click OK to exit the Map Properties dialog box.
  6. Preview the Viewsheet, and hover the mouse over different states to view the corresponding Data Tip.
We will help you get started Contact us