> For the complete documentation index, see [llms.txt](https://help.pump.co/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://help.pump.co/pump-view/playground.md). # 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. --- # Agent Instructions This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com. ## Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter: ``` GET https://help.pump.co/pump-view/playground.md?ask=&goal= ``` `ask` is the immediate question: it should be specific, self-contained, and written in natural language. `goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.