{
"__typename": "TableViz",
"id": "f2524330-7c21-4b23-8cd9-10d74bb75b53",
"columns": [
{
"__typename": "VizColumn",
"column": {
"__typename": "AnswerColumn",
"id": "f70df70d-b37f-4cfc-b3b6-28af82183d2d",
"name": "Account Balance",
"type": "MEASURE"
}
}
],
"data": {
"columnDataLite": [
{
"columnId": "f70df70d-b37f-4cfc-b3b6-28af82183d2d",
"columnDataType": "DOUBLE",
"dataValue": [
8542.212710650001
]
}
],
"completionRatio": 1,
"samplingRatio": 1,
"totalRowCount": "1"
},
"user": {
"userName": "tsadmin",
"userGUID": "59481331-ee53-42be-a548-bd87be6ddd4a",
"userEmail": "TSuser@thoughtspot.com"
},
"reportBookMetadata": {
"id": "f5d85d72-1234-4f11-a850-5f76191251bb",
"description": "",
"metadata": {
"author": "Administrator",
"authorId": "59481331-ee53-42be-a548-bd87be6ddd4a",
"createdAt": "1623062404647",
"modifiedAt": "1623062404647",
"generationNum": "2471",
"isHidden": false,
"type": "",
"tags": [],
"__typename": "AnswerMetadata"
},
"name": "Total Account Balance",
"suggestedDisplayMode": "TABLE_MODE",
"visualizations": {
"id": "47805958-d92b-4301-a1ca-59b84d57c25e",
"title": "Headline Account Balance",
"vizProp": {
"headlineVizPropVersion": "V1",
"columnProperty": null,
"__typename": "HeadlineVizProps"
},
"aggregationType": [
"TABLE_AGGR"
],
"possibleAggregations": [
"SUM",
"AVERAGE",
"STD_DEVIATION",
"VARIANCE",
"MIN",
"MAX",
"TABLE_AGGR"
],
"headlineColumn": {
"id": "f70df70d-b37f-4cfc-b3b6-28af82183d2d",
"name": "Account Balance",
"type": "MEASURE",
"baseColumnType": "SAGE_COLUMN",
"formulaId": "",
"columnProps": {
"version": null,
"columnProperties": null,
"__typename": "AnswerColumnProps"
},
"dataType": "DOUBLE",
"aggregationType": "SUM",
"formatPattern": null,
"isGroupBy": false,
"isUserDefinedTitle": false,
"isAdditive": true,
"customCalendarType": null,
"formatType": "CURRENCY",
"calendarGuid": "",
"format": {
"pattern": "",
"currencyFormat": {
"column": "",
"type": "ISO_CODE",
"isoCode": "USD",
"__typename": "CurrencyFormat"
},
"__typename": "AnswerColumnFormat"
},
"referencedColumns": [
{
"guid": "93861df4-220d-4c82-b5ac-6c14c810ddd3",
"displayName": "Account Balance",
"__typename": "EntityHeader"
}
],
"referencedTables": [
{
"guid": "0d3713c5-9b7d-473f-a262-b2f23ae4fce6",
"displayName": "Retail Banking",
"__typename": "EntityHeader"
}
],
"legacySheetProperties": null,
"legacyColumnFormatProperties": null,
"timeBucket": "NO_BUCKET",
"geoConfig": null,
"__typename": "AnswerColumn"
},
"sortInfo": [],
"__typename": "HeadlineViz"
},
"headerMetadata": {
"id": "f5d85d72-1234-4f11-a850-5f76191251bb",
"name": "Total Account Balance",
"description": "",
"isNewAnswer": false,
"isHidden": false,
"loading": false
}
}
}Callback JSON response payloads
Table of Contents
The examples in this section show the contents of the payload sent from ThoughtSpot for the custom action workflows.
Sample response payload for callback custom actions🔗
Search data payload🔗
The following example shows the data payload for a callback custom action on a search result:
The following example shows the data payload for a callback custom action in the context menu of a saved Answer:
{
"id": "app-callback",
"contextMenuPoints": {
"clickedPoint": {
"selectedAttributes": [],
"deselectedAttributes": [],
"selectedMeasures": [],
"deselectedMeasures": [
{
"column": {
"__typename": "AnswerColumn",
"id": "f70df70d-b37f-4cfc-b3b6-28af82183d2d",
"name": "Account Balance",
"type": "MEASURE",
"baseColumnType": "SAGE_COLUMN",
"formulaId": "",
"columnProps": {
"__typename": "AnswerColumnProps",
"version": "V1",
"columnProperties": null
},
"dataType": "DOUBLE",
"aggregationType": "SUM",
"formatPattern": null,
"isGroupBy": false,
"isUserDefinedTitle": false,
"isAdditive": true,
"customCalendarType": null,
"formatType": "CURRENCY",
"calendarGuid": "",
"format": {
"__typename": "AnswerColumnFormat",
"pattern": "",
"currencyFormat": {
"__typename": "CurrencyFormat",
"column": "",
"type": "ISO_CODE",
"isoCode": "USD"
}
},
"referencedColumns": [
{
"__typename": "EntityHeader",
"guid": "93861df4-220d-4c82-b5ac-6c14c810ddd3",
"displayName": "Account Balance"
}
],
"referencedTables": [
{
"__typename": "EntityHeader",
"guid": "0d3713c5-9b7d-473f-a262-b2f23ae4fce6",
"displayName": "Retail Banking"
}
],
"legacySheetProperties": null,
"legacyColumnFormatProperties": null,
"timeBucket": "NO_BUCKET",
"geoConfig": null
},
"value": 8542.212710650001
}
]
},
"selectedPoints": [
{
"selectedAttributes": [],
"deselectedAttributes": [],
"selectedMeasures": [],
"deselectedMeasures": [
{
"column": {
"__typename": "AnswerColumn",
"id": "f70df70d-b37f-4cfc-b3b6-28af82183d2d",
"name": "Account Balance",
"type": "MEASURE",
"baseColumnType": "SAGE_COLUMN",
"formulaId": "",
"columnProps": {
"__typename": "AnswerColumnProps",
"version": "V1",
"columnProperties": null
},
"dataType": "DOUBLE",
"aggregationType": "SUM",
"formatPattern": null,
"isGroupBy": false,
"isUserDefinedTitle": false,
"isAdditive": true,
"customCalendarType": null,
"formatType": "CURRENCY",
"calendarGuid": "",
"format": {
"__typename": "AnswerColumnFormat",
"pattern": "",
"currencyFormat": {
"__typename": "CurrencyFormat",
"column": "",
"type": "ISO_CODE",
"isoCode": "USD"
}
},
"referencedColumns": [
{
"__typename": "EntityHeader",
"guid": "93861df4-220d-4c82-b5ac-6c14c810ddd3",
"displayName": "Account Balance"
}
],
"referencedTables": [
{
"__typename": "EntityHeader",
"guid": "0d3713c5-9b7d-473f-a262-b2f23ae4fce6",
"displayName": "Retail Banking"
}
],
"legacySheetProperties": null,
"legacyColumnFormatProperties": null,
"timeBucket": "NO_BUCKET",
"geoConfig": null
},
"value": 8542.212710650001
}
]
}
]
}
}Liveboard🔗
The following example shows the data payload for a callback for code based custom action for the primary action on a Liveboard:
{
"type": "customAction",
"data": {
"liveboardId": "87328d32-2bf0-4fc4-ac51-a738712d7e79",
"id": "my-liveboard-custom-action",
"pinboardDetails": {
"__typename": "Pinboard",
"authorDisplayName": "rani.gangwar",
"authorGuid": "0000083e-e253-10af-aa97-5e45d512ebbd",
"containers": [
{
"__typename": "Container",
"answerId": "4d5e51cf-71e1-4765-8e6e-9f9d01bcf95d",
"chartType": "COLUMN",
"dataSourceIds": [
"cd252e5c-b552-49a8-821d-3eadaa049cca"
],
"description": "",
"groupContainerIds": null,
"id": "6fda068c-92f7-4744-8fa5-ac01b0812d6b",
"isTimeSeriesKpi": false,
"name": "Total sales by product",
"noteTile": null,
"refVizId": "f6a2ee16-4035-4d83-9b27-64a7d1af2e32",
"referencedParameters": [],
"referencedVizType": 1,
"type": "PINNED_ANSWER"
}
],
"dateCreated": 1773813596421,
"dateModified": 1773815813982,
"defaultPersonalisedView": null,
"description": "",
"id": "87328d32-2bf0-4fc4-ac51-a738712d7e79",
"inScopeParameters": [],
"isDiscoverable": false,
"isFavorite": false,
"layout": [
{
"__typename": "ContainerLayout",
"height": 4,
"id": "6fda068c-92f7-4744-8fa5-ac01b0812d6b",
"width": 6,
"x": 0,
"y": 0
}
],
"liveboardStyle": {
"__typename": "LiveboardStyleConfig",
"componentOverrides": [],
"defaultStyle": {
"__typename": "LiveboardStyle",
"compositeStyle": null,
"configStyle": {
"__typename": "LiveboardConfigStyle",
"gridColumnCount": "12",
"groupGutter": "8px",
"hideGroupDescription": true,
"hideGroupDivider": false,
"hideGroupTileDescription": false,
"hideGroupTitle": false,
"hideTileDescription": false,
"kpiHeroFontSize": "M",
"lbGutter": "16px"
},
"pureStyle": {
"__typename": "LiveboardPureStyle",
"axisDataLabelColor": "#5E5E5E",
"axisTitleColor": "#5E5E5E",
"borderRadius": "16px",
"filterChipActiveBgColor": "#C0C6CF",
"filterChipActiveTextColor": "#1D232F",
"filterChipBgColor": "#EAEDF2",
"filterChipHoverBgColor": "#DBDFE7",
"filterChipHoverTextColor": "#1D232F",
"filterChipTextColor": "#1D232F",
"groupBgColor": "#FFFFFF",
"groupBorderColor": "#EAEDF2",
"groupDescriptionFontColor": "#4A515E",
"groupPadding": "8px",
"groupTileBgColor": "#FFFFFF",
"groupTileBorderColor": "#EAEDF2",
"groupTileDescriptionFontColor": "#4A515E",
"groupTilePadding": "4px",
"groupTileTitleFontColor": "#4A515E",
"groupTileTitleFontSize": "14px",
"groupTileTitleFontWeight": "medium",
"groupTitleFontColor": "#1D232F",
"groupTitleFontSize": "16px",
"groupTitleFontWeight": "medium",
"headerActionButtonActiveColor": "#C0C6CF",
"headerActionButtonBgColor": "#EAEDF2",
"headerActionButtonFontColor": "#1D232F",
"headerActionButtonHoverColor": "#DBDFE7",
"headerBadgeActiveColor": "#163772",
"headerBadgeBgColor": "#2770EF",
"headerBadgeFontColor": "#FFFFFF",
"headerBadgeHoverColor": "#2359B6",
"headerBadgeModifiedBgColor": "#777E8B",
"headerBgColor": "#FFFFFF",
"headerFontColor": "#1D232F",
"iconSize": "24px",
"kpiAnalyseFontColor": "#2770EF",
"kpiComparisonFontColor": "#777E8B",
"kpiDeltaBadgeNegativeBgColor": "#FFEBEC",
"kpiDeltaBadgeNegativeFontColor": "#E22B3D",
"kpiDeltaBadgePositiveBgColor": "#E0F8EF",
"kpiDeltaBadgePositiveFontColor": "#06BF7F",
"kpiNumberFontColor": "#1D232F",
"lbBgColor": "#F6F8FA",
"lbBgDotColor": "#C0C6CF",
"legendHoverBackground": "#E5EEFD",
"legendTextColor": "#5E5E5E",
"noteBodyFontColor": "#1D232F",
"noteHeadingFontColor": "#1D232F",
"parameterChipActiveBgColor": "#323946",
"parameterChipActiveTextColor": "#FFFFFF",
"parameterChipBgColor": "#777E8B",
"parameterChipHoverBgColor": "#4A515E",
"parameterChipHoverTextColor": "#FFFFFF",
"parameterChipTextColor": "#FFFFFF",
"tabActiveBorderColor": "#2770EF",
"tileBgColor": "#FFFFFF",
"tileBorderColor": "#EAEDF2",
"tileDescriptionFontColor": "#4A515E",
"tilePadding": "8px",
"tileTitleFontColor": "#1D232F",
"tileTitleFontSize": "16px",
"tileTitleFontWeight": "medium"
}
}
},
"modifiedBy": "0000083e-e253-10af-aa97-5e45d512ebbd",
"name": "Docs copy of (Sample) Sales Performance",
"orderedChips": [],
"orderedTabIds": [],
"parameters": [],
"permissions": {
"__typename": "PinboardPermissions",
"columnPermissions": [],
"containersPermission": [
{
"__typename": "ContainerPermission",
"answerId": "4d5e51cf-71e1-4765-8e6e-9f9d01bcf95d",
"permission": {
"__typename": "ObjectPermission",
"dataSourceAccessLevel": "READ_ONLY",
"dataSourceNamesWithNoAccess": [],
"objectAccessLevel": "MODIFY"
}
}
],
"dataSourcePermissions": [
{
"__typename": "PermissionObject",
"id": "cd252e5c-b552-49a8-821d-3eadaa049cca",
"name": "(Sample) Retail - Apparel",
"permission": "READ_ONLY"
}
],
"pinboardLevelPermission": {
"__typename": "ObjectPermission",
"columnIdsWithNoAccess": null,
"dataSourceAccessLevel": "READ_ONLY",
"dataSourceNamesWithNoAccess": [],
"objectAccessLevel": "MODIFY"
},
"pinboardPermission": {
"__typename": "PermissionObject",
"id": "87328d32-2bf0-4fc4-ac51-a738712d7e79",
"permission": "MODIFY"
}
},
"pinboardFilter": null,
"pinboardGenerationNumber": "4646949",
"pinboardSignature": "-6032047147599776089",
"tabs": [],
"tags": []
},
"userGuid": "0000083e-e253-10af-aa97-5e45d512ebbd",
"currentOrgId": 0
},
"status": "end",
"answerService": {
"thoughtSpotHost": "<ThoughtSpot-Host-URL>",
"tmlOverride": {},
"answer": {}
}
}The following example shows the data payload for a callback custom action in the More menu of a Liveboard visualization:
{
"id":"callback-action",
"embedAnswerData":{
"__typename":"TableViz",
"clientState":{
},
"description":"",
"filterGroups":[
{
"__typename":"FilterGroup",
"columnInfo":{
"__typename":"FilterColumn",
"aggregationType":"NONE",
"calendarGuid":"",
"dataType":"CHAR",
"formulaId":"",
"isAggregateApplied":false,
"name":"Currency Code",
"referencedColumns":[
{
"__typename":"EntityHeader",
"displayName":"Currency Code",
"guid":"616451a0-abf5-47e0-998a-adca86baf882"
}
],
"referencedTables":[
{
"__typename":"EntityHeader",
"displayName":"Tea Sales",
"guid":"84815b7f-f884-4d89-bd7b-6420927cf547"
}
],
"timeBucket":"NO_BUCKET",
"type":"ATTRIBUTE"
},
"displayName":null,
"filters":[
{
"__typename":"Filter",
"filterContent":[
{
"__typename":"FilterContent",
"filterType":"EQ",
"negate":false,
"value":[
{
"__typename":"FilterContentValue",
"key":"usd"
}
]
}
],
"filterId":"0b9702fa-7307-5c14-be75-13273f9d0dc6"
}
],
"groupId":{
"__typename":"FilterGroupId",
"answerColumnId":"f8f28785-a7ed-53e4-9d23-565673ae3902",
"dataSourceId":null,
"logicalColumnId":null
},
"isEditable":true,
"isMandatory":null
}
],
"hashKey":"10078428522383724324",
"headlineVisibilityMap":[
{
"__typename":"HeadlineVisibility",
"columnId":"8b91c6a0-cc7b-42df-8b3f-a7b23679f325",
"isVisible":false
},
{
"__typename":"HeadlineVisibility",
"columnId":"f8f28785-a7ed-53e4-9d23-565673ae3902",
"isVisible":false
}
],
"id":"3c0e1f61-2521-49cb-b95a-4c762bdce44e",
"name":"Total Sales",
"permission":{
"__typename":"ObjectPermission",
"dataSourceAccessLevel":"MODIFY",
"dataSourceNamesWithNoAccess":[
],
"objectAccessLevel":"MODIFY"
},
"queryableDataSource":"DEFAULT",
"visualizations":[
{
"__typename":"TableViz",
"clientState":{
},
"columns":[
{
"__typename":"VizColumn",
"column":{
"__typename":"AnswerColumn",
"aggregationType":"NONE",
"baseColumnType":"SAGE_COLUMN",
"calendarGuid":"",
"columnProps":{
"__typename":"AnswerColumnProps",
"columnProperties":null,
"version":"V1"
},
"customCalendarType":null,
"dataType":"CHAR",
"format":null,
"formatPattern":null,
"formatType":null,
"formulaId":"",
"geoConfig":null,
"id":"f8f28785-a7ed-53e4-9d23-565673ae3902",
"isAdditive":false,
"isAggregateApplied":false,
"isGroupBy":true,
"isUserDefinedTitle":false,
"legacyColumnFormatProperties":null,
"legacySheetProperties":{
},
"name":"Currency Code",
"referencedColumns":[
{
"__typename":"EntityHeader",
"displayName":"Currency Code",
"guid":"616451a0-abf5-47e0-998a-adca86baf882"
}
],
"referencedTables":[
{
"__typename":"EntityHeader",
"displayName":"Tea Sales",
"guid":"84815b7f-f884-4d89-bd7b-6420927cf547"
}
],
"showGrowth":false,
"timeBucket":"NO_BUCKET",
"type":"ATTRIBUTE"
},
"legacyMetricDefinition":null
},
{
"__typename":"VizColumn",
"column":{
"__typename":"AnswerColumn",
"aggregationType":"SUM",
"baseColumnType":"SAGE_COLUMN",
"calendarGuid":"",
"columnProps":{
"__typename":"AnswerColumnProps",
"columnProperties":null,
"version":"V1"
},
"customCalendarType":null,
"dataType":"DOUBLE",
"format":{
"__typename":"AnswerColumnFormat",
"currencyFormat":{
"__typename":"CurrencyFormat",
"column":"f8f28785-a7ed-53e4-9d23-565673ae3902",
"isoCode":"",
"type":"COLUMN"
},
"pattern":""
},
"formatPattern":null,
"formatType":"CURRENCY",
"formulaId":"",
"geoConfig":null,
"id":"f31712d5-d528-4c7a-93de-7d431bc1e57b",
"isAdditive":true,
"isAggregateApplied":true,
"isGroupBy":false,
"isUserDefinedTitle":false,
"legacyColumnFormatProperties":null,
"legacySheetProperties":{
},
"name":"Total Revenue",
"referencedColumns":[
{
"__typename":"EntityHeader",
"displayName":"Revenue",
"guid":"9e78a664-19d6-4a44-be53-eedbfc7df585"
}
],
"referencedTables":[
{
"__typename":"EntityHeader",
"displayName":"Tea Sales",
"guid":"84815b7f-f884-4d89-bd7b-6420927cf547"
}
],
"showGrowth":false,
"timeBucket":"NO_BUCKET",
"type":"MEASURE"
},
"legacyMetricDefinition":null
}
],
"id":"3c0e1f61-2521-49cb-b95a-4c762bdce44e",
"sortInfo":[
],
"topInfo":[
],
"vizProp":{
"__typename":"TableVizProps",
"columnProperties":[
],
"density":null,
"orderedColumnIds":[
],
"showGridSummary":null,
"showTableFooter":null,
"tableVizPropVersion":"V1",
"theme":null,
"widthState":[
],
"wrapTableHeader":true
}
}
],
"columns":[
{
"__typename":"VizColumn",
"column":{
"__typename":"AnswerColumn",
"dataType":"CHAR",
"format":null,
"id":"f8f28785-a7ed-53e4-9d23-565673ae3902",
"name":"Currency Code",
"referencedColumns":[
{
"__typename":"EntityHeader",
"displayName":"Currency Code"
}
],
"timeBucket":"NO_BUCKET",
"type":"ATTRIBUTE"
}
},
{
"__typename":"VizColumn",
"column":{
"__typename":"AnswerColumn",
"dataType":"DOUBLE",
"format":{
"__typename":"AnswerColumnFormat",
"currencyFormat":{
"__typename":"CurrencyFormat",
"column":"f8f28785-a7ed-53e4-9d23-565673ae3902",
"isoCode":"",
"type":"COLUMN"
},
"pattern":""
},
"id":"f31712d5-d528-4c7a-93de-7d431bc1e57b",
"name":"Total Revenue",
"referencedColumns":[
{
"__typename":"EntityHeader",
"displayName":"Revenue"
}
],
"timeBucket":"NO_BUCKET",
"type":"MEASURE"
}
}
],
"data":{
"columnDataLite":[
{
"columnId":"5b37be07-7c23-4f8f-ad2a-1876a51e6383",
"columnDataType":"CHAR",
"dataValue":[
"chamomile",
"earl gray",
"mint"
]
},
{
"columnId":"f31712d5-d528-4c7a-93de-7d431bc1e57b",
"columnDataType":"DOUBLE",
"dataValue":[
54.87,
18.36,
193.19
]
}
],
"completionRatio":1,
"samplingRatio":1,
"totalRowCount":"3",
"queryPerfStats":{
"timeTakenDatamanager":"4"
}
},
"user":{
"userName":"tsadmin",
"userGUID":"59481331-ee53-42be-a548-bd87be6ddd4a",
"userEmail":""
},
"reportBookMetadata":{
"headerMetadata":{
"id":"f8ab03d4-1f5f-427f-b556-0662fd2b4fba",
"name":"Total Sales",
"description":"",
"isNewAnswer":false,
"isHidden":true,
"loading":false
}
},
"isAnswerUnsaved":false,
"vizId":"2c9a59ec-c741-45c8-bb35-84928aece3fb"
},
"operation":"GetTableWithHeadlineData",
"session":{
"genNo":0,
"sessionId":"54c45759-84f0-4805-96cf-f15f84755de2",
"acSession":{
"sessionId":"acedc647-d438-44b2-b48f-f1d1a7c05a82",
"genNo":1
}
},
"query":""
}The following example shows the data payload of callback custom action in the context menu of a Liveboard visualization:
{
"id": "ac-callback",
"contextMenuPoints": {
"clickedPoint": {
"selectedAttributes": [],
"deselectedAttributes":
{
"column": {
"__typename": "AnswerColumn",
"aggregationType": "NONE",
"baseColumnType": "SAGE_COLUMN",
"calendarGuid": "",
"columnProps": {
"__typename": "AnswerColumnProps",
"columnProperties": null,
"version": "V1"
},
"customCalendarType": null,
"dataType": "CHAR",
"format": null,
"formatPattern": null,
"formatType": null,
"formulaId": "",
"geoConfig": null,
"id": "c30d89ee-6b57-5f3f-86ea-13d60efef40c",
"isAdditive": false,
"isAggregateApplied": false,
"isGroupBy": true,
"isUserDefinedTitle": false,
"legacyColumnFormatProperties": null,
"legacySheetProperties": null,
"name": "Currency Code",
"referencedColumns": [
{
"__typename": "EntityHeader",
"displayName": "Currency Code",
"guid": "616451a0-abf5-47e0-998a-adca86baf882"
}
],
"referencedTables": [
{
"__typename": "EntityHeader",
"displayName": "Tea Sales",
"guid": "84815b7f-f884-4d89-bd7b-6420927cf547"
}
],
"showGrowth": false,
"timeBucket": "NO_BUCKET",
"type": "ATTRIBUTE"
},
"value": "usd"
},
"selectedMeasures": [
],
"deselectedMeasures": [
{
"column": {
"__typename": "AnswerColumn",
"aggregationType": "SUM",
"baseColumnType": "SAGE_COLUMN",
"calendarGuid": "",
"columnProps": {
"__typename": "AnswerColumnProps",
"columnProperties": null,
"version": "V1"
},
"customCalendarType": null,
"dataType": "DOUBLE",
"format": {
"__typename": "AnswerColumnFormat",
"currencyFormat": {
"__typename": "CurrencyFormat",
"column": "c30d89ee-6b57-5f3f-86ea-13d60efef40c",
"isoCode": "",
"type": "COLUMN"
},
"pattern": ""
},
"formatPattern": null,
"formatType": "CURRENCY",
"formulaId": "",
"geoConfig": null,
"id": "57dcb444-162e-4965-9d99-4f2ab9b49d2b",
"isAdditive": true,
"isAggregateApplied": true,
"isGroupBy": false,
"isUserDefinedTitle": false,
"legacyColumnFormatProperties": null,
"legacySheetProperties": null,
"name": "Total Revenue",
"referencedColumns": [
{
"__typename": "EntityHeader",
"displayName": "Revenue",
"guid": "9e78a664-19d6-4a44-be53-eedbfc7df585"
}
],
"referencedTables": [
{
"__typename": "EntityHeader",
"displayName": "Tea Sales",
"guid": "84815b7f-f884-4d89-bd7b-6420927cf547"
}
],
"showGrowth": false,
"timeBucket": "NO_BUCKET",
"type": "MEASURE"
},
"value": 54.87
}
]
},
"selectedPoints": [
{
"selectedAttributes": [],
"deselectedAttributes":
{
"column": {
"__typename": "AnswerColumn",
"aggregationType": "NONE",
"baseColumnType": "SAGE_COLUMN",
"calendarGuid": "",
"columnProps": {
"__typename": "AnswerColumnProps",
"columnProperties": null,
"version": "V1"
},
"customCalendarType": null,
"dataType": "CHAR",
"format": null,
"formatPattern": null,
"formatType": null,
"formulaId": "",
"geoConfig": null,
"id": "c30d89ee-6b57-5f3f-86ea-13d60efef40c",
"isAdditive": false,
"isAggregateApplied": false,
"isGroupBy": true,
"isUserDefinedTitle": false,
"legacyColumnFormatProperties": null,
"legacySheetProperties": null,
"name": "Currency Code",
"referencedColumns": [
{
"__typename": "EntityHeader",
"displayName": "Currency Code",
"guid": "616451a0-abf5-47e0-998a-adca86baf882"
}
],
"referencedTables": [
{
"__typename": "EntityHeader",
"displayName": "Tea Sales",
"guid": "84815b7f-f884-4d89-bd7b-6420927cf547"
}
],
"showGrowth": false,
"timeBucket": "NO_BUCKET",
"type": "ATTRIBUTE"
},
"value": "usd"
},
"selectedMeasures": [
{
"column": {
"__typename": "AnswerColumn",
"aggregationType": "SUM",
"baseColumnType": "SAGE_COLUMN",
"calendarGuid": "",
"columnProps": {
"__typename": "AnswerColumnProps",
"columnProperties": null,
"version": "V1"
},
"customCalendarType": null,
"dataType": "INT64",
"format": {
"__typename": "AnswerColumnFormat",
"currencyFormat": {
"__typename": "CurrencyFormat",
"column": "",
"isoCode": "INR",
"type": "ISO_CODE"
},
"pattern": ""
},
"formatPattern": null,
"formatType": "CURRENCY",
"formulaId": "",
"geoConfig": null,
"id": "e99b3d11-a10a-496e-b036-2f6882edc873",
"isAdditive": true,
"isAggregateApplied": true,
"isGroupBy": false,
"isUserDefinedTitle": false,
"legacyColumnFormatProperties": null,
"legacySheetProperties": null,
"name": "Total Sales",
"referencedColumns": [
{
"__typename": "EntityHeader",
"displayName": "Sales",
"guid": "3abe8d75-a732-482c-898d-d8460ca9e806"
}
],
"referencedTables": [
{
"__typename": "EntityHeader",
"displayName": "Tea Sales",
"guid": "84815b7f-f884-4d89-bd7b-6420927cf547"
}
],
"showGrowth": false,
"timeBucket": "NO_BUCKET",
"type": "MEASURE"
},
"value": 558
}
],
"deselectedMeasures": [
]
}
]
}
}Spotter🔗
The following example shows the data payload for a code based custom action for the More menu in Spotter:
Data payload
{
"type": "customAction",
"data": {
"id": "my-custom-action",
"embedAnswerData": {
"__typename": "ChartViz",
"clientState": {},
"cohorts": [],
"description": "",
"displayDescription": "",
"displayMode": "CHART_MODE",
"displayName": "",
"dynamicDescription": "",
"dynamicName": "",
"filterGroups": [
{
"__typename": "FilterGroup",
"columnInfo": {
"__typename": "FilterColumn",
"aggregationType": "NONE",
"calendarGuid": "",
"dataType": "CHAR",
"description": null,
"formulaId": "",
"isAggregateApplied": false,
"isMasked": null,
"isStrictDateColumn": false,
"name": "product",
"referencedColumns": [
{
"__typename": "EntityHeader",
"displayName": "product",
"guid": "085f9694-0d02-479e-973a-d216336e5253"
}
],
"referencedTables": [
{
"__typename": "EntityHeader",
"displayName": "(Sample) Retail - Apparel",
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca"
}
],
"timeBucket": "NO_BUCKET",
"type": "ATTRIBUTE"
},
"displayName": null,
"filters": [
{
"__typename": "Filter",
"dateFilterContent": [],
"filterContent": [
{
"__typename": "FilterContent",
"filterType": "EQ",
"negate": false,
"value": [
{
"__typename": "FilterContentValue",
"key": "f2 jackets"
}
]
}
],
"filterId": "7d0a505f-8289-5c79-b7f0-bc2f118d90d0"
}
],
"groupId": {
"__typename": "FilterGroupId",
"answerColumnId": "bba4be57-6156-48a3-9e69-a2775237772a",
"dataSourceId": null,
"logicalColumnId": null
},
"isEditable": true,
"isMandatory": null,
"isSingleValue": null,
"sourceContainerId": null
},
{
"__typename": "FilterGroup",
"columnInfo": {
"__typename": "FilterColumn",
"aggregationType": "NONE",
"calendarGuid": "",
"dataType": "CHAR",
"description": null,
"formulaId": "",
"isAggregateApplied": false,
"isMasked": null,
"isStrictDateColumn": false,
"name": "zip code",
"referencedColumns": [
{
"__typename": "EntityHeader",
"displayName": "zip code",
"guid": "6f09ed23-a8d8-4017-8887-e3fd983cc58c"
}
],
"referencedTables": [
{
"__typename": "EntityHeader",
"displayName": "(Sample) Retail - Apparel",
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca"
}
],
"timeBucket": "NO_BUCKET",
"type": "ATTRIBUTE"
},
"displayName": null,
"filters": [
{
"__typename": "Filter",
"dateFilterContent": [],
"filterContent": [
{
"__typename": "FilterContent",
"filterType": "EQ",
"negate": false,
"value": [
{
"__typename": "FilterContentValue",
"key": "63144"
}
]
}
],
"filterId": "e1581fc4-3ea1-5d8a-8b47-679d9559dda8"
}
],
"groupId": {
"__typename": "FilterGroupId",
"answerColumnId": "b870f86f-8947-450d-b4e9-56bc9d2562a6",
"dataSourceId": null,
"logicalColumnId": null
},
"isEditable": true,
"isMandatory": null,
"isSingleValue": null,
"sourceContainerId": null
},
{
"__typename": "FilterGroup",
"columnInfo": {
"__typename": "FilterColumn",
"aggregationType": "NONE",
"calendarGuid": "bfa39848-ba4f-46d8-80fd-b695064e61b7",
"dataType": "DATE",
"description": null,
"formulaId": "",
"isAggregateApplied": false,
"isMasked": null,
"isStrictDateColumn": false,
"name": "date",
"referencedColumns": [
{
"__typename": "EntityHeader",
"displayName": "date",
"guid": "a0314a96-e56c-4dc2-af0d-ee14a444e4fe"
}
],
"referencedTables": [
{
"__typename": "EntityHeader",
"displayName": "(Sample) Retail - Apparel",
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca"
}
],
"timeBucket": "NO_BUCKET",
"type": "ATTRIBUTE"
},
"displayName": null,
"filters": [
{
"__typename": "Filter",
"dateFilterContent": [
{
"__typename": "DateFilterContent",
"dateFilter": {
"__typename": "DateFilterValue",
"datePeriod": "DAY",
"dateRange": {
"__typename": "FilterDateRange",
"highEpoch": "1773792000",
"lowEpoch": "1773705600"
},
"epoch": null,
"forEachPeriod": "NUM_DATE_PERIODS",
"hasUnprocessedTemporalValues": false,
"includeCurrentPeriod": false,
"monthName": "",
"number": 0,
"op": "EQ",
"quarterName": "",
"type": "YESTERDAY",
"weekDayName": "",
"yearName": ""
},
"negate": false
}
],
"filterContent": [
{
"__typename": "FilterContent",
"filterType": "BW_INC_MIN",
"negate": false,
"value": [
{
"__typename": "FilterContentValue",
"key": "1773705600"
},
{
"__typename": "FilterContentValue",
"key": "1773792000"
}
]
}
],
"filterId": "0a32e1f0-7a0a-5785-8c6c-13bb5dfa6a28"
}
],
"groupId": {
"__typename": "FilterGroupId",
"answerColumnId": "21ee5724-10b2-41ee-8008-a6cc1129959b",
"dataSourceId": null,
"logicalColumnId": null
},
"isEditable": true,
"isMandatory": null,
"isSingleValue": null,
"sourceContainerId": null
}
],
"formulas": [],
"hashKey": "",
"headlineVisibilityMap": [
{
"__typename": "HeadlineVisibility",
"columnId": "bac67a4f-2e89-456a-8b62-6df830ff4e1b",
"isVisible": true
}
],
"id": "60d9622c-6028-498c-8269-426d09cf6780",
"inScopeParameters": [],
"incompeleteAnswerDetails": {
"__typename": "IncompeleteAnswerDetails",
"brokenTokenDetails": null
},
"metadata": {
"__typename": "AnswerMetadata",
"author": "",
"authorId": "0000083e-e253-10af-aa97-5e45d512ebbd",
"createdAt": null,
"generationNum": "-1",
"isDiscoverable": false,
"isHidden": false,
"modifiedAt": null,
"tags": [],
"type": ""
},
"name": "Total sales",
"orderedChips": [
{
"__typename": "Chip",
"objectId": "b870f86f-8947-450d-b4e9-56bc9d2562a6",
"type": "FILTER"
},
{
"__typename": "Chip",
"objectId": "21ee5724-10b2-41ee-8008-a6cc1129959b",
"type": "FILTER"
},
{
"__typename": "Chip",
"objectId": "bba4be57-6156-48a3-9e69-a2775237772a",
"type": "FILTER"
}
],
"parameters": [],
"pathAnalysisConfig": null,
"permission": {
"__typename": "ObjectPermission",
"dataSourceAccessLevel": "READ_ONLY",
"dataSourceNamesWithNoAccess": [],
"objectAccessLevel": "MODIFY"
},
"phrases": [
{
"__typename": "SagePhrase",
"isAmbiguous": false,
"isComplete": true,
"tokens": [
{
"__typename": "SageToken",
"column": {
"__typename": "ColumnInfo",
"columnGuid": "de1b3cfd-1725-400a-b6c7-0cd0f2b70bf1",
"name": "sales"
},
"dataType": "DOUBLE",
"hasSpaceAfter": true,
"isExtensible": false,
"isFromCohort": false,
"isFromFormula": false,
"recognizedTokenJson": {
"token": "sales",
"typeEnum": "MEASURE",
"dataType": "DOUBLE",
"guid": "de1b3cfd-1725-400a-b6c7-0cd0f2b70bf1",
"outputGuid": "bac67a4f-2e89-456a-8b62-6df830ff4e1b",
"joinPath": [
{
"rootTable": {
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca"
},
"leafTable": {
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca"
}
}
],
"tokenMetadata": {
"name": "sales",
"table": {
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca",
"name": "(Sample) Retail - Apparel"
},
"rootTables": [
{
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca",
"name": "(Sample) Retail - Apparel"
}
],
"isFormula": false
},
"hasSpaceAfter": true,
"canonicalForm": "sales",
"idxInPrevQuery": 0,
"whiteSpaceSuffix": {
"type": "SINGLE_SPACE"
}
},
"source": {
"__typename": "SourceInfo",
"id": "cd252e5c-b552-49a8-821d-3eadaa049cca",
"name": "(Sample) Retail - Apparel"
},
"text": "sales",
"trailingWhitespace": " ",
"type": "MEASURE"
}
],
"type": "AGGREGATED_COLUMN_PHRASE"
},
{
"__typename": "SagePhrase",
"isAmbiguous": false,
"isComplete": true,
"tokens": [
{
"__typename": "SageToken",
"column": {
"__typename": "ColumnInfo",
"columnGuid": "085f9694-0d02-479e-973a-d216336e5253",
"name": "product"
},
"dataType": "CHAR",
"hasSpaceAfter": true,
"isExtensible": false,
"isFromCohort": false,
"isFromFormula": false,
"recognizedTokenJson": {
"token": "product",
"typeEnum": "ATTRIBUTE",
"dataType": "CHAR",
"guid": "085f9694-0d02-479e-973a-d216336e5253",
"outputGuid": "bba4be57-6156-48a3-9e69-a2775237772a",
"joinPath": [
{
"rootTable": {
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca"
},
"leafTable": {
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca"
}
}
],
"tokenMetadata": {
"name": "product",
"table": {
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca",
"name": "(Sample) Retail - Apparel"
},
"rootTables": [
{
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca",
"name": "(Sample) Retail - Apparel"
}
],
"isFormula": false
},
"hasSpaceAfter": true,
"canonicalForm": "product",
"idxInPrevQuery": 1,
"whiteSpaceSuffix": {
"type": "SINGLE_SPACE"
}
},
"source": {
"__typename": "SourceInfo",
"id": "cd252e5c-b552-49a8-821d-3eadaa049cca",
"name": "(Sample) Retail - Apparel"
},
"text": "product",
"trailingWhitespace": " ",
"type": "ATTRIBUTE"
},
{
"__typename": "SageToken",
"column": {
"__typename": "ColumnInfo",
"columnGuid": "",
"name": null
},
"dataType": "UNKNOWN",
"hasSpaceAfter": true,
"isExtensible": false,
"isFromCohort": false,
"isFromFormula": false,
"recognizedTokenJson": {
"token": "=",
"typeEnum": "OPERATOR",
"hasSpaceAfter": true,
"canonicalForm": "=",
"idxInPrevQuery": 2,
"whiteSpaceSuffix": {
"type": "SINGLE_SPACE"
}
},
"source": {
"__typename": "SourceInfo",
"id": null,
"name": null
},
"text": "=",
"trailingWhitespace": " ",
"type": "OPERATOR"
},
{
"__typename": "SageToken",
"column": {
"__typename": "ColumnInfo",
"columnGuid": "085f9694-0d02-479e-973a-d216336e5253",
"name": "product"
},
"dataType": "CHAR",
"hasSpaceAfter": true,
"isExtensible": false,
"isFromCohort": false,
"isFromFormula": false,
"recognizedTokenJson": {
"token": "'f2 jackets'",
"typeEnum": "VALUE",
"dataType": "CHAR",
"matchType": "EXACT",
"guid": "085f9694-0d02-479e-973a-d216336e5253",
"outputGuid": "bba4be57-6156-48a3-9e69-a2775237772a",
"joinPath": [
{
"rootTable": {
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca"
},
"leafTable": {
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca"
}
}
],
"tokenMetadata": {
"name": "product",
"table": {
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca",
"name": "(Sample) Retail - Apparel"
},
"rootTables": [
{
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca",
"name": "(Sample) Retail - Apparel"
}
],
"isFormula": false
},
"valueMatch": true,
"requiresDelimiters": true,
"hasSpaceAfter": true,
"canonicalForm": "'f2 jackets'",
"idxInPrevQuery": 3,
"whiteSpaceSuffix": {
"type": "SINGLE_SPACE"
},
"isCohort": false
},
"source": {
"__typename": "SourceInfo",
"id": "cd252e5c-b552-49a8-821d-3eadaa049cca",
"name": "(Sample) Retail - Apparel"
},
"text": "'f2 jackets'",
"trailingWhitespace": " ",
"type": "VALUE"
}
],
"type": "FILTER_PHRASE"
},
{
"__typename": "SagePhrase",
"isAmbiguous": false,
"isComplete": true,
"tokens": [
{
"__typename": "SageToken",
"column": {
"__typename": "ColumnInfo",
"columnGuid": "6f09ed23-a8d8-4017-8887-e3fd983cc58c",
"name": "zip code"
},
"dataType": "CHAR",
"hasSpaceAfter": true,
"isExtensible": false,
"isFromCohort": false,
"isFromFormula": false,
"recognizedTokenJson": {
"token": "zip code",
"typeEnum": "ATTRIBUTE",
"dataType": "CHAR",
"guid": "6f09ed23-a8d8-4017-8887-e3fd983cc58c",
"outputGuid": "b870f86f-8947-450d-b4e9-56bc9d2562a6",
"joinPath": [
{
"rootTable": {
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca"
},
"leafTable": {
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca"
}
}
],
"tokenMetadata": {
"name": "zip code",
"table": {
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca",
"name": "(Sample) Retail - Apparel"
},
"rootTables": [
{
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca",
"name": "(Sample) Retail - Apparel"
}
],
"isFormula": false
},
"hasSpaceAfter": true,
"canonicalForm": "zip code",
"idxInPrevQuery": 4,
"whiteSpaceSuffix": {
"type": "SINGLE_SPACE"
}
},
"source": {
"__typename": "SourceInfo",
"id": "cd252e5c-b552-49a8-821d-3eadaa049cca",
"name": "(Sample) Retail - Apparel"
},
"text": "zip code",
"trailingWhitespace": " ",
"type": "ATTRIBUTE"
},
{
"__typename": "SageToken",
"column": {
"__typename": "ColumnInfo",
"columnGuid": "",
"name": null
},
"dataType": "UNKNOWN",
"hasSpaceAfter": true,
"isExtensible": false,
"isFromCohort": false,
"isFromFormula": false,
"recognizedTokenJson": {
"token": "=",
"typeEnum": "OPERATOR",
"hasSpaceAfter": true,
"canonicalForm": "=",
"idxInPrevQuery": 5,
"whiteSpaceSuffix": {
"type": "SINGLE_SPACE"
}
},
"source": {
"__typename": "SourceInfo",
"id": null,
"name": null
},
"text": "=",
"trailingWhitespace": " ",
"type": "OPERATOR"
},
{
"__typename": "SageToken",
"column": {
"__typename": "ColumnInfo",
"columnGuid": "6f09ed23-a8d8-4017-8887-e3fd983cc58c",
"name": "zip code"
},
"dataType": "CHAR",
"hasSpaceAfter": true,
"isExtensible": false,
"isFromCohort": false,
"isFromFormula": false,
"recognizedTokenJson": {
"token": "'63144'",
"typeEnum": "VALUE",
"dataType": "CHAR",
"matchType": "EXACT",
"guid": "6f09ed23-a8d8-4017-8887-e3fd983cc58c",
"outputGuid": "b870f86f-8947-450d-b4e9-56bc9d2562a6",
"joinPath": [
{
"rootTable": {
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca"
},
"leafTable": {
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca"
}
}
],
"tokenMetadata": {
"name": "zip code",
"table": {
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca",
"name": "(Sample) Retail - Apparel"
},
"rootTables": [
{
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca",
"name": "(Sample) Retail - Apparel"
}
],
"isFormula": false
},
"valueMatch": true,
"requiresDelimiters": true,
"hasSpaceAfter": true,
"canonicalForm": "'63144'",
"idxInPrevQuery": 6,
"whiteSpaceSuffix": {
"type": "SINGLE_SPACE"
},
"isCohort": false
},
"source": {
"__typename": "SourceInfo",
"id": "cd252e5c-b552-49a8-821d-3eadaa049cca",
"name": "(Sample) Retail - Apparel"
},
"text": "'63144'",
"trailingWhitespace": " ",
"type": "VALUE"
}
],
"type": "FILTER_PHRASE"
},
{
"__typename": "SagePhrase",
"isAmbiguous": false,
"isComplete": true,
"tokens": [
{
"__typename": "SageToken",
"column": {
"__typename": "ColumnInfo",
"columnGuid": "a0314a96-e56c-4dc2-af0d-ee14a444e4fe",
"name": "date"
},
"dataType": "DATE",
"hasSpaceAfter": true,
"isExtensible": false,
"isFromCohort": false,
"isFromFormula": false,
"recognizedTokenJson": {
"token": "date",
"typeEnum": "ATTRIBUTE",
"dataType": "DATE",
"guid": "a0314a96-e56c-4dc2-af0d-ee14a444e4fe",
"outputGuid": "21ee5724-10b2-41ee-8008-a6cc1129959b",
"joinPath": [
{
"rootTable": {
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca"
},
"leafTable": {
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca"
}
}
],
"tokenMetadata": {
"name": "date",
"table": {
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca",
"name": "(Sample) Retail - Apparel"
},
"rootTables": [
{
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca",
"name": "(Sample) Retail - Apparel"
}
],
"isFormula": false
},
"hasSpaceAfter": true,
"canonicalForm": "date",
"idxInPrevQuery": 7,
"whiteSpaceSuffix": {
"type": "SINGLE_SPACE"
}
},
"source": {
"__typename": "SourceInfo",
"id": "cd252e5c-b552-49a8-821d-3eadaa049cca",
"name": "(Sample) Retail - Apparel"
},
"text": "date",
"trailingWhitespace": " ",
"type": "ATTRIBUTE"
},
{
"__typename": "SageToken",
"column": {
"__typename": "ColumnInfo",
"columnGuid": "",
"name": null
},
"dataType": "UNKNOWN",
"hasSpaceAfter": true,
"isExtensible": false,
"isFromCohort": false,
"isFromFormula": false,
"recognizedTokenJson": {
"token": "=",
"typeEnum": "OPERATOR",
"hasSpaceAfter": true,
"canonicalForm": "=",
"idxInPrevQuery": 8,
"whiteSpaceSuffix": {
"type": "SINGLE_SPACE"
}
},
"source": {
"__typename": "SourceInfo",
"id": null,
"name": null
},
"text": "=",
"trailingWhitespace": " ",
"type": "OPERATOR"
},
{
"__typename": "SageToken",
"column": {
"__typename": "ColumnInfo",
"columnGuid": "a0314a96-e56c-4dc2-af0d-ee14a444e4fe",
"name": "date"
},
"dataType": "DATE",
"hasSpaceAfter": true,
"isExtensible": false,
"isFromCohort": false,
"isFromFormula": false,
"recognizedTokenJson": {
"token": "yesterday",
"typeEnum": "VALUE",
"dataType": "DATE",
"matchType": "EXACT",
"guid": "a0314a96-e56c-4dc2-af0d-ee14a444e4fe",
"outputGuid": "21ee5724-10b2-41ee-8008-a6cc1129959b",
"joinPath": [
{
"rootTable": {
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca"
},
"leafTable": {
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca"
}
}
],
"tokenMetadata": {
"name": "date",
"table": {
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca",
"name": "(Sample) Retail - Apparel"
},
"rootTables": [
{
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca",
"name": "(Sample) Retail - Apparel"
}
],
"isFormula": false
},
"valueMatch": false,
"hasSpaceAfter": true,
"canBeExtended": false,
"dateFilter": {
"type": "YESTERDAY",
"op": "EQ"
},
"canonicalForm": "yesterday",
"idxInPrevQuery": 9,
"whiteSpaceSuffix": {
"type": "SINGLE_SPACE"
},
"isCohort": false
},
"source": {
"__typename": "SourceInfo",
"id": "cd252e5c-b552-49a8-821d-3eadaa049cca",
"name": "(Sample) Retail - Apparel"
},
"text": "yesterday",
"trailingWhitespace": " ",
"type": "VALUE"
}
],
"type": "FILTER_PHRASE"
}
],
"phrasesTimestamp": "1773817179992",
"queryableDataSource": "RDBMS_SNOWFLAKE",
"selectedColumns": [
{
"__typename": "SelectedColumn",
"guid": "de1b3cfd-1725-400a-b6c7-0cd0f2b70bf1"
}
],
"selectedFormulas": [],
"sortInfo": [],
"sources": [
{
"__typename": "Source",
"author": {
"__typename": "EntityHeader",
"displayName": "System User",
"guid": "67e15c06-d153-4924-a4cd-ff615393b60f"
},
"header": {
"__typename": "EntityHeader",
"description": null,
"displayName": "(Sample) Retail - Apparel",
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca"
},
"isAccessible": true,
"schema": {
"__typename": "EntityHeader",
"description": null,
"displayName": null,
"guid": null
}
}
],
"suggestedDisplayMode": "CHART_MODE",
"visualizations": [
{
"__typename": "TableViz",
"clientState": {},
"columns": [
{
"__typename": "VizColumn",
"column": {
"__typename": "AnswerColumn",
"aggregationType": "SUM",
"baseColumnType": "SAGE_COLUMN",
"calendarGuid": "",
"chartSpecificColumnType": "UNDEFINED",
"columnProps": {
"__typename": "AnswerColumnProps",
"columnProperties": null,
"version": "V1"
},
"customCalendarType": null,
"customOrder": [],
"dataType": "DOUBLE",
"dynamicTitle": "",
"format": null,
"formatPattern": null,
"formatType": null,
"formulaId": "",
"geoConfig": null,
"id": "bac67a4f-2e89-456a-8b62-6df830ff4e1b",
"isAdditive": true,
"isAggregateApplied": true,
"isGroupBy": false,
"isMandatory": false,
"isStrictDateColumn": false,
"isTimeBucketRestricted": false,
"isUserDefinedTitle": false,
"legacyColumnFormatProperties": null,
"legacySheetProperties": null,
"name": "Total sales",
"referencedColumns": [
{
"__typename": "EntityHeader",
"description": "",
"displayName": "sales",
"guid": "de1b3cfd-1725-400a-b6c7-0cd0f2b70bf1"
}
],
"referencedTables": [
{
"__typename": "EntityHeader",
"description": "",
"displayName": "(Sample) Retail - Apparel",
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca"
}
],
"showGrowth": false,
"timeBucket": "NO_BUCKET",
"type": "MEASURE",
"uniqueValues": "-1"
},
"legacyMetricDefinition": null
}
],
"id": "aeedf2f8-8f90-42c3-b681-eb96d97038a0",
"sortInfo": [],
"topInfo": [],
"visualOverrides": {
"__typename": "TableVisualOverrides",
"overrides": null
},
"vizProp": {
"__typename": "TableVizProps",
"columnProperties": [],
"density": null,
"orderedColumnIds": [],
"showGridSummary": null,
"showTableFooter": null,
"tableVizPropVersion": "V1",
"theme": null,
"widthState": [],
"wrapTableHeader": null
}
},
{
"__typename": "HeadlineViz",
"aggregationType": [
"SUM"
],
"headlineColumn": {
"__typename": "AnswerColumn",
"aggregationType": "SUM",
"baseColumnType": "SAGE_COLUMN",
"calendarGuid": "",
"chartSpecificColumnType": "UNDEFINED",
"columnProps": {
"__typename": "AnswerColumnProps",
"columnProperties": null,
"version": "V1"
},
"customCalendarType": null,
"customOrder": [],
"dataType": "DOUBLE",
"dynamicTitle": "",
"format": null,
"formatPattern": null,
"formatType": null,
"formulaId": "",
"geoConfig": null,
"id": "bac67a4f-2e89-456a-8b62-6df830ff4e1b",
"isAdditive": true,
"isAggregateApplied": true,
"isGroupBy": false,
"isMandatory": false,
"isStrictDateColumn": false,
"isTimeBucketRestricted": false,
"isUserDefinedTitle": false,
"legacyColumnFormatProperties": null,
"legacySheetProperties": null,
"name": "Total sales",
"referencedColumns": [
{
"__typename": "EntityHeader",
"description": "",
"displayName": "sales",
"guid": "de1b3cfd-1725-400a-b6c7-0cd0f2b70bf1"
}
],
"referencedTables": [
{
"__typename": "EntityHeader",
"description": "",
"displayName": "(Sample) Retail - Apparel",
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca"
}
],
"showGrowth": false,
"timeBucket": "NO_BUCKET",
"type": "MEASURE",
"uniqueValues": "-1"
},
"id": "d8164286-f1f9-450f-99cb-c5e8c260e1b2",
"possibleAggregations": [
"SUM",
"AVERAGE",
"STD_DEVIATION",
"VARIANCE",
"MIN",
"MAX"
],
"showPossibleAggregates": false,
"sortInfo": [],
"title": "Headline Total sales",
"visualOverrides": {
"__typename": "HeadlineVisualOverrides",
"overrides": null
},
"vizProp": {
"__typename": "HeadlineVizProps",
"columnProperty": null,
"headlineVizPropVersion": "V1"
}
},
{
"__typename": "ChartViz",
"clientState": {},
"columns": [
{
"__typename": "VizColumn",
"column": {
"__typename": "AnswerColumn",
"aggregationType": "SUM",
"baseColumnType": "SAGE_COLUMN",
"calendarGuid": "",
"chartSpecificColumnType": "UNDEFINED",
"columnProps": {
"__typename": "AnswerColumnProps",
"columnProperties": null,
"version": "V1"
},
"customCalendarType": null,
"customOrder": [],
"dataType": "DOUBLE",
"dynamicTitle": "",
"format": null,
"formatPattern": null,
"formatType": null,
"formulaId": "",
"geoConfig": null,
"id": "bac67a4f-2e89-456a-8b62-6df830ff4e1b",
"isAdditive": true,
"isAggregateApplied": true,
"isGroupBy": false,
"isMandatory": false,
"isStrictDateColumn": false,
"isTimeBucketRestricted": false,
"isUserDefinedTitle": false,
"legacyColumnFormatProperties": null,
"legacySheetProperties": null,
"name": "Total sales",
"referencedColumns": [
{
"__typename": "EntityHeader",
"description": "",
"displayName": "sales",
"guid": "de1b3cfd-1725-400a-b6c7-0cd0f2b70bf1"
}
],
"referencedTables": [
{
"__typename": "EntityHeader",
"description": "",
"displayName": "(Sample) Retail - Apparel",
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca"
}
],
"showGrowth": false,
"timeBucket": "NO_BUCKET",
"type": "MEASURE",
"uniqueValues": "-1"
},
"legacyMetricDefinition": null
},
{
"__typename": "VizColumn",
"column": {
"__typename": "AnswerColumn",
"aggregationType": "NONE",
"baseColumnType": "VIZ_SPECIFIC_COLUMN",
"calendarGuid": "",
"chartSpecificColumnType": "MEASURE_NAMES",
"columnProps": {
"__typename": "AnswerColumnProps",
"columnProperties": null,
"version": "V1"
},
"customCalendarType": null,
"customOrder": [],
"dataType": "CHAR",
"dynamicTitle": "",
"format": null,
"formatPattern": null,
"formatType": null,
"formulaId": "",
"geoConfig": null,
"id": "dd8bb852-d70d-4269-9bae-11953323d7bd",
"isAdditive": false,
"isAggregateApplied": false,
"isGroupBy": false,
"isMandatory": false,
"isStrictDateColumn": false,
"isTimeBucketRestricted": false,
"isUserDefinedTitle": false,
"legacyColumnFormatProperties": null,
"legacySheetProperties": null,
"name": "Measure names",
"referencedColumns": [],
"referencedTables": [],
"showGrowth": false,
"timeBucket": "NO_BUCKET",
"type": "ATTRIBUTE",
"uniqueValues": null
},
"legacyMetricDefinition": null
},
{
"__typename": "VizColumn",
"column": {
"__typename": "AnswerColumn",
"aggregationType": "NONE",
"baseColumnType": "VIZ_SPECIFIC_COLUMN",
"calendarGuid": "",
"chartSpecificColumnType": "MEASURE_VALUES",
"columnProps": {
"__typename": "AnswerColumnProps",
"columnProperties": null,
"version": "V1"
},
"customCalendarType": null,
"customOrder": [],
"dataType": "DOUBLE",
"dynamicTitle": "",
"format": null,
"formatPattern": null,
"formatType": null,
"formulaId": "",
"geoConfig": null,
"id": "55ea0d3d-84fa-4734-b929-5f9a39f2d35d",
"isAdditive": false,
"isAggregateApplied": false,
"isGroupBy": false,
"isMandatory": false,
"isStrictDateColumn": false,
"isTimeBucketRestricted": false,
"isUserDefinedTitle": false,
"legacyColumnFormatProperties": null,
"legacySheetProperties": null,
"name": "Measure values",
"referencedColumns": [],
"referencedTables": [],
"showGrowth": false,
"timeBucket": "NO_BUCKET",
"type": "MEASURE",
"uniqueValues": null
},
"legacyMetricDefinition": null
}
],
"config": {
"__typename": "ChartConfig",
"axisConfig": [
{
"__typename": "AxisConfig",
"category": [],
"color": [],
"measureValues": [],
"size": null,
"sort": [],
"x": [],
"y": [
{
"__typename": "AnswerColumn",
"aggregationType": "SUM",
"baseColumnType": "SAGE_COLUMN",
"calendarGuid": "",
"chartSpecificColumnType": "UNDEFINED",
"columnProps": {
"__typename": "AnswerColumnProps",
"columnProperties": null,
"version": "V1"
},
"customCalendarType": null,
"customOrder": [],
"dataType": "DOUBLE",
"dynamicTitle": "",
"format": null,
"formatPattern": null,
"formatType": null,
"formulaId": "",
"geoConfig": null,
"id": "bac67a4f-2e89-456a-8b62-6df830ff4e1b",
"isAdditive": true,
"isAggregateApplied": true,
"isGroupBy": false,
"isMandatory": false,
"isStrictDateColumn": false,
"isTimeBucketRestricted": false,
"isUserDefinedTitle": false,
"legacyColumnFormatProperties": null,
"legacySheetProperties": null,
"name": "Total sales",
"referencedColumns": [
{
"__typename": "EntityHeader",
"description": "",
"displayName": "sales",
"guid": "de1b3cfd-1725-400a-b6c7-0cd0f2b70bf1"
}
],
"referencedTables": [
{
"__typename": "EntityHeader",
"description": "",
"displayName": "(Sample) Retail - Apparel",
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca"
}
],
"showGrowth": false,
"timeBucket": "NO_BUCKET",
"type": "MEASURE",
"uniqueValues": "-1"
}
]
}
],
"chartType": "KPI",
"customChartConfig": null,
"customChartGuid": "",
"customChartManifest": null,
"isLocked": false
},
"customVisualProps": {},
"id": "60d9622c-6028-498c-8269-426d09cf6780",
"sortInfo": [],
"sortOrder": [],
"topInfo": [],
"visualOverrides": {
"__typename": "ChartVisualOverrides",
"defaults": null,
"overrides": null
},
"vizProp": {
"__typename": "ChartVizProps",
"axisProperties": [
{
"__typename": "AxisObj",
"id": "c6619d19-d1ff-4103-b9e1-c0f34920e5c6",
"properties": {
"__typename": "AxisProperties",
"axisType": "Y",
"customProps": null,
"dynamicTitle": null,
"format": null,
"isOpposite": false,
"linkedColumns": [
"bac67a4f-2e89-456a-8b62-6df830ff4e1b"
],
"name": null,
"yAxisRange": null
}
},
{
"__typename": "AxisObj",
"id": "36440c20-e309-4ea4-a7f6-ef3ac3ce9937",
"properties": {
"__typename": "AxisProperties",
"axisType": "X",
"customProps": null,
"dynamicTitle": null,
"format": null,
"isOpposite": null,
"linkedColumns": [],
"name": null,
"yAxisRange": null
}
}
],
"chartProperties": {
"__typename": "ChartProperties",
"allLabels": null,
"axisExtremes": null,
"chartSpecific": {
"__typename": "ChartSpecificProperties",
"customProps": null,
"dataFieldArea": null,
"hidePivotSummaries": null,
"isHeatmapOverlayed": null,
"isStackedAsPercent": null,
"markersEnabled": null,
"pivotState": null,
"pivotSummariesState": {
"__typename": "PivotSummariesState",
"showColumnGrandTotals": null,
"showColumnTotals": null,
"showRowGrandTotals": null,
"showRowTotals": null
},
"showPivotSummaryPrior": null,
"stackedAsPercentFormat": null,
"summaryFormat": null,
"summaryMode": null,
"useFlatLayout": null
},
"dataSize": null,
"gridLines": null,
"isZoomed": null,
"kpiDisplayProperties": {
"__typename": "KpiDisplayProperties",
"changeInterpretation": "UPWARD_IS_GOOD",
"kpiDisplayColorArray": [],
"showChange": true,
"showChangeAs": "PERCENT"
},
"legendPosition": null,
"mapviewport": null,
"responsiveLayoutDisabled": null,
"responsiveLayoutPreference": null,
"showLegend": null,
"showLinearRegressionLine": null,
"showStackedLabels": null,
"visibleSeriesNames": []
},
"columnProperties": [
{
"columnId": "bac67a4f-2e89-456a-8b62-6df830ff4e1b",
"columnProperty": {
"__typename": "ChartVizColumnProperties",
"conditionalFormatting": null,
"customProps": null,
"dataLabels": null,
"excludeNullValues": null,
"handleMissingValues": null,
"kpiColumnProperties": {
"__typename": "KpiColumnProperties",
"abbreviatedPreviousDate": null,
"handleNullData": null,
"showAbbreviatedPreviousDate": null,
"showComparisonDate": true,
"showCurrentDateLabel": true,
"showPreviousDateLabel": true,
"showPreviousValue": true,
"showSparkline": true
}
}
},
{
"columnId": "dd8bb852-d70d-4269-9bae-11953323d7bd",
"columnProperty": {
"__typename": "ChartVizColumnProperties",
"conditionalFormatting": null,
"customProps": null,
"dataLabels": null,
"excludeNullValues": null,
"handleMissingValues": null,
"kpiColumnProperties": {
"__typename": "KpiColumnProperties",
"abbreviatedPreviousDate": null,
"handleNullData": null,
"showAbbreviatedPreviousDate": null,
"showComparisonDate": true,
"showCurrentDateLabel": true,
"showPreviousDateLabel": true,
"showPreviousValue": true,
"showSparkline": true
}
}
},
{
"columnId": "55ea0d3d-84fa-4734-b929-5f9a39f2d35d",
"columnProperty": {
"__typename": "ChartVizColumnProperties",
"conditionalFormatting": null,
"customProps": null,
"dataLabels": null,
"excludeNullValues": null,
"handleMissingValues": null,
"kpiColumnProperties": {
"__typename": "KpiColumnProperties",
"abbreviatedPreviousDate": null,
"handleNullData": null,
"showAbbreviatedPreviousDate": null,
"showComparisonDate": true,
"showCurrentDateLabel": true,
"showPreviousDateLabel": true,
"showPreviousValue": true,
"showSparkline": true
}
}
}
],
"customColorSelectorArray": [],
"multiColorSeriesColors": [],
"seriesColors": [],
"systemMultiColorSeriesColors": [],
"systemSeriesColors": [],
"tooltipConfig": null,
"version": "V4DOT2"
}
}
],
"columns": [
{
"__typename": "VizColumn",
"column": {
"__typename": "AnswerColumn",
"dataType": "DOUBLE",
"id": "bac67a4f-2e89-456a-8b62-6df830ff4e1b",
"name": "Total sales",
"referencedColumns": [
{
"__typename": "EntityHeader",
"displayName": "sales"
}
],
"type": "MEASURE"
}
},
{
"__typename": "VizColumn",
"column": {
"__typename": "AnswerColumn",
"dataType": "CHAR",
"id": "dd8bb852-d70d-4269-9bae-11953323d7bd",
"name": "Measure names",
"referencedColumns": [],
"type": "ATTRIBUTE"
}
},
{
"__typename": "VizColumn",
"column": {
"__typename": "AnswerColumn",
"dataType": "DOUBLE",
"id": "55ea0d3d-84fa-4734-b929-5f9a39f2d35d",
"name": "Measure values",
"referencedColumns": [],
"type": "MEASURE"
}
}
],
"config": {
"__typename": "ChartConfig",
"chartType": "KPI"
},
"data": [
{
"columnDataLite": [
{
"columnDataType": "DOUBLE",
"columnId": "bac67a4f-2e89-456a-8b62-6df830ff4e1b",
"dataValue": [
0
]
}
],
"completionRatio": 1,
"queryPerfStats": {
"timeTakenCdw": [
{
"queryName": "f3e44987-e43a-31b5-86bf-18efd9a417d1",
"queryTimeTaken": "391"
},
{
"queryName": "0802bc97-9223-497c-9092-6ca75e4ed873",
"queryTimeTaken": "475"
}
],
"timeTakenDatamanager": "488"
},
"samplingRatio": 1,
"totalRowCount": "1"
}
],
"user": {
"userName": "rani.gangwar@thoughtspot.com",
"userGUID": "0000083e-e253-10af-aa97-5e45d512ebbd",
"userEmail": "rani.gangwar@thoughtspot.com"
},
"reportBookMetadata": {
"id": "44aadbc7-3b75-4897-9b2b-2a6ecad4fe31",
"description": "",
"metadata": {
"__typename": "AnswerMetadata",
"author": "",
"authorId": "0000083e-e253-10af-aa97-5e45d512ebbd",
"createdAt": null,
"generationNum": "-1",
"isDiscoverable": false,
"isHidden": false,
"modifiedAt": null,
"tags": [],
"type": ""
},
"name": "Total sales",
"suggestedDisplayMode": "CHART_MODE",
"visualizations": [
{
"__typename": "TableViz",
"clientState": {},
"columns": [
{
"__typename": "VizColumn",
"column": {
"__typename": "AnswerColumn",
"aggregationType": "SUM",
"baseColumnType": "SAGE_COLUMN",
"calendarGuid": "",
"chartSpecificColumnType": "UNDEFINED",
"columnProps": {
"__typename": "AnswerColumnProps",
"columnProperties": null,
"version": "V1"
},
"customCalendarType": null,
"customOrder": [],
"dataType": "DOUBLE",
"dynamicTitle": "",
"format": null,
"formatPattern": null,
"formatType": null,
"formulaId": "",
"geoConfig": null,
"id": "bac67a4f-2e89-456a-8b62-6df830ff4e1b",
"isAdditive": true,
"isAggregateApplied": true,
"isGroupBy": false,
"isMandatory": false,
"isStrictDateColumn": false,
"isTimeBucketRestricted": false,
"isUserDefinedTitle": false,
"legacyColumnFormatProperties": null,
"legacySheetProperties": null,
"name": "Total sales",
"referencedColumns": [
{
"__typename": "EntityHeader",
"description": "",
"displayName": "sales",
"guid": "de1b3cfd-1725-400a-b6c7-0cd0f2b70bf1"
}
],
"referencedTables": [
{
"__typename": "EntityHeader",
"description": "",
"displayName": "(Sample) Retail - Apparel",
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca"
}
],
"showGrowth": false,
"timeBucket": "NO_BUCKET",
"type": "MEASURE",
"uniqueValues": "-1"
},
"legacyMetricDefinition": null
}
],
"id": "aeedf2f8-8f90-42c3-b681-eb96d97038a0",
"sortInfo": [],
"topInfo": [],
"visualOverrides": {
"__typename": "TableVisualOverrides",
"overrides": null
},
"vizProp": {
"__typename": "TableVizProps",
"columnProperties": [],
"density": null,
"orderedColumnIds": [],
"showGridSummary": null,
"showTableFooter": null,
"tableVizPropVersion": "V1",
"theme": null,
"widthState": [],
"wrapTableHeader": null
}
},
{
"__typename": "HeadlineViz",
"aggregationType": [
"SUM"
],
"headlineColumn": {
"__typename": "AnswerColumn",
"aggregationType": "SUM",
"baseColumnType": "SAGE_COLUMN",
"calendarGuid": "",
"chartSpecificColumnType": "UNDEFINED",
"columnProps": {
"__typename": "AnswerColumnProps",
"columnProperties": null,
"version": "V1"
},
"customCalendarType": null,
"customOrder": [],
"dataType": "DOUBLE",
"dynamicTitle": "",
"format": null,
"formatPattern": null,
"formatType": null,
"formulaId": "",
"geoConfig": null,
"id": "bac67a4f-2e89-456a-8b62-6df830ff4e1b",
"isAdditive": true,
"isAggregateApplied": true,
"isGroupBy": false,
"isMandatory": false,
"isStrictDateColumn": false,
"isTimeBucketRestricted": false,
"isUserDefinedTitle": false,
"legacyColumnFormatProperties": null,
"legacySheetProperties": null,
"name": "Total sales",
"referencedColumns": [
{
"__typename": "EntityHeader",
"description": "",
"displayName": "sales",
"guid": "de1b3cfd-1725-400a-b6c7-0cd0f2b70bf1"
}
],
"referencedTables": [
{
"__typename": "EntityHeader",
"description": "",
"displayName": "(Sample) Retail - Apparel",
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca"
}
],
"showGrowth": false,
"timeBucket": "NO_BUCKET",
"type": "MEASURE",
"uniqueValues": "-1"
},
"id": "d8164286-f1f9-450f-99cb-c5e8c260e1b2",
"possibleAggregations": [
"SUM",
"AVERAGE",
"STD_DEVIATION",
"VARIANCE",
"MIN",
"MAX"
],
"showPossibleAggregates": false,
"sortInfo": [],
"title": "Headline Total sales",
"visualOverrides": {
"__typename": "HeadlineVisualOverrides",
"overrides": null
},
"vizProp": {
"__typename": "HeadlineVizProps",
"columnProperty": null,
"headlineVizPropVersion": "V1"
}
},
{
"__typename": "ChartViz",
"clientState": {},
"columns": [
{
"__typename": "VizColumn",
"column": {
"__typename": "AnswerColumn",
"aggregationType": "SUM",
"baseColumnType": "SAGE_COLUMN",
"calendarGuid": "",
"chartSpecificColumnType": "UNDEFINED",
"columnProps": {
"__typename": "AnswerColumnProps",
"columnProperties": null,
"version": "V1"
},
"customCalendarType": null,
"customOrder": [],
"dataType": "DOUBLE",
"dynamicTitle": "",
"format": null,
"formatPattern": null,
"formatType": null,
"formulaId": "",
"geoConfig": null,
"id": "bac67a4f-2e89-456a-8b62-6df830ff4e1b",
"isAdditive": true,
"isAggregateApplied": true,
"isGroupBy": false,
"isMandatory": false,
"isStrictDateColumn": false,
"isTimeBucketRestricted": false,
"isUserDefinedTitle": false,
"legacyColumnFormatProperties": null,
"legacySheetProperties": null,
"name": "Total sales",
"referencedColumns": [
{
"__typename": "EntityHeader",
"description": "",
"displayName": "sales",
"guid": "de1b3cfd-1725-400a-b6c7-0cd0f2b70bf1"
}
],
"referencedTables": [
{
"__typename": "EntityHeader",
"description": "",
"displayName": "(Sample) Retail - Apparel",
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca"
}
],
"showGrowth": false,
"timeBucket": "NO_BUCKET",
"type": "MEASURE",
"uniqueValues": "-1"
},
"legacyMetricDefinition": null
},
{
"__typename": "VizColumn",
"column": {
"__typename": "AnswerColumn",
"aggregationType": "NONE",
"baseColumnType": "VIZ_SPECIFIC_COLUMN",
"calendarGuid": "",
"chartSpecificColumnType": "MEASURE_NAMES",
"columnProps": {
"__typename": "AnswerColumnProps",
"columnProperties": null,
"version": "V1"
},
"customCalendarType": null,
"customOrder": [],
"dataType": "CHAR",
"dynamicTitle": "",
"format": null,
"formatPattern": null,
"formatType": null,
"formulaId": "",
"geoConfig": null,
"id": "dd8bb852-d70d-4269-9bae-11953323d7bd",
"isAdditive": false,
"isAggregateApplied": false,
"isGroupBy": false,
"isMandatory": false,
"isStrictDateColumn": false,
"isTimeBucketRestricted": false,
"isUserDefinedTitle": false,
"legacyColumnFormatProperties": null,
"legacySheetProperties": null,
"name": "Measure names",
"referencedColumns": [],
"referencedTables": [],
"showGrowth": false,
"timeBucket": "NO_BUCKET",
"type": "ATTRIBUTE",
"uniqueValues": null
},
"legacyMetricDefinition": null
},
{
"__typename": "VizColumn",
"column": {
"__typename": "AnswerColumn",
"aggregationType": "NONE",
"baseColumnType": "VIZ_SPECIFIC_COLUMN",
"calendarGuid": "",
"chartSpecificColumnType": "MEASURE_VALUES",
"columnProps": {
"__typename": "AnswerColumnProps",
"columnProperties": null,
"version": "V1"
},
"customCalendarType": null,
"customOrder": [],
"dataType": "DOUBLE",
"dynamicTitle": "",
"format": null,
"formatPattern": null,
"formatType": null,
"formulaId": "",
"geoConfig": null,
"id": "55ea0d3d-84fa-4734-b929-5f9a39f2d35d",
"isAdditive": false,
"isAggregateApplied": false,
"isGroupBy": false,
"isMandatory": false,
"isStrictDateColumn": false,
"isTimeBucketRestricted": false,
"isUserDefinedTitle": false,
"legacyColumnFormatProperties": null,
"legacySheetProperties": null,
"name": "Measure values",
"referencedColumns": [],
"referencedTables": [],
"showGrowth": false,
"timeBucket": "NO_BUCKET",
"type": "MEASURE",
"uniqueValues": null
},
"legacyMetricDefinition": null
}
],
"config": {
"__typename": "ChartConfig",
"axisConfig": [
{
"__typename": "AxisConfig",
"category": [],
"color": [],
"measureValues": [],
"size": null,
"sort": [],
"x": [],
"y": [
{
"__typename": "AnswerColumn",
"aggregationType": "SUM",
"baseColumnType": "SAGE_COLUMN",
"calendarGuid": "",
"chartSpecificColumnType": "UNDEFINED",
"columnProps": {
"__typename": "AnswerColumnProps",
"columnProperties": null,
"version": "V1"
},
"customCalendarType": null,
"customOrder": [],
"dataType": "DOUBLE",
"dynamicTitle": "",
"format": null,
"formatPattern": null,
"formatType": null,
"formulaId": "",
"geoConfig": null,
"id": "bac67a4f-2e89-456a-8b62-6df830ff4e1b",
"isAdditive": true,
"isAggregateApplied": true,
"isGroupBy": false,
"isMandatory": false,
"isStrictDateColumn": false,
"isTimeBucketRestricted": false,
"isUserDefinedTitle": false,
"legacyColumnFormatProperties": null,
"legacySheetProperties": null,
"name": "Total sales",
"referencedColumns": [
{
"__typename": "EntityHeader",
"description": "",
"displayName": "sales",
"guid": "de1b3cfd-1725-400a-b6c7-0cd0f2b70bf1"
}
],
"referencedTables": [
{
"__typename": "EntityHeader",
"description": "",
"displayName": "(Sample) Retail - Apparel",
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca"
}
],
"showGrowth": false,
"timeBucket": "NO_BUCKET",
"type": "MEASURE",
"uniqueValues": "-1"
}
]
}
],
"chartType": "KPI",
"customChartConfig": null,
"customChartGuid": "",
"customChartManifest": null,
"isLocked": false
},
"customVisualProps": {},
"id": "60d9622c-6028-498c-8269-426d09cf6780",
"sortInfo": [],
"sortOrder": [],
"suggestedConfig": [
{
"__typename": "ChartConfig",
"axisConfig": [
{
"__typename": "AxisConfig",
"category": [],
"color": [],
"measureValues": [],
"size": null,
"sort": [],
"x": [],
"y": [
{
"__typename": "AnswerColumn",
"aggregationType": "SUM",
"baseColumnType": "SAGE_COLUMN",
"calendarGuid": "",
"chartSpecificColumnType": "UNDEFINED",
"columnProps": {
"__typename": "AnswerColumnProps",
"columnProperties": null,
"version": "V1"
},
"customCalendarType": null,
"customOrder": [],
"dataType": "DOUBLE",
"dynamicTitle": "",
"format": null,
"formatPattern": null,
"formatType": null,
"formulaId": "",
"geoConfig": null,
"id": "bac67a4f-2e89-456a-8b62-6df830ff4e1b",
"isAdditive": true,
"isAggregateApplied": true,
"isGroupBy": false,
"isMandatory": false,
"isStrictDateColumn": false,
"isTimeBucketRestricted": false,
"isUserDefinedTitle": false,
"legacyColumnFormatProperties": null,
"legacySheetProperties": null,
"name": "Total sales",
"referencedColumns": [
{
"__typename": "EntityHeader",
"description": "",
"displayName": "sales",
"guid": "de1b3cfd-1725-400a-b6c7-0cd0f2b70bf1"
}
],
"referencedTables": [
{
"__typename": "EntityHeader",
"description": "",
"displayName": "(Sample) Retail - Apparel",
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca"
}
],
"showGrowth": false,
"timeBucket": "NO_BUCKET",
"type": "MEASURE",
"uniqueValues": "-1"
}
]
}
],
"chartType": "KPI",
"customChartConfig": null,
"customChartGuid": "",
"customChartManifest": null,
"isLocked": false
}
],
"topInfo": [],
"visualOverrides": {
"__typename": "ChartVisualOverrides",
"defaults": null,
"overrides": null
},
"vizProp": {
"__typename": "ChartVizProps",
"axisProperties": [
{
"__typename": "AxisObj",
"id": "c6619d19-d1ff-4103-b9e1-c0f34920e5c6",
"properties": {
"__typename": "AxisProperties",
"axisType": "Y",
"customProps": null,
"dynamicTitle": null,
"format": null,
"isOpposite": false,
"linkedColumns": [
"bac67a4f-2e89-456a-8b62-6df830ff4e1b"
],
"name": null,
"yAxisRange": null
}
},
{
"__typename": "AxisObj",
"id": "36440c20-e309-4ea4-a7f6-ef3ac3ce9937",
"properties": {
"__typename": "AxisProperties",
"axisType": "X",
"customProps": null,
"dynamicTitle": null,
"format": null,
"isOpposite": null,
"linkedColumns": [],
"name": null,
"yAxisRange": null
}
}
],
"chartProperties": {
"__typename": "ChartProperties",
"allLabels": null,
"axisExtremes": null,
"chartSpecific": {
"__typename": "ChartSpecificProperties",
"customProps": null,
"dataFieldArea": null,
"hidePivotSummaries": null,
"isHeatmapOverlayed": null,
"isStackedAsPercent": null,
"markersEnabled": null,
"pivotState": null,
"pivotSummariesState": {
"__typename": "PivotSummariesState",
"showColumnGrandTotals": null,
"showColumnTotals": null,
"showRowGrandTotals": null,
"showRowTotals": null
},
"showPivotSummaryPrior": null,
"stackedAsPercentFormat": null,
"summaryFormat": null,
"summaryMode": null,
"useFlatLayout": null
},
"dataSize": null,
"gridLines": null,
"isZoomed": null,
"kpiDisplayProperties": {
"__typename": "KpiDisplayProperties",
"changeInterpretation": "UPWARD_IS_GOOD",
"kpiDisplayColorArray": [],
"showChange": true,
"showChangeAs": "PERCENT"
},
"legendPosition": null,
"mapviewport": null,
"responsiveLayoutDisabled": null,
"responsiveLayoutPreference": null,
"showLegend": null,
"showLinearRegressionLine": null,
"showStackedLabels": null,
"visibleSeriesNames": []
},
"columnProperties": [
{
"columnId": "bac67a4f-2e89-456a-8b62-6df830ff4e1b",
"columnProperty": {
"__typename": "ChartVizColumnProperties",
"conditionalFormatting": null,
"customProps": null,
"dataLabels": null,
"excludeNullValues": null,
"handleMissingValues": null,
"kpiColumnProperties": {
"__typename": "KpiColumnProperties",
"abbreviatedPreviousDate": null,
"handleNullData": null,
"showAbbreviatedPreviousDate": null,
"showComparisonDate": true,
"showCurrentDateLabel": true,
"showPreviousDateLabel": true,
"showPreviousValue": true,
"showSparkline": true
}
}
},
{
"columnId": "dd8bb852-d70d-4269-9bae-11953323d7bd",
"columnProperty": {
"__typename": "ChartVizColumnProperties",
"conditionalFormatting": null,
"customProps": null,
"dataLabels": null,
"excludeNullValues": null,
"handleMissingValues": null,
"kpiColumnProperties": {
"__typename": "KpiColumnProperties",
"abbreviatedPreviousDate": null,
"handleNullData": null,
"showAbbreviatedPreviousDate": null,
"showComparisonDate": true,
"showCurrentDateLabel": true,
"showPreviousDateLabel": true,
"showPreviousValue": true,
"showSparkline": true
}
}
},
{
"columnId": "55ea0d3d-84fa-4734-b929-5f9a39f2d35d",
"columnProperty": {
"__typename": "ChartVizColumnProperties",
"conditionalFormatting": null,
"customProps": null,
"dataLabels": null,
"excludeNullValues": null,
"handleMissingValues": null,
"kpiColumnProperties": {
"__typename": "KpiColumnProperties",
"abbreviatedPreviousDate": null,
"handleNullData": null,
"showAbbreviatedPreviousDate": null,
"showComparisonDate": true,
"showCurrentDateLabel": true,
"showPreviousDateLabel": true,
"showPreviousValue": true,
"showSparkline": true
}
}
}
],
"customColorSelectorArray": [],
"multiColorSeriesColors": [],
"seriesColors": [],
"systemMultiColorSeriesColors": [],
"systemSeriesColors": [],
"tooltipConfig": null,
"version": "V4DOT2"
}
}
],
"headerMetadata": {
"id": "44aadbc7-3b75-4897-9b2b-2a6ecad4fe31",
"name": "Total sales",
"description": "",
"isNewAnswer": true,
"isHidden": false,
"displayMode": "CHART_MODE"
}
},
"isAnswerUnsaved": {
"hasUnsavedChanges": false
}
},
"operation": "GetChartWithData",
"session": {
"genNo": 2,
"sessionId": "4caa0015-b33e-4bb0-a193-b0cc99e79272",
"acSession": {
"sessionId": "1cb7a49a-704a-4d83-969e-56880708af25",
"genNo": 1
}
},
"query": "query GetChartWithData($session: BachSessionIdInput!, $batchSize: Int, $offset: Int! = 0, $deadline: Int!, $shouldFetchExtraColumnsData: Boolean, $singlePointKpi: SinglePointKpiParamsInput) {\n getAnswer(session: $session) {\n id {\n sessionId\n }\n answer {\n id\n queryableDataSource\n \n permission {\n ...permission\n }\n visualizations {\n id\n ... on ChartViz {\n data(\n deadline: $deadline\n pagination: {isClientPaginated: true, size: $batchSize, offset: $offset}\n shouldFetchExtraColumnsData: $shouldFetchExtraColumnsData\n singlePointKpi: $singlePointKpi\n )\n ...chartVizWithoutSuggestedConfig\n }\n }\n }\n }\n}\n\nfragment permission on ObjectPermission {\n objectAccessLevel\n dataSourceAccessLevel\n dataSourceNamesWithNoAccess\n}\n\nfragment chartVizWithoutSuggestedConfig on ChartViz {\n id\n sortOrder {\n columnId\n order\n isUserSorted\n sortAscending\n }\n columns {\n ...vizColumn\n }\n clientState\n customVisualProps\n vizProp {\n ...chartVizProps\n }\n config {\n ...chartConfig\n }\n sortInfo {\n columnId\n sortAscending\n category\n customOrder\n }\n topInfo {\n columnId\n sortAscending\n }\n visualOverrides {\n ...chartVisualOverrides\n }\n}\n\nfragment vizColumn on VizColumn {\n column {\n ...answerColumn\n }\n legacyMetricDefinition {\n row {\n color\n plotAsBand\n range {\n max\n min\n }\n }\n }\n}\n\nfragment answerColumn on AnswerColumn {\n id\n name\n type\n baseColumnType\n chartSpecificColumnType\n formulaId\n columnProps {\n version\n columnProperties {\n format {\n ...formatConfig\n }\n sortConfig\n }\n }\n dataType\n isAggregateApplied\n aggregationType\n formatPattern\n isGroupBy\n isUserDefinedTitle\n isAdditive\n showGrowth\n customCalendarType\n formatType\n calendarGuid\n format {\n pattern\n currencyFormat {\n column\n type\n isoCode\n }\n }\n referencedColumns {\n guid\n displayName\n description\n }\n referencedTables {\n guid\n displayName\n description\n }\n legacySheetProperties\n legacyColumnFormatProperties\n timeBucket\n geoConfig {\n type\n fixedValue\n columnGuid\n customFileGuid\n geometryType\n parent {\n type\n fixedValue\n columnGuid\n customFileGuid\n geometryType\n }\n }\n customOrder\n uniqueValues\n isMandatory\n isStrictDateColumn\n isTimeBucketRestricted\n dynamicTitle\n}\n\nfragment formatConfig on FormatConfig {\n category\n numberFormatConfig {\n decimals\n negativeValueFormat\n removeTrailingZeroes\n toSeparateThousands\n unit\n }\n percentageFormatConfig {\n decimals\n removeTrailingZeroes\n }\n currencyFormatConfig {\n decimals\n locale\n removeTrailingZeroes\n toSeparateThousands\n unit\n }\n customFormatConfig {\n format\n }\n isCategoryEditable\n}\n\nfragment chartVizProps on ChartVizProps {\n version\n axisProperties {\n id\n properties {\n axisType\n format {\n ...formatConfig\n }\n isOpposite\n customProps\n linkedColumns\n dynamicTitle\n name\n yAxisRange {\n max\n min\n }\n }\n }\n chartProperties {\n allLabels\n axisExtremes {\n x {\n max\n min\n }\n y {\n max\n min\n }\n }\n chartSpecific {\n customProps\n pivotState {\n columnExpandedPaths {\n paths\n }\n rowExpandedPaths {\n paths\n }\n fields {\n dataField\n sortBy\n sortBySummaryField\n sortBySummaryPath\n sortOrder\n expanded\n area\n }\n }\n useFlatLayout\n dataFieldArea\n hidePivotSummaries\n showPivotSummaryPrior\n pivotSummariesState {\n ...pivotSummariesState\n }\n isHeatmapOverlayed\n isStackedAsPercent\n markersEnabled\n stackedAsPercentFormat {\n ...formatConfig\n }\n summaryFormat {\n ...formatConfig\n }\n summaryMode\n }\n dataSize\n gridLines {\n xGridlineEnabled\n yGridlineEnabled\n }\n isZoomed\n mapviewport {\n center\n zoomLevel\n extent\n }\n responsiveLayoutDisabled\n responsiveLayoutPreference\n showLinearRegressionLine\n showStackedLabels\n visibleSeriesNames\n showLegend\n legendPosition\n kpiDisplayProperties {\n showChange\n showChangeAs\n changeInterpretation\n kpiDisplayColorArray\n }\n }\n columnProperties {\n columnId\n columnProperty {\n dataLabels\n conditionalFormatting {\n ...conditionalFormatting\n }\n handleMissingValues\n excludeNullValues\n customProps\n kpiColumnProperties {\n showAbbreviatedPreviousDate\n abbreviatedPreviousDate\n showSparkline\n showComparisonDate\n showCurrentDateLabel\n showPreviousDateLabel\n showPreviousValue\n handleNullData\n }\n }\n }\n customColorSelectorArray\n seriesColors {\n color\n serieName\n }\n multiColorSeriesColors {\n serieName\n colorMap {\n serieName\n color\n }\n }\n systemSeriesColors {\n color\n serieName\n }\n systemMultiColorSeriesColors {\n serieName\n colorMap {\n serieName\n color\n }\n }\n tooltipConfig {\n columnIds\n }\n}\n\nfragment pivotSummariesState on PivotSummariesState {\n showRowTotals\n showColumnTotals\n showRowGrandTotals\n showColumnGrandTotals\n}\n\nfragment conditionalFormatting on ConditionalFormatting {\n rows {\n comparisonType\n lhsColumnId\n rhsColumnId\n comparisonParameterId\n isHighlightRow\n backgroundFormatType\n value\n operator\n fontProperties {\n bold\n color\n italic\n strikeThrough\n underline\n }\n gradientBackgroundAttrs {\n isAutoScaled\n backgroundFormatRange\n backgroundFormatMidpoint\n colors\n }\n plotAsBand\n rangeValues {\n max\n min\n }\n solidBackgroundAttrs {\n color\n }\n }\n}\n\nfragment chartConfig on ChartConfig {\n chartType\n isLocked\n customChartGuid\n customChartManifest {\n ...customChartManifest\n }\n customChartConfig {\n ...customChartConfig\n }\n axisConfig {\n x {\n ...answerColumn\n }\n y {\n ...answerColumn\n }\n color {\n ...answerColumn\n }\n size {\n ...answerColumn\n }\n category {\n ...answerColumn\n }\n sort {\n ...answerColumn\n }\n measureValues {\n ...answerColumn\n }\n }\n}\n\nfragment customChartManifest on CustomChartManifest {\n id\n name\n description\n sourceUrl\n chartAppAccessToken\n iconUrl\n}\n\nfragment customChartConfig on CustomChartConfig {\n key\n dimensions {\n ...columnDrivenChartConfigDimension\n ...axisDrivenChartConfigDimension\n }\n}\n\nfragment columnDrivenChartConfigDimension on ColumnDrivenChartConfigDimension {\n key\n columns\n}\n\nfragment axisDrivenChartConfigDimension on AxisDrivenChartConfigDimension {\n key\n axes {\n ...flatAxis\n ...mergedAxis\n ...dualAxis\n }\n}\n\nfragment flatAxis on FlatAxis {\n column\n}\n\nfragment mergedAxis on MergedAxis {\n columns\n}\n\nfragment dualAxis on DualAxis {\n primary {\n ...flatAxis\n ...mergedAxis\n }\n secondary {\n ...flatAxis\n ...mergedAxis\n }\n}\n\nfragment chartVisualOverrides on ChartVisualOverrides {\n defaults {\n colorPalette {\n colors\n }\n }\n overrides {\n legendProperties {\n showLegend\n position\n }\n dataLabelProperties {\n allLabels\n stackLabelsProperties {\n isVisible\n }\n columnDataLabelProperties {\n columnId\n properties {\n isVisible\n filter {\n value\n operator\n }\n }\n }\n }\n axisProperties {\n linkedColumns\n properties {\n isNameVisible\n isLabelVisible\n yAxisRange {\n max\n min\n }\n }\n }\n displayProperties {\n summariesState {\n ...summariesState\n }\n regressionLineProperties {\n enabled\n }\n gridLineProperties {\n xGridlineEnabled\n yGridlineEnabled\n }\n }\n columnProperties {\n columnId\n properties {\n color\n conditionalFormatting {\n ...conditionalFormatting\n }\n }\n }\n }\n}\n\nfragment summariesState on SummariesState {\n showRowTotals\n showColumnTotals\n showRowGrandTotals\n showColumnGrandTotals\n}",
"convId": "RCDc8oDF94ri",
"messageId": "_0vAOWsBMY7g",
"callId": "GGiI0gYm4Ij2"
},
"status": "end",
"answerService": {
"session": {
"genNo": 2,
"sessionId": "4caa0015-b33e-4bb0-a193-b0cc99e79272",
"acSession": {
"sessionId": "1cb7a49a-704a-4d83-969e-56880708af25",
"genNo": 1
}
},
"thoughtSpotHost": "<ThoughtSpot-Host-URL>",
"tmlOverride": {},
"answer": {
"__typename": "ChartViz",
"clientState": {},
"cohorts": [],
"description": "",
"displayDescription": "",
"displayMode": "CHART_MODE",
"displayName": "",
"dynamicDescription": "",
"dynamicName": "",
"filterGroups": [
{
"__typename": "FilterGroup",
"columnInfo": {
"__typename": "FilterColumn",
"aggregationType": "NONE",
"calendarGuid": "",
"dataType": "CHAR",
"description": null,
"formulaId": "",
"isAggregateApplied": false,
"isMasked": null,
"isStrictDateColumn": false,
"name": "product",
"referencedColumns": [
{
"__typename": "EntityHeader",
"displayName": "product",
"guid": "085f9694-0d02-479e-973a-d216336e5253"
}
],
"referencedTables": [
{
"__typename": "EntityHeader",
"displayName": "(Sample) Retail - Apparel",
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca"
}
],
"timeBucket": "NO_BUCKET",
"type": "ATTRIBUTE"
},
"displayName": null,
"filters": [
{
"__typename": "Filter",
"dateFilterContent": [],
"filterContent": [
{
"__typename": "FilterContent",
"filterType": "EQ",
"negate": false,
"value": [
{
"__typename": "FilterContentValue",
"key": "f2 jackets"
}
]
}
],
"filterId": "7d0a505f-8289-5c79-b7f0-bc2f118d90d0"
}
],
"groupId": {
"__typename": "FilterGroupId",
"answerColumnId": "bba4be57-6156-48a3-9e69-a2775237772a",
"dataSourceId": null,
"logicalColumnId": null
},
"isEditable": true,
"isMandatory": null,
"isSingleValue": null,
"sourceContainerId": null
},
{
"__typename": "FilterGroup",
"columnInfo": {
"__typename": "FilterColumn",
"aggregationType": "NONE",
"calendarGuid": "",
"dataType": "CHAR",
"description": null,
"formulaId": "",
"isAggregateApplied": false,
"isMasked": null,
"isStrictDateColumn": false,
"name": "zip code",
"referencedColumns": [
{
"__typename": "EntityHeader",
"displayName": "zip code",
"guid": "6f09ed23-a8d8-4017-8887-e3fd983cc58c"
}
],
"referencedTables": [
{
"__typename": "EntityHeader",
"displayName": "(Sample) Retail - Apparel",
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca"
}
],
"timeBucket": "NO_BUCKET",
"type": "ATTRIBUTE"
},
"displayName": null,
"filters": [
{
"__typename": "Filter",
"dateFilterContent": [],
"filterContent": [
{
"__typename": "FilterContent",
"filterType": "EQ",
"negate": false,
"value": [
{
"__typename": "FilterContentValue",
"key": "63144"
}
]
}
],
"filterId": "e1581fc4-3ea1-5d8a-8b47-679d9559dda8"
}
],
"groupId": {
"__typename": "FilterGroupId",
"answerColumnId": "b870f86f-8947-450d-b4e9-56bc9d2562a6",
"dataSourceId": null,
"logicalColumnId": null
},
"isEditable": true,
"isMandatory": null,
"isSingleValue": null,
"sourceContainerId": null
},
{
"__typename": "FilterGroup",
"columnInfo": {
"__typename": "FilterColumn",
"aggregationType": "NONE",
"calendarGuid": "bfa39848-ba4f-46d8-80fd-b695064e61b7",
"dataType": "DATE",
"description": null,
"formulaId": "",
"isAggregateApplied": false,
"isMasked": null,
"isStrictDateColumn": false,
"name": "date",
"referencedColumns": [
{
"__typename": "EntityHeader",
"displayName": "date",
"guid": "a0314a96-e56c-4dc2-af0d-ee14a444e4fe"
}
],
"referencedTables": [
{
"__typename": "EntityHeader",
"displayName": "(Sample) Retail - Apparel",
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca"
}
],
"timeBucket": "NO_BUCKET",
"type": "ATTRIBUTE"
},
"displayName": null,
"filters": [
{
"__typename": "Filter",
"dateFilterContent": [
{
"__typename": "DateFilterContent",
"dateFilter": {
"__typename": "DateFilterValue",
"datePeriod": "DAY",
"dateRange": {
"__typename": "FilterDateRange",
"highEpoch": "1773792000",
"lowEpoch": "1773705600"
},
"epoch": null,
"forEachPeriod": "NUM_DATE_PERIODS",
"hasUnprocessedTemporalValues": false,
"includeCurrentPeriod": false,
"monthName": "",
"number": 0,
"op": "EQ",
"quarterName": "",
"type": "YESTERDAY",
"weekDayName": "",
"yearName": ""
},
"negate": false
}
],
"filterContent": [
{
"__typename": "FilterContent",
"filterType": "BW_INC_MIN",
"negate": false,
"value": [
{
"__typename": "FilterContentValue",
"key": "1773705600"
},
{
"__typename": "FilterContentValue",
"key": "1773792000"
}
]
}
],
"filterId": "0a32e1f0-7a0a-5785-8c6c-13bb5dfa6a28"
}
],
"groupId": {
"__typename": "FilterGroupId",
"answerColumnId": "21ee5724-10b2-41ee-8008-a6cc1129959b",
"dataSourceId": null,
"logicalColumnId": null
},
"isEditable": true,
"isMandatory": null,
"isSingleValue": null,
"sourceContainerId": null
}
],
"formulas": [],
"hashKey": "",
"headlineVisibilityMap": [
{
"__typename": "HeadlineVisibility",
"columnId": "bac67a4f-2e89-456a-8b62-6df830ff4e1b",
"isVisible": true
}
],
"id": "60d9622c-6028-498c-8269-426d09cf6780",
"inScopeParameters": [],
"incompeleteAnswerDetails": {
"__typename": "IncompeleteAnswerDetails",
"brokenTokenDetails": null
},
"metadata": {
"__typename": "AnswerMetadata",
"author": "",
"authorId": "0000083e-e253-10af-aa97-5e45d512ebbd",
"createdAt": null,
"generationNum": "-1",
"isDiscoverable": false,
"isHidden": false,
"modifiedAt": null,
"tags": [],
"type": ""
},
"name": "Total sales",
"orderedChips": [
{
"__typename": "Chip",
"objectId": "b870f86f-8947-450d-b4e9-56bc9d2562a6",
"type": "FILTER"
},
{
"__typename": "Chip",
"objectId": "21ee5724-10b2-41ee-8008-a6cc1129959b",
"type": "FILTER"
},
{
"__typename": "Chip",
"objectId": "bba4be57-6156-48a3-9e69-a2775237772a",
"type": "FILTER"
}
],
"parameters": [],
"pathAnalysisConfig": null,
"permission": {
"__typename": "ObjectPermission",
"dataSourceAccessLevel": "READ_ONLY",
"dataSourceNamesWithNoAccess": [],
"objectAccessLevel": "MODIFY"
},
"phrases": [
{
"__typename": "SagePhrase",
"isAmbiguous": false,
"isComplete": true,
"tokens": [
{
"__typename": "SageToken",
"column": {
"__typename": "ColumnInfo",
"columnGuid": "de1b3cfd-1725-400a-b6c7-0cd0f2b70bf1",
"name": "sales"
},
"dataType": "DOUBLE",
"hasSpaceAfter": true,
"isExtensible": false,
"isFromCohort": false,
"isFromFormula": false,
"recognizedTokenJson": {
"token": "sales",
"typeEnum": "MEASURE",
"dataType": "DOUBLE",
"guid": "de1b3cfd-1725-400a-b6c7-0cd0f2b70bf1",
"outputGuid": "bac67a4f-2e89-456a-8b62-6df830ff4e1b",
"joinPath": [
{
"rootTable": {
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca"
},
"leafTable": {
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca"
}
}
],
"tokenMetadata": {
"name": "sales",
"table": {
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca",
"name": "(Sample) Retail - Apparel"
},
"rootTables": [
{
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca",
"name": "(Sample) Retail - Apparel"
}
],
"isFormula": false
},
"hasSpaceAfter": true,
"canonicalForm": "sales",
"idxInPrevQuery": 0,
"whiteSpaceSuffix": {
"type": "SINGLE_SPACE"
}
},
"source": {
"__typename": "SourceInfo",
"id": "cd252e5c-b552-49a8-821d-3eadaa049cca",
"name": "(Sample) Retail - Apparel"
},
"text": "sales",
"trailingWhitespace": " ",
"type": "MEASURE"
}
],
"type": "AGGREGATED_COLUMN_PHRASE"
},
{
"__typename": "SagePhrase",
"isAmbiguous": false,
"isComplete": true,
"tokens": [
{
"__typename": "SageToken",
"column": {
"__typename": "ColumnInfo",
"columnGuid": "085f9694-0d02-479e-973a-d216336e5253",
"name": "product"
},
"dataType": "CHAR",
"hasSpaceAfter": true,
"isExtensible": false,
"isFromCohort": false,
"isFromFormula": false,
"recognizedTokenJson": {
"token": "product",
"typeEnum": "ATTRIBUTE",
"dataType": "CHAR",
"guid": "085f9694-0d02-479e-973a-d216336e5253",
"outputGuid": "bba4be57-6156-48a3-9e69-a2775237772a",
"joinPath": [
{
"rootTable": {
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca"
},
"leafTable": {
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca"
}
}
],
"tokenMetadata": {
"name": "product",
"table": {
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca",
"name": "(Sample) Retail - Apparel"
},
"rootTables": [
{
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca",
"name": "(Sample) Retail - Apparel"
}
],
"isFormula": false
},
"hasSpaceAfter": true,
"canonicalForm": "product",
"idxInPrevQuery": 1,
"whiteSpaceSuffix": {
"type": "SINGLE_SPACE"
}
},
"source": {
"__typename": "SourceInfo",
"id": "cd252e5c-b552-49a8-821d-3eadaa049cca",
"name": "(Sample) Retail - Apparel"
},
"text": "product",
"trailingWhitespace": " ",
"type": "ATTRIBUTE"
},
{
"__typename": "SageToken",
"column": {
"__typename": "ColumnInfo",
"columnGuid": "",
"name": null
},
"dataType": "UNKNOWN",
"hasSpaceAfter": true,
"isExtensible": false,
"isFromCohort": false,
"isFromFormula": false,
"recognizedTokenJson": {
"token": "=",
"typeEnum": "OPERATOR",
"hasSpaceAfter": true,
"canonicalForm": "=",
"idxInPrevQuery": 2,
"whiteSpaceSuffix": {
"type": "SINGLE_SPACE"
}
},
"source": {
"__typename": "SourceInfo",
"id": null,
"name": null
},
"text": "=",
"trailingWhitespace": " ",
"type": "OPERATOR"
},
{
"__typename": "SageToken",
"column": {
"__typename": "ColumnInfo",
"columnGuid": "085f9694-0d02-479e-973a-d216336e5253",
"name": "product"
},
"dataType": "CHAR",
"hasSpaceAfter": true,
"isExtensible": false,
"isFromCohort": false,
"isFromFormula": false,
"recognizedTokenJson": {
"token": "'f2 jackets'",
"typeEnum": "VALUE",
"dataType": "CHAR",
"matchType": "EXACT",
"guid": "085f9694-0d02-479e-973a-d216336e5253",
"outputGuid": "bba4be57-6156-48a3-9e69-a2775237772a",
"joinPath": [
{
"rootTable": {
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca"
},
"leafTable": {
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca"
}
}
],
"tokenMetadata": {
"name": "product",
"table": {
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca",
"name": "(Sample) Retail - Apparel"
},
"rootTables": [
{
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca",
"name": "(Sample) Retail - Apparel"
}
],
"isFormula": false
},
"valueMatch": true,
"requiresDelimiters": true,
"hasSpaceAfter": true,
"canonicalForm": "'f2 jackets'",
"idxInPrevQuery": 3,
"whiteSpaceSuffix": {
"type": "SINGLE_SPACE"
},
"isCohort": false
},
"source": {
"__typename": "SourceInfo",
"id": "cd252e5c-b552-49a8-821d-3eadaa049cca",
"name": "(Sample) Retail - Apparel"
},
"text": "'f2 jackets'",
"trailingWhitespace": " ",
"type": "VALUE"
}
],
"type": "FILTER_PHRASE"
},
{
"__typename": "SagePhrase",
"isAmbiguous": false,
"isComplete": true,
"tokens": [
{
"__typename": "SageToken",
"column": {
"__typename": "ColumnInfo",
"columnGuid": "6f09ed23-a8d8-4017-8887-e3fd983cc58c",
"name": "zip code"
},
"dataType": "CHAR",
"hasSpaceAfter": true,
"isExtensible": false,
"isFromCohort": false,
"isFromFormula": false,
"recognizedTokenJson": {
"token": "zip code",
"typeEnum": "ATTRIBUTE",
"dataType": "CHAR",
"guid": "6f09ed23-a8d8-4017-8887-e3fd983cc58c",
"outputGuid": "b870f86f-8947-450d-b4e9-56bc9d2562a6",
"joinPath": [
{
"rootTable": {
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca"
},
"leafTable": {
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca"
}
}
],
"tokenMetadata": {
"name": "zip code",
"table": {
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca",
"name": "(Sample) Retail - Apparel"
},
"rootTables": [
{
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca",
"name": "(Sample) Retail - Apparel"
}
],
"isFormula": false
},
"hasSpaceAfter": true,
"canonicalForm": "zip code",
"idxInPrevQuery": 4,
"whiteSpaceSuffix": {
"type": "SINGLE_SPACE"
}
},
"source": {
"__typename": "SourceInfo",
"id": "cd252e5c-b552-49a8-821d-3eadaa049cca",
"name": "(Sample) Retail - Apparel"
},
"text": "zip code",
"trailingWhitespace": " ",
"type": "ATTRIBUTE"
},
{
"__typename": "SageToken",
"column": {
"__typename": "ColumnInfo",
"columnGuid": "",
"name": null
},
"dataType": "UNKNOWN",
"hasSpaceAfter": true,
"isExtensible": false,
"isFromCohort": false,
"isFromFormula": false,
"recognizedTokenJson": {
"token": "=",
"typeEnum": "OPERATOR",
"hasSpaceAfter": true,
"canonicalForm": "=",
"idxInPrevQuery": 5,
"whiteSpaceSuffix": {
"type": "SINGLE_SPACE"
}
},
"source": {
"__typename": "SourceInfo",
"id": null,
"name": null
},
"text": "=",
"trailingWhitespace": " ",
"type": "OPERATOR"
},
{
"__typename": "SageToken",
"column": {
"__typename": "ColumnInfo",
"columnGuid": "6f09ed23-a8d8-4017-8887-e3fd983cc58c",
"name": "zip code"
},
"dataType": "CHAR",
"hasSpaceAfter": true,
"isExtensible": false,
"isFromCohort": false,
"isFromFormula": false,
"recognizedTokenJson": {
"token": "'63144'",
"typeEnum": "VALUE",
"dataType": "CHAR",
"matchType": "EXACT",
"guid": "6f09ed23-a8d8-4017-8887-e3fd983cc58c",
"outputGuid": "b870f86f-8947-450d-b4e9-56bc9d2562a6",
"joinPath": [
{
"rootTable": {
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca"
},
"leafTable": {
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca"
}
}
],
"tokenMetadata": {
"name": "zip code",
"table": {
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca",
"name": "(Sample) Retail - Apparel"
},
"rootTables": [
{
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca",
"name": "(Sample) Retail - Apparel"
}
],
"isFormula": false
},
"valueMatch": true,
"requiresDelimiters": true,
"hasSpaceAfter": true,
"canonicalForm": "'63144'",
"idxInPrevQuery": 6,
"whiteSpaceSuffix": {
"type": "SINGLE_SPACE"
},
"isCohort": false
},
"source": {
"__typename": "SourceInfo",
"id": "cd252e5c-b552-49a8-821d-3eadaa049cca",
"name": "(Sample) Retail - Apparel"
},
"text": "'63144'",
"trailingWhitespace": " ",
"type": "VALUE"
}
],
"type": "FILTER_PHRASE"
},
{
"__typename": "SagePhrase",
"isAmbiguous": false,
"isComplete": true,
"tokens": [
{
"__typename": "SageToken",
"column": {
"__typename": "ColumnInfo",
"columnGuid": "a0314a96-e56c-4dc2-af0d-ee14a444e4fe",
"name": "date"
},
"dataType": "DATE",
"hasSpaceAfter": true,
"isExtensible": false,
"isFromCohort": false,
"isFromFormula": false,
"recognizedTokenJson": {
"token": "date",
"typeEnum": "ATTRIBUTE",
"dataType": "DATE",
"guid": "a0314a96-e56c-4dc2-af0d-ee14a444e4fe",
"outputGuid": "21ee5724-10b2-41ee-8008-a6cc1129959b",
"joinPath": [
{
"rootTable": {
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca"
},
"leafTable": {
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca"
}
}
],
"tokenMetadata": {
"name": "date",
"table": {
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca",
"name": "(Sample) Retail - Apparel"
},
"rootTables": [
{
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca",
"name": "(Sample) Retail - Apparel"
}
],
"isFormula": false
},
"hasSpaceAfter": true,
"canonicalForm": "date",
"idxInPrevQuery": 7,
"whiteSpaceSuffix": {
"type": "SINGLE_SPACE"
}
},
"source": {
"__typename": "SourceInfo",
"id": "cd252e5c-b552-49a8-821d-3eadaa049cca",
"name": "(Sample) Retail - Apparel"
},
"text": "date",
"trailingWhitespace": " ",
"type": "ATTRIBUTE"
},
{
"__typename": "SageToken",
"column": {
"__typename": "ColumnInfo",
"columnGuid": "",
"name": null
},
"dataType": "UNKNOWN",
"hasSpaceAfter": true,
"isExtensible": false,
"isFromCohort": false,
"isFromFormula": false,
"recognizedTokenJson": {
"token": "=",
"typeEnum": "OPERATOR",
"hasSpaceAfter": true,
"canonicalForm": "=",
"idxInPrevQuery": 8,
"whiteSpaceSuffix": {
"type": "SINGLE_SPACE"
}
},
"source": {
"__typename": "SourceInfo",
"id": null,
"name": null
},
"text": "=",
"trailingWhitespace": " ",
"type": "OPERATOR"
},
{
"__typename": "SageToken",
"column": {
"__typename": "ColumnInfo",
"columnGuid": "a0314a96-e56c-4dc2-af0d-ee14a444e4fe",
"name": "date"
},
"dataType": "DATE",
"hasSpaceAfter": true,
"isExtensible": false,
"isFromCohort": false,
"isFromFormula": false,
"recognizedTokenJson": {
"token": "yesterday",
"typeEnum": "VALUE",
"dataType": "DATE",
"matchType": "EXACT",
"guid": "a0314a96-e56c-4dc2-af0d-ee14a444e4fe",
"outputGuid": "21ee5724-10b2-41ee-8008-a6cc1129959b",
"joinPath": [
{
"rootTable": {
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca"
},
"leafTable": {
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca"
}
}
],
"tokenMetadata": {
"name": "date",
"table": {
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca",
"name": "(Sample) Retail - Apparel"
},
"rootTables": [
{
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca",
"name": "(Sample) Retail - Apparel"
}
],
"isFormula": false
},
"valueMatch": false,
"hasSpaceAfter": true,
"canBeExtended": false,
"dateFilter": {
"type": "YESTERDAY",
"op": "EQ"
},
"canonicalForm": "yesterday",
"idxInPrevQuery": 9,
"whiteSpaceSuffix": {
"type": "SINGLE_SPACE"
},
"isCohort": false
},
"source": {
"__typename": "SourceInfo",
"id": "cd252e5c-b552-49a8-821d-3eadaa049cca",
"name": "(Sample) Retail - Apparel"
},
"text": "yesterday",
"trailingWhitespace": " ",
"type": "VALUE"
}
],
"type": "FILTER_PHRASE"
}
],
"phrasesTimestamp": "1773817179992",
"queryableDataSource": "RDBMS_SNOWFLAKE",
"selectedColumns": [
{
"__typename": "SelectedColumn",
"guid": "de1b3cfd-1725-400a-b6c7-0cd0f2b70bf1"
}
],
"selectedFormulas": [],
"sortInfo": [],
"sources": [
{
"__typename": "Source",
"author": {
"__typename": "EntityHeader",
"displayName": "System User",
"guid": "67e15c06-d153-4924-a4cd-ff615393b60f"
},
"header": {
"__typename": "EntityHeader",
"description": null,
"displayName": "(Sample) Retail - Apparel",
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca"
},
"isAccessible": true,
"schema": {
"__typename": "EntityHeader",
"description": null,
"displayName": null,
"guid": null
}
}
],
"suggestedDisplayMode": "CHART_MODE",
"visualizations": [
{
"__typename": "TableViz",
"clientState": {},
"columns": [
{
"__typename": "VizColumn",
"column": {
"__typename": "AnswerColumn",
"aggregationType": "SUM",
"baseColumnType": "SAGE_COLUMN",
"calendarGuid": "",
"chartSpecificColumnType": "UNDEFINED",
"columnProps": {
"__typename": "AnswerColumnProps",
"columnProperties": null,
"version": "V1"
},
"customCalendarType": null,
"customOrder": [],
"dataType": "DOUBLE",
"dynamicTitle": "",
"format": null,
"formatPattern": null,
"formatType": null,
"formulaId": "",
"geoConfig": null,
"id": "bac67a4f-2e89-456a-8b62-6df830ff4e1b",
"isAdditive": true,
"isAggregateApplied": true,
"isGroupBy": false,
"isMandatory": false,
"isStrictDateColumn": false,
"isTimeBucketRestricted": false,
"isUserDefinedTitle": false,
"legacyColumnFormatProperties": null,
"legacySheetProperties": null,
"name": "Total sales",
"referencedColumns": [
{
"__typename": "EntityHeader",
"description": "",
"displayName": "sales",
"guid": "de1b3cfd-1725-400a-b6c7-0cd0f2b70bf1"
}
],
"referencedTables": [
{
"__typename": "EntityHeader",
"description": "",
"displayName": "(Sample) Retail - Apparel",
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca"
}
],
"showGrowth": false,
"timeBucket": "NO_BUCKET",
"type": "MEASURE",
"uniqueValues": "-1"
},
"legacyMetricDefinition": null
}
],
"id": "aeedf2f8-8f90-42c3-b681-eb96d97038a0",
"sortInfo": [],
"topInfo": [],
"visualOverrides": {
"__typename": "TableVisualOverrides",
"overrides": null
},
"vizProp": {
"__typename": "TableVizProps",
"columnProperties": [],
"density": null,
"orderedColumnIds": [],
"showGridSummary": null,
"showTableFooter": null,
"tableVizPropVersion": "V1",
"theme": null,
"widthState": [],
"wrapTableHeader": null
}
},
{
"__typename": "HeadlineViz",
"aggregationType": [
"SUM"
],
"headlineColumn": {
"__typename": "AnswerColumn",
"aggregationType": "SUM",
"baseColumnType": "SAGE_COLUMN",
"calendarGuid": "",
"chartSpecificColumnType": "UNDEFINED",
"columnProps": {
"__typename": "AnswerColumnProps",
"columnProperties": null,
"version": "V1"
},
"customCalendarType": null,
"customOrder": [],
"dataType": "DOUBLE",
"dynamicTitle": "",
"format": null,
"formatPattern": null,
"formatType": null,
"formulaId": "",
"geoConfig": null,
"id": "bac67a4f-2e89-456a-8b62-6df830ff4e1b",
"isAdditive": true,
"isAggregateApplied": true,
"isGroupBy": false,
"isMandatory": false,
"isStrictDateColumn": false,
"isTimeBucketRestricted": false,
"isUserDefinedTitle": false,
"legacyColumnFormatProperties": null,
"legacySheetProperties": null,
"name": "Total sales",
"referencedColumns": [
{
"__typename": "EntityHeader",
"description": "",
"displayName": "sales",
"guid": "de1b3cfd-1725-400a-b6c7-0cd0f2b70bf1"
}
],
"referencedTables": [
{
"__typename": "EntityHeader",
"description": "",
"displayName": "(Sample) Retail - Apparel",
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca"
}
],
"showGrowth": false,
"timeBucket": "NO_BUCKET",
"type": "MEASURE",
"uniqueValues": "-1"
},
"id": "d8164286-f1f9-450f-99cb-c5e8c260e1b2",
"possibleAggregations": [
"SUM",
"AVERAGE",
"STD_DEVIATION",
"VARIANCE",
"MIN",
"MAX"
],
"showPossibleAggregates": false,
"sortInfo": [],
"title": "Headline Total sales",
"visualOverrides": {
"__typename": "HeadlineVisualOverrides",
"overrides": null
},
"vizProp": {
"__typename": "HeadlineVizProps",
"columnProperty": null,
"headlineVizPropVersion": "V1"
}
},
{
"__typename": "ChartViz",
"clientState": {},
"columns": [
{
"__typename": "VizColumn",
"column": {
"__typename": "AnswerColumn",
"aggregationType": "SUM",
"baseColumnType": "SAGE_COLUMN",
"calendarGuid": "",
"chartSpecificColumnType": "UNDEFINED",
"columnProps": {
"__typename": "AnswerColumnProps",
"columnProperties": null,
"version": "V1"
},
"customCalendarType": null,
"customOrder": [],
"dataType": "DOUBLE",
"dynamicTitle": "",
"format": null,
"formatPattern": null,
"formatType": null,
"formulaId": "",
"geoConfig": null,
"id": "bac67a4f-2e89-456a-8b62-6df830ff4e1b",
"isAdditive": true,
"isAggregateApplied": true,
"isGroupBy": false,
"isMandatory": false,
"isStrictDateColumn": false,
"isTimeBucketRestricted": false,
"isUserDefinedTitle": false,
"legacyColumnFormatProperties": null,
"legacySheetProperties": null,
"name": "Total sales",
"referencedColumns": [
{
"__typename": "EntityHeader",
"description": "",
"displayName": "sales",
"guid": "de1b3cfd-1725-400a-b6c7-0cd0f2b70bf1"
}
],
"referencedTables": [
{
"__typename": "EntityHeader",
"description": "",
"displayName": "(Sample) Retail - Apparel",
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca"
}
],
"showGrowth": false,
"timeBucket": "NO_BUCKET",
"type": "MEASURE",
"uniqueValues": "-1"
},
"legacyMetricDefinition": null
},
{
"__typename": "VizColumn",
"column": {
"__typename": "AnswerColumn",
"aggregationType": "NONE",
"baseColumnType": "VIZ_SPECIFIC_COLUMN",
"calendarGuid": "",
"chartSpecificColumnType": "MEASURE_NAMES",
"columnProps": {
"__typename": "AnswerColumnProps",
"columnProperties": null,
"version": "V1"
},
"customCalendarType": null,
"customOrder": [],
"dataType": "CHAR",
"dynamicTitle": "",
"format": null,
"formatPattern": null,
"formatType": null,
"formulaId": "",
"geoConfig": null,
"id": "dd8bb852-d70d-4269-9bae-11953323d7bd",
"isAdditive": false,
"isAggregateApplied": false,
"isGroupBy": false,
"isMandatory": false,
"isStrictDateColumn": false,
"isTimeBucketRestricted": false,
"isUserDefinedTitle": false,
"legacyColumnFormatProperties": null,
"legacySheetProperties": null,
"name": "Measure names",
"referencedColumns": [],
"referencedTables": [],
"showGrowth": false,
"timeBucket": "NO_BUCKET",
"type": "ATTRIBUTE",
"uniqueValues": null
},
"legacyMetricDefinition": null
},
{
"__typename": "VizColumn",
"column": {
"__typename": "AnswerColumn",
"aggregationType": "NONE",
"baseColumnType": "VIZ_SPECIFIC_COLUMN",
"calendarGuid": "",
"chartSpecificColumnType": "MEASURE_VALUES",
"columnProps": {
"__typename": "AnswerColumnProps",
"columnProperties": null,
"version": "V1"
},
"customCalendarType": null,
"customOrder": [],
"dataType": "DOUBLE",
"dynamicTitle": "",
"format": null,
"formatPattern": null,
"formatType": null,
"formulaId": "",
"geoConfig": null,
"id": "55ea0d3d-84fa-4734-b929-5f9a39f2d35d",
"isAdditive": false,
"isAggregateApplied": false,
"isGroupBy": false,
"isMandatory": false,
"isStrictDateColumn": false,
"isTimeBucketRestricted": false,
"isUserDefinedTitle": false,
"legacyColumnFormatProperties": null,
"legacySheetProperties": null,
"name": "Measure values",
"referencedColumns": [],
"referencedTables": [],
"showGrowth": false,
"timeBucket": "NO_BUCKET",
"type": "MEASURE",
"uniqueValues": null
},
"legacyMetricDefinition": null
}
],
"config": {
"__typename": "ChartConfig",
"axisConfig": [
{
"__typename": "AxisConfig",
"category": [],
"color": [],
"measureValues": [],
"size": null,
"sort": [],
"x": [],
"y": [
{
"__typename": "AnswerColumn",
"aggregationType": "SUM",
"baseColumnType": "SAGE_COLUMN",
"calendarGuid": "",
"chartSpecificColumnType": "UNDEFINED",
"columnProps": {
"__typename": "AnswerColumnProps",
"columnProperties": null,
"version": "V1"
},
"customCalendarType": null,
"customOrder": [],
"dataType": "DOUBLE",
"dynamicTitle": "",
"format": null,
"formatPattern": null,
"formatType": null,
"formulaId": "",
"geoConfig": null,
"id": "bac67a4f-2e89-456a-8b62-6df830ff4e1b",
"isAdditive": true,
"isAggregateApplied": true,
"isGroupBy": false,
"isMandatory": false,
"isStrictDateColumn": false,
"isTimeBucketRestricted": false,
"isUserDefinedTitle": false,
"legacyColumnFormatProperties": null,
"legacySheetProperties": null,
"name": "Total sales",
"referencedColumns": [
{
"__typename": "EntityHeader",
"description": "",
"displayName": "sales",
"guid": "de1b3cfd-1725-400a-b6c7-0cd0f2b70bf1"
}
],
"referencedTables": [
{
"__typename": "EntityHeader",
"description": "",
"displayName": "(Sample) Retail - Apparel",
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca"
}
],
"showGrowth": false,
"timeBucket": "NO_BUCKET",
"type": "MEASURE",
"uniqueValues": "-1"
}
]
}
],
"chartType": "KPI",
"customChartConfig": null,
"customChartGuid": "",
"customChartManifest": null,
"isLocked": false
},
"customVisualProps": {},
"id": "60d9622c-6028-498c-8269-426d09cf6780",
"sortInfo": [],
"sortOrder": [],
"topInfo": [],
"visualOverrides": {
"__typename": "ChartVisualOverrides",
"defaults": null,
"overrides": null
},
"vizProp": {
"__typename": "ChartVizProps",
"axisProperties": [
{
"__typename": "AxisObj",
"id": "c6619d19-d1ff-4103-b9e1-c0f34920e5c6",
"properties": {
"__typename": "AxisProperties",
"axisType": "Y",
"customProps": null,
"dynamicTitle": null,
"format": null,
"isOpposite": false,
"linkedColumns": [
"bac67a4f-2e89-456a-8b62-6df830ff4e1b"
],
"name": null,
"yAxisRange": null
}
},
{
"__typename": "AxisObj",
"id": "36440c20-e309-4ea4-a7f6-ef3ac3ce9937",
"properties": {
"__typename": "AxisProperties",
"axisType": "X",
"customProps": null,
"dynamicTitle": null,
"format": null,
"isOpposite": null,
"linkedColumns": [],
"name": null,
"yAxisRange": null
}
}
],
"chartProperties": {
"__typename": "ChartProperties",
"allLabels": null,
"axisExtremes": null,
"chartSpecific": {
"__typename": "ChartSpecificProperties",
"customProps": null,
"dataFieldArea": null,
"hidePivotSummaries": null,
"isHeatmapOverlayed": null,
"isStackedAsPercent": null,
"markersEnabled": null,
"pivotState": null,
"pivotSummariesState": {
"__typename": "PivotSummariesState",
"showColumnGrandTotals": null,
"showColumnTotals": null,
"showRowGrandTotals": null,
"showRowTotals": null
},
"showPivotSummaryPrior": null,
"stackedAsPercentFormat": null,
"summaryFormat": null,
"summaryMode": null,
"useFlatLayout": null
},
"dataSize": null,
"gridLines": null,
"isZoomed": null,
"kpiDisplayProperties": {
"__typename": "KpiDisplayProperties",
"changeInterpretation": "UPWARD_IS_GOOD",
"kpiDisplayColorArray": [],
"showChange": true,
"showChangeAs": "PERCENT"
},
"legendPosition": null,
"mapviewport": null,
"responsiveLayoutDisabled": null,
"responsiveLayoutPreference": null,
"showLegend": null,
"showLinearRegressionLine": null,
"showStackedLabels": null,
"visibleSeriesNames": []
},
"columnProperties": [
{
"columnId": "bac67a4f-2e89-456a-8b62-6df830ff4e1b",
"columnProperty": {
"__typename": "ChartVizColumnProperties",
"conditionalFormatting": null,
"customProps": null,
"dataLabels": null,
"excludeNullValues": null,
"handleMissingValues": null,
"kpiColumnProperties": {
"__typename": "KpiColumnProperties",
"abbreviatedPreviousDate": null,
"handleNullData": null,
"showAbbreviatedPreviousDate": null,
"showComparisonDate": true,
"showCurrentDateLabel": true,
"showPreviousDateLabel": true,
"showPreviousValue": true,
"showSparkline": true
}
}
},
{
"columnId": "dd8bb852-d70d-4269-9bae-11953323d7bd",
"columnProperty": {
"__typename": "ChartVizColumnProperties",
"conditionalFormatting": null,
"customProps": null,
"dataLabels": null,
"excludeNullValues": null,
"handleMissingValues": null,
"kpiColumnProperties": {
"__typename": "KpiColumnProperties",
"abbreviatedPreviousDate": null,
"handleNullData": null,
"showAbbreviatedPreviousDate": null,
"showComparisonDate": true,
"showCurrentDateLabel": true,
"showPreviousDateLabel": true,
"showPreviousValue": true,
"showSparkline": true
}
}
},
{
"columnId": "55ea0d3d-84fa-4734-b929-5f9a39f2d35d",
"columnProperty": {
"__typename": "ChartVizColumnProperties",
"conditionalFormatting": null,
"customProps": null,
"dataLabels": null,
"excludeNullValues": null,
"handleMissingValues": null,
"kpiColumnProperties": {
"__typename": "KpiColumnProperties",
"abbreviatedPreviousDate": null,
"handleNullData": null,
"showAbbreviatedPreviousDate": null,
"showComparisonDate": true,
"showCurrentDateLabel": true,
"showPreviousDateLabel": true,
"showPreviousValue": true,
"showSparkline": true
}
}
}
],
"customColorSelectorArray": [],
"multiColorSeriesColors": [],
"seriesColors": [],
"systemMultiColorSeriesColors": [],
"systemSeriesColors": [],
"tooltipConfig": null,
"version": "V4DOT2"
}
}
],
"columns": [
{
"__typename": "VizColumn",
"column": {
"__typename": "AnswerColumn",
"dataType": "DOUBLE",
"id": "bac67a4f-2e89-456a-8b62-6df830ff4e1b",
"name": "Total sales",
"referencedColumns": [
{
"__typename": "EntityHeader",
"displayName": "sales"
}
],
"type": "MEASURE"
}
},
{
"__typename": "VizColumn",
"column": {
"__typename": "AnswerColumn",
"dataType": "CHAR",
"id": "dd8bb852-d70d-4269-9bae-11953323d7bd",
"name": "Measure names",
"referencedColumns": [],
"type": "ATTRIBUTE"
}
},
{
"__typename": "VizColumn",
"column": {
"__typename": "AnswerColumn",
"dataType": "DOUBLE",
"id": "55ea0d3d-84fa-4734-b929-5f9a39f2d35d",
"name": "Measure values",
"referencedColumns": [],
"type": "MEASURE"
}
}
],
"config": {
"__typename": "ChartConfig",
"chartType": "KPI"
},
"data": [
{
"columnDataLite": [
{
"columnDataType": "DOUBLE",
"columnId": "bac67a4f-2e89-456a-8b62-6df830ff4e1b",
"dataValue": [
0
]
}
],
"completionRatio": 1,
"queryPerfStats": {
"timeTakenCdw": [
{
"queryName": "f3e44987-e43a-31b5-86bf-18efd9a417d1",
"queryTimeTaken": "391"
},
{
"queryName": "0802bc97-9223-497c-9092-6ca75e4ed873",
"queryTimeTaken": "475"
}
],
"timeTakenDatamanager": "488"
},
"samplingRatio": 1,
"totalRowCount": "1"
}
],
"user": {
"userName": "rani.gangwar@thoughtspot.com",
"userGUID": "0000083e-e253-10af-aa97-5e45d512ebbd",
"userEmail": "rani.gangwar@thoughtspot.com"
},
"reportBookMetadata": {
"id": "44aadbc7-3b75-4897-9b2b-2a6ecad4fe31",
"description": "",
"metadata": {
"__typename": "AnswerMetadata",
"author": "",
"authorId": "0000083e-e253-10af-aa97-5e45d512ebbd",
"createdAt": null,
"generationNum": "-1",
"isDiscoverable": false,
"isHidden": false,
"modifiedAt": null,
"tags": [],
"type": ""
},
"name": "Total sales",
"suggestedDisplayMode": "CHART_MODE",
"visualizations": [
{
"__typename": "TableViz",
"clientState": {},
"columns": [
{
"__typename": "VizColumn",
"column": {
"__typename": "AnswerColumn",
"aggregationType": "SUM",
"baseColumnType": "SAGE_COLUMN",
"calendarGuid": "",
"chartSpecificColumnType": "UNDEFINED",
"columnProps": {
"__typename": "AnswerColumnProps",
"columnProperties": null,
"version": "V1"
},
"customCalendarType": null,
"customOrder": [],
"dataType": "DOUBLE",
"dynamicTitle": "",
"format": null,
"formatPattern": null,
"formatType": null,
"formulaId": "",
"geoConfig": null,
"id": "bac67a4f-2e89-456a-8b62-6df830ff4e1b",
"isAdditive": true,
"isAggregateApplied": true,
"isGroupBy": false,
"isMandatory": false,
"isStrictDateColumn": false,
"isTimeBucketRestricted": false,
"isUserDefinedTitle": false,
"legacyColumnFormatProperties": null,
"legacySheetProperties": null,
"name": "Total sales",
"referencedColumns": [
{
"__typename": "EntityHeader",
"description": "",
"displayName": "sales",
"guid": "de1b3cfd-1725-400a-b6c7-0cd0f2b70bf1"
}
],
"referencedTables": [
{
"__typename": "EntityHeader",
"description": "",
"displayName": "(Sample) Retail - Apparel",
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca"
}
],
"showGrowth": false,
"timeBucket": "NO_BUCKET",
"type": "MEASURE",
"uniqueValues": "-1"
},
"legacyMetricDefinition": null
}
],
"id": "aeedf2f8-8f90-42c3-b681-eb96d97038a0",
"sortInfo": [],
"topInfo": [],
"visualOverrides": {
"__typename": "TableVisualOverrides",
"overrides": null
},
"vizProp": {
"__typename": "TableVizProps",
"columnProperties": [],
"density": null,
"orderedColumnIds": [],
"showGridSummary": null,
"showTableFooter": null,
"tableVizPropVersion": "V1",
"theme": null,
"widthState": [],
"wrapTableHeader": null
}
},
{
"__typename": "HeadlineViz",
"aggregationType": [
"SUM"
],
"headlineColumn": {
"__typename": "AnswerColumn",
"aggregationType": "SUM",
"baseColumnType": "SAGE_COLUMN",
"calendarGuid": "",
"chartSpecificColumnType": "UNDEFINED",
"columnProps": {
"__typename": "AnswerColumnProps",
"columnProperties": null,
"version": "V1"
},
"customCalendarType": null,
"customOrder": [],
"dataType": "DOUBLE",
"dynamicTitle": "",
"format": null,
"formatPattern": null,
"formatType": null,
"formulaId": "",
"geoConfig": null,
"id": "bac67a4f-2e89-456a-8b62-6df830ff4e1b",
"isAdditive": true,
"isAggregateApplied": true,
"isGroupBy": false,
"isMandatory": false,
"isStrictDateColumn": false,
"isTimeBucketRestricted": false,
"isUserDefinedTitle": false,
"legacyColumnFormatProperties": null,
"legacySheetProperties": null,
"name": "Total sales",
"referencedColumns": [
{
"__typename": "EntityHeader",
"description": "",
"displayName": "sales",
"guid": "de1b3cfd-1725-400a-b6c7-0cd0f2b70bf1"
}
],
"referencedTables": [
{
"__typename": "EntityHeader",
"description": "",
"displayName": "(Sample) Retail - Apparel",
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca"
}
],
"showGrowth": false,
"timeBucket": "NO_BUCKET",
"type": "MEASURE",
"uniqueValues": "-1"
},
"id": "d8164286-f1f9-450f-99cb-c5e8c260e1b2",
"possibleAggregations": [
"SUM",
"AVERAGE",
"STD_DEVIATION",
"VARIANCE",
"MIN",
"MAX"
],
"showPossibleAggregates": false,
"sortInfo": [],
"title": "Headline Total sales",
"visualOverrides": {
"__typename": "HeadlineVisualOverrides",
"overrides": null
},
"vizProp": {
"__typename": "HeadlineVizProps",
"columnProperty": null,
"headlineVizPropVersion": "V1"
}
},
{
"__typename": "ChartViz",
"clientState": {},
"columns": [
{
"__typename": "VizColumn",
"column": {
"__typename": "AnswerColumn",
"aggregationType": "SUM",
"baseColumnType": "SAGE_COLUMN",
"calendarGuid": "",
"chartSpecificColumnType": "UNDEFINED",
"columnProps": {
"__typename": "AnswerColumnProps",
"columnProperties": null,
"version": "V1"
},
"customCalendarType": null,
"customOrder": [],
"dataType": "DOUBLE",
"dynamicTitle": "",
"format": null,
"formatPattern": null,
"formatType": null,
"formulaId": "",
"geoConfig": null,
"id": "bac67a4f-2e89-456a-8b62-6df830ff4e1b",
"isAdditive": true,
"isAggregateApplied": true,
"isGroupBy": false,
"isMandatory": false,
"isStrictDateColumn": false,
"isTimeBucketRestricted": false,
"isUserDefinedTitle": false,
"legacyColumnFormatProperties": null,
"legacySheetProperties": null,
"name": "Total sales",
"referencedColumns": [
{
"__typename": "EntityHeader",
"description": "",
"displayName": "sales",
"guid": "de1b3cfd-1725-400a-b6c7-0cd0f2b70bf1"
}
],
"referencedTables": [
{
"__typename": "EntityHeader",
"description": "",
"displayName": "(Sample) Retail - Apparel",
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca"
}
],
"showGrowth": false,
"timeBucket": "NO_BUCKET",
"type": "MEASURE",
"uniqueValues": "-1"
},
"legacyMetricDefinition": null
},
{
"__typename": "VizColumn",
"column": {
"__typename": "AnswerColumn",
"aggregationType": "NONE",
"baseColumnType": "VIZ_SPECIFIC_COLUMN",
"calendarGuid": "",
"chartSpecificColumnType": "MEASURE_NAMES",
"columnProps": {
"__typename": "AnswerColumnProps",
"columnProperties": null,
"version": "V1"
},
"customCalendarType": null,
"customOrder": [],
"dataType": "CHAR",
"dynamicTitle": "",
"format": null,
"formatPattern": null,
"formatType": null,
"formulaId": "",
"geoConfig": null,
"id": "dd8bb852-d70d-4269-9bae-11953323d7bd",
"isAdditive": false,
"isAggregateApplied": false,
"isGroupBy": false,
"isMandatory": false,
"isStrictDateColumn": false,
"isTimeBucketRestricted": false,
"isUserDefinedTitle": false,
"legacyColumnFormatProperties": null,
"legacySheetProperties": null,
"name": "Measure names",
"referencedColumns": [],
"referencedTables": [],
"showGrowth": false,
"timeBucket": "NO_BUCKET",
"type": "ATTRIBUTE",
"uniqueValues": null
},
"legacyMetricDefinition": null
},
{
"__typename": "VizColumn",
"column": {
"__typename": "AnswerColumn",
"aggregationType": "NONE",
"baseColumnType": "VIZ_SPECIFIC_COLUMN",
"calendarGuid": "",
"chartSpecificColumnType": "MEASURE_VALUES",
"columnProps": {
"__typename": "AnswerColumnProps",
"columnProperties": null,
"version": "V1"
},
"customCalendarType": null,
"customOrder": [],
"dataType": "DOUBLE",
"dynamicTitle": "",
"format": null,
"formatPattern": null,
"formatType": null,
"formulaId": "",
"geoConfig": null,
"id": "55ea0d3d-84fa-4734-b929-5f9a39f2d35d",
"isAdditive": false,
"isAggregateApplied": false,
"isGroupBy": false,
"isMandatory": false,
"isStrictDateColumn": false,
"isTimeBucketRestricted": false,
"isUserDefinedTitle": false,
"legacyColumnFormatProperties": null,
"legacySheetProperties": null,
"name": "Measure values",
"referencedColumns": [],
"referencedTables": [],
"showGrowth": false,
"timeBucket": "NO_BUCKET",
"type": "MEASURE",
"uniqueValues": null
},
"legacyMetricDefinition": null
}
],
"config": {
"__typename": "ChartConfig",
"axisConfig": [
{
"__typename": "AxisConfig",
"category": [],
"color": [],
"measureValues": [],
"size": null,
"sort": [],
"x": [],
"y": [
{
"__typename": "AnswerColumn",
"aggregationType": "SUM",
"baseColumnType": "SAGE_COLUMN",
"calendarGuid": "",
"chartSpecificColumnType": "UNDEFINED",
"columnProps": {
"__typename": "AnswerColumnProps",
"columnProperties": null,
"version": "V1"
},
"customCalendarType": null,
"customOrder": [],
"dataType": "DOUBLE",
"dynamicTitle": "",
"format": null,
"formatPattern": null,
"formatType": null,
"formulaId": "",
"geoConfig": null,
"id": "bac67a4f-2e89-456a-8b62-6df830ff4e1b",
"isAdditive": true,
"isAggregateApplied": true,
"isGroupBy": false,
"isMandatory": false,
"isStrictDateColumn": false,
"isTimeBucketRestricted": false,
"isUserDefinedTitle": false,
"legacyColumnFormatProperties": null,
"legacySheetProperties": null,
"name": "Total sales",
"referencedColumns": [
{
"__typename": "EntityHeader",
"description": "",
"displayName": "sales",
"guid": "de1b3cfd-1725-400a-b6c7-0cd0f2b70bf1"
}
],
"referencedTables": [
{
"__typename": "EntityHeader",
"description": "",
"displayName": "(Sample) Retail - Apparel",
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca"
}
],
"showGrowth": false,
"timeBucket": "NO_BUCKET",
"type": "MEASURE",
"uniqueValues": "-1"
}
]
}
],
"chartType": "KPI",
"customChartConfig": null,
"customChartGuid": "",
"customChartManifest": null,
"isLocked": false
},
"customVisualProps": {},
"id": "60d9622c-6028-498c-8269-426d09cf6780",
"sortInfo": [],
"sortOrder": [],
"suggestedConfig": [
{
"__typename": "ChartConfig",
"axisConfig": [
{
"__typename": "AxisConfig",
"category": [],
"color": [],
"measureValues": [],
"size": null,
"sort": [],
"x": [],
"y": [
{
"__typename": "AnswerColumn",
"aggregationType": "SUM",
"baseColumnType": "SAGE_COLUMN",
"calendarGuid": "",
"chartSpecificColumnType": "UNDEFINED",
"columnProps": {
"__typename": "AnswerColumnProps",
"columnProperties": null,
"version": "V1"
},
"customCalendarType": null,
"customOrder": [],
"dataType": "DOUBLE",
"dynamicTitle": "",
"format": null,
"formatPattern": null,
"formatType": null,
"formulaId": "",
"geoConfig": null,
"id": "bac67a4f-2e89-456a-8b62-6df830ff4e1b",
"isAdditive": true,
"isAggregateApplied": true,
"isGroupBy": false,
"isMandatory": false,
"isStrictDateColumn": false,
"isTimeBucketRestricted": false,
"isUserDefinedTitle": false,
"legacyColumnFormatProperties": null,
"legacySheetProperties": null,
"name": "Total sales",
"referencedColumns": [
{
"__typename": "EntityHeader",
"description": "",
"displayName": "sales",
"guid": "de1b3cfd-1725-400a-b6c7-0cd0f2b70bf1"
}
],
"referencedTables": [
{
"__typename": "EntityHeader",
"description": "",
"displayName": "(Sample) Retail - Apparel",
"guid": "cd252e5c-b552-49a8-821d-3eadaa049cca"
}
],
"showGrowth": false,
"timeBucket": "NO_BUCKET",
"type": "MEASURE",
"uniqueValues": "-1"
}
]
}
],
"chartType": "KPI",
"customChartConfig": null,
"customChartGuid": "",
"customChartManifest": null,
"isLocked": false
}
],
"topInfo": [],
"visualOverrides": {
"__typename": "ChartVisualOverrides",
"defaults": null,
"overrides": null
},
"vizProp": {
"__typename": "ChartVizProps",
"axisProperties": [
{
"__typename": "AxisObj",
"id": "c6619d19-d1ff-4103-b9e1-c0f34920e5c6",
"properties": {
"__typename": "AxisProperties",
"axisType": "Y",
"customProps": null,
"dynamicTitle": null,
"format": null,
"isOpposite": false,
"linkedColumns": [
"bac67a4f-2e89-456a-8b62-6df830ff4e1b"
],
"name": null,
"yAxisRange": null
}
},
{
"__typename": "AxisObj",
"id": "36440c20-e309-4ea4-a7f6-ef3ac3ce9937",
"properties": {
"__typename": "AxisProperties",
"axisType": "X",
"customProps": null,
"dynamicTitle": null,
"format": null,
"isOpposite": null,
"linkedColumns": [],
"name": null,
"yAxisRange": null
}
}
],
"chartProperties": {
"__typename": "ChartProperties",
"allLabels": null,
"axisExtremes": null,
"chartSpecific": {
"__typename": "ChartSpecificProperties",
"customProps": null,
"dataFieldArea": null,
"hidePivotSummaries": null,
"isHeatmapOverlayed": null,
"isStackedAsPercent": null,
"markersEnabled": null,
"pivotState": null,
"pivotSummariesState": {
"__typename": "PivotSummariesState",
"showColumnGrandTotals": null,
"showColumnTotals": null,
"showRowGrandTotals": null,
"showRowTotals": null
},
"showPivotSummaryPrior": null,
"stackedAsPercentFormat": null,
"summaryFormat": null,
"summaryMode": null,
"useFlatLayout": null
},
"dataSize": null,
"gridLines": null,
"isZoomed": null,
"kpiDisplayProperties": {
"__typename": "KpiDisplayProperties",
"changeInterpretation": "UPWARD_IS_GOOD",
"kpiDisplayColorArray": [],
"showChange": true,
"showChangeAs": "PERCENT"
},
"legendPosition": null,
"mapviewport": null,
"responsiveLayoutDisabled": null,
"responsiveLayoutPreference": null,
"showLegend": null,
"showLinearRegressionLine": null,
"showStackedLabels": null,
"visibleSeriesNames": []
},
"columnProperties": [
{
"columnId": "bac67a4f-2e89-456a-8b62-6df830ff4e1b",
"columnProperty": {
"__typename": "ChartVizColumnProperties",
"conditionalFormatting": null,
"customProps": null,
"dataLabels": null,
"excludeNullValues": null,
"handleMissingValues": null,
"kpiColumnProperties": {
"__typename": "KpiColumnProperties",
"abbreviatedPreviousDate": null,
"handleNullData": null,
"showAbbreviatedPreviousDate": null,
"showComparisonDate": true,
"showCurrentDateLabel": true,
"showPreviousDateLabel": true,
"showPreviousValue": true,
"showSparkline": true
}
}
},
{
"columnId": "dd8bb852-d70d-4269-9bae-11953323d7bd",
"columnProperty": {
"__typename": "ChartVizColumnProperties",
"conditionalFormatting": null,
"customProps": null,
"dataLabels": null,
"excludeNullValues": null,
"handleMissingValues": null,
"kpiColumnProperties": {
"__typename": "KpiColumnProperties",
"abbreviatedPreviousDate": null,
"handleNullData": null,
"showAbbreviatedPreviousDate": null,
"showComparisonDate": true,
"showCurrentDateLabel": true,
"showPreviousDateLabel": true,
"showPreviousValue": true,
"showSparkline": true
}
}
},
{
"columnId": "55ea0d3d-84fa-4734-b929-5f9a39f2d35d",
"columnProperty": {
"__typename": "ChartVizColumnProperties",
"conditionalFormatting": null,
"customProps": null,
"dataLabels": null,
"excludeNullValues": null,
"handleMissingValues": null,
"kpiColumnProperties": {
"__typename": "KpiColumnProperties",
"abbreviatedPreviousDate": null,
"handleNullData": null,
"showAbbreviatedPreviousDate": null,
"showComparisonDate": true,
"showCurrentDateLabel": true,
"showPreviousDateLabel": true,
"showPreviousValue": true,
"showSparkline": true
}
}
}
],
"customColorSelectorArray": [],
"multiColorSeriesColors": [],
"seriesColors": [],
"systemMultiColorSeriesColors": [],
"systemSeriesColors": [],
"tooltipConfig": null,
"version": "V4DOT2"
}
}
],
"headerMetadata": {
"id": "44aadbc7-3b75-4897-9b2b-2a6ecad4fe31",
"name": "Total sales",
"description": "",
"isNewAnswer": true,
"isHidden": false,
"displayMode": "CHART_MODE"
}
},
"isAnswerUnsaved": {
"hasUnsavedChanges": false
}
}
}
}