Calculates and visualizes inclusion and exclusion counts and metrics across all combinations of user supplied dataSets simultaneously
| Key | Value(s) | Description |
|---|---|---|
| method | "Overlap" | Calculates and visualizes inclusion and exclusion counts and metrics across all combinations of user supplied dataSets simultaneously |
| asTable | "TableName" | outputs results to a datajet table |
| countMode | "countMode" | 0 = default 1 = Percent Only 2 = |
| dataSet{} | Optional Base Filter | |
| dataSets[] | Input datasets | |
| enabled[] | dataset is included in the calculation | |
| forEach{} | When Iterator is selected the forEach method will be activated | |
| hideEmptySetRow | remove 00000 row | |
| index | true/false | include index, base target columns |
| names[] | List of Dataset display names | |
| saveAsModel | "ModelName" | Optional. Name of model same as saveAs. Saves output to Data table Viewer list |
| saveAs | "ModelName" | Optional. Name of model same as saveAsModel Saves output to Data table Viewer list |
| secondaryProcess{} | supported | |
| sortMode | "sortMode" | 0 = hits 1 = count 2 = default |
| workbook | "WorkbookName" | outputs to excel workbook |
{
"method": "Overlap",
"project": "BENCH_nyc_taxi",
"asTable": "TestTable"
"upset": true,
"dataSet": {
"logic": "or",
"name": "PU_Borough_Brooklyn",
"strict": true,
"set": [
{
"logic": "and",
"stype": "FIELD",
"entity": {
"type": "field",
"name": "fhvhv.PU_Borough",
"table": "fhvhv",
"valueFilter": []
},
"op": "=",
"values": [
"Brooklyn"
]
}
]
},
"dataSets": [
{
"logic": "or",
"name": "IS_AIRPORT_TRIP",
"strict": true,
"set": [
{
"logic": "or",
"stype": "FIELD",
"entity": {
"type": "field",
"name": "fhvhv.IS_AIRPORT_TRIP",
"table": "fhvhv",
"valueFilter": []
},
"op": "=",
"values": [
"1"
]
}
],
"NodeType": "DataSet"
},
{
"logic": "or",
"name": "IS_FROM_AIRPORT",
"strict": true,
"set": [
{
"logic": "or",
"stype": "FIELD",
"entity": {
"type": "field",
"name": "fhvhv.IS_FROM_AIRPORT",
"table": "fhvhv",
"valueFilter": []
},
"op": "=",
"values": [
"1"
]
}
],
"NodeType": "DataSet"
},
{
"logic": "or",
"name": "IS_LONG_TRIP",
"strict": true,
"set": [
{
"logic": "or",
"stype": "FIELD",
"entity": {
"type": "field",
"name": "fhvhv.IS_LONG_TRIP",
"table": "fhvhv",
"valueFilter": []
},
"op": "=",
"values": [
"1"
]
}
],
"NodeType": "DataSet"
},
{
"logic": "or",
"name": "IS_TO_AIRPORT",
"strict": true,
"set": [
{
"logic": "or",
"stype": "FIELD",
"entity": {
"type": "field",
"name": "fhvhv.IS_TO_AIRPORT",
"table": "fhvhv",
"valueFilter": []
},
"op": "=",
"values": [
"1"
]
}
],
"NodeType": "DataSet"
},
{
"logic": "or",
"name": "IS_MORNING_RUSH",
"strict": true,
"set": [
{
"logic": "or",
"stype": "FIELD",
"entity": {
"type": "field",
"name": "fhvhv.IS_MORNING_RUSH",
"table": "fhvhv",
"valueFilter": []
},
"op": "=",
"values": [
"1"
]
}
],
"NodeType": "DataSet"
},
{
"logic": "or",
"name": "IS_EVENING_RUSH",
"strict": true,
"set": [
{
"logic": "or",
"stype": "FIELD",
"entity": {
"type": "field",
"name": "fhvhv.IS_EVENING_RUSH",
"table": "fhvhv",
"valueFilter": []
},
"op": "=",
"values": [
"1"
]
}
],
"NodeType": "DataSet"
},
{
"logic": "or",
"name": "IS_RUSH_HOUR",
"strict": true,
"set": [
{
"logic": "or",
"stype": "FIELD",
"entity": {
"type": "field",
"name": "fhvhv.IS_RUSH_HOUR",
"table": "fhvhv",
"valueFilter": []
},
"op": "=",
"values": [
"1"
]
}
],
"NodeType": "DataSet"
}
],
"names": [
"IS_AIRPORT_TRIP",
"IS_FROM_AIRPORT",
"IS_LONG_TRIP",
"IS_TO_AIRPORT",
"IS_MORNING_RUSH",
"IS_EVENING_RUSH",
"IS_RUSH_HOUR"
],
"enabled": [
true,
true,
true,
true,
true,
true,
true
],
"sortMode": 1,
"countMode": 0,
"index": true,
"upsetConfig": {},
"hideEmptySetRow": false
}