Visual Meta Data

Visual-JSON-Data.json

//visualMetaData
{
  "schemaName":"ecommerce",
  "tableName":"ecommerce",
  "selectFields":[
    {"column":"metro_region","aggregator":null},
    {"column":"sessions","aggregator":"SUM"},
    {"column":"transactions","aggregator":"SUM"},
    {"column":"transaction_revenue","aggregator":"SUM"},
    {"column":"datehour","aggregator":null}
  ],
  "groupBy":["metro_region","datehour"],
  "orderBy":[
    {"column":"sessions","order":false}
  ],
  "filters":[
    {"column":"sessions","connect":null,"operator":">=","value":"10"},
    {"column":"transactions","connect":"or","operator":">","value":"5"}
  ]
}
//visualQualifierMetadata
{
  "filters":[
    {
      "column":"transactions",
      "connect":null,
      "operator":"<",
      "comparisonAggregator":"SUM",
      "comparisonPeriod":"past 7 days"
    }
  ],
  "period":{
    "column":"datehour",
    "operator":"PERIODOP",
    "value":"is yesterday"
  }
}