Playground

Playground and Filters

The Playground is Pump View's interactive workspace for exploring cloud spend. It combines a query builder, visualization controls, and a data table so you can slice your costs by any dimension and spot trends or anomalies.

Navigate to View > Playground in the left sidebar.

Query builder

The query builder sits at the top of the Playground. It follows a structured format:

Select all from [dimension] in [provider] Where [filters]

SQL Querying is also available to filter.

Breakdown dimensions

The first dropdown controls how your spend is grouped. Available dimensions:

Dimension	What it shows
Service	Spend grouped by cloud service (e.g., Amazon EC2, Cloud Run, Azure VMs)
Account	Spend grouped by linked account or project
Region	Spend grouped by cloud region (e.g., us-east-1, europe-west1)
Resource	Spend grouped by individual resource ID
SKU	Spend grouped by SKU or line-item description
Usage Type	Spend grouped by usage category (e.g., DataTransfer, Storage, Compute)
Charge Type	Spend grouped by charge category (e.g., on-demand, reserved, spot, tax)
Commitment	Spend grouped by commitment instrument (RI, SP, CUD)
Marketplace	Spend grouped by AWS/GCP/Azure marketplace purchases
Provider	Spend grouped by cloud provider, useful when you have multiple providers connected

Filters

Click + Add filter to narrow results. Filters use the same dimensions listed above. For example, you can select "Service" as your breakdown and add a filter for "Region = us-east-1" to see per-service spend in a specific region.

Multiple filters can be combined. Each filter supports multi-select, so you can include or exclude specific values.

Provider scope

The in [provider] dropdown scopes your query to a specific provider (AWS, GCP, Azure) or across all connected providers. When you have multiple clouds connected, you can query across all of them in a single view.

Visualization modes

Standard (Bar)

The default view is a bar graph. Displays a stacked bar or line chart of total spend over your selected time range, broken down by whatever dimension you chose. The data table below the chart shows the full breakdown with sortable columns.

Line

Select Line in the visualization drop down at the top right to switch from stacked bars to a line chart of total spend over your selected time range, broken down by whatever dimension you chose. This is the clearest way to spot trends and inflection points over time, especially when comparing multiple services or accounts that would otherwise clutter a stacked bar view.

Each line represents one value within your selected breakdown dimension. The data table below the chart shows the same sortable breakdown as in Standard view.

Top Movers

Toggle Top Movers in the top-right toolbar to switch to a waterfall chart that highlights what changed between two time periods. This is the fastest way to answer "what drove my cost increase (or decrease) this month?"

Top Movers compares two periods side by side and sorts every item by absolute change. The chart shows increases in red (above the zero line) and decreases in green (below the zero line). The table below displays each item with its absolute dollar change and percent change.

For example, if you select a 30-day window, Top Movers compares the previous 30 days against the 30 days before that, then ranks every service by how much its cost moved.

Pie

Toggle Pie to see your spend for the selected time range as a proportional breakdown by dimension. This is the fastest way to answer "what's my spend mix?" rather than "how has my spend changed?"

Pie view works best with a small number of segments. If your breakdown dimension has many distinct values (for example, Resource or SKU), consider narrowing with a filter first, or switch to Bar or Line for a more readable view.

Sankey

Toggle Sankey to see your spend as flows between dimensions — for example, how spend moves from provider to account to service. This view is useful for understanding how cost flows through your organization's structure rather than just how much each individual item costs.

Each node represents a value within a dimension, and the width of each connecting flow represents the dollar amount moving between them. Sankey is most useful when you have at least two breakdown dimensions to compare (for example, Account and Service) rather than a single flat list.

Time range

Use the time range controls in the toolbar:

Option	What it covers
1D	Last 1 day
7D	Last 7 days
30D	Last 30 days
3M	Last 3 months
Custom	Pick a specific date range

Forecasting

The Forecast dropdown in the toolbar projects your end-of-month spend based on current trends. Two confidence levels are available:

Level	What it means
P50	Median projection. Your spend is equally likely to land above or below this number.
P90	Conservative projection. 90% chance your actual spend will be at or below this number. Useful for budget planning.

The forecast engine is labeled in the toolbar (e.g., "Engine: statsforecast"). Forecast lines appear as dotted extensions beyond your current data on the chart.

Saving a query as a report

Any Playground view can be saved as a report. Click New Report next to the Playground header to save the current query, filters, time range, and visualization settings. Give it a name, and select Save in the upper right hand corner to save to the Reports tab. See Reports article for details on scheduling and sharing.