311_test.json

{
  "version": "2",
  "header": {
    "title": "NYC 311 Data",
    "description": "The last 3 million NYC 311 complaints",
    "navigation": [
      {
        "label": "Download",
        "url": ""
      }
    ]
  },
  "cards": [
  
    {
      "x": 0,
      "y": 2,
      "width": 12,
      "height": 5,
      "vizwit": {
        "title": "Created Date",
        "description": "Date the complaint was created",
        "chartType": "datetime",
        "user":"cwhong",
        "sql":"SELECT count(*) as value,date_trunc('month', created_date) as label FROM union_311 GROUP BY date_trunc('month', created_date) ORDER BY date_trunc('month', created_date)",
        "triggerField": "created_date"
      }
    },{
      "x": 0,
      "y": 0,
      "width": 6,
      "height": 2,
      "vizwit": {
        "title": "Complaints in the last 30 days",
        "chartType": "callout",
        "user": "cwhong",
        "sql": "SELECT count(*) as value FROM union_311 WHERE created_date > current_date - interval '10' day",
        "valueFormat": "0,0",
        "labelFormat": "[Calendar year] YYYY"
      }
    }
  ]
}