Untitled
unknown
plain_text
2 years ago
18 kB
3
Indexable
[
{
"_id": "SURVEY_EXECUTIVE_VIEW_DB_1_2",
"name": "Summary",
"dashboardId": "SURVEY_EXECUTIVE_VIEW_DB_1",
"moduleType": "LISTENING",
"requests": [
{
"key": "6615799afb7c8d22a5c07c41",
"reportingEngine": "PLATFORM",
"filters": [
{
"filterType": "IN",
"field": "SURVEY_ID",
"values": [],
"userFilter": false,
"allValuesAllowed": true,
"lockedWithValues": false,
"hidden": false,
"favourite": false,
"mandatory": false,
"locked": false,
"ignoreAddingToDimensionFilter": false,
"details": {
"__id": "f7e0e7ba-672d-4805-a4c5-51860ae1c654",
"reportName": "SURVEY_CLICK_TRACKER_REPORT",
"name": "SURVEY_ID",
"srcType": "NORMAL",
"type": "DIMENSION",
"valueAdditional": {},
"uniqueId": "D_SURVEY_ID",
"fieldId": "SURVEY_ID",
"lookupType": "SURVEY_ID",
"valuesMetaData": [],
"filterIndex": 0
}
}
],
"projections": [
{
"key": "M_SURVEY_REPORT_SURVEY_RESPONSE_COUNT_0",
"measurement": "SURVEY_RESPONSE_COUNT",
"aggregateFunction": "SUM"
},
{
"key": "M_SURVEY_REPORT_D332B905_6A50_4717_8C14_203DE8F8F8B3_1",
"measurement": "d332b905-6a50-4717-8c14-203de8f8f8b3",
"aggregateFunction": "SUM"
}
],
"report": "SURVEY_REPORT",
"tzOffset": 0,
"additional": {
"renderConfig": "{\"M_SURVEY_REPORT_SURVEY_RESPONSE_COUNT_0\":{\"measurementFn\":\"SUM\",\"decorations\":[\"CHANGE\",\"PERCENTAGE_CHANGE\"]},\"M_SURVEY_REPORT_D332B905_6A50_4717_8C14_203DE8F8F8B3_1\":{\"measurementFn\":\"SUM\",\"decorations\":[\"CHANGE\",\"PERCENTAGE_CHANGE\"]}}",
"projectionDecorations": "{\"M_SURVEY_REPORT_SURVEY_RESPONSE_COUNT_0\":[\"CHANGE\",\"PERCENTAGE_CHANGE\"],\"M_SURVEY_REPORT_D332B905_6A50_4717_8C14_203DE8F8F8B3_1\":[\"CHANGE\",\"PERCENTAGE_CHANGE\"]}"
},
"cacheDisabled": false,
"projectionDecorations": [
"PERCENTAGE_CHANGE",
"CHANGE"
]
},
{
"key": "6615799afb7c8d22a5c07c42",
"reportingEngine": "PLATFORM",
"filters": [
{
"filterType": "IN",
"field": "SURVEY_ID",
"values": [],
"userFilter": false,
"allValuesAllowed": true,
"lockedWithValues": false,
"hidden": false,
"favourite": false,
"mandatory": false,
"locked": false,
"ignoreAddingToDimensionFilter": false,
"details": {
"__id": "f7e0e7ba-672d-4805-a4c5-51860ae1c654",
"reportName": "SURVEY_CLICK_TRACKER_REPORT",
"name": "SURVEY_ID",
"srcType": "NORMAL",
"type": "DIMENSION",
"valueAdditional": {},
"uniqueId": "D_SURVEY_ID",
"fieldId": "SURVEY_ID",
"lookupType": "SURVEY_ID",
"valuesMetaData": [],
"filterIndex": 0
}
}
],
"projections": [
{
"key": "M_SURVEY_QUESTION_RESPONSE_MENTIONS_COUNT_0",
"measurement": "MENTIONS_COUNT",
"aggregateFunction": "SUM"
},
{
"key": "M_SURVEY_QUESTION_RESPONSE_SURVEY_RESPONSE_INSIGHTS_POLARITY_SCORE_1",
"measurement": "SURVEY_RESPONSE_INSIGHTS_POLARITY_SCORE",
"aggregateFunction": "SUM"
}
],
"report": "SURVEY_QUESTION_RESPONSE",
"tzOffset": 0,
"additional": {
"renderConfig": "{\"M_SURVEY_QUESTION_RESPONSE_MENTIONS_COUNT_0\":{\"measurementFn\":\"SUM\",\"decorations\":[\"CHANGE\",\"PERCENTAGE_CHANGE\"]}}",
"projectionDecorations": "{\"M_SURVEY_QUESTION_RESPONSE_MENTIONS_COUNT_0\":[\"CHANGE\",\"PERCENTAGE_CHANGE\"]}"
},
"cacheDisabled": false,
"projectionDecorations": [
"PERCENTAGE_CHANGE",
"CHANGE"
]
}
],
"additional": {
"version": "3",
"viewType": "CUSTOM",
"hidePercentageFromLabel": "false",
"ignoreAllDashboardFilters": "false",
"overrideDashboardFilters": "false",
"overrideAllDashboardFilters": "false",
"axes": "[{\"measurementFn\":\"SUM\",\"measurement\":{\"additional\":null,\"aliases\":null,\"channelTypes\":[],\"dataType\":null,\"description\":\"\",\"displayName\":\"Survey Response Count\",\"hidden\":false,\"i18nLabelPrefix\":null,\"name\":\"SURVEY_RESPONSE_COUNT\",\"plural\":null,\"rank\":110,\"uniqueKey\":\"M_SURVEY_REPORT_SURVEY_RESPONSE_COUNT\",\"filters\":null,\"additionalDetailsForRecordTable\":{},\"colorConfig\":null,\"cumulativeAverageDenominator\":null,\"defaultAggregationFunction\":null,\"groupNames\":[],\"measurementGroups\":[\"COMMON\"],\"primaryField\":null,\"rawDisplayName\":\"Survey Response Count\",\"recordTableColumnType\":\"DEFAULT\",\"shared\":false,\"sharedKey\":null,\"shortName\":\"Survey Response Count\",\"translationMap\":{},\"type\":\"MEASUREMENT\",\"__typename\":\"Measurement\",\"id\":\"M_SURVEY_REPORT_SURVEY_RESPONSE_COUNT\",\"text\":\"Survey Response Count\",\"srcType\":\"SCRIPT\",\"reports\":[\"SURVEY_REPORT\"],\"report\":\"SURVEY_REPORT\",\"snIcon\":\"icon-undefined\",\"fieldDetails\":{\"SURVEY_REPORT\":{\"langVsTranslatedFieldValues\":null,\"name\":\"SURVEY_RESPONSE_COUNT\",\"fieldName\":\"SURVEY_RESPONSE_COUNT\",\"lcName\":null,\"plural\":null,\"filters\":null,\"hidden\":false,\"dataType\":null,\"additional\":null,\"uniqueKey\":\"M_SURVEY_REPORT_SURVEY_RESPONSE_COUNT\",\"i18nLabelPrefix\":null,\"aliases\":null,\"mandatory\":null,\"onlyIncl\":null,\"channelTypes\":[],\"type\":\"SCRIPT\",\"measurementGroups\":[\"COMMON\"],\"groupNames\":null,\"sharedKey\":null,\"color\":null,\"shortName\":\"Survey Response Count\",\"defaultAggregationFunction\":null,\"colorConfig\":null,\"primaryField\":null,\"cumulativeAverageDenominator\":null,\"filterMeasurement\":true,\"field\":null,\"script\":\"spr-count\",\"lang\":\"native\",\"internalParams\":null,\"requiresParams\":false,\"shared\":false,\"translationMap\":{},\"recordTableColumnType\":\"DEFAULT\",\"additionalDetailsForRecordTable\":{},\"rawDisplayName\":\"Survey Response Count\",\"displayName\":\"Survey Response Count\",\"description\":null,\"rank\":110}},\"favorite\":false,\"disabled\":false,\"disabledReason\":null,\"isFieldVisible\":true,\"fieldType\":\"MEASUREMENT\",\"userFavourite\":false}},{\"measurementFn\":\"SUM\",\"label\":\"Text Response Count\",\"measurement\":{\"langVsTranslatedFieldValues\":null,\"name\":\"MENTIONS_COUNT\",\"lcName\":null,\"plural\":null,\"filters\":null,\"hidden\":false,\"dataType\":null,\"ordering\":null,\"additional\":{},\"uniqueKey\":\"M_SURVEY_QUESTION_RESPONSE_MENTIONS_COUNT\",\"i18nLabelPrefix\":null,\"i18nLabel\":null,\"aliases\":null,\"controllingFilters\":null,\"mandatory\":null,\"onlyIncl\":null,\"channelTypes\":null,\"code\":null,\"type\":\"MEASUREMENT\",\"measurementGroups\":[],\"groupNames\":null,\"isShared\":false,\"sharedKey\":null,\"color\":null,\"shortName\":null,\"defaultAggregationFunction\":null,\"colorConfig\":null,\"primaryField\":null,\"cumulativeAverageDenominator\":null,\"filterMeasurement\":true,\"field\":null,\"script\":\"1\",\"lang\":null,\"internalParams\":null,\"requiresParams\":false,\"shared\":false,\"displayName\":\"Text Response Count\",\"description\":\"Text Response Count\",\"rank\":1,\"srcType\":\"SCRIPT\",\"id\":\"M_SURVEY_QUESTION_RESPONSE_MENTIONS_COUNT\",\"reports\":[\"SURVEY_QUESTION_RESPONSE\"],\"report\":\"SURVEY_QUESTION_RESPONSE\",\"isFieldVisible\":true,\"text\":\"Text Response Count\",\"snIcon\":\"icon-undefined\"}},{\"measurementFn\":\"SUM\",\"measurement\":{\"additional\":{\"surveyId\":\"660d28fb0412883bf2121684\"},\"aliases\":null,\"channelTypes\":[],\"dataType\":null,\"description\":\"NPS\",\"displayName\":\"NPS\",\"hidden\":false,\"i18nLabelPrefix\":null,\"name\":\"d332b905-6a50-4717-8c14-203de8f8f8b3\",\"plural\":null,\"rank\":110,\"uniqueKey\":\"M_SURVEY_REPORT_D332B905-6A50-4717-8C14-203DE8F8F8B3\",\"filters\":null,\"additionalDetailsForRecordTable\":{},\"colorConfig\":null,\"cumulativeAverageDenominator\":null,\"defaultAggregationFunction\":null,\"groupNames\":[],\"measurementGroups\":[\"COMMON\"],\"primaryField\":null,\"rawDisplayName\":\"NPS\",\"recordTableColumnType\":\"DEFAULT\",\"shared\":false,\"sharedKey\":null,\"shortName\":\"NPS\",\"translationMap\":{},\"type\":\"MEASUREMENT\",\"__typename\":\"Measurement\",\"id\":\"M_SURVEY_REPORT_D332B905-6A50-4717-8C14-203DE8F8F8B3\",\"text\":\"NPS\",\"srcType\":\"DELTA\",\"reports\":[\"SURVEY_REPORT\"],\"report\":\"SURVEY_REPORT\",\"snIcon\":\"icon-undefined\",\"fieldDetails\":{\"SURVEY_REPORT\":{\"langVsTranslatedFieldValues\":null,\"name\":\"d332b905-6a50-4717-8c14-203de8f8f8b3\",\"fieldName\":\"responses.d332b905-6a50-4717-8c14-203de8f8f8b3\",\"lcName\":null,\"plural\":null,\"filters\":null,\"hidden\":false,\"dataType\":null,\"additional\":{\"surveyId\":\"660d28fb0412883bf2121684\"},\"uniqueKey\":\"M_SURVEY_REPORT_D332B905-6A50-4717-8C14-203DE8F8F8B3\",\"i18nLabelPrefix\":null,\"aliases\":null,\"mandatory\":null,\"onlyIncl\":null,\"channelTypes\":[],\"type\":\"DELTA\",\"measurementGroups\":[\"COMMON\"],\"groupNames\":null,\"sharedKey\":null,\"color\":null,\"shortName\":\"NPS\",\"defaultAggregationFunction\":null,\"colorConfig\":null,\"primaryField\":null,\"cumulativeAverageDenominator\":null,\"filterMeasurement\":true,\"shared\":false,\"translationMap\":{},\"recordTableColumnType\":\"DEFAULT\",\"additionalDetailsForRecordTable\":{},\"rawDisplayName\":\"NPS\",\"displayName\":\"NPS\",\"description\":\"NPS\",\"rank\":110}},\"favorite\":false,\"disabled\":false,\"disabledReason\":null,\"isFieldVisible\":true,\"fieldType\":\"MEASUREMENT\",\"userFavourite\":false}},{\"measurementFn\":\"SUM\",\"measurement\":{\"__typename\":\"Measurement\",\"additional\":{\"MSG_DATE_DIMENSION\":\"date\",\"REPORT_NAME_KEY\":\"SURVEY_REPORT\",\"MSG_DRILL_DOWN_DIMENSION\":\"CASE\",\"MSG_DRILL_DOWN_ALLOWED\":true},\"aliases\":null,\"channelTypes\":[],\"dataType\":null,\"description\":\"\",\"displayName\":\"Agent Predicted CSAT Score\",\"hidden\":false,\"i18nLabelPrefix\":\"agent_\",\"name\":\"CASE_PREDICTED_CSAT_RATING\",\"plural\":null,\"rank\":96,\"uniqueKey\":\"M_AGENT_STATUS_REPORT_CASE_PREDICTED_CSAT_RATING\",\"filters\":null,\"additionalDetailsForRecordTable\":{},\"colorConfig\":null,\"cumulativeAverageDenominator\":null,\"defaultAggregationFunction\":null,\"groupNames\":[],\"measurementGroups\":[\"COMMON\"],\"primaryField\":null,\"rawDisplayName\":\"Agent Predicted CSAT Score\",\"recordTableColumnType\":\"DEFAULT\",\"shared\":false,\"sharedKey\":null,\"shortName\":\"Agent Predicted CSAT Score\",\"translationMap\":{},\"type\":\"MEASUREMENT\",\"id\":\"M_AGENT_STATUS_REPORT_CASE_PREDICTED_CSAT_RATING\",\"text\":\"Agent Predicted CSAT Score\",\"srcType\":\"SCRIPT\",\"reports\":[\"AGENT_STATUS_REPORT\"],\"report\":\"AGENT_STATUS_REPORT\",\"snIcon\":\"icon-undefined\",\"fieldDetails\":{\"AGENT_STATUS_REPORT\":{\"langVsTranslatedFieldValues\":null,\"name\":\"CASE_PREDICTED_CSAT_RATING\",\"fieldName\":\"CASE_PREDICTED_CSAT_RATING\",\"lcName\":null,\"plural\":null,\"filters\":null,\"hidden\":false,\"dataType\":null,\"additional\":{\"MSG_DATE_DIMENSION\":\"date\",\"REPORT_NAME_KEY\":\"SURVEY_REPORT\",\"MSG_DRILL_DOWN_DIMENSION\":\"CASE\",\"MSG_DRILL_DOWN_ALLOWED\":true},\"uniqueKey\":\"M_AGENT_STATUS_REPORT_CASE_PREDICTED_CSAT_RATING\",\"i18nLabelPrefix\":\"agent_\",\"aliases\":null,\"mandatory\":null,\"onlyIncl\":null,\"channelTypes\":[],\"type\":\"SCRIPT\",\"measurementGroups\":[\"COMMON\"],\"groupNames\":null,\"sharedKey\":null,\"color\":null,\"shortName\":\"Agent Predicted CSAT Score\",\"defaultAggregationFunction\":null,\"colorConfig\":null,\"primaryField\":null,\"cumulativeAverageDenominator\":null,\"filterMeasurement\":true,\"field\":null,\"script\":\"def rv = 0.0d; if(doc.containsKey('caseCustomProperties.mappedCustomProperties.spr_uc_predicted_csat_rating') &&doc['caseCustomProperties.mappedCustomProperties.spr_uc_predicted_csat_rating'].value!= null&&doc['caseCustomProperties.mappedCustomProperties.spr_uc_predicted_csat_rating'].value.length()>=1){rv = Double.parseDouble(doc['caseCustomProperties.mappedCustomProperties.spr_uc_predicted_csat_rating'].value);} boolean filterMode = false; if(params.get('filterMode') != null) { filterMode = params.get('filterMode'); }if(filterMode) {String filterType = 'EQUALS'; if(params.get('filterType') != null) { filterType = params.get('filterType');} def values = params.get('filterValues'); if(values == null || values.size() < 1) { return false;} String filterValue = String.valueOf(values.get(0)); double cmpVal = Double.parseDouble(filterValue); if('GTE'.compareTo(filterType) == 0) {return rv>=cmpVal;} else if('GT'.compareTo(filterType) == 0) {return rv>cmpVal;} else if('LTE'.compareTo(filterType) == 0) {return rv<=cmpVal;} else if('LT'.compareTo(filterType) == 0) {return rv<cmpVal;} else if('EQUALS'.compareTo(filterType) == 0) {return rv==cmpVal;} else {return false;}} else { return rv;}\",\"lang\":\"painless\",\"internalParams\":null,\"requiresParams\":false,\"shared\":false,\"translationMap\":{},\"recordTableColumnType\":\"DEFAULT\",\"additionalDetailsForRecordTable\":{},\"rawDisplayName\":\"Agent Predicted CSAT Score\",\"displayName\":\"Agent Predicted CSAT Score\",\"description\":null,\"rank\":96}},\"favorite\":false,\"disabled\":false,\"disabledReason\":null,\"isFieldVisible\":true,\"fieldType\":\"MEASUREMENT\",\"userFavourite\":false}},false]",
"standardAnalyticsDrilldown": true
},
"chartParams": "[{\"type\":\"COUNTER_SUMMARY\",\"quadrantLabels\":null,\"isCounterListView\":true,\"columnsDetail\":{},\"actionableChartParams\":{\"isActionable\":false}}]",
"locked": false,
"notComparable": false,
"searchableData": {
"uniqueFieldKeys": [
"M_SURVEY_REPORT_SURVEY_RESPONSE_COUNT",
"M_SURVEY_REPORT_D332B905-6A50-4717-8C14-203DE8F8F8B3",
"M_AGENT_STATUS_REPORT_CASE_PREDICTED_CSAT_RATING",
"M_SURVEY_QUESTION_RESPONSE_MENTIONS_COUNT",
"D_SURVEY_ID"
]
},
"widgetAxes": [
{
"_id": "M_SURVEY_REPORT_SURVEY_RESPONSE_COUNT",
"label": "Survey Response Count",
"type": "MEASUREMENT",
"additional": {
"decorationFn": "SUM",
"isSwitcherDisabled": "true"
}
},
{
"_id": "M_SURVEY_QUESTION_RESPONSE_MENTIONS_COUNT",
"label": "Text Response Count",
"type": "MEASUREMENT",
"additional": {
"decorationFn": "SUM",
"isSwitcherDisabled": "true"
}
},
{
"_id": "M_SURVEY_REPORT_D332B905-6A50-4717-8C14-203DE8F8F8B3",
"label": "NPS",
"type": "MEASUREMENT",
"additional": {
"decorationFn": "SUM",
"isSwitcherDisabled": "true"
}
},
{
"_id": "M_SURVEY_QUESTION_RESPONSE_SURVEY_RESPONSE_INSIGHTS_POLARITY_SCORE_1",
"type": "MEASUREMENT",
"additional": {
"decorationFn": "SUM",
"isSwitcherDisabled": "true"
}
}
],
"dynamicBenchmarkEnabled": false,
"versionId": 1,
"clientId": 66000002,
"ownerUserId": 66003219,
"createdTime": 1712682894538,
"modifiedTime": 1712683418935,
"deleted": false,
"permissionTypes": [],
"_class": "com.spr.shifu.dashboards.beans.Widget",
"category": null,
"childWidgets": null,
"customPivotDimensionKeys": null,
"customPivotSort": null,
"defaultTargetMetric": null,
"defaultTargetMetrics": null,
"description": null,
"displayAnnotations": null,
"grants": [
"CLIENT/66000002/OWNERSHIP",
"USER/66003219/OWNERSHIP"
],
"lastModifiedUserId": 66003219,
"lensConfig": null,
"pivotDimensionKeys": null,
"rootLocale": "en_US",
"selectedAnnotationIds": null,
"tabs": null,
"targetMetrics": null,
"targets": null,
"tutorialLink": null
}
] Editor is loading...
Leave a Comment