Warp Pivot changelog
Update with composer update qalainau/filament-warp-pivot, then run php artisan filament:assets.
1.10.2 Nov 20, 2026
Fixed
- Console error
warpPivot is not defined: on pages where Livewire re-renders the component inside another Alpine component, the browser console could showwarpPivot is not definedbefore the component's script had arrived. Empty components are now registered up front, and the real ones replace them as soon as they load. No visible change.
1.10.1 Nov 17, 2026
Fixed
- Copying cells: a cell whose text contains a lone carriage return (
\r, e.g. text that came from an old Mac file) is now quoted when copied, so pasting it into Excel or Google Sheets no longer splits it into extra rows.
1.10.0 Nov 17, 2026
Added
Relationship::titleUsing(): build the header from the related record, for examplefn (SalesOrder $record): string => "{$record->number} {$record->title}", instead of one column withtitleAttribute(). WithoutorderBy(), headers are sorted by the text it returns.
Fixed
- Drill-down: the
with()(andwithout()) of the query given toquery()is now kept when the records of a cell are listed. It was dropped, so arecordUrl(), record action or format that reads a relation loaded it once per record, and failed in apps that useModel::preventLazyLoading(). - Screen readers: when the data was reloaded with fewer columns (for example after a layout or tenant change) just after scrolling, building the hidden table for screen readers could fail with "Cannot read properties of undefined" in the browser console. It now only reads the rows and columns that still exist.
1.9.0 Nov 15, 2026
Added
PivotPage::canWrite(): override it to make a page view only for some roles. The drill-down's in-place editing and its edit and delete actions are hidden and refused, and layouts can't be shared; reading, export and the user's own layouts stay.canAccess()of the page is now also checked on every call the open page sends. See "Restricting pages per role" in the README.blankLabel()on every dimension: the header of the records without a value (NULL), in the table and in the list of values of a filter. For exampleRelationship::make('department')->blankLabel('No department'). It is "(blank)" by default, as before.
1.8.1 Nov 14, 2026
Fixed
- Drill-down: columns that show a related value (
store.name,order.customer.name) no longer fail in apps that useModel::shouldBeStrict()orModel::preventLazyLoading(). The relations of the page's records are now loaded in one query per relation, instead of one query per record. - Accessibility: the table for screen readers is now a tree grid (
role="treegrid"), because its rows have levels and can be expanded. As a grid, the levels of the rows were not valid ARIA.
1.8.0 Nov 12, 2026
Added
Pivot::summarize(): the aggregation as categories and series (plain arrays), with the level below a row when you pass its path. For charts, APIs and your own code.Pivot::fromComponent(SalesByRegion::class): the pivot of a page or widget class, without rendering it.
Changed
- Now requires Filament 5.9 or later (was 5.0). Parts of the plugin did not work on older 5.x versions, which were never tested. The tests now also run on the lowest supported versions before each release.
1.7.0 Nov 10, 2026
Changed
- A table with few rows is as tall as its rows instead of the full height of the window;
height()is now the largest height. With a chart, the pivot keeps the full height. - Bold from
formatWhen()andcustomizeCell()is drawn heavier (700) than the subtotals (600), and the numbers of a closed group row are drawn at the normal weight, so a bold cell stands out in every row. - The filter dialog names each part of a condition: "Value to compare", "Comparison", "Compare with" and "Period" (in the ten languages).
- Japanese: the saved layouts button is "保存した表示", so it is no longer confused with "表示の設定" (layout options).
Fixed
- Slanted category names of a column or line chart are no longer cut on the left (the first name) or at the bottom.
- Related records with the same
orderBy()value (a position inside a region, for example) are ordered by their title, the same way on every database.
1.6.1 Nov 7, 2026
Fixed
- Two different measures with the same name in one
values()ormeasures()call (a share of sales written asSum::make('amount')->showAs(...)next toSum::make('amount'), withoutname()) no longer replace each other silently, which made the Sales column disappear and showed the share twice. The pivot now stops withThe pivot has two measures named [amount_sum]and says to give the second one its ownname(). Passing the same measure again, or a measure of the same name in a later call (a page changing the values of its parent), still works.
Documentation
- README "Money stored in cents": divide every amount a formula combines in the same way (
divideBy()on the cost too), or the formula subtracts cents from dollars. - README "Dimensions": dates are read in
app.timezoneand grouped in the dimension's timezone; how to report in Tokyo time with dates stored in UTC. - README "Cell actions": what
$argumentsholds, why to usecellQuery()instead of rebuilding the records fromconditions, and a new section "Testing cell actions" (callAction(TestAction::make(...)->table()->arguments([...]))). - Laravel Boost guidelines and skill: the same three points.
1.6.0 Nov 6, 2026
Added
money('USD', divideBy: 100)(anddivideBy()) for amounts stored in cents: the integers are added up in SQL and each cell is divided once, so screens, formulas, filters and Excel cells get exact values (no44.9999998).DrillDownFormat::money('USD', divideBy: 100)formats drill-down columns of cents indrillDownFormats().- Values in rows:
valuesOn('rows'), and a "Σ Values" field in the field panel to drag between Rows and Columns (saved asvaluesAxisin the layout). Exports, totals, sorting and the chart work with it. drillDownModalWidth()changes the width of the drill-down dialog.- Browser tests:
rowHeaderRect(row)gives the position of a row header and its open/close triangle, andfieldRect(name)the position of a field in the field panel.
Changed
- The drill-down dialog is wider (
Width::SevenExtraLarge, wasFiveExtraLarge), and columns of short values (numbers, dates, text up to 20 characters such as order numbers) no longer wrap; only long text wraps. CalldrillDownModalWidth(Width::FiveExtraLarge)for the old width.
Fixed
- Excel: amounts with a currency get the decimals of the currency (
$#,##0.00for USD) whendecimals()is not set, as on screen; they were written with no decimals.
1.5.0 Nov 6, 2026
Added
- Browser tests:
cellPoint({ row, column, measure })gives the position of a cell (found by header paths or labels) to click, with its value and text, andwhenIdle()waits until queries, the drill-down and saves have finished.
1.4.1 Nov 6, 2026
Fixed
- README: the "Tenancy" example put
rows(['store'])without registeringstoreindimensions(), so it stopped with "The pivot has no dimension named [store]". It now passesRelationship::make('store').
Changed
- README, "Filters and permissions": the policy's
viewAny(andauthorize()) only refuse the pivot's data calls with a 403; the page still opens and stays in the navigation. An example shows Filament'scanAccess()on the page to lock it and hide it from the navigation. - README, "Dimensions": strings in
rows()andcolumns()must be registered names, and aDatedimension is always namedcolumn:granularity(ordered_at:month), even alone, inrows(),columns(),$conditionsand tests.
1.4.0 Nov 6, 2026
Added
- Instructions for AI coding assistants (Claude Code, Cursor, Codex) through Laravel Boost:
a guideline that Boost adds to
CLAUDE.mdandAGENTS.md, and thewarp-pivot-developmentskill for building pivots and testing them. Selectqalainau/filament-warp-pivotinphp artisan boost:install, or add it to"packages"inboost.json. See AI coding assistants (Laravel Boost). php artisan warp:assign-tenant "App\Models\Team" 1: for apps that add Filament's tenancy after saving layouts. Saved layouts without a tenant are hidden from every tenant; the command gives them (warp_pivot_views) to one tenant, together with the rows without a tenant of every other installed Warp plugin, in one transaction.--dry-runonly counts them. See "Adding tenancy to an app that already has saved layouts" in the README.- README: "Testing with tenancy". Another tenant's records and saved layouts are treated like ones that do not exist (no exception or 403), with a table of what each call returns and an example test of what a tenant sees.
1.3.0 Nov 2, 2026
Fixed
- Relative date conditions read naturally in every language: the current period is one word or phrase ("today",
"this week", 「今日」, 「今天」, 「本週」, 「이번 달」) instead of "this" + "day" (「本天」), the units are plural after a
number ("in the last 3 months", 「直近 3 か月」), and the words before the number agree with the period in Spanish,
Italian and Portuguese ("en las últimas 2 semanas"). The language files have
filter.relative.*in place offilter.periods.*; if you published and changedfilter.periods, move your wording tofilter.relative. - Translations read more naturally: the Korean name of the Compact layout is a noun (「압축 형식」, it was the adverb 「간단히」), Spanish speaks to the user with tú everywhere (it mixed usted and tú), and French says « Ordre personnalisé » for a custom sort order.
1.2.0 Oct 31, 2026
Added
drillDownFormats(): a closure per drill-down column to show its value your own way (money in cents, percentages, your own date format), also for columns that are not attributes and are worked out from the record. Columns of amounts and percentages are aligned to the right.
Fixed
- Date-only columns of related models in the drill-down (
'order.order_date' => 'Order date'with adatecast on the order) were shown with a time ("12:00 AM"), and could be shown as the day before in a timezone behind UTC. The cast of the related model is now used, also through nested relationships (order.customer.signed_up_on).
1.1.1 Oct 25, 2026
Fixed
- After publishing the migrations (
php artisan vendor:publish --tag=filament-warp-pivot-migrations, as the README says for editing them),php artisan migratestopped with "table already exists": Warp Pivot ran its own copy as well. A published migration now replaces the bundled one; migrations you have not published still run as before.
1.1.0 Oct 25, 2026
Upgrading
- Run
php artisan migrateafter updating. The newupdate_warp_pivot_views_keys_to_stringsmigration turnswarp_pivot_views.owner_idandtenant_idinto text columns and keeps the saved layouts.
Added
- A "Tenancy" section in the README: a full panel example, what is kept to the current tenant, how the relationship is found, and things to know.
Changed
warp_pivot_views.owner_idandtenant_idare text columns, so users and tenants with UUID or ULID keys can save layouts (MySQL, MariaDB and PostgreSQL refused them before). Runphp artisan migrateafter updating: a new migration changes the columns of an existing table and keeps the saved layouts.PivotView::$owner_idand$tenant_idare now strings.- When the model has no relationship to the tenant, the pivot says how to fix it (name another relationship with
scopeToTenant(relationship: …), or turn the scope off) instead of failing with "Call to undefined method".
1.0.1 Oct 20, 2026
Added
- Widgets that use
InteractsWithPageFiltersare queried again when the dashboard's filters change. - When records are changed from a drill-down or a cell action, other pivots on the same page that read the same table are queried again.
Fixed
- After a record is edited in the drill-down, the list is loaded again, so columns that the model changes along with the edited one (an amount worked out from the quantity, say) show their new values.
- Pressing Esc or opening another cell while an edit was being saved left the totals and the list as they were.
- Hiding or showing a drill-down column while editing could save the value to the neighbouring column.
- Editing a date and time in the drill-down moved it by the difference between Filament's timezone and the app's. Date-only columns are now shown and saved without a timezone.
- When a model event stopped the save of a drill-down edit, the edit looked saved.
- Saved layouts now keep the display settings and the column widths, and applying one no longer leaves the previous display in place.
- "Reset" now also puts the filters back to their defaults.
- Columns grow when their values get wider after the pivot is queried again (after an edit, say), and are measured again when the web font has loaded.
- The context menu closes when the pivot is queried again, so its items no longer act on a different cell.
- The selected cells stay selected when the pivot is queried again or a header is opened from the keyboard.
- The chart's measure, the sorted column and the column widths follow their measure when values are removed or reordered.
- A saved layout that was deleted or unshared is taken out of the list when it is chosen.
1.0.0 Oct 20, 2026
Added
PivotPage,PivotWidgetandInteractsWithPivotto put a canvas-rendered pivot table on a page, on a dashboard or in any Livewire component.- Aggregation in the database with
GROUP BY:Count,CountDistinct,Sum,Avg,Min,Max,Ratioand SQL expressions, with subtotals and grand totals that are computed from the records. - Dimensions:
Column,Relationship(any depth ofbelongsTo),Date(periods and cycles in the display timezone),BinsandExpression, withlimit(),orderByValue()andformatLabelUsing(). - Headers that open on demand, expand and collapse all, sorting rows by a column, "Other" for the rest of a top N, and
maxCells(). - Values shown as shares of totals, differences from the previous column and running totals.
- A field panel to rearrange rows, columns and values, saved layouts with filters (private, shared and default), and the layout in the URL.
- Number formats, heatmaps, data bars and colors by thresholds.
- Drilling down from a cell to its records, with links to each record and to another screen.
- Searching and sorting the drill-down list (
drillDownSearchable(),drillDownSortable()), and Filament actions on its records (drillDownRecordActions()) that open on top of it and update the totals when they finish. - Excel and CSV export and printing. The CSV writes values that spreadsheets would read as formulas (
=,+,-,@) as text. - Filament table filters,
viewAnypolicies and tenancy. - Cell selection with the keyboard, copying as tab-separated text, a live count, sum and average, and an ARIA grid for screen readers.
StdDevandVariancemeasures, computed from the records for every subtotal.Formulameasures and calculated values users write in the field panel, evaluated in PHP from the aggregated values.- Pivot charts: column, stacked column, bar, stacked bar, line, area, column and line, pie, donut and scatter, with tooltips, a legend that hides series, drilling down from a mark and PNG export.
- Member filters with a searchable checklist, a filters area in the field panel, sorting headers by label or value, and the top or bottom N from the field panel or
limit(bottom: true)andorderByLabel(). - Users can change the aggregation, decimals, heatmap, data bars and conditional formatting (text or fill) of a value.
- Values shown as an index or a rank among their siblings.
- Compact, classic and flat layouts, grand totals and subtotals shown or hidden per axis, columns resized by dragging, and the display saved with layouts and in the URL.
- Context menus on headers and cells, expanding or collapsing one level, HTML export and full-screen mode.
- Conditions on dimensions: on the label (contains, begins with, between…), on a value of each header, and on dates (between two days, the last, current or next period).
MedianandProductmeasures, durations (duration()), negative numbers in parentheses, text for empty cells and divisions by zero, and custom separators.- Conditional formatting with formulas over the cell and the other values of the cell (
formatWhen()), with bold and italic, for all cells, values only or totals only. - Calculated values over the columns of each record (
recordFormulaColumns()), andand,orandnotin formulas. - The grand total row at the top (
grandTotalsPosition()), the table and the chart together, a title, value labels with their aggregation, pivots that cannot be opened and closed, and headers in the user's own order. - Choosing the columns of the drill-down and editing its cells in place (
drillDownEditable()). - PDF and PNG exports of the table, headers and footers for every export, the xlsx sheet name, exports handed to the server (
saveExportsUsing()), and layouts saved to and opened from a file. - Cell actions (
cellActions(),cellClickAction(),cellQuery()), a JavaScript API, events, and hooks to draw cells and build the context menu. - English, Japanese, German, French, Spanish, Italian, Brazilian Portuguese, Korean and Chinese (simplified and traditional) translations.