{
  "columnsSelection": {
    "mode": "ALL"
  },
  "explorationSampling": {
    "_refreshTrigger": 0,
    "selection": {
      "filter": {
        "distinct": false,
        "enabled": false
      },
      "latestPartitionsN": 1,
      "maxRecords": 10000,
      "ordering": {
        "rules": [],
        "enabled": false
      },
      "withinFirstN": -1,
      "partitionSelectionMethod": "ALL",
      "maxStoredBytes": 104857600,
      "targetRatio": 0.02,
      "maxReadUncompressedBytes": -1,
      "samplingMethod": "HEAD_SEQUENTIAL",
      "timeout": -1
    },
    "autoRefreshSample": false
  },
  "explorationFilters": [],
  "origin": "PREPARE_RECIPE",
  "exploreUIParams": {
    "autoRefresh": true
  },
  "steps": [
    {
      "preview": false,
      "mainColor": "#ff9c00",
      "name": "Date formatting",
      "metaType": "GROUP",
      "disabled": false,
      "comment": "Parse dates, extract date components from purchase_date, and compute days_active.",
      "steps": [
        {
          "preview": false,
          "metaType": "PROCESSOR",
          "disabled": false,
          "type": "DateParser",
          "params": {
            "outCol": "",
            "formats": [
              "yyyy-MM"
            ],
            "columns": [
              "card_first_active_month"
            ],
            "timezone_id": "UTC",
            "appliesTo": "SINGLE_COLUMN",
            "lang": "auto"
          },
          "alwaysShowComment": false
        },
        {
          "preview": false,
          "metaType": "PROCESSOR",
          "disabled": false,
          "type": "DateParser",
          "params": {
            "outCol": "",
            "formats": [
              "yyyy-MM-dd HH:mm:ss"
            ],
            "columns": [
              "purchase_date"
            ],
            "timezone_id": "UTC",
            "appliesTo": "SINGLE_COLUMN",
            "lang": "auto"
          },
          "alwaysShowComment": false
        },
        {
          "preview": false,
          "metaType": "PROCESSOR",
          "disabled": false,
          "type": "DateComponentsExtractor",
          "params": {
            "outMonthColumn": "purchase_month",
            "outHourColumn": "purchase_hour",
            "outYearColumn": "purchase_year",
            "column": "purchase_date",
            "outDayOfWeekColumn": "purchase_dow",
            "timezone_id": "UTC",
            "outDayColumn": "purchase_day"
          },
          "alwaysShowComment": false
        },
        {
          "preview": false,
          "metaType": "PROCESSOR",
          "disabled": false,
          "type": "DateDifference",
          "params": {
            "output": "days_active",
            "input2": "purchase_date",
            "outputUnit": "DAYS",
            "input1": "card_first_active_month",
            "compareTo": "COLUMN",
            "reverse": false
          },
          "alwaysShowComment": false
        },
        {
          "preview": false,
          "metaType": "PROCESSOR",
          "disabled": false,
          "type": "FilterOnNumericalRange",
          "params": {
            "min": 0.0,
            "booleanMode": "AND",
            "columns": [
              "days_active"
            ],
            "action": "KEEP_ROW",
            "appliesTo": "SINGLE_COLUMN"
          },
          "alwaysShowComment": false
        },
        {
          "preview": false,
          "metaType": "PROCESSOR",
          "disabled": false,
          "type": "ColumnsSelector",
          "params": {
            "columns": [
              "purchase_month",
              "purchase_day",
              "purchase_dow",
              "purchase_hour"
            ],
            "keep": false,
            "appliesTo": "COLUMNS"
          },
          "alwaysShowComment": false
        }
      ],
      "alwaysShowComment": true,
      "secondaryColor": "#f4e0c1"
    }
  ],
  "maxProcessedMemTableBytes": -1,
  "previewMode": "ALL_ROWS",
  "vizSampling": {
    "_refreshTrigger": 0,
    "selection": {
      "useMemTable": false,
      "filter": {
        "distinct": false,
        "enabled": false
      },
      "latestPartitionsN": 1,
      "maxRecords": -1,
      "ordering": {
        "rules": [],
        "enabled": false
      },
      "withinFirstN": -1,
      "partitionSelectionMethod": "ALL",
      "targetRatio": 0.02,
      "maxReadUncompressedBytes": -1,
      "samplingMethod": "FULL"
    },
    "autoRefreshSample": false
  },
  "analysisColumnData": {},
  "columnWidthsByName": {
    "merchant_latitude": 143,
    "purchase_date_parsed_day": 195,
    "purchase_day": 105,
    "card_fico_score": 128,
    "purchase_month": 120,
    "merchant_id": 127,
    "card_longitude": 120,
    "item_category": 113,
    "merchant_state_enName": 173,
    "purchase_date_parsed": 190,
    "card_state": 120,
    "card_state_enName": 143,
    "signature_provided": 150,
    "card_age": 100,
    "purchase_dow": 105,
    "merchant_cardholder_distance": 225,
    "card_first_active_month_parsed": 260,
    "transaction_id": 120,
    "purchase_year": 113,
    "purchase_weekend": 135,
    "card_first_active_month": 188,
    "days_active": 100,
    "card_latitude": 113,
    "merchant_location": 169,
    "merchant_category_id": 165,
    "card_id": 120,
    "merchant_subsector_description": 240,
    "merchant_longitude": 150,
    "purchase_date_parsed_year": 203,
    "purchase_hour": 113,
    "card_location": 113,
    "purchase_amount": 128,
    "card_reward_program": 158,
    "purchase_date_parsed_month": 210,
    "merchant_state": 120,
    "purchase_date": 148,
    "authorized_flag": 128
  },
  "sorting": [
    {
      "column": "days_active",
      "ascending": true
    }
  ],
  "globalSearchQuery": "",
  "coloring": {
    "scheme": "MEANING_AND_STATUS",
    "individualColumns": [],
    "valueColoringMode": "HASH"
  }
}