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.
examples/opportunity-revenue-recipe.wdpr
View on GitHub{
"runMode": "full",
"nodes": {
"LOAD_OPPORTUNITY": {
"action": "load",
"sources": [],
"parameters": {
"dataset": {
"type": "connectedDataset",
"label": "Opportunity",
"connectionName": "SFDC_LOCAL",
"sourceObjectName": "Opportunity"
},
"fields": ["Id", "AccountId", "StageName", "CloseDate", "Amount"],
"mode": "SYNCED",
"preserveCurrencyFields": [],
"sampleDetails": { "type": "TopN", "sortBy": [] }
}
},
"LOAD_ACCOUNT": {
"action": "load",
"sources": [],
"parameters": {
"dataset": {
"type": "connectedDataset",
"label": "Account",
"connectionName": "SFDC_LOCAL",
"sourceObjectName": "Account"
},
"fields": ["Id", "Name", "Industry"],
"mode": "SYNCED",
"preserveCurrencyFields": [],
"sampleDetails": { "type": "TopN", "sortBy": [] }
}
},
"FILTER_CLOSED_WON": {
"action": "filter",
"sources": ["LOAD_OPPORTUNITY"],
"parameters": {
"filterExpressions": [
{ "field": "StageName", "operator": "EQUAL", "operands": ["Closed Won"], "type": "TEXT" }
]
}
},
"JOIN_ACCOUNT": {
"action": "join",
"sources": ["FILTER_CLOSED_WON", "LOAD_ACCOUNT"],
"parameters": {
"joinType": "LOOKUP",
"leftKeys": ["AccountId"],
"rightKeys": ["Id"],
"rightQualifier": "Account"
}
},
"COMPUTE_CLOSE_YEAR": {
"action": "formula",
"sources": ["JOIN_ACCOUNT"],
"parameters": {
"expressionType": "SQL",
"fields": [{ "name": "CloseYear", "label": "Close Year", "type": "TEXT", "formulaExpression": "date_format(CloseDate, 'yyyy')" }]
}
},
"COMPUTE_CLOSE_MONTH": {
"action": "formula",
"sources": ["COMPUTE_CLOSE_YEAR"],
"parameters": {
"expressionType": "SQL",
"fields": [{ "name": "CloseMonth", "label": "Close Month", "type": "TEXT", "formulaExpression": "date_format(CloseDate, 'MM/yyyy')" }]
}
},
"EXTRACT0": {
"action": "extractGrains",
"sources": ["COMPUTE_CLOSE_MONTH"],
"parameters": { "grainExtractions": [] }
},
"AGGREGATE_BY_ACCOUNT_MONTH": {
"action": "aggregate",
"sources": ["EXTRACT0"],
"parameters": {
"aggregations": [{ "name": "TotalRevenue", "label": "Total Revenue", "action": "SUM", "source": "Amount" }],
"groupings": ["AccountId", "Account.Name", "Account.Industry", "CloseYear", "CloseMonth"],
"nodeType": "STANDARD",
"pivots": []
}
},
"OUTPUT_DTS_OPW": {
"action": "save",
"sources": ["AGGREGATE_BY_ACCOUNT_MONTH"],
"parameters": {
"dataset": {
"type": "analyticsDataset",
"label": "DTS_OpportunityRev",
"name": "DTS_OpportunityRev",
"folderName": "OpportunityInsights"
},
"fields": [],
"measuresToCurrencies": []
}
}
},
"ui": {
"nodes": {
"LOAD_OPPORTUNITY": { "label": "Opportunity", "type": "LOAD_DATASET", "top": 112, "left": 112, "parameters": { "sampleSize": 2000 } },
"LOAD_ACCOUNT": { "label": "Account", "type": "LOAD_DATASET", "top": 252, "left": 252, "parameters": { "sampleSize": 2000 } },
"FILTER_CLOSED_WON": { "label": "FILTER_CLOSED_WON", "type": "FILTER", "top": 112, "left": 252 },
"JOIN_ACCOUNT": { "label": "JOIN_ACCOUNT", "type": "JOIN", "top": 112, "left": 392 },
"TRANSFORM0": {
"label": "TRANSFORM0", "type": "TRANSFORM", "top": 112, "left": 532,
"graph": {
"COMPUTE_CLOSE_YEAR": { "parameters": { "type": "BASE_FORMULA_UI" } },
"COMPUTE_CLOSE_MONTH": { "parameters": { "type": "BASE_FORMULA_UI" } }
},
"connectors": [{ "source": "COMPUTE_CLOSE_YEAR", "target": "COMPUTE_CLOSE_MONTH" }]
},
"AGGREGATE0": {
"label": "AGGREGATE0", "type": "AGGREGATE", "top": 112, "left": 672,
"graph": { "EXTRACT0": null, "AGGREGATE_BY_ACCOUNT_MONTH": null },
"connectors": [{ "source": "EXTRACT0", "target": "AGGREGATE_BY_ACCOUNT_MONTH" }]
},
"OUTPUT_DTS_OPW": { "label": "OUTPUT_DTS_OPW", "type": "OUTPUT", "top": 112, "left": 812 }
},
"connectors": [
{ "source": "LOAD_OPPORTUNITY", "target": "FILTER_CLOSED_WON" },
{ "source": "FILTER_CLOSED_WON", "target": "JOIN_ACCOUNT" },
{ "source": "LOAD_ACCOUNT", "target": "JOIN_ACCOUNT" },
{ "source": "JOIN_ACCOUNT", "target": "TRANSFORM0" },
{ "source": "TRANSFORM0", "target": "AGGREGATE0" },
{ "source": "AGGREGATE0", "target": "OUTPUT_DTS_OPW" }
],
"hiddenColumns": []
}
}
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 |