Skip to content

Instantly share code, notes, and snippets.

@vnehess
Created October 13, 2014 15:40
Show Gist options
  • Select an option

  • Save vnehess/fd92bf2cd2fb1a879974 to your computer and use it in GitHub Desktop.

Select an option

Save vnehess/fd92bf2cd2fb1a879974 to your computer and use it in GitHub Desktop.
Salesforce Analytics Dashboard Template (1280 wide)
{
"lastModified": 1413149207,
"name_lc": "dashboard template (1280)",
"state": {
"widgets": {
"box_25": {
"params": {
"imgUrl": "",
"borderColor": "rgba(220, 220, 220, 0.2)",
"backgroundColor": "rgba(220, 220, 220, 0.2)",
"stretch": false
},
"type": "BoxWidget",
"pos": {
"w": 280,
"zIndex": 5,
"y": 90,
"h": 40,
"x": 10
}
},
"box_13": {
"params": {
"imgUrl": "",
"borderColor": "rgba(0, 47, 99, 0.1)",
"backgroundColor": "rgba(220, 220, 220, 0.2)",
"stretch": false
},
"type": "BoxWidget",
"pos": {
"w": 990,
"zIndex": 16,
"y": 430,
"h": 40,
"x": 300
}
},
"box_7": {
"params": {
"imgUrl": "",
"borderColor": "rgba(163, 227, 255, 0.25)",
"backgroundColor": "rgba(163, 227, 255, 0.25)",
"stretch": false
},
"type": "BoxWidget",
"pos": {
"w": 1280,
"zIndex": 6,
"y": 10,
"h": 70,
"x": 10
}
},
"box_6": {
"params": {
"imgUrl": "",
"borderColor": "rgba(220, 220, 220, 0.2)",
"backgroundColor": "rgba(220, 220, 220, 0.2)",
"stretch": false
},
"type": "BoxWidget",
"pos": {
"w": 490,
"zIndex": 1,
"y": 90,
"h": 40,
"x": 800
}
},
"text_1": {
"params": {
"text": "Raw Data Table Title",
"textColor": "rgb(52, 65, 86)",
"textAlignment": "center",
"fontSize": 18
},
"type": "TextWidget",
"pos": {
"w": "auto",
"zIndex": 15,
"y": 820,
"h": "auto",
"x": 10
}
},
"text_15": {
"params": {
"text": "Filters / Refinements ",
"textColor": "rgb(52, 65, 86)",
"textAlignment": "center",
"fontSize": 18
},
"type": "TextWidget",
"pos": {
"w": "auto",
"zIndex": 41,
"y": 90,
"h": "auto",
"x": 10
}
},
"box_5": {
"params": {
"imgUrl": "",
"borderColor": "rgba(220, 220, 220, 0.2)",
"backgroundColor": "rgba(220, 220, 220, 0.2)",
"stretch": false
},
"type": "BoxWidget",
"pos": {
"w": 280,
"zIndex": 6,
"y": 90,
"h": 710,
"x": 10
}
},
"box_4": {
"params": {
"imgUrl": "",
"borderColor": "rgba(220, 220, 220, 0.2)",
"backgroundColor": "rgba(220, 220, 220, 0.2)",
"stretch": false
},
"type": "BoxWidget",
"pos": {
"w": 1280,
"zIndex": 3,
"y": 810,
"h": 400,
"x": 10
}
},
"text_11": {
"params": {
"text": "Upper Main title - enter text",
"textColor": "#000",
"textAlignment": "center",
"fontSize": 18
},
"type": "TextWidget",
"pos": {
"w": "auto",
"zIndex": 30,
"y": 90,
"h": "auto",
"x": 300
}
},
"box_17": {
"params": {
"imgUrl": "",
"borderColor": "rgba(0,0,0,0.25)",
"backgroundColor": "rgba(255, 255, 255, 0)",
"stretch": false
},
"type": "BoxWidget",
"pos": {
"w": 990,
"zIndex": 2,
"y": 430,
"h": 370,
"x": 300
}
},
"box_9": {
"params": {
"imgUrl": "",
"borderColor": "rgba(0, 45, 87, 0.1)",
"backgroundColor": "rgba(0, 140, 201, 0)",
"stretch": false
},
"type": "BoxWidget",
"pos": {
"w": 490,
"zIndex": 7,
"y": 90,
"h": 330,
"x": 300
}
},
"box_8": {
"params": {
"imgUrl": "",
"borderColor": "rgba(0, 0, 0, 0.1)",
"backgroundColor": "rgba(0, 140, 201, 0)",
"stretch": false
},
"type": "BoxWidget",
"pos": {
"w": 1280,
"zIndex": 4,
"y": 810,
"h": 40,
"x": 10
}
},
"text_6": {
"params": {
"text": "Measures / Sumary",
"textColor": "#000",
"textAlignment": "center",
"fontSize": 18
},
"type": "TextWidget",
"pos": {
"w": "auto",
"zIndex": 29,
"y": 90,
"h": "auto",
"x": 800
}
},
"box_1": {
"params": {
"imgUrl": "",
"borderColor": "rgba(0, 74, 119, 0.2)",
"backgroundColor": "rgba(220, 220, 220, 0.2)",
"stretch": false
},
"type": "BoxWidget",
"pos": {
"w": 490,
"zIndex": 9,
"y": 90,
"h": 40,
"x": 300
}
},
"text_8": {
"params": {
"text": "Lower Main title - enter text\n",
"textColor": "rgb(52, 65, 86)",
"textAlignment": "center",
"fontSize": 18
},
"type": "TextWidget",
"pos": {
"w": "auto",
"zIndex": 17,
"y": 430,
"h": "auto",
"x": 300
}
},
"box_3": {
"params": {
"imgUrl": "",
"borderColor": "rgba(0, 30, 105, 0.1)",
"backgroundColor": "rgba(0, 140, 201, 0)",
"stretch": false
},
"type": "BoxWidget",
"pos": {
"w": 500,
"zIndex": 0,
"y": 90,
"h": 330,
"x": 790
}
},
"text_3": {
"params": {
"text": "This dashboard provides a view of shipments and zone, region, market and period.",
"textColor": "rgb(166, 166, 166)",
"textAlignment": "left",
"fontSize": 15
},
"type": "TextWidget",
"pos": {
"w": "auto",
"zIndex": 11,
"y": 40,
"h": "auto",
"x": 10
}
},
"text_5": {
"params": {
"text": "What question does this dashboard address ?",
"textColor": "rgb(51, 113, 184)",
"textAlignment": "left",
"fontSize": 25
},
"type": "TextWidget",
"pos": {
"w": "auto",
"zIndex": 13,
"y": 10,
"h": "auto",
"x": 0
}
}
},
"steps": {
"step_1": {
"isFacet": true,
"start": null,
"query": {
"values": [],
"order": [],
"pigql": null,
"dimensions": [],
"measures": [
[
"count",
"*"
]
],
"aggregateFilters": [],
"facet_filters": [
"{{ facet_selection(step_Date_Year_Date_Week_12) }}",
"{{ facet_selection(step_Zone_3) }}",
"{{ facet_selection(step_Market_4) }}",
"{{ facet_selection(step_Date_Year_Date_Week_5) }}",
"{{ facet_selection(step_9) }}",
"{{ facet_selection(step_Planning_Customer_7) }}",
"{{ facet_selection(step_8) }}",
"{{ facet_selection(step_Region_2) }}",
"{{ facet_selection(step_6) }}",
"{{ facet_selection(step_11) }}",
"{{ facet_selection(step_10) }}",
"{{ facet_selection(step_Date_Year_Date_Month_13) }}"
],
"groups": [],
"filters": [],
"formula": null
},
"extra": {
"chartType": "hbar"
},
"selectMode": "single",
"useGlobal": true,
"em": "Shipments2",
"type": "aggregate",
"isGlobal": false
},
"step_Date_Year_Date_Week_12": {
"isFacet": true,
"start": null,
"query": {
"values": [],
"order": [],
"pigql": null,
"dimensions": [
"Date_Year~~~Date_Week"
],
"measures": [
[
"sum",
"Tot_Direct_List__"
]
],
"aggregateFilters": [],
"facet_filters": [
"{{ facet_selection(step_1) }}",
"{{ facet_selection(step_Zone_3) }}",
"{{ facet_selection(step_Market_4) }}",
"{{ facet_selection(step_Date_Year_Date_Week_5) }}",
"{{ facet_selection(step_9) }}",
"{{ facet_selection(step_Planning_Customer_7) }}",
"{{ facet_selection(step_8) }}",
"{{ facet_selection(step_Region_2) }}",
"{{ facet_selection(step_6) }}",
"{{ facet_selection(step_11) }}",
"{{ facet_selection(step_10) }}",
"{{ facet_selection(step_Date_Year_Date_Month_13) }}"
],
"groups": [
[
"Date_Year",
"Date_Week"
]
],
"filters": [],
"formula": null
},
"extra": {
"chartType": "hbar"
},
"selectMode": "single",
"useGlobal": true,
"em": "Shipments2",
"type": "aggregate",
"isGlobal": false
},
"step_Zone_3": {
"isFacet": true,
"start": null,
"query": {
"values": [],
"order": [],
"pigql": null,
"dimensions": [
"Zone"
],
"measures": [
[
"count",
"*"
]
],
"aggregateFilters": [],
"facet_filters": [
"{{ facet_selection(step_1) }}",
"{{ facet_selection(step_Date_Year_Date_Week_12) }}",
"{{ facet_selection(step_Market_4) }}",
"{{ facet_selection(step_Date_Year_Date_Week_5) }}",
"{{ facet_selection(step_9) }}",
"{{ facet_selection(step_Planning_Customer_7) }}",
"{{ facet_selection(step_8) }}",
"{{ facet_selection(step_Region_2) }}",
"{{ facet_selection(step_6) }}",
"{{ facet_selection(step_11) }}",
"{{ facet_selection(step_10) }}",
"{{ facet_selection(step_Date_Year_Date_Month_13) }}"
],
"groups": [
"Zone"
],
"filters": [],
"formula": null
},
"extra": {
"chartType": "hbar"
},
"selectMode": "single",
"useGlobal": true,
"em": "Shipments2",
"type": "aggregate",
"isGlobal": false
},
"step_Market_4": {
"isFacet": true,
"start": null,
"query": {
"values": [],
"order": [],
"pigql": null,
"dimensions": [
"Market"
],
"measures": [
[
"count",
"*"
]
],
"aggregateFilters": [],
"facet_filters": [
"{{ facet_selection(step_1) }}",
"{{ facet_selection(step_Date_Year_Date_Week_12) }}",
"{{ facet_selection(step_Zone_3) }}",
"{{ facet_selection(step_Date_Year_Date_Week_5) }}",
"{{ facet_selection(step_9) }}",
"{{ facet_selection(step_Planning_Customer_7) }}",
"{{ facet_selection(step_8) }}",
"{{ facet_selection(step_Region_2) }}",
"{{ facet_selection(step_6) }}",
"{{ facet_selection(step_11) }}",
"{{ facet_selection(step_10) }}",
"{{ facet_selection(step_Date_Year_Date_Month_13) }}"
],
"groups": [
"Market"
],
"filters": [],
"formula": null
},
"extra": {
"chartType": "hbar"
},
"selectMode": "single",
"useGlobal": true,
"em": "Shipments2",
"type": "aggregate",
"isGlobal": false
},
"step_Date_Year_Date_Week_5": {
"isFacet": true,
"start": null,
"query": {
"values": [],
"order": [],
"pigql": null,
"dimensions": [
"Date_Year~~~Date_Week"
],
"measures": [
[
"sum",
"Direct_Phys_Cs_excl_Displays"
]
],
"aggregateFilters": [],
"facet_filters": [
"{{ facet_selection(step_1) }}",
"{{ facet_selection(step_Date_Year_Date_Week_12) }}",
"{{ facet_selection(step_Zone_3) }}",
"{{ facet_selection(step_Market_4) }}",
"{{ facet_selection(step_9) }}",
"{{ facet_selection(step_Planning_Customer_7) }}",
"{{ facet_selection(step_8) }}",
"{{ facet_selection(step_Region_2) }}",
"{{ facet_selection(step_6) }}",
"{{ facet_selection(step_11) }}",
"{{ facet_selection(step_10) }}",
"{{ facet_selection(step_Date_Year_Date_Month_13) }}"
],
"groups": [
[
"Date_Year",
"Date_Week"
]
],
"filters": [],
"formula": null
},
"extra": {
"chartType": "hbar"
},
"selectMode": "single",
"useGlobal": true,
"em": "Shipments2",
"type": "aggregate",
"isGlobal": false
},
"step_9": {
"isFacet": true,
"start": null,
"query": {
"values": [
"Customer_Name",
"Customer__",
"Date",
"Date_Day",
"Date_Month",
"Direct_Dep_Demand_List__",
"Direct_Dep_Demand_Phys_Cs",
"Direct_List___excl_Displays",
"Direct_Phys_Cs_excl_Displays",
"Indirect_Dep_Demand_List__"
],
"order": [],
"pigql": null,
"dimensions": [],
"measures": [
[
"sum",
"Direct_Phys_Cs_excl_Displays"
]
],
"aggregateFilters": [],
"facet_filters": [
"{{ facet_selection(step_1) }}",
"{{ facet_selection(step_Date_Year_Date_Week_12) }}",
"{{ facet_selection(step_Zone_3) }}",
"{{ facet_selection(step_Market_4) }}",
"{{ facet_selection(step_Date_Year_Date_Week_5) }}",
"{{ facet_selection(step_Planning_Customer_7) }}",
"{{ facet_selection(step_8) }}",
"{{ facet_selection(step_Region_2) }}",
"{{ facet_selection(step_6) }}",
"{{ facet_selection(step_11) }}",
"{{ facet_selection(step_10) }}",
"{{ facet_selection(step_Date_Year_Date_Month_13) }}"
],
"groups": [],
"filters": [],
"formula": null
},
"extra": {
"chartType": "valuestable"
},
"selectMode": "single",
"useGlobal": true,
"em": "Shipments2",
"type": "grain",
"isGlobal": false
},
"step_8": {
"isFacet": true,
"start": null,
"query": {
"values": [],
"order": [],
"pigql": null,
"dimensions": [],
"measures": [
[
"sum",
"Direct_Phys_Cs_excl_Displays"
]
],
"aggregateFilters": [],
"facet_filters": [
"{{ facet_selection(step_1) }}",
"{{ facet_selection(step_Date_Year_Date_Week_12) }}",
"{{ facet_selection(step_Zone_3) }}",
"{{ facet_selection(step_Market_4) }}",
"{{ facet_selection(step_Date_Year_Date_Week_5) }}",
"{{ facet_selection(step_9) }}",
"{{ facet_selection(step_Planning_Customer_7) }}",
"{{ facet_selection(step_Region_2) }}",
"{{ facet_selection(step_6) }}",
"{{ facet_selection(step_11) }}",
"{{ facet_selection(step_10) }}",
"{{ facet_selection(step_Date_Year_Date_Month_13) }}"
],
"groups": [],
"filters": [],
"formula": null
},
"extra": {
"chartType": "hbar"
},
"selectMode": "single",
"useGlobal": true,
"em": "Shipments2",
"type": "aggregate",
"isGlobal": false
},
"step_Planning_Customer_7": {
"isFacet": true,
"start": null,
"query": {
"values": [],
"order": [],
"pigql": null,
"dimensions": [
"Planning_Customer"
],
"measures": [
[
"sum",
"Direct_Phys_Cs_excl_Displays"
]
],
"aggregateFilters": [],
"facet_filters": [
"{{ facet_selection(step_1) }}",
"{{ facet_selection(step_Date_Year_Date_Week_12) }}",
"{{ facet_selection(step_Zone_3) }}",
"{{ facet_selection(step_Market_4) }}",
"{{ facet_selection(step_Date_Year_Date_Week_5) }}",
"{{ facet_selection(step_9) }}",
"{{ facet_selection(step_8) }}",
"{{ facet_selection(step_Region_2) }}",
"{{ facet_selection(step_6) }}",
"{{ facet_selection(step_11) }}",
"{{ facet_selection(step_10) }}",
"{{ facet_selection(step_Date_Year_Date_Month_13) }}"
],
"groups": [
"Planning_Customer"
],
"filters": [],
"formula": null
},
"extra": {
"chartType": "hbar"
},
"selectMode": "single",
"useGlobal": true,
"em": "Shipments2",
"type": "aggregate",
"isGlobal": false
},
"step_Region_2": {
"isFacet": true,
"start": null,
"query": {
"values": [],
"order": [],
"pigql": null,
"dimensions": [
"Region"
],
"measures": [
[
"count",
"*"
]
],
"aggregateFilters": [],
"facet_filters": [
"{{ facet_selection(step_1) }}",
"{{ facet_selection(step_Date_Year_Date_Week_12) }}",
"{{ facet_selection(step_Zone_3) }}",
"{{ facet_selection(step_Market_4) }}",
"{{ facet_selection(step_Date_Year_Date_Week_5) }}",
"{{ facet_selection(step_9) }}",
"{{ facet_selection(step_Planning_Customer_7) }}",
"{{ facet_selection(step_8) }}",
"{{ facet_selection(step_6) }}",
"{{ facet_selection(step_11) }}",
"{{ facet_selection(step_10) }}",
"{{ facet_selection(step_Date_Year_Date_Month_13) }}"
],
"groups": [
"Region"
],
"filters": [],
"formula": null
},
"extra": {
"chartType": "hbar"
},
"selectMode": "single",
"useGlobal": true,
"em": "Shipments2",
"type": "aggregate",
"isGlobal": false
},
"step_6": {
"isFacet": true,
"start": null,
"query": {
"values": [],
"order": [],
"pigql": null,
"dimensions": [],
"measures": [
[
"sum",
"Direct_Phys_Cs_excl_Displays"
]
],
"aggregateFilters": [],
"facet_filters": [
"{{ facet_selection(step_1) }}",
"{{ facet_selection(step_Date_Year_Date_Week_12) }}",
"{{ facet_selection(step_Zone_3) }}",
"{{ facet_selection(step_Market_4) }}",
"{{ facet_selection(step_Date_Year_Date_Week_5) }}",
"{{ facet_selection(step_9) }}",
"{{ facet_selection(step_Planning_Customer_7) }}",
"{{ facet_selection(step_8) }}",
"{{ facet_selection(step_Region_2) }}",
"{{ facet_selection(step_11) }}",
"{{ facet_selection(step_10) }}",
"{{ facet_selection(step_Date_Year_Date_Month_13) }}"
],
"groups": [],
"filters": [],
"formula": null
},
"extra": {
"chartType": "hbar"
},
"selectMode": "single",
"useGlobal": true,
"em": "Shipments2",
"type": "aggregate",
"isGlobal": false
},
"step_11": {
"isFacet": true,
"start": null,
"query": {
"values": [],
"order": [],
"pigql": null,
"dimensions": [],
"measures": [
[
"sum",
"Tot_Direct_List__"
]
],
"aggregateFilters": [],
"facet_filters": [
"{{ facet_selection(step_1) }}",
"{{ facet_selection(step_Date_Year_Date_Week_12) }}",
"{{ facet_selection(step_Zone_3) }}",
"{{ facet_selection(step_Market_4) }}",
"{{ facet_selection(step_Date_Year_Date_Week_5) }}",
"{{ facet_selection(step_9) }}",
"{{ facet_selection(step_Planning_Customer_7) }}",
"{{ facet_selection(step_8) }}",
"{{ facet_selection(step_Region_2) }}",
"{{ facet_selection(step_6) }}",
"{{ facet_selection(step_10) }}",
"{{ facet_selection(step_Date_Year_Date_Month_13) }}"
],
"groups": [],
"filters": [],
"formula": null
},
"extra": {
"chartType": "hbar"
},
"selectMode": "single",
"useGlobal": true,
"em": "Shipments2",
"type": "aggregate",
"isGlobal": false
},
"step_10": {
"isFacet": true,
"start": null,
"query": {
"values": [],
"order": [],
"pigql": null,
"dimensions": [],
"measures": [
[
"sum",
"Tot_Direct_Phys_Cs"
]
],
"aggregateFilters": [],
"facet_filters": [
"{{ facet_selection(step_1) }}",
"{{ facet_selection(step_Date_Year_Date_Week_12) }}",
"{{ facet_selection(step_Zone_3) }}",
"{{ facet_selection(step_Market_4) }}",
"{{ facet_selection(step_Date_Year_Date_Week_5) }}",
"{{ facet_selection(step_9) }}",
"{{ facet_selection(step_Planning_Customer_7) }}",
"{{ facet_selection(step_8) }}",
"{{ facet_selection(step_Region_2) }}",
"{{ facet_selection(step_6) }}",
"{{ facet_selection(step_11) }}",
"{{ facet_selection(step_Date_Year_Date_Month_13) }}"
],
"groups": [],
"filters": [],
"formula": null
},
"extra": {
"chartType": "hbar"
},
"selectMode": "single",
"useGlobal": true,
"em": "Shipments2",
"type": "aggregate",
"isGlobal": false
},
"step_Date_Year_Date_Month_13": {
"isFacet": true,
"start": null,
"query": {
"values": [],
"order": [],
"pigql": null,
"dimensions": [
"Date_Year~~~Date_Month"
],
"measures": [
[
"sum",
"Tot_Direct_List__"
]
],
"aggregateFilters": [],
"facet_filters": [
"{{ facet_selection(step_1) }}",
"{{ facet_selection(step_Date_Year_Date_Week_12) }}",
"{{ facet_selection(step_Zone_3) }}",
"{{ facet_selection(step_Market_4) }}",
"{{ facet_selection(step_Date_Year_Date_Week_5) }}",
"{{ facet_selection(step_9) }}",
"{{ facet_selection(step_Planning_Customer_7) }}",
"{{ facet_selection(step_8) }}",
"{{ facet_selection(step_Region_2) }}",
"{{ facet_selection(step_6) }}",
"{{ facet_selection(step_11) }}",
"{{ facet_selection(step_10) }}"
],
"groups": [
[
"Date_Year",
"Date_Month"
]
],
"filters": [],
"formula": null
},
"extra": {
"chartType": "hbar"
},
"selectMode": "single",
"useGlobal": true,
"em": "Shipments2",
"type": "aggregate",
"isGlobal": false
}
},
"cards": {}
},
"_uid": "0FKB00000004EgiOAE",
"_createdBy": {
"_type": "user",
"profilePhotoUrl": "https://c.gus.content.force.com/profilephoto/729B0000000062p/T",
"name": "Ron Hess",
"_uid": "005B0000001BWHyIAO"
},
"folder": {
"_type": "folder",
"_uid": "00lB0000000aZLEIA2"
},
"edgemarts": {
"emName": {
"_type": "edgemart",
"_uid": "0FbB00000004EL6KAM"
}
},
"_type": "dashboard",
"_container": {
"_container": "0FKB00000004EgiOAE",
"_type": "container"
},
"_createdDateTime": 1413148799,
"assetSharingUrl": "https://gs0.salesforce.com/analytics/wave/lens?assetId=0FKB00000004EgiOAE&orgId=00DB00000000kdE&loginHost=gs0.salesforce.com&urlType=sharing",
"_permissions": {
"modify": true,
"view": true
},
"description": "generic template, click Edit, then Save a Copy for reuse",
"views": "--",
"_url": "/insights/internal_api/v1.0/esObject/lens/0FKB00000004EgiOAE/json",
"name": "Dashboard Template (1280)",
"_lastAccessed": 1413150228,
"_files": {}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment