All articles

Understanding Widget Types

Table 13. Availability - Legacy plans


Overview

All users except for collaborators on all paid accounts have access to widgets within dashboards.

The widget editor supports various types of widgets, each designed to visualize data in distinct formats. Two notable widget types are the pivot table and table with breakdowns. The pivot table enables users to analyze multidimensional data by arranging it into rows and columns, allowing for flexible exploration and comparison. Meanwhile, the table with breakdowns offers a structured view of data with the ability to drill down into specific categories for detailed analysis.

Pivot Table

A pivot table is a specialised widget type that enables users to analyze and summarize large datasets by rearranging and aggregating data dynamically. It provides a flexible way to explore relationships between multiple variables.

Pivot_table.png

Table with Breakdowns

Similar to a pivot table, this widget type allows users to display tabular data with the option to include breakdowns for deeper analysis. It offers a structured view of the data, making it easier to identify patterns and trends.

Table_with__breakdown.png

Available Widget types

Widgets are key elements of a dashboard, presenting data and insights in a user-friendly and visually engaging way. Various types of widgets fulfill different data visualization needs. Here's a summary of common widget types and their purpose.

  1. Indicators: These are simple widgets that display a single value or metric, often represented as a number. They provide a quick snapshot of key metrics.

  2. Donuts: Donut charts are circular charts similar to pie charts. They are useful for showing the proportion of parts to a whole, with each segment representing a category or percentage of the total.

  3. Column Charts: Column charts represent data using vertical bars, where the height of each bar corresponds to the value it represents. They are effective for comparing discrete categories or showing changes over time.

  4. Stacked Column Charts: Stacked column charts display multiple series of data stacked on top of one another. They are useful for illustrating total values as well as the contributions of individual components to the total.

  5. Percentage Stacked Column Charts: Similar to stacked column charts, but each column's height represents a percentage of the whole rather than absolute values.

  6. Bar Charts: Bar charts are similar to column charts but display data horizontally, with the length of each bar representing the value it represents. They are often used for comparing data across different categories.

  7. Stacked Bar Charts: Similar to stacked column charts but with horizontal bars stacked on top of each other.

  8. Percentage Stacked Bar Charts: Similar to stacked bar charts, but each bar's length represents a percentage of the whole rather than absolute values.

  9. Line Graphs: Line graphs represent data as points connected by lines. They are effective for showing trends over time or relationships between variables.

  10. Tree Maps: Tree maps display hierarchical data as nested rectangles, with the size of each rectangle representing a quantitative value. They are useful for visualising complex datasets and comparing proportions.

  11. Area Charts: Area charts are similar to line graphs but with the area below the lines filled in with color. They are effective for showing cumulative totals over time or comparing multiple series.

  12. Stacked Areas: Stacked area charts display multiple series of data stacked on top of each other, with the area below the lines filled in with color.

  13. Percentage Stacked Areas: Similar to stacked area charts, but each area represents a percentage of the whole rather than absolute values.

Switching Between Widget Types

Users can effortlessly transition between various widget types using the editor's intuitive interface:

Intuitive Controls: Utilize metric and breakdown pickers to tailor the visualization to your needs. These tools enable you to select specific data points and dimensions for analysis.

Dynamic Widget Adjustment: Depending on your selection, the widget type adapts for optimal data representation. For instance, choosing a single metric and breakdown might create an indicator widget, whereas selecting multiple metrics could transform it into a table.

Tip

Experiment with different metric and breakdown combinations to discover the most effective way to visualize your data, enhancing your analytical insights.

To do this:

  1. Navigate to the desired widget.

  2. Select the specific metric, such as New 1 .

  3. Upon clicking the desired metric, a new window will pop up.

  4. In this new window, a Table 2 will be displayed.

  5. You can add breakdowns to the table to analyze the data further.

  6. Arrange your data into different columns by selecting appropriate Fields 3 .

Switchin_widget_type__sheet_1_.png
Switchin_widget_type__sheet_2_.png

What's next?

Top