Get Familiar with Dashboard JSON Changes for Wave Designer

The dashboard JSON contains new parameters that impact users who create the JSON from scratch.
JSON Parameter Description
mode
Required. Indicates the method used to determine the column size for a table widget. Valid values are:
  • variable—If you specify this mode, you must also specify minColumnWidth and maxColumnWidth.
  • fixed—If you specify this mode, you must also specify fixedColumnWidth.
  • fittocontainer

For more information, see Show Totals and Maximize the Display in Tables.

Sample JSON:
"steps": {
  "lens_1": {                
    "type": "grain",
    "visualizationParameters": {                    
      "options": {},
      "type": "table",                    
      "parameters": {
        "customBulkActions": [],                        
        "mode": "variable",
        "minColumnWidth": 40,                        
        "maxColumnWidth": 300,
        "totals": true                    
      }                
    }        
  }
},
"widgets": {            
  "table_1": {                
    "type": "table",
    "parameters": {                    
      "customBulkActions": [],
      "mode": "fittocontainer",                    
      "exploreLink": true,
      "totals": true,                    
      "step": "lens_1"                
    }
  }        
},
visualizationParameters

Optional. (For saql step type only.) Contains chart properties defined in the step. When you associate the step with a widget, the widget chart properties override these settings.

JSON sample:
"steps": {
  "lens_1": {
    "type": "saql",
    "isFacet": true,
    "useGlobal": true,
    "numbers": [],
    "groups": [],
    "strings": [],
    "query": "q = load \"Opp_Icons\";\nq = group q by 'Forecast_Category';\nq = foreach q generate 'Forecast_Category' as 'Forecast_Category', sum('Amount') as 'Total Amount';\nq = order q by 'Forecast_Category' asc;\nq = limit q 10000;",
    "visualizationParameters": {
      "type": "chart",
      "parameters": {
        "visualizationType": "vbar",
        "autoFitMode": "none",
        "title": {
          "label": "",
          "subtitleLabel": "",
          "align": "center"
        },
        "theme": "wave",
        "showValues": true,
        "axisMode": "multi",
        "binValues": false,
        "bins": {
          "breakpoints": {
            "low": 0,
            "high": 100
          },
          "bands": {
            "low": {
              "label": "",
              "color": "#B22222"
            },
             "medium": {
              "label": "",
              "color": "#ffa500"
            },
            "high": {
              "label": "",
              "color": "#008000"
            }
          }
        },
        "dimensionAxis": {
          "showAxis": true,
          "showTitle": true,
          "title": "",
          "customSize": "auto",
          "icons": {
            "useIcons": false,
            "iconProps": {
              "column": "",
              "fit": "cover",
              "type": "round"
            }
          }
        },
        "measureAxis1": {
          "sqrtScale": false,
          "showAxis": true,
          "customDomain": {
            "showDomain": false,
            "low": null,
            "high": null
          },
          "showTitle": true,
          "title": "",
          "referenceLine": null
        },
        "measureAxis2": {
          "sqrtScale": false,
          "showAxis": true,
          "customDomain": {
            "showDomain": false,
            "low": null,
            "high": null
          },
          "showTitle": true,
          "title": "",
          "referenceLine": null
        },
        "legend": {
          "show": true,
          "showHeader": true,
          "inside": false,
          "position": "right-top",
          "customSize": "auto"
        },
        "trellis": {
          "enable": false,
          "showGridLines": true,
          "flipLabels": false,
          "type": "x",
          "chartsPerLine": 4
        }
      }
    } 
  }
},