Created
September 11, 2017 13:24
-
-
Save yasarshaikh/d1339435d81f3e481105af7f3ba4cea1 to your computer and use it in GitHub Desktop.
JSON - Sales Operations dashboard || Lightning Rollout Specialist challenge #7
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| HTTP/1.1 200 OK | |
| Date: Mon, 11 Sep 2017 13:19:09 GMT | |
| Strict-Transport-Security: max-age=31536000; includeSubDomains | |
| Public-Key-Pins-Report-Only: pin-sha256="9n0izTnSRF+W4W4JTq51avSXkWhQB8duS2bxVLfzXsY="; max-age=86400; report-uri="https://calm-dawn-26291.herokuapp.com/hpkp-report/00D7F000001v17g"; | |
| X-Content-Type-Options: nosniff | |
| X-XSS-Protection: 1; mode=block | |
| Content-Security-Policy: referrer origin-when-cross-origin; upgrade-insecure-requests | |
| Set-Cookie: BrowserId=5gmgnsJsSHmpuKWSZDgkyQ;Path=/;Domain=.salesforce.com;Expires=Fri, 10-Nov-2017 13:19:09 GMT | |
| Expires: Thu, 01 Jan 1970 00:00:00 GMT | |
| Sforce-Limit-Info: api-usage=24/15000 | |
| isCacheHit: false | |
| Content-Type: application/json;charset=UTF-8 | |
| Vary: Accept-Encoding | |
| Content-Encoding: gzip | |
| Transfer-Encoding: chunked | |
| { | |
| "componentData" : [ { | |
| "componentId" : "01a7F000000graqQAA", | |
| "reportResult" : { | |
| "attributes" : null, | |
| "allData" : true, | |
| "factMap" : { | |
| "0!T" : { | |
| "aggregates" : [ { | |
| "label" : "$115,000.00", | |
| "value" : 115000 | |
| } ] | |
| }, | |
| "1!T" : { | |
| "aggregates" : [ { | |
| "label" : "$675,000.00", | |
| "value" : 675000 | |
| } ] | |
| }, | |
| "0_0!T" : { | |
| "aggregates" : [ { | |
| "label" : "$100,000.00", | |
| "value" : 100000 | |
| } ] | |
| }, | |
| "2!T" : { | |
| "aggregates" : [ { | |
| "label" : "$330,000.00", | |
| "value" : 330000 | |
| } ] | |
| }, | |
| "0_1!T" : { | |
| "aggregates" : [ { | |
| "label" : "$15,000.00", | |
| "value" : 15000 | |
| } ] | |
| }, | |
| "3!T" : { | |
| "aggregates" : [ { | |
| "label" : "$110,000.00", | |
| "value" : 110000 | |
| } ] | |
| }, | |
| "T!T" : { | |
| "aggregates" : [ { | |
| "label" : "$5,760,000.00", | |
| "value" : 5760000 | |
| } ] | |
| }, | |
| "4!T" : { | |
| "aggregates" : [ { | |
| "label" : "$120,000.00", | |
| "value" : 120000 | |
| } ] | |
| }, | |
| "5!T" : { | |
| "aggregates" : [ { | |
| "label" : "$370,000.00", | |
| "value" : 370000 | |
| } ] | |
| }, | |
| "7_0!T" : { | |
| "aggregates" : [ { | |
| "label" : "$3,645,000.00", | |
| "value" : 3645000 | |
| } ] | |
| }, | |
| "6!T" : { | |
| "aggregates" : [ { | |
| "label" : "$395,000.00", | |
| "value" : 395000 | |
| } ] | |
| }, | |
| "7!T" : { | |
| "aggregates" : [ { | |
| "label" : "$3,645,000.00", | |
| "value" : 3645000 | |
| } ] | |
| }, | |
| "1_0!T" : { | |
| "aggregates" : [ { | |
| "label" : "$675,000.00", | |
| "value" : 675000 | |
| } ] | |
| }, | |
| "3_0!T" : { | |
| "aggregates" : [ { | |
| "label" : "$110,000.00", | |
| "value" : 110000 | |
| } ] | |
| }, | |
| "5_0!T" : { | |
| "aggregates" : [ { | |
| "label" : "$370,000.00", | |
| "value" : 370000 | |
| } ] | |
| }, | |
| "4_0!T" : { | |
| "aggregates" : [ { | |
| "label" : "$120,000.00", | |
| "value" : 120000 | |
| } ] | |
| }, | |
| "2_0!T" : { | |
| "aggregates" : [ { | |
| "label" : "$330,000.00", | |
| "value" : 330000 | |
| } ] | |
| }, | |
| "6_0!T" : { | |
| "aggregates" : [ { | |
| "label" : "$395,000.00", | |
| "value" : 395000 | |
| } ] | |
| } | |
| }, | |
| "groupingsAcross" : null, | |
| "groupingsDown" : { | |
| "groupings" : [ { | |
| "groupings" : [ { | |
| "groupings" : [ ], | |
| "key" : "7_0", | |
| "label" : "Closed Won", | |
| "value" : "Closed Won" | |
| } ], | |
| "key" : "7", | |
| "label" : "100%", | |
| "value" : 100 | |
| }, { | |
| "groupings" : [ { | |
| "groupings" : [ ], | |
| "key" : "1_0", | |
| "label" : "Needs Analysis", | |
| "value" : "Needs Analysis" | |
| } ], | |
| "key" : "1", | |
| "label" : "20%", | |
| "value" : 20 | |
| }, { | |
| "groupings" : [ { | |
| "groupings" : [ ], | |
| "key" : "6_0", | |
| "label" : "Negotiation/Review", | |
| "value" : "Negotiation/Review" | |
| } ], | |
| "key" : "6", | |
| "label" : "90%", | |
| "value" : 90 | |
| }, { | |
| "groupings" : [ { | |
| "groupings" : [ ], | |
| "key" : "5_0", | |
| "label" : "Proposal/Price Quote", | |
| "value" : "Proposal/Price Quote" | |
| } ], | |
| "key" : "5", | |
| "label" : "75%", | |
| "value" : 75 | |
| }, { | |
| "groupings" : [ { | |
| "groupings" : [ ], | |
| "key" : "2_0", | |
| "label" : "Value Proposition", | |
| "value" : "Value Proposition" | |
| } ], | |
| "key" : "2", | |
| "label" : "50%", | |
| "value" : 50 | |
| }, { | |
| "groupings" : [ { | |
| "groupings" : [ ], | |
| "key" : "4_0", | |
| "label" : "Perception Analysis", | |
| "value" : "Perception Analysis" | |
| } ], | |
| "key" : "4", | |
| "label" : "70%", | |
| "value" : 70 | |
| }, { | |
| "groupings" : [ { | |
| "groupings" : [ ], | |
| "key" : "0_0", | |
| "label" : "Prospecting", | |
| "value" : "Prospecting" | |
| }, { | |
| "groupings" : [ ], | |
| "key" : "0_1", | |
| "label" : "Qualification", | |
| "value" : "Qualification" | |
| } ], | |
| "key" : "0", | |
| "label" : "10%", | |
| "value" : 10 | |
| }, { | |
| "groupings" : [ { | |
| "groupings" : [ ], | |
| "key" : "3_0", | |
| "label" : "Id. Decision Makers", | |
| "value" : "Id. Decision Makers" | |
| } ], | |
| "key" : "3", | |
| "label" : "60%", | |
| "value" : 60 | |
| } ] | |
| }, | |
| "hasDetailRows" : false, | |
| "reportExtendedMetadata" : { | |
| "aggregateColumnInfo" : { | |
| "s!AMOUNT" : { | |
| "acrossGroupingContext" : null, | |
| "dataType" : "currency", | |
| "downGroupingContext" : null, | |
| "label" : "Sum of Amount" | |
| } | |
| }, | |
| "detailColumnInfo" : { }, | |
| "groupingColumnInfo" : { | |
| "PROBABILITY" : { | |
| "dataType" : "percent", | |
| "groupingLevel" : 1, | |
| "label" : "Probability (%)" | |
| }, | |
| "STAGE_NAME" : { | |
| "dataType" : "picklist", | |
| "groupingLevel" : 0, | |
| "label" : "Stage" | |
| } | |
| } | |
| }, | |
| "reportMetadata" : { | |
| "aggregates" : [ "s!AMOUNT" ], | |
| "chart" : null, | |
| "currency" : null, | |
| "description" : null, | |
| "detailColumns" : [ ], | |
| "developerName" : "Opportunities_Pipeline", | |
| "division" : null, | |
| "folderId" : "00D7F000001v17gUAA", | |
| "groupingsAcross" : [ ], | |
| "groupingsDown" : [ { | |
| "dateGranularity" : "None", | |
| "name" : "PROBABILITY", | |
| "sortAggregate" : null, | |
| "sortOrder" : "Asc" | |
| }, { | |
| "dateGranularity" : "None", | |
| "name" : "STAGE_NAME", | |
| "sortAggregate" : null, | |
| "sortOrder" : "Asc" | |
| } ], | |
| "hasDetailRows" : true, | |
| "hasRecordCount" : true, | |
| "historicalSnapshotDates" : [ ], | |
| "id" : "00O7F000003N95MUAS", | |
| "name" : "Opportunities Pipeline", | |
| "reportBooleanFilter" : null, | |
| "reportFilters" : [ ], | |
| "reportFormat" : "SUMMARY", | |
| "reportType" : { | |
| "label" : "Opportunities", | |
| "type" : "Opportunity" | |
| }, | |
| "scope" : "organization", | |
| "showGrandTotal" : true, | |
| "showSubtotals" : true, | |
| "sortBy" : [ ], | |
| "standardDateFilter" : { | |
| "column" : "CLOSE_DATE", | |
| "durationValue" : "CUSTOM", | |
| "endDate" : null, | |
| "startDate" : null | |
| }, | |
| "standardFilters" : [ { | |
| "name" : "open", | |
| "value" : "all" | |
| }, { | |
| "name" : "probability", | |
| "value" : ">0" | |
| } ] | |
| } | |
| }, | |
| "status" : { | |
| "dataStatus" : "DATA", | |
| "errorCode" : null, | |
| "errorMessage" : null, | |
| "errorSeverity" : null, | |
| "refreshDate" : "2017-09-11T13:18:35.000+0000", | |
| "refreshStatus" : "IDLE" | |
| } | |
| }, { | |
| "componentId" : "01a7F000000grarQAA", | |
| "reportResult" : { | |
| "attributes" : null, | |
| "allData" : true, | |
| "factMap" : { | |
| "T!T" : { | |
| "aggregates" : [ { | |
| "label" : "$4,739,500.00", | |
| "value" : 4739500 | |
| } ] | |
| } | |
| }, | |
| "groupingsAcross" : null, | |
| "groupingsDown" : { | |
| "groupings" : [ ] | |
| }, | |
| "hasDetailRows" : false, | |
| "reportExtendedMetadata" : { | |
| "aggregateColumnInfo" : { | |
| "s!EXP_AMOUNT" : { | |
| "acrossGroupingContext" : null, | |
| "dataType" : "currency", | |
| "downGroupingContext" : null, | |
| "label" : "Sum of Expected Revenue" | |
| } | |
| }, | |
| "detailColumnInfo" : { }, | |
| "groupingColumnInfo" : { } | |
| }, | |
| "reportMetadata" : { | |
| "aggregates" : [ "s!EXP_AMOUNT" ], | |
| "chart" : null, | |
| "currency" : null, | |
| "description" : null, | |
| "detailColumns" : [ ], | |
| "developerName" : "Opportunities_Pipeline", | |
| "division" : null, | |
| "folderId" : "00D7F000001v17gUAA", | |
| "groupingsAcross" : [ ], | |
| "groupingsDown" : [ ], | |
| "hasDetailRows" : true, | |
| "hasRecordCount" : true, | |
| "historicalSnapshotDates" : [ ], | |
| "id" : "00O7F000003N95MUAS", | |
| "name" : "Opportunities Pipeline", | |
| "reportBooleanFilter" : null, | |
| "reportFilters" : [ ], | |
| "reportFormat" : "SUMMARY", | |
| "reportType" : { | |
| "label" : "Opportunities", | |
| "type" : "Opportunity" | |
| }, | |
| "scope" : "organization", | |
| "showGrandTotal" : true, | |
| "showSubtotals" : true, | |
| "sortBy" : [ ], | |
| "standardDateFilter" : { | |
| "column" : "CLOSE_DATE", | |
| "durationValue" : "CUSTOM", | |
| "endDate" : null, | |
| "startDate" : null | |
| }, | |
| "standardFilters" : [ { | |
| "name" : "open", | |
| "value" : "all" | |
| }, { | |
| "name" : "probability", | |
| "value" : ">0" | |
| } ] | |
| } | |
| }, | |
| "status" : { | |
| "dataStatus" : "DATA", | |
| "errorCode" : null, | |
| "errorMessage" : null, | |
| "errorSeverity" : null, | |
| "refreshDate" : "2017-09-11T13:18:35.000+0000", | |
| "refreshStatus" : "IDLE" | |
| } | |
| }, { | |
| "componentId" : "01a7F000000grasQAA", | |
| "reportResult" : { | |
| "attributes" : null, | |
| "allData" : true, | |
| "factMap" : { | |
| "0!T" : { | |
| "aggregates" : [ { | |
| "label" : "$2,881,000.00", | |
| "value" : 2881000 | |
| } ] | |
| }, | |
| "1!T" : { | |
| "aggregates" : [ { | |
| "label" : "$1,791,500.00", | |
| "value" : 1791500 | |
| } ] | |
| }, | |
| "2!T" : { | |
| "aggregates" : [ { | |
| "label" : "$46,000.00", | |
| "value" : 46000 | |
| } ] | |
| }, | |
| "3!T" : { | |
| "aggregates" : [ { | |
| "label" : "$21,000.00", | |
| "value" : 21000 | |
| } ] | |
| }, | |
| "T!T" : { | |
| "aggregates" : [ { | |
| "label" : "$4,739,500.00", | |
| "value" : 4739500 | |
| } ] | |
| } | |
| }, | |
| "groupingsAcross" : null, | |
| "groupingsDown" : { | |
| "groupings" : [ { | |
| "groupings" : [ ], | |
| "key" : "0", | |
| "label" : "Existing Customer - Upgrade", | |
| "value" : "Existing Customer - Upgrade" | |
| }, { | |
| "groupings" : [ ], | |
| "key" : "1", | |
| "label" : "New Customer", | |
| "value" : "New Customer" | |
| }, { | |
| "groupings" : [ ], | |
| "key" : "2", | |
| "label" : "-", | |
| "value" : null | |
| }, { | |
| "groupings" : [ ], | |
| "key" : "3", | |
| "label" : "Existing Customer - Replacement", | |
| "value" : "Existing Customer - Replacement" | |
| } ] | |
| }, | |
| "hasDetailRows" : false, | |
| "reportExtendedMetadata" : { | |
| "aggregateColumnInfo" : { | |
| "s!EXP_AMOUNT" : { | |
| "acrossGroupingContext" : null, | |
| "dataType" : "currency", | |
| "downGroupingContext" : null, | |
| "label" : "Sum of Expected Revenue" | |
| } | |
| }, | |
| "detailColumnInfo" : { }, | |
| "groupingColumnInfo" : { | |
| "TYPE" : { | |
| "dataType" : "picklist", | |
| "groupingLevel" : 2, | |
| "label" : "Type" | |
| } | |
| } | |
| }, | |
| "reportMetadata" : { | |
| "aggregates" : [ "s!EXP_AMOUNT" ], | |
| "chart" : null, | |
| "currency" : null, | |
| "description" : null, | |
| "detailColumns" : [ ], | |
| "developerName" : "Opportunities_Pipeline", | |
| "division" : null, | |
| "folderId" : "00D7F000001v17gUAA", | |
| "groupingsAcross" : [ ], | |
| "groupingsDown" : [ { | |
| "dateGranularity" : "None", | |
| "name" : "TYPE", | |
| "sortAggregate" : null, | |
| "sortOrder" : "Asc" | |
| } ], | |
| "hasDetailRows" : true, | |
| "hasRecordCount" : true, | |
| "historicalSnapshotDates" : [ ], | |
| "id" : "00O7F000003N95MUAS", | |
| "name" : "Opportunities Pipeline", | |
| "reportBooleanFilter" : null, | |
| "reportFilters" : [ ], | |
| "reportFormat" : "SUMMARY", | |
| "reportType" : { | |
| "label" : "Opportunities", | |
| "type" : "Opportunity" | |
| }, | |
| "scope" : "organization", | |
| "showGrandTotal" : true, | |
| "showSubtotals" : true, | |
| "sortBy" : [ ], | |
| "standardDateFilter" : { | |
| "column" : "CLOSE_DATE", | |
| "durationValue" : "CUSTOM", | |
| "endDate" : null, | |
| "startDate" : null | |
| }, | |
| "standardFilters" : [ { | |
| "name" : "open", | |
| "value" : "all" | |
| }, { | |
| "name" : "probability", | |
| "value" : ">0" | |
| } ] | |
| } | |
| }, | |
| "status" : { | |
| "dataStatus" : "DATA", | |
| "errorCode" : null, | |
| "errorMessage" : null, | |
| "errorSeverity" : null, | |
| "refreshDate" : "2017-09-11T13:18:40.000+0000", | |
| "refreshStatus" : "IDLE" | |
| } | |
| } ], | |
| "dashboardMetadata" : { | |
| "attributes" : { | |
| "dashboardId" : "01Z7F000000ghZnUAI", | |
| "dashboardName" : "Sales Operations", | |
| "statusUrl" : "/services/data/v35.0/analytics/dashboards/01Z7F000000ghZnUAI/status", | |
| "type" : "Dashboard" | |
| }, | |
| "canChangeRunningUser" : false, | |
| "components" : [ { | |
| "componentData" : 0, | |
| "footer" : null, | |
| "header" : "Opp Probability by Stage", | |
| "id" : "01a7F000000graqQAA", | |
| "properties" : { | |
| "aggregates" : [ { | |
| "name" : "s!AMOUNT" | |
| } ], | |
| "autoSelectColumns" : false, | |
| "groupings" : [ { | |
| "name" : "PROBABILITY" | |
| }, { | |
| "name" : "STAGE_NAME" | |
| } ], | |
| "maxRows" : null, | |
| "sort" : { | |
| "column" : "s!AMOUNT", | |
| "sortOrder" : "desc" | |
| }, | |
| "useReportChart" : false, | |
| "visualizationProperties" : { | |
| "axisRange" : { | |
| "max" : null, | |
| "min" : null, | |
| "rangeType" : "auto" | |
| }, | |
| "groupByType" : "grouped", | |
| "legendPosition" : "Right", | |
| "showValues" : true | |
| }, | |
| "visualizationType" : "Column" | |
| }, | |
| "reportId" : "00O7F000003N95MUAS", | |
| "title" : null, | |
| "type" : "Report" | |
| }, { | |
| "componentData" : 1, | |
| "footer" : null, | |
| "header" : "Sum of Opportunity Amount", | |
| "id" : "01a7F000000grarQAA", | |
| "properties" : { | |
| "aggregates" : [ { | |
| "name" : "s!EXP_AMOUNT" | |
| } ], | |
| "autoSelectColumns" : false, | |
| "groupings" : null, | |
| "maxRows" : null, | |
| "sort" : null, | |
| "useReportChart" : false, | |
| "visualizationProperties" : { | |
| "breakPoints" : [ { | |
| "aggregateName" : "s!EXP_AMOUNT", | |
| "breaks" : [ { | |
| "color" : "c23934", | |
| "lowerBound" : 0, | |
| "upperBound" : 33 | |
| }, { | |
| "color" : "ffb75d", | |
| "lowerBound" : 33, | |
| "upperBound" : 67 | |
| }, { | |
| "color" : "00716b", | |
| "lowerBound" : 67, | |
| "upperBound" : 100 | |
| } ] | |
| } ], | |
| "showPercentages" : true, | |
| "showTotal" : true | |
| }, | |
| "visualizationType" : "Gauge" | |
| }, | |
| "reportId" : "00O7F000003N95MUAS", | |
| "title" : null, | |
| "type" : "Report" | |
| }, { | |
| "componentData" : 2, | |
| "footer" : null, | |
| "header" : "New and Existing Business", | |
| "id" : "01a7F000000grasQAA", | |
| "properties" : { | |
| "aggregates" : [ { | |
| "name" : "s!EXP_AMOUNT" | |
| } ], | |
| "autoSelectColumns" : false, | |
| "groupings" : [ { | |
| "name" : "TYPE" | |
| } ], | |
| "maxRows" : null, | |
| "sort" : { | |
| "column" : "s!EXP_AMOUNT", | |
| "sortOrder" : "desc" | |
| }, | |
| "useReportChart" : false, | |
| "visualizationProperties" : { | |
| "combineSmallGroups" : false, | |
| "legendPosition" : "Right", | |
| "showPercentages" : false, | |
| "showTotal" : false, | |
| "showValues" : true | |
| }, | |
| "visualizationType" : "Donut" | |
| }, | |
| "reportId" : "00O7F000003N95MUAS", | |
| "title" : null, | |
| "type" : "Report" | |
| } ], | |
| "description" : null, | |
| "developerName" : "zwdBozOZpQJwJKEjoGTfXqmWEsMMgv", | |
| "filters" : [ { | |
| "name" : "Stage value", | |
| "options" : [ { | |
| "alias" : "Prospecting, Qualification, Needs Anal", | |
| "endValue" : null, | |
| "id" : "0IC7F000000fxwEWAQ", | |
| "operation" : "equals", | |
| "startValue" : null, | |
| "value" : "Prospecting,Qualification,Needs Analysis,Value Proposition,Id. Decision Makers,Perception Analysis,Proposal/Price Quote,Negotiation/Review,Closed Won,Closed Lost" | |
| } ], | |
| "selectedOption" : null | |
| } ], | |
| "folderId" : "00l7F000000lM9bQAE", | |
| "id" : "01Z7F000000ghZnUAI", | |
| "layout" : { | |
| "components" : [ { | |
| "colspan" : 3, | |
| "column" : 0, | |
| "row" : 0, | |
| "rowspan" : 4 | |
| }, { | |
| "colspan" : 3, | |
| "column" : 0, | |
| "row" : 4, | |
| "rowspan" : 4 | |
| }, { | |
| "colspan" : 3, | |
| "column" : 0, | |
| "row" : 8, | |
| "rowspan" : 4 | |
| } ], | |
| "gridLayout" : true, | |
| "numColumns" : 9, | |
| "rowHeight" : 80 | |
| }, | |
| "name" : "Sales Operations", | |
| "runningUser" : { | |
| "displayName" : "Yasar Shaikh", | |
| "id" : "0057F000000WDz0QAG" | |
| } | |
| } | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment