Turn any entity into an interactive pivot table. Drag dimensions onto rows and columns, pick a measure and aggregation, then chart it and drill down to the underlying records.
| Owner | Negotiation | Won | Total |
|---|---|---|---|
| A. Morgan | 316K | 412K | 728K |
| R. Collins | 262K | 305K | 567K |
| S. Bennett | 188K | 246K | 434K |
| D. Foster | 141K | 190K | 331K |
| Total | 907K | 1.15M | 2.06M |
Slice & Dice reads straight from your entities. There's no export, no separate BI tool, no modeling step — point it at any data set and explore.
Drag dimensions onto Rows and Columns. Each unique value becomes a row or column header; cells fill with the aggregated measure and totals are computed automatically.
Replace Region with Owner or Stage, switch the measure from Value to Count, or change the aggregation from Sum to Average — the grid recomputes instantly.
Flip the same pivot into a bar, line, pie or stacked column chart. Dimensions become axes and series; measures become the values plotted.
Click any cell or bar to expand the exact records behind that number — open a deal, a ticket or an order without leaving the analysis.
Pin the pivot or chart to any dashboard as a reusable widget. Compose several widgets into an executive view, share it through the page viewer, and it refreshes live as records change.
Pick the aggregation per measure. The same Deal Value field can be summed for pipeline, averaged for deal size, or counted for volume — all in the same pivot.
How many records fall in each cell — deals, tickets, orders.
Total a numeric or currency field — total pipeline, revenue, hours.
Average value per group — average deal size or resolution time.
Smallest value in the group — earliest date, lowest amount.
Largest value in the group — biggest deal, latest activity.
Compare values across a dimension.
Trend a measure over time.
Show composition of a whole.
Break each bar by a second dimension.
Slice & Dice keeps the table and the chart in sync. Toggle between views to read exact figures or spot the shape of the data — rows and columns map straight onto axes and series.
Every saved query lives in one place with a name, language and usage count. A saved query isn't a dead end — it's a live data source you can pivot in Slice & Dice, bind to a page, return from a function or hand to an AI agent as a tool.
Pivots, drill-downs and hand-written queries all run inside Processo's permission model. Analysis can be flexible without ever bypassing who's allowed to see what.
Results honour the data-level (row) and field-level access mapped in the Authorization Matrix — a user only ever sees rows their hierarchy permits.
Fields flagged PII or ePHI stay protected. Sensitive columns are masked or withheld for users without clearance — even inside an ad-hoc query.
Queries and pivots are scoped to their process and organization. In a multi-tenant setup, one tenant's analysis can never reach another's data.
Save any pivot, chart or query result as a widget, then drop several onto a dashboard. Resize, arrange and share through the page viewer — every widget refreshes live as records flow through your process.
Because Slice & Dice reads any entity, the questions change but the workflow doesn't.
Owner × Stage with Sum of Value — see where revenue is concentrated and which reps have stalled deals, then drill into the ones to chase.
Priority × Week with Avg of Resolution Time — spot which priorities are slipping SLA and drill into the slowest tickets.
Product Category × Month with Count and Sum of Total — track volume against revenue and find the SKUs driving growth.
Slice & Dice sits on top of your data model and feeds your apps. It pairs naturally with the rest of the platform.
Hand a saved query to an agent as a tool for natural-language answers.
Explore →Drop pivots and charts as widgets onto any dashboard.
Explore →The entities and records every pivot reads from.
Explore →Dimensions and measures come from your fields.
Explore →