Skip to content

Instantly share code, notes, and snippets.

@rozanovz

rozanovz/gist:b8494196679575e42692e810963a359a

Created April 29, 2016 13:21
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save rozanovz/b8494196679575e42692e810963a359a to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save rozanovz/b8494196679575e42692e810963a359a to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
{
"card":{
"description":"TD-TR-03",
"name":"T5/T6- Weekly Trading Report - exc VAT Last Week",
"subType":"table",
"rangeName":"prevWeek",
"selectedTotals":[
],
"type":"table",
"yAxis":{
"label":"Label",
"type":"Label",
"symbol":null
},
"xAxis":{
"label":"Date",
"type":"Date",
"symbol":null
},
"multipleAxis":false,
"showGroupingAsPercentage":false,
"showTableTotals":true,
"availableTypes":[
"line",
"bar"
],
"columnsSort":[
{
"text":"All - Forecast exc VAT",
"initialIndex":1,
"direction":"asc"
},
{
"text":"store",
"initialIndex":0,
"direction":"asc"
}
],
"selectedFrequency":"Total",
"fromDate":1460851200000,
"toDate":1461455999000,
"metricInfoMap":{
"undefined":{
}
},
"dataSets":[
{
"metric":{
"id":242
},
"virtualId":1,
"hidden":false,
"name":"All - Forecast exc VAT",
"color":null,
"position":0
},
{
"metric":{
"id":10083
},
"virtualId":2,
"hidden":true,
"name":"Web - Shipping Charges inc VAT (Pounds)",
"color":null,
"position":1
},
{
"metric":{
"id":295
},
"virtualId":3,
"hidden":true,
"name":"Web - Ship Revenue exc VAT (Pounds)",
"color":null,
"position":2
},
{
"metric":{
"id":10085
},
"virtualId":4,
"hidden":true,
"name":"Trade - Shipping Charges exc VAT (Pounds)",
"color":null,
"position":3
},
{
"metric":{
"id":10075
},
"virtualId":5,
"hidden":true,
"name":"Store Revenue exc VAT (Pounds)",
"color":null,
"position":4
},
{
"metric":{
"id":241
},
"virtualId":6,
"hidden":false,
"name":"All - Budget exc VAT",
"color":null,
"position":5
},
{
"metric":{
"id":290
},
"virtualId":7,
"hidden":true,
"name":"Trade - Refunds exc VAT (Pounds)",
"color":null,
"position":6
},
{
"metric":{
"id":289
},
"virtualId":8,
"hidden":true,
"name":"Trade - Ship Revenue exc VAT (Pounds)",
"color":null,
"position":7
},
{
"metric":{
"id":293
},
"virtualId":9,
"hidden":true,
"name":"Web - Refunds exc VAT (Pounds)",
"color":null,
"position":8
},
{
"comparable":{
"rangeName":"prevYear",
"dataSet":{
"virtualId":8303
}
},
"virtualId":10,
"hidden":true,
"name":"LY Trade Ref",
"color":null,
"position":9
},
{
"comparable":{
"rangeName":"prevYear",
"dataSet":{
"virtualId":8299
}
},
"virtualId":11,
"hidden":true,
"name":"LY Web Rev",
"color":null,
"position":10
},
{
"comparable":{
"rangeName":"prevYear",
"dataSet":{
"virtualId":8301
}
},
"virtualId":12,
"hidden":true,
"name":"LY Store Rev",
"color":null,
"position":11
},
{
"comparable":{
"rangeName":"prevYear",
"dataSet":{
"virtualId":8305
}
},
"virtualId":13,
"hidden":true,
"name":"LY Web Ref",
"color":null,
"position":12
},
{
"comparable":{
"rangeName":"prevYear",
"dataSet":{
"virtualId":8304
}
},
"virtualId":14,
"hidden":true,
"name":"LY Trade Rev",
"color":null,
"position":13
},
{
"comparable":{
"rangeName":"prevYear",
"dataSet":{
"virtualId":8298
}
},
"virtualId":15,
"hidden":true,
"name":"LY Web SC",
"color":null,
"position":14
},
{
"comparable":{
"rangeName":"prevYear",
"dataSet":{
"virtualId":8300
}
},
"virtualId":16,
"hidden":true,
"name":"LY Trade SC",
"color":null,
"position":15
},
{
"formula":{
"virtualId":24
},
"virtualId":17,
"hidden":false,
"name":"Vs Budget",
"color":null,
"position":16
},
{
"formula":{
"virtualId":23
},
"virtualId":18,
"hidden":false,
"name":"LY Revenue",
"color":null,
"position":17
},
{
"formula":{
"virtualId":22
},
"virtualId":19,
"hidden":false,
"name":"Revenue",
"color":null,
"position":18
},
{
"formula":{
"virtualId":26
},
"virtualId":20,
"hidden":false,
"name":"Vs Forecast",
"color":null,
"position":19
},
{
"formula":{
"virtualId":25
},
"virtualId":21,
"hidden":false,
"name":"YoY",
"color":null,
"position":20
}
],
"segments":[
],
"groupBys":[
{
"column":{
"id":133,
"type":"varchar",
"tableId":44,
"displayName":null,
"hidden":false,
"name":"store",
"label":"store"
},
"values":null,
"applyGroupByNull":false
}
],
"formulas":[
{
"virtualId":22,
"type":"£",
"expression":"A+B-C+F-G+M+N",
"name":"Revenue",
"metrics":{
"1":"A",
"2":"B",
"3":"C",
"6":"F",
"7":"G",
"13":"M",
"14":"N"
},
"color":null
},
{
"virtualId":23,
"type":"£",
"expression":"H+I-J+K-L+O+P",
"name":"LY Revenue",
"metrics":{
"8":"H",
"9":"I",
"10":"J",
"11":"K",
"12":"L",
"15":"O",
"16":"P"
},
"color":null
},
{
"virtualId":24,
"type":"%",
"expression":"((A+B-C+F-G+M+N)/D)-1",
"name":"Vs Budget",
"metrics":{
"1":"A",
"2":"B",
"3":"C",
"4":"D",
"6":"F",
"7":"G",
"13":"M",
"14":"N"
},
"color":null
},
{
"virtualId":25,
"type":"%",
"expression":"((A+B-C+F-G+M+N)/(H+I-J+K-L+O+P))-1",
"name":"YoY",
"metrics":{
"1":"A",
"2":"B",
"3":"C",
"6":"F",
"7":"G",
"8":"H",
"9":"I",
"10":"J",
"11":"K",
"12":"L",
"13":"M",
"14":"N",
"15":"O",
"16":"P"
},
"color":null
},
{
"virtualId":26,
"type":"%",
"expression":"((A+B-C+F-G+M+N)/E)-1",
"name":"Vs Forecast",
"metrics":{
"1":"A",
"2":"B",
"3":"C",
"5":"E",
"6":"F",
"7":"G",
"13":"M",
"14":"N"
},
"color":null
}
],
"filters":[
],
"owner":{
"id":10
},
"letters":{
"0":"A",
"1":"B",
"2":"C",
"3":"D",
"4":"E",
"5":"F",
"6":"G",
"7":"H",
"8":"I",
"9":"J",
"10":"K",
"11":"L",
"12":"M",
"13":"N",
"14":"O",
"15":"P",
"16":"Q",
"17":"R",
"18":"S",
"19":"T",
"20":"U",
"21":"V",
"22":"W",
"23":"X",
"24":"Y",
"25":"Z"
},
"moving":{
"from":true,
"to":true
},
"size":2000
},
"page":1
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment