Skip to content

Instantly share code, notes, and snippets.

@ninapavlich
Created March 18, 2020 00:22
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ninapavlich/ebe40002d9a5f6b96c01a6e9412f8ad9 to your computer and use it in GitHub Desktop.
Save ninapavlich/ebe40002d9a5f6b96c01a6e9412f8ad9 to your computer and use it in GitHub Desktop.
Example Arizona ADHS Coronavirus Tableau Data
{
"secondaryInfo": {
"presModelMap": {
"dataDictionary": {
"presModelHolder": {
"genDataDictionaryPresModel": {
"dataSegments": {
"0": {
"dataColumns": [
{
"dataType": "integer",
"dataValues": [
0,
5,
4,
1,
9,
20,
12,
8,
221,
142,
66
]
},
{
"dataType": "real",
"dataValues": [
32.7539,
34.7064,
31.5332,
32.9849,
31.9681,
35.3134,
35.6177,
33.2798,
33.6724,
33.1001,
33.0361,
33.7446,
35.6465,
31.8901,
35.3025,
-113.9364,
-112.4429,
-110.812,
-111.4931,
-111.7806,
-110.2972,
-113.9958,
-112.7681,
-113.9329,
-109.2714,
-109.958,
-110.685,
-112.0424,
-109.7497,
-109.4451
]
},
{
"dataType": "cstring",
"dataValues": [
"Yuma",
"Yavapai",
"Santa Cruz",
"Pinal",
"Pima",
"Navajo",
"Mohave",
"Maricopa",
"La Paz",
"Greenlee",
"Graham",
"Gila",
"Coconino",
"Cochise",
"Apache",
"32.754",
"34.706",
"31.533",
"32.985",
"31.968",
"35.313",
"35.618",
"33.280",
"33.672",
"33.100",
"33.036",
"33.745",
"35.647",
"31.890",
"35.303",
"-113.936",
"-112.443",
"-110.812",
"-111.493",
"-111.781",
"-110.297",
"-113.996",
"-112.768",
"-113.933",
"-109.271",
"-109.958",
"-110.685",
"-112.042",
"-109.750",
"-109.445",
"Total Deaths",
"Total Cases",
"Arizona State Public Health Laboratory",
"Private Laboratory",
"Number of People Tested",
"Number of Ruled-Out",
"Number of Pending",
"Number of Positive",
"Low with some areas of heightened risk",
"Minimal",
"3/17/2020"
]
}
]
}
}
}
}
},
"vizData": {
"presModelHolder": {
"genPresModelMapPresModel": {
"presModelMap": {
"Cases": {
"presModelHolder": {
"genVizDataPresModel": {
"vizColumns": [],
"paneColumnsData": {
"vizDataColumns": [
{
"fn": "[system:visual].[tuple_id]",
"fnDisagg": "",
"formatStrings": [],
"isAutoSelect": false,
"paneIndices": [
0
],
"columnIndices": [
0
]
},
{
"fn": "[federated.0bibgdn1mu8r11118qrjp194z8uj].[none:F1:nk]",
"fnDisagg": "",
"localBaseColumnName": "[F1]",
"baseColumnName": "[federated.0bibgdn1mu8r11118qrjp194z8uj].[F1]",
"fieldCaption": "Category",
"formatStrings": [],
"datasourceCaption": "federated.0bibgdn1mu8r11118qrjp194z8uj",
"dataType": "cstring",
"stringCollation": {
"name": "LEN_RUS_S2",
"charsetId": 0
},
"fieldRole": "dimension",
"isAutoSelect": true,
"paneIndices": [
0
],
"columnIndices": [
1
]
},
{
"fn": "[federated.0bibgdn1mu8r11118qrjp194z8uj].[sum:Positive:qk]",
"fnDisagg": "",
"localBaseColumnName": "[Positive]",
"baseColumnName": "[federated.0bibgdn1mu8r11118qrjp194z8uj].[Positive]",
"fieldCaption": "SUM(Positive)",
"formatStrings": [
"",
"-1",
"t",
"",
"",
"",
"0",
".",
",",
"3;0"
],
"datasourceCaption": "federated.0bibgdn1mu8r11118qrjp194z8uj",
"dataType": "integer",
"aggregation": "sum",
"fieldRole": "measure",
"isAutoSelect": false,
"paneIndices": [
0
],
"columnIndices": [
2
]
}
],
"paneColumnsList": [
{
"paneDescriptor": {
"paneDescrKey": "d57d9225e111769",
"xFields": [],
"yFields": [
"[federated.0bibgdn1mu8r11118qrjp194z8uj].[none:F1:nk]"
],
"xIndex": 0,
"yIndex": 0
},
"vizPaneColumns": [
{
"tupleIds": [
1,
2,
3,
4
],
"valueIndices": [],
"aliasIndices": [],
"formatstrIndices": []
},
{
"tupleIds": [],
"valueIndices": [
45,
46,
47,
48
],
"aliasIndices": [
45,
46,
47,
48
],
"formatstrIndices": [
-1,
-1,
-1,
-1
]
},
{
"tupleIds": [],
"valueIndices": [],
"aliasIndices": [
0,
5,
6,
7
],
"formatstrIndices": [
-1,
-1,
-1,
-1
]
}
]
}
]
},
"highlightCaptions": [],
"filterFields": [],
"ubertipData": {
"ubertipPaneDatas": [
{
"htmlTooltip": "<span style=\"white-space:pre-wrap;tab-size:10;-moz-tab-size:10\"><table style=\"vertical-align:top;padding:0px\" cellspacing=\"0\"><tr><td style=\"white-space:pre\"><span style=\"font-family:'Tableau Book';font-size:13px;color:#787878;font-weight:normal;font-style:normal;text-decoration:none;\">Category:</span></td><td>&nbsp;</td><td><span style=\"font-family:'Tableau Book';font-size:13px;color:#333333;font-weight:bold;font-style:normal;text-decoration:none;\">&lt;[federated.0bibgdn1mu8r11118qrjp194z8uj].[none:F1:nk]&gt;</span></td></tr><tr><td style=\"white-space:pre\"><span style=\"font-family:'Tableau Book';font-size:13px;color:#787878;font-weight:normal;font-style:normal;text-decoration:none;\">Positive Cases:</span></td><td>&nbsp;</td><td><span style=\"font-family:'Tableau Book';font-size:13px;color:#333333;font-weight:bold;font-style:normal;text-decoration:none;\">&lt;[federated.0bibgdn1mu8r11118qrjp194z8uj].[sum:Positive:qk]&gt;</span></td></tr></table></span>",
"showButtons": false,
"summaryField": "SUM(Positive)",
"fieldVector": [],
"htmlTooltipModified": ""
}
],
"fn": ""
},
"reflineFields": [],
"refLineTips": []
}
}
},
"County Map": {
"presModelHolder": {
"genVizDataPresModel": {
"vizColumns": [],
"paneColumnsData": {
"vizDataColumns": [
{
"fn": "[system:visual].[tuple_id]",
"fnDisagg": "",
"formatStrings": [],
"isAutoSelect": false,
"paneIndices": [
0
],
"columnIndices": [
0
]
},
{
"fn": "[federated.1uxrrkh1vgr43b172nibp09csq7l].[none:County:nk]",
"fnDisagg": "",
"localBaseColumnName": "[County]",
"baseColumnName": "[federated.1uxrrkh1vgr43b172nibp09csq7l].[County]",
"fieldCaption": "County",
"formatStrings": [],
"datasourceCaption": "federated.1uxrrkh1vgr43b172nibp09csq7l",
"dataType": "cstring",
"stringCollation": {
"name": "LEN_RUS_S2",
"charsetId": 0
},
"fieldRole": "dimension",
"isAutoSelect": true,
"paneIndices": [
0
],
"columnIndices": [
1
]
},
{
"fn": "[federated.1uxrrkh1vgr43b172nibp09csq7l].[sum:Count:qk]",
"fnDisagg": "",
"localBaseColumnName": "[Count]",
"baseColumnName": "[federated.1uxrrkh1vgr43b172nibp09csq7l].[Count]",
"fieldCaption": "SUM(Count)",
"formatStrings": [
"",
"-1",
"t",
"",
"",
"",
"0",
".",
",",
"3;0"
],
"datasourceCaption": "federated.1uxrrkh1vgr43b172nibp09csq7l",
"dataType": "integer",
"aggregation": "sum",
"fieldRole": "measure",
"isAutoSelect": false,
"paneIndices": [
0
],
"columnIndices": [
2
]
},
{
"fn": "[federated.1uxrrkh1vgr43b172nibp09csq7l].[Latitude (generated)]",
"fnDisagg": "",
"localBaseColumnName": "[Latitude (generated)]",
"baseColumnName": "[federated.1uxrrkh1vgr43b172nibp09csq7l].[Latitude (generated)]",
"fieldCaption": "Latitude (generated)",
"formatStrings": [
"",
"-1",
"t",
"",
"",
"",
"0",
".",
",",
"3;0"
],
"datasourceCaption": "federated.1uxrrkh1vgr43b172nibp09csq7l",
"dataType": "real",
"fieldRole": "measure",
"isAutoSelect": false,
"paneIndices": [
0
],
"columnIndices": [
3
]
},
{
"fn": "[federated.1uxrrkh1vgr43b172nibp09csq7l].[Longitude (generated)]",
"fnDisagg": "",
"localBaseColumnName": "[Longitude (generated)]",
"baseColumnName": "[federated.1uxrrkh1vgr43b172nibp09csq7l].[Longitude (generated)]",
"fieldCaption": "Longitude (generated)",
"formatStrings": [
"",
"-1",
"t",
"",
"",
"",
"0",
".",
",",
"3;0"
],
"datasourceCaption": "federated.1uxrrkh1vgr43b172nibp09csq7l",
"dataType": "real",
"fieldRole": "measure",
"isAutoSelect": false,
"paneIndices": [
0
],
"columnIndices": [
4
]
}
],
"paneColumnsList": [
{
"paneDescriptor": {
"paneDescrKey": "d578387abf4f5c33",
"xFields": [
"[federated.1uxrrkh1vgr43b172nibp09csq7l].[Longitude (generated)]"
],
"yFields": [
"[federated.1uxrrkh1vgr43b172nibp09csq7l].[Latitude (generated)]"
],
"xIndex": 0,
"yIndex": 0
},
"vizPaneColumns": [
{
"tupleIds": [
1,
2,
3,
4,
5,
6,
7,
8,
9,
10,
11,
12,
13,
14,
15
],
"valueIndices": [],
"aliasIndices": [],
"formatstrIndices": []
},
{
"tupleIds": [],
"valueIndices": [],
"aliasIndices": [
0,
1,
2,
3,
4,
5,
6,
7,
8,
9,
10,
11,
12,
13,
14
],
"formatstrIndices": [
-1,
-1,
-1,
-1,
-1,
-1,
-1,
-1,
-1,
-1,
-1,
-1,
-1,
-1,
-1
]
},
{
"tupleIds": [],
"valueIndices": [],
"aliasIndices": [
0,
0,
0,
1,
2,
3,
0,
4,
0,
0,
3,
0,
0,
0,
0
],
"formatstrIndices": [
-1,
-1,
-1,
-1,
-1,
-1,
-1,
-1,
-1,
-1,
-1,
-1,
-1,
-1,
-1
]
},
{
"tupleIds": [],
"valueIndices": [
0,
1,
2,
3,
4,
5,
6,
7,
8,
9,
10,
11,
12,
13,
14
],
"aliasIndices": [
-16,
-17,
-18,
-19,
-20,
-21,
-22,
-23,
-24,
-25,
-26,
-27,
-28,
-29,
-30
],
"formatstrIndices": [
-1,
-1,
-1,
-1,
-1,
-1,
-1,
-1,
-1,
-1,
-1,
-1,
-1,
-1,
-1
]
},
{
"tupleIds": [],
"valueIndices": [
15,
16,
17,
18,
19,
20,
21,
22,
23,
24,
25,
26,
27,
28,
29
],
"aliasIndices": [
-31,
-32,
-33,
-34,
-35,
-36,
-37,
-38,
-39,
-40,
-41,
-42,
-43,
-44,
-45
],
"formatstrIndices": [
-1,
-1,
-1,
-1,
-1,
-1,
-1,
-1,
-1,
-1,
-1,
-1,
-1,
-1,
-1
]
}
]
}
]
},
"highlightCaptions": [],
"filterFields": [],
"ubertipData": {
"ubertipPaneDatas": [
{
"htmlTooltip": "<span style=\"white-space:pre-wrap;tab-size:10;-moz-tab-size:10\"><table style=\"vertical-align:top;padding:0px\" cellspacing=\"0\"><tr><td style=\"white-space:pre\"><span style=\"font-family:'Tableau Book';font-size:13px;color:#787878;font-weight:normal;font-style:normal;text-decoration:none;\">County:</span></td><td>&nbsp;</td><td><span style=\"font-family:'Tableau Book';font-size:13px;color:#333333;font-weight:bold;font-style:normal;text-decoration:none;\">&lt;[federated.1uxrrkh1vgr43b172nibp09csq7l].[none:County:nk]&gt;</span></td></tr><tr><td style=\"white-space:pre\"><span style=\"font-family:'Tableau Book';font-size:13px;color:#787878;font-weight:normal;font-style:normal;text-decoration:none;\">Cases:</span></td><td>&nbsp;</td><td><span style=\"font-family:'Tableau Book';font-size:13px;color:#333333;font-weight:bold;font-style:normal;text-decoration:none;\">&lt;[federated.1uxrrkh1vgr43b172nibp09csq7l].[sum:Count:qk]&gt;</span></td></tr></table></span>",
"showButtons": false,
"summaryField": "SUM(Count)",
"fieldVector": [],
"htmlTooltipModified": ""
}
],
"fn": ""
},
"reflineFields": [],
"refLineTips": []
}
}
},
"Date": {
"presModelHolder": {
"genVizDataPresModel": {
"vizColumns": [],
"paneColumnsData": {
"vizDataColumns": [
{
"fn": "[system:visual].[tuple_id]",
"fnDisagg": "",
"formatStrings": [],
"isAutoSelect": false,
"paneIndices": [
0
],
"columnIndices": [
0
]
},
{
"fn": "[federated.168babi1dznpsr1bkxwey132vjet].[none:date:qk]",
"fnDisagg": "",
"localBaseColumnName": "[date]",
"baseColumnName": "[federated.168babi1dznpsr1bkxwey132vjet].[date]",
"fieldCaption": "Date",
"formatStrings": [
"*M/d/yyyy",
"en_US",
"",
"h:mm:ss tt",
"0",
"1",
"1",
"1"
],
"datasourceCaption": "federated.168babi1dznpsr1bkxwey132vjet",
"dataType": "date",
"fieldRole": "dimension",
"isAutoSelect": false,
"paneIndices": [
0
],
"columnIndices": [
1
]
}
],
"paneColumnsList": [
{
"paneDescriptor": {
"paneDescrKey": "6344701b2a6cb0ec",
"xFields": [],
"yFields": [],
"xIndex": 0,
"yIndex": 0
},
"vizPaneColumns": [
{
"tupleIds": [
1
],
"valueIndices": [],
"aliasIndices": [],
"formatstrIndices": []
},
{
"tupleIds": [],
"valueIndices": [],
"aliasIndices": [
-56
],
"formatstrIndices": [
-1
]
}
]
}
]
},
"highlightCaptions": [],
"filterFields": [],
"ubertipData": {
"ubertipPaneDatas": [
{
"htmlTooltip": "<span style=\"white-space:pre-wrap;tab-size:10;-moz-tab-size:10\"><table style=\"vertical-align:top;padding:0px\" cellspacing=\"0\"><tr><td style=\"white-space:pre\"><span style=\"font-family:'Tableau Book';font-size:13px;color:#787878;font-weight:normal;font-style:normal;text-decoration:none;\">Date:</span></td><td>&nbsp;</td><td><span style=\"font-family:'Tableau Book';font-size:13px;color:#333333;font-weight:bold;font-style:normal;text-decoration:none;\">&lt;[federated.168babi1dznpsr1bkxwey132vjet].[none:date:qk]&gt;</span></td></tr></table></span>",
"showButtons": false,
"summaryField": "",
"fieldVector": [],
"htmlTooltipModified": ""
}
],
"fn": ""
},
"reflineFields": [],
"refLineTips": []
}
}
},
"Risk": {
"presModelHolder": {
"genVizDataPresModel": {
"vizColumns": [],
"paneColumnsData": {
"vizDataColumns": [
{
"fn": "[system:visual].[tuple_id]",
"fnDisagg": "",
"formatStrings": [],
"isAutoSelect": false,
"paneIndices": [
0
],
"columnIndices": [
0
]
},
{
"fn": "[federated.16khe800vcmc1s18rc6ti1ga3tjv].[none:Risk:nk]",
"fnDisagg": "",
"localBaseColumnName": "[Risk]",
"baseColumnName": "[federated.16khe800vcmc1s18rc6ti1ga3tjv].[Risk]",
"fieldCaption": "Risk",
"formatStrings": [],
"datasourceCaption": "federated.16khe800vcmc1s18rc6ti1ga3tjv",
"dataType": "cstring",
"stringCollation": {
"name": "LEN_RUS_S2",
"charsetId": 0
},
"fieldRole": "dimension",
"isAutoSelect": true,
"paneIndices": [
0
],
"columnIndices": [
1
]
}
],
"paneColumnsList": [
{
"paneDescriptor": {
"paneDescrKey": "6344701b2a6cb0ec",
"xFields": [],
"yFields": [],
"xIndex": 0,
"yIndex": 0
},
"vizPaneColumns": [
{
"tupleIds": [
1
],
"valueIndices": [],
"aliasIndices": [],
"formatstrIndices": []
},
{
"tupleIds": [],
"valueIndices": [],
"aliasIndices": [
53
],
"formatstrIndices": [
-1
]
}
]
}
]
},
"highlightCaptions": [],
"filterFields": [],
"ubertipData": {
"ubertipPaneDatas": [
{
"htmlTooltip": "<span style=\"white-space:pre-wrap;tab-size:10;-moz-tab-size:10\"><table style=\"vertical-align:top;padding:0px\" cellspacing=\"0\"><tr><td style=\"white-space:pre\"><span style=\"font-family:'Tableau Book';font-size:13px;color:#787878;font-weight:normal;font-style:normal;text-decoration:none;\">Risk:</span></td><td>&nbsp;</td><td><span><a class=\"relax-selection\" href=\"SelectionRelaxation4219377926\"><span style=\"font-family:'Tableau Book';font-size:13px;color:#333333;font-weight:bold;font-style:normal;text-decoration:none;\">&lt;[federated.16khe800vcmc1s18rc6ti1ga3tjv].[none:Risk:nk]&gt;</span></a></span></td></tr></table></span>",
"showButtons": true,
"summaryField": "",
"fieldVector": [],
"htmlTooltipModified": ""
}
],
"standardCommands": {
"commandItems": [
{
"commandsType": "item",
"name": "Keep Only",
"iconRes": ":/en_US/TQRC_KEEP_ONLY",
"command": "tabdoc:keep-only-or-exclude dashboard=\"COVID-19 table\" exclude=\"false\" worksheet=\"Risk\""
},
{
"commandsType": "item",
"name": "Exclude",
"iconRes": ":/en_US/TQRC_EXCLUDE",
"command": "tabdoc:keep-only-or-exclude dashboard=\"COVID-19 table\" exclude=\"true\" worksheet=\"Risk\""
},
{
"commandsType": "item",
"name": "",
"description": "Group Members",
"iconRes": ":/en_US/TQRC_MERGE",
"command": "tabdoc:merge-or-split dashboard=\"COVID-19 table\" merge-or-split=\"merge\" worksheet=\"Risk\""
},
{
"commandsType": "item",
"name": "",
"description": "View Data...",
"iconRes": ":/en_US/TQRC_VIEWDATA",
"command": "tabdoc:view-selected-data selector={} visual-id-pres-model={\"worksheet\": \"Risk\",\"dashboard\": \"COVID-19 table\"}"
}
]
},
"multiselectCommands": {
"commandItems": [
{
"commandsType": "item",
"name": "",
"description": "View Data...",
"iconRes": ":/en_US/TQRC_VIEWDATA",
"command": "tabdoc:view-selected-data selector={} visual-id-pres-model={\"worksheet\": \"Risk\",\"dashboard\": \"COVID-19 table\"}"
}
]
},
"fn": ""
},
"reflineFields": [],
"refLineTips": []
}
}
},
"Spread": {
"presModelHolder": {
"genVizDataPresModel": {
"vizColumns": [],
"paneColumnsData": {
"vizDataColumns": [
{
"fn": "[system:visual].[tuple_id]",
"fnDisagg": "",
"formatStrings": [],
"isAutoSelect": false,
"paneIndices": [
0
],
"columnIndices": [
0
]
},
{
"fn": "[federated.08rb4bj01ld9co1ao6zmz0d1dtof].[none:Level:nk]",
"fnDisagg": "",
"localBaseColumnName": "[Level]",
"baseColumnName": "[federated.08rb4bj01ld9co1ao6zmz0d1dtof].[Level]",
"fieldCaption": "Level",
"formatStrings": [],
"datasourceCaption": "federated.08rb4bj01ld9co1ao6zmz0d1dtof",
"dataType": "cstring",
"stringCollation": {
"name": "LEN_RUS_S2",
"charsetId": 0
},
"fieldRole": "dimension",
"isAutoSelect": true,
"paneIndices": [
0
],
"columnIndices": [
1
]
}
],
"paneColumnsList": [
{
"paneDescriptor": {
"paneDescrKey": "6344701b2a6cb0ec",
"xFields": [],
"yFields": [],
"xIndex": 0,
"yIndex": 0
},
"vizPaneColumns": [
{
"tupleIds": [
1
],
"valueIndices": [],
"aliasIndices": [],
"formatstrIndices": []
},
{
"tupleIds": [],
"valueIndices": [],
"aliasIndices": [
54
],
"formatstrIndices": [
-1
]
}
]
}
]
},
"highlightCaptions": [],
"filterFields": [],
"ubertipData": {
"ubertipPaneDatas": [
{
"htmlTooltip": "<span style=\"white-space:pre-wrap;tab-size:10;-moz-tab-size:10\"><table style=\"vertical-align:top;padding:0px\" cellspacing=\"0\"><tr><td style=\"white-space:pre\"><span style=\"font-family:'Tableau Book';font-size:13px;color:#787878;font-weight:normal;font-style:normal;text-decoration:none;\">Level:</span></td><td>&nbsp;</td><td><span><a class=\"relax-selection\" href=\"SelectionRelaxation2781296460\"><span style=\"font-family:'Tableau Book';font-size:13px;color:#333333;font-weight:bold;font-style:normal;text-decoration:none;\">&lt;[federated.08rb4bj01ld9co1ao6zmz0d1dtof].[none:Level:nk]&gt;</span></a></span></td></tr></table></span>",
"showButtons": true,
"summaryField": "",
"fieldVector": [],
"htmlTooltipModified": ""
}
],
"standardCommands": {
"commandItems": [
{
"commandsType": "item",
"name": "Keep Only",
"iconRes": ":/en_US/TQRC_KEEP_ONLY",
"command": "tabdoc:keep-only-or-exclude dashboard=\"COVID-19 table\" exclude=\"false\" worksheet=\"Spread\""
},
{
"commandsType": "item",
"name": "Exclude",
"iconRes": ":/en_US/TQRC_EXCLUDE",
"command": "tabdoc:keep-only-or-exclude dashboard=\"COVID-19 table\" exclude=\"true\" worksheet=\"Spread\""
},
{
"commandsType": "item",
"name": "",
"description": "Group Members",
"iconRes": ":/en_US/TQRC_MERGE",
"command": "tabdoc:merge-or-split dashboard=\"COVID-19 table\" merge-or-split=\"merge\" worksheet=\"Spread\""
},
{
"commandsType": "item",
"name": "",
"description": "View Data...",
"iconRes": ":/en_US/TQRC_VIEWDATA",
"command": "tabdoc:view-selected-data selector={} visual-id-pres-model={\"worksheet\": \"Spread\",\"dashboard\": \"COVID-19 table\"}"
}
]
},
"multiselectCommands": {
"commandItems": [
{
"commandsType": "item",
"name": "",
"description": "View Data...",
"iconRes": ":/en_US/TQRC_VIEWDATA",
"command": "tabdoc:view-selected-data selector={} visual-id-pres-model={\"worksheet\": \"Spread\",\"dashboard\": \"COVID-19 table\"}"
}
]
},
"fn": ""
},
"reflineFields": [],
"refLineTips": []
}
}
},
"Testing": {
"presModelHolder": {
"genVizDataPresModel": {
"vizColumns": [],
"paneColumnsData": {
"vizDataColumns": [
{
"fn": "[system:visual].[tuple_id]",
"fnDisagg": "",
"formatStrings": [],
"isAutoSelect": false,
"paneIndices": [
0
],
"columnIndices": [
0
]
},
{
"fn": "[federated.0ymsnpi0gojlnk1fpbwp71bo9hm5].[none:F1:nk]",
"fnDisagg": "",
"localBaseColumnName": "[F1]",
"baseColumnName": "[federated.0ymsnpi0gojlnk1fpbwp71bo9hm5].[F1]",
"fieldCaption": "Category",
"formatStrings": [],
"datasourceCaption": "federated.0ymsnpi0gojlnk1fpbwp71bo9hm5",
"dataType": "cstring",
"stringCollation": {
"name": "LEN_RUS_S2",
"charsetId": 0
},
"fieldRole": "dimension",
"isAutoSelect": true,
"paneIndices": [
0
],
"columnIndices": [
1
]
},
{
"fn": "[federated.0ymsnpi0gojlnk1fpbwp71bo9hm5].[sum:Count:qk]",
"fnDisagg": "",
"localBaseColumnName": "[Count]",
"baseColumnName": "[federated.0ymsnpi0gojlnk1fpbwp71bo9hm5].[Count]",
"fieldCaption": "SUM(Count)",
"formatStrings": [
"",
"-1",
"t",
"",
"",
"",
"0",
".",
",",
"3;0"
],
"datasourceCaption": "federated.0ymsnpi0gojlnk1fpbwp71bo9hm5",
"dataType": "integer",
"aggregation": "sum",
"fieldRole": "measure",
"isAutoSelect": false,
"paneIndices": [
0
],
"columnIndices": [
2
]
}
],
"paneColumnsList": [
{
"paneDescriptor": {
"paneDescrKey": "a8c495acfe737ac2",
"xFields": [],
"yFields": [
"[federated.0ymsnpi0gojlnk1fpbwp71bo9hm5].[none:F1:nk]"
],
"xIndex": 0,
"yIndex": 0
},
"vizPaneColumns": [
{
"tupleIds": [
1,
2,
3,
4
],
"valueIndices": [],
"aliasIndices": [],
"formatstrIndices": []
},
{
"tupleIds": [],
"valueIndices": [
49,
50,
51,
52
],
"aliasIndices": [
49,
50,
51,
52
],
"formatstrIndices": [
-1,
-1,
-1,
-1
]
},
{
"tupleIds": [],
"valueIndices": [],
"aliasIndices": [
8,
9,
10,
6
],
"formatstrIndices": [
-1,
-1,
-1,
-1
]
}
]
}
]
},
"highlightCaptions": [],
"filterFields": [],
"ubertipData": {
"ubertipPaneDatas": [
{
"htmlTooltip": "<span style=\"white-space:pre-wrap;tab-size:10;-moz-tab-size:10\"><table style=\"vertical-align:top;padding:0px\" cellspacing=\"0\"><tr><td style=\"white-space:pre\"><span style=\"font-family:'Tableau Book';font-size:13px;color:#787878;font-weight:normal;font-style:normal;text-decoration:none;\">Category:</span></td><td>&nbsp;</td><td><span style=\"font-family:'Tableau Book';font-size:13px;color:#333333;font-weight:bold;font-style:normal;text-decoration:none;\">&lt;[federated.0ymsnpi0gojlnk1fpbwp71bo9hm5].[none:F1:nk]&gt;</span></td></tr><tr><td style=\"white-space:pre\"><span style=\"font-family:'Tableau Book';font-size:13px;color:#787878;font-weight:normal;font-style:normal;text-decoration:none;\">Count:</span></td><td>&nbsp;</td><td><span style=\"font-family:'Tableau Book';font-size:13px;color:#333333;font-weight:bold;font-style:normal;text-decoration:none;\">&lt;[federated.0ymsnpi0gojlnk1fpbwp71bo9hm5].[sum:Count:qk]&gt;</span></td></tr></table></span>",
"showButtons": false,
"summaryField": "SUM(Count)",
"fieldVector": [],
"htmlTooltipModified": ""
}
],
"fn": ""
},
"reflineFields": [],
"refLineTips": []
}
}
}
}
}
}
}
}
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment