Generate pivot tables and charts from raw data using natural language - analyze sales by region, summarize data by category, and create visualizations effortlessly. Activates when you request "excel pivot wizard" functionality.
Creates advanced pivot tables with calculated fields, slicers, and dynamic dashboards for data analysis and reporting.
| Error | Cause | Solution | |-------|-------|----------| | Field not found | Changed source data | Refresh data connection | | Calculated field error | Invalid formula | Check field names match exactly | | Slicer not updating | Disconnected report | Reconnect slicer to pivot |
Example: Sales Dashboard Request: "Create a pivot summarizing sales by region and product" Result: Pivot with region rows, product columns, revenue values, and date slicer
Example: Financial Analysis Request: "Build a pivot showing monthly trends by cost center" Result: Time-series pivot with calculated YoY growth fields
${CLAUDE_SKILL_DIR}/references/pivot-formulas.md for calculated field syntax下载完整 Skill 目录,包含 SKILL.md 及所有相关文件
Google Workspace CLI for Gmail, Calendar, Drive, Contacts, Sheets, and Docs.
Manage Apple Notes via the `memo` CLI on macOS (create, view, edit, delete, search, move, and export notes). Use when a user asks OpenClaw to add a note, list notes, search notes, or manage note folders.
Work with Obsidian vaults (plain Markdown notes) and automate via obsidian-cli.
Use when you need to control Slack from OpenClaw via the slack tool, including reacting to messages or pinning/unpinning items in Slack channels or DMs.
Manage Apple Reminders via remindctl CLI (list, add, edit, complete, delete). Supports lists, date filters, and JSON/plain output.
Manage Trello boards, lists, and cards via the Trello REST API.
Category:productivity