forcedotcom/sf-skills / skills/crm-analytics-wave-generate
crm-analytics-wave-generate
VerifiedUse to build a Wave Recipe, deploy a CRM Analytics dataset or dashboard, or author the full CRMA asset stack — apps, Wave Recipes (.wdpr), datasets, and dashboards — against a connected Salesforce org via REST and Metadata APIs, without CRM Analytics Studio or Dashboard Builder. TRIGGER when: user asks to build or create a Wave Recipe, generate a .wdpr or .wdpr-meta.xml, deploy a .wdash or .wapp, run a recipe or dataflowjob programmatically, upload CSV data via InsightsExternalData, validate a dataset schema with synthetic data, fetch dataset XMD, audit dashboard SAQL re-encoding, or find unused dataset fields. TRIGGER on keywords: Wave Recipe, CRMA, CRM Analytics, wdpr, wdash, wapp, WaveRecipe, Wave dataflow, dataflowjob, InsightsExternalData, SAQL, dataset XMD, Analytics Studio, R3 format, wave/recipes, wave/dashboards, or analytics on Salesforce objects (opportunities, leads, cases, accounts, sales). DO NOT TRIGGER for standard Salesforce reports or LWC components unrelated to CRM Analytics.
assets/dashboard-template.json
View on GitHub{
"dataSourceLinksInfo": {},
"gridLayouts": [{
"name": "default",
"numColumns": 24,
"pages": [{
"label": "Page 1",
"name": "Page_1",
"navigationHidden": false,
"widgets": [
{ "name": "wgt_kpi", "row": 0, "column": 6, "colspan": 18, "rowspan": 4 },
{ "name": "wgt_filter", "row": 0, "column": 0, "colspan": 6, "rowspan": 4 },
{ "name": "wgt_chart", "row": 4, "column": 0, "colspan": 24, "rowspan": 9 },
{ "name": "wgt_table", "row": 13, "column": 0, "colspan": 24, "rowspan": 9 }
]
}]
}],
"widgets": {
"wgt_filter": { "type": "listselector", "parameters": { "step": "step_filter" } },
"wgt_kpi": { "type": "number", "parameters": { "step": "step_kpi", "measureField": "{MEASURE_FIELD}" } },
"wgt_chart": { "type": "chart", "parameters": { "step": "step_chart", "visualizationType": "hbar" } },
"wgt_table": { "type": "chart", "parameters": { "step": "step_table", "visualizationType": "flatTable" } }
},
"steps": {
"step_filter": {
"type": "saql",
"query": "q = load \"{DATASET_NAME}\"; q = foreach q generate '{FILTER_FIELD}' as '{FILTER_FIELD}'; q = limit q 1000;",
"broadcastFacet": true,
"useGlobal": true,
"selectMode": "multi",
"groups": [],
"numbers": [],
"strings": []
},
"step_kpi": {
"type": "saql",
"query": "q = load \"{DATASET_NAME}\"; q = group q by all; q = foreach q generate sum('{MEASURE_FIELD}') as '{MEASURE_FIELD}';",
"broadcastFacet": true,
"useGlobal": true,
"selectMode": "single",
"groups": [],
"numbers": [],
"strings": []
},
"step_chart": {
"type": "saql",
"query": "q = load \"{DATASET_NAME}\"; q = group q by '{DIMENSION_FIELD}'; q = foreach q generate '{DIMENSION_FIELD}' as '{DIMENSION_FIELD}', sum('{MEASURE_FIELD}') as '{MEASURE_FIELD}'; q = order q by '{MEASURE_FIELD}' desc; q = limit q 20;",
"broadcastFacet": true,
"useGlobal": true,
"selectMode": "single",
"groups": [],
"numbers": [],
"strings": []
},
"step_table": {
"type": "saql",
"query": "q = load \"{DATASET_NAME}\"; q = group q by '{DIMENSION_FIELD}'; q = foreach q generate '{DIMENSION_FIELD}' as '{DIMENSION_FIELD}', sum('{MEASURE_FIELD}') as '{MEASURE_FIELD}'; q = order q by '{MEASURE_FIELD}' desc; q = limit q 100;",
"broadcastFacet": true,
"useGlobal": true,
"selectMode": "single",
"groups": [],
"numbers": [],
"strings": []
}
}
}
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| rea-analysis-optimizationmorluto/reaOptimize REA providers and shared analysis workflows for agent context, latency, CPU, and memory while preserving correctness and Evidence. Use for analysis bottlenecks and cache or query design; CI/test-suite optimization belongs to rea-ci-tests-audit. | Stars: 472k | Updated | Claude CodeCodex | Verified | Install |
| rea-ci-tests-auditmorluto/reaAudit REA CI and test suites for correctness, fixture drift, false passes, and measured performance; use for suite or workflow investigations and efficiency changes, rather than ordinary feature testing or a single test failure. | Stars: 472k | Updated | Claude CodeCodex | Verified | Install |
| rea-tool-designmorluto/reaAudit, investigate, design, or change REA investigation tools, CLI/MCP contracts, provider capabilities, and Evidence semantics. | Stars: 472k | Updated | Claude CodeCodex | Verified | Install |
| ponytail-auditDietrichGebert/ponytailQuality audit of the whole repo: bugs, security, real load, missing tests, speed, and what to delete. Most important first. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |