Explore the API
Filters and drill-down
Filter by region or sales dates, drill a chart from Region to Product, then return to the root. Worksheet values remain unchanged.
Try this workflowExplore and compare
Change the inputs, run an action, and inspect the live result below.
ResultLive API output
North totals 680. Query results and current filter definitions are shown after each action.
Preparing sample...
Keep exploringReset or save
Reset restores this sample's starting document. TXWB retains its spreadsheet, dashboard, and reporting definitions.
Ready to tryUse the controls above to interact with this demo.
What this demonstrates
Filters and drill-down
Shared analytics filters narrow dashboard queries. A chart's drillDown hierarchy advances when a mark is selected. Resetting filters or drilling to level zero clears the appropriate context.
APIs used
Dashboard.setFilters()
Dashboard.selectMark()
Dashboard.drillTo()
Dashboard.query()
How to explore
Filter by region or sales dates, drill a chart from Region to Product, then return to the root. Worksheet values remain unchanged.
North totals 680. Query results and current filter definitions are shown after each action.
Document ownership
The ready event supplies the initialized editor. Each action resolves document objects from the current workbook. Reset loads a clean TXWB snapshot; worksheet, range, chart, and dashboard handles must be acquired again after loading.
The Code panel shows this sample's actual implementation and the shared hosting code. Downloads contain the current document; changes are not stored on the server.
NuGet packages
TXTextControl.TXSheetControl.AspNetCore
2.0.0-beta.1
Provides the Razor spreadsheet editor, browser APIs, and packaged fonts.
dotnet add package TXTextControl.TXSheetControl.AspNetCore --version 2.0.0-beta.1
