Visualizations

Visualizations turn your data into clear, meaningful insights that are easy to explore and share. When configuring Data tiles, you can choose from a range of visualization types, depending on the structure and content of your data. Each visualization type has its own configuration options and best-use scenarios.

Visualization types

You can select and configure visualization types in the Visualization tab of the right-hand panel in the tile editor. The initial options available may vary based on your dataset, but you can use Shaping or SQL Analytics to manipulate your data so that it can be visualized in more ways.

  • Table: Displays raw data in a structured, sortable table format. Best for viewing detailed records, inspecting query results, or validating data.
  • Scalar: Shows a single value, such as a total, count, or percentage. Best for KPIs or summary metrics (for example, “Total Sales” or “Average Resolution Time”).
  • Line graph: Plots values over time or a continuous variable. Best for tracking trends, identifying spikes or drops, and time-based analysis.
  • Bar chart: Compares categorical values or aggregated data side-by-side. Best for ranking categories, comparing quantities, or showing part-to-whole relationships.
  • Blocks: Displays key metrics in colored blocks or tiles for quick visual scanning. Best for dashboards highlighting several KPIs or categorical counts.
  • Donut: A circular chart representing parts of a whole. Best for showing proportional breakdowns (for example, “Tickets by Status”).
  • Embed: Displays external or custom content directly within your dashboard. Best for integrating third-party dashboards or internal portals.
  • Gauge: Displays a single value against a defined range. Best for monitoring progress toward a goal or threshold.

Troubleshooting visualizations

Which visualizations are offered to you depends on the data available, for example Line Graph will only be offered if there is time series data in your dataset.

When a warning triangle is shown it means that that particular visualization cannot be shown at this time. It may be that shaping the data will allow others visualization to be used.

Example fixes

If your ticket data does not currently display a Line, Bar, or Donut visualization, try reshaping it with the following operations:

  1. Filter | Group | Sort > Group by > Created Date > Bucket by > Day
    → Adds time buckets to support trend visualizations (for example, Line or Bar charts).
  2. Filter | Group | Sort > Group > Aggregation type > Count
    → Creates aggregated data suitable for Bar or Donut charts.

Once the data structure supports the selected visualization, the warning will disappear and the chart will render.

Resetting visualization settings

If your configuration becomes complex or you want to start over, use the Reset button in the Visualization panel. This reverts all visualization-specific changes to their defaults without affecting your underlying data or filters.

Tips for choosing the right visualization

  • Understand your goal: Are you comparing, tracking, summarizing, or exploring data?
  • Match visualization to data type:
    • Time-based → Line Graph
    • Categorical → Bar or Donut
    • Single metric → Scalar or Gauge
  • Keep it simple: Too many visual elements can obscure insights.
  • Validate your data shape: Ensure proper grouping and aggregation before switching visualization types.

Was this article helpful?

Have more questions or facing an issue?
Submit a ticket