Untitled
unknown
plain_text
a year ago
18 kB
1
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