Untitled

 avatar
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