Skip to content

forcedotcom/sf-skills / skills/crm-analytics-wave-generate

crm-analytics-wave-generate

Verified

Use 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": []
        }
    }
}
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: 472kUpdated Claude CodeCodexVerifiedInstall
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: 472kUpdated Claude CodeCodexVerifiedInstall
rea-tool-designmorluto/reaAudit, investigate, design, or change REA investigation tools, CLI/MCP contracts, provider capabilities, and Evidence semantics.Stars: 472kUpdated Claude CodeCodexVerifiedInstall
ponytail-auditDietrichGebert/ponytailQuality audit of the whole repo: bugs, security, real load, missing tests, speed, and what to delete. Most important first.Stars: 194kUpdated Claude CodeCodexVerifiedInstall