Dashboards often lack immediate context, resulting in a frustrating user experience. Analysts must constantly switch between views, tabs, and reports just to understand the insights. To solve this, AWS introduced Sheet Tooltips in Amazon Quick Sight, a powerful feature that enables richer, more interactive data storytelling in a single dashboard view.

The Problem with Traditional Dashboards

• Fragmented insights: Users must navigate multiple sheets to gain context for a data point.
• Too many clicks: Constant drill-downs and filter menus interrupt the natural flow of analysis.
• Cognitive overload: Forcing users to interpret multiple dense visuals separately can overwhelm them and obscure the main narrative.
• Static tooltips: Traditional hover-overs only show basic values (like a single text string or number) rather than actionable, layered insights.

What is Amazon Quick Sight?

It empowers teams to build interactive dashboards, perform ad-hoc analyses, and seamlessly share insights across the organization. Some of its heavy-hitting features include:

• SPICE Engine:
  • The Super-fast, Parallel, In-memory Calculation Engine designed for blazing-fast data retrieval.
• Auto-scaling Architecture
  • Fully serverless, meaning it scales automatically without requiring infrastructure management.
• Deep AWS Integration
  • Natively connects with S3, RDS, Redshift, and various third-party data sources.

How Standard Tooltips Work

Before diving into the new sheet tooltips, it is helpful to review how standard tooltips currently function in the Amazon Quick Sight ecosystem.

When you hover your cursor over any graphical element in a visual, like a date on a line chart, a basic tooltip pops up. It provides information about that specific element. By default, the information in this tooltip is determined by the data mapped in your “Fields well.”

If you use the “Detailed tooltip” option, you get a bit more control over this setup:

• You can display the primary field value as the tooltip title
• You can choose to display the mathematical aggregations (such as sums or averages) applied to the fields
• You can manually add and customize labels for up to 10 data fields that appear on hover

Amazon Quick Sight Sheet Tooltips

When a user hovers over a data point:

• A rich, contextual canvas appears instantly.

• The pop-up can include multiple charts, key performance indicators (KPIs), text boxes, and even images.

How Sheet Tooltips Work

• Step 1: Hover Interaction

  • A user hovers their cursor over a specific data point on the main dashboard. For example, this could be a bar representing the “Asia” region. Amazon Quick Sight instantly captures the contextual dimension values at that exact coordinate.

• Step 2: Filter Inheritance

  • The tooltip sheet inherits all active filters from the main visual. It then applies an extra filter for the data point you hovered over. For example, hovering on “Asia” filters all visuals inside the tooltip to Asian data.

• Step 3: Rendering the Tooltip Sheet

  • The engine loads the visual elements—charts, text, and images—defined for that tooltip sheet. Data is processed rapidly via the in-memory SPICE engine or via Direct Query.

• Step 4: Contextual Insight Display

  • The tooltip instantly displays detailed breakdown charts, KPIs, and historical trends. The system reuses existing dashboard logic. It then applies on-the-fly context-specific filtering.

Real-World Use Cases Across Industries

• Financial & Executive Dashboards: Executives often need a macro view of the business. A main dashboard might show overarching revenue by region. When the executive hovers over the “North America” bar, a sheet tooltip pops up. It instantly displays a line chart of month-over-month trends, a pie chart showing revenue by department, and a gauge chart comparing actuals to quarterly targets.
• Healthcare & Patient Analytics: A hospital’s population health dashboard might display a key metric, such as the overall readmission rate. When a care manager hovers over a high-risk facility, a tooltip sheet pops up. It details patient demographics, localized utilization metrics, and specific risk gaps for that location. This enables immediate, proactive intervention.
• Supply Chain & Operational Monitoring: Logistics teams tracking global operations can view a map of all distribution centers. Hovering over a specific warehouse location reveals a mini-dashboard displaying current inventory volume, average delivery latency metrics, and a list of the top delayed products.

Step-by-Step: How to Build Your First Sheet Tooltip

• Step 1: Navigate to Interactions

  • Open your analysis in the console, then select the visual you want to enhance (e.g., a bar chart). Click the Format visual icon. In the Properties panel on the right, go to the Interactions tab.

• Step 2: Enable Sheet Tooltips

  • Under the Tooltip configuration, look for the Type dropdown and select ‘sheet tooltip’.

• Step 3: Create the Sheet

  • Click the Create sheet tooltip button. Amazon Quick Sight opens a new, blank tooltip sheet using a free-form layout canvas.

• Step 4: Design Your Mini-Dashboard

  • Add supplementary visuals. You can drop in up to 5 visuals, 5 text boxes, and 5 images. Resize and arrange them as you want in the hover window.

• Step 5: Return and Test

  • Once you are happy with the layout, click the < (Back) button at the top menu bar. This returns you to the main dashboard.
    Now, you can hover over your visual to see your custom, dynamic tooltip in action.

Advanced Capabilities: Small Multiples and Parameters

• Small Multiples Support

  • Sheet tooltips natively integrate with visuals, utilizing the small multiples feature. Small multiples split a visual into a grid of comparative partitions. By attaching a sheet tooltip to this grid, viewers can hover over an individual panel to uncover highly localized, detailed context for that specific partition without losing their macroscopic comparative view.

• Parameter-Driven Tooltip Switching

  • To take progressive disclosure to its absolute peak, sheet tooltips support parameter-driven interactivity. This allows dashboard authors to create dynamic tooltips where the reader uses a control on the main canvas to literally switch which visuals render inside the tooltip. For instance, a reader can toggle a parameter to instantly swap the tooltip’s display from a “Sales by Quarter” breakdown to a “Sales by Category” view.

The Core Benefits of Sheet Tooltip

• Fewer Sheets to Manage:

  • It drastically reduces the need to build and maintain multiple drill-down dashboards, consolidating macroscopic and microscopic insights into a single interface.

• Better User Experience (UX):

  • Less navigation translates to smoother interaction. It surfaces vital functionality directly within the flow of the user’s natural interaction, keeping them focused on one visual context.

• Faster Decision-Making:

  • Sheet tooltips give instant access to deeper, layered insights. Users spend less time clicking through filters and switching views.

• Improved Data Storytelling:

  • It executes the psychological principle of progressive disclosure. It combines summary and detail seamlessly, helping users understand cause and effect without suffering from cognitive overload.

The Limitations of Sheet Tooltip

• Capacity and Dimension Limits:

  • Up to 50 tooltip sheets per analysis
  • Up to 5 visuals per tooltip sheet
  • Up to 5 text boxes per tooltip sheet
  • Up to 5 images per tooltip sheet
  • The maximum size of a tooltip sheet is 640px wide by 720px tall
  • Tooltip sheets use only the free-form layout

• Cross-Sheet Filtering:

  • Cross-sheet filters cannot be scoped to tooltip sheets

• Minimum Sheet Requirement:

  • An analysis must contain at least one regular interactive sheet. It cannot consist solely of tooltip sheets

• Unsupported Visual Types:

To ensure tooltip sheets load quickly and maintain a focused experience, certain complex visuals cannot host or be placed inside a sheet tooltip. The following visual types are strictly excluded:

• • Sankey diagrams
  • Waterfall charts
  • KPIs
  • Radar charts
  • Wordclouds
  • Custom content visuals
  • Highcharts
  • Insights
  • Layer map visuals

From Static to Interactive UI Dashboards

Sheet tooltips represent a massive shift from static, traditional dashboards to highly interactive, layered storytelling systems. By embracing progressive disclosure, they remove friction in data analysis and embed dynamically filtered, contextually relevant insights right where the user is already looking.

When used properly, they clear up visual clutter, drastically reduce manual sheet navigation, and enable lightning-fast, data-driven decisions. As enterprise dashboards continue to evolve, features like sheet tooltips prove that the future of BI isn’t just about displaying data—it’s about letting users intuitively experience insights in perfect context.