Skip to content

Instantly share code, notes, and snippets.

@rozanovz

rozanovz/gist:422a0d390adfaa8135345876b8955bbc

Created April 29, 2016 13:20
Show Gist options

  • Select an option

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

Select an option

Learn more about clone URLs
Save rozanovz/422a0d390adfaa8135345876b8955bbc to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
{
"data":{
"results":[
[
"[\"Holkham Head Office\"]",
0.0,
0.0,
299.5592307692308,
0.0,
0.0
],
[
"[\"Korea Press\"]",
0.0,
0.0,
2209.44,
0.0,
0.0
],
[
"[\"Online Selfridges\"]",
0.0,
0.0,
83592.3499999998,
0.0,
0.0
],
[
"[\"Harrods Lower Level\"]",
0.0,
0.0,
595790.8999999997,
0.0,
0.0
],
[
"[\"Selfridges Trafford\"]",
0.0,
0.0,
688753.8200000012,
0.0,
0.0
],
[
"[\"Canary Wharf\"]",
0.0,
0.0,
947610.9200000013,
0.0,
0.0
],
[
"[\"Duke of York\"]",
0.0,
0.0,
1003312.2200000018,
0.0,
0.0
],
[
"[\"Hong Kong IFC Store\"]",
0.0,
0.0,
1172997.7083333335,
0.0,
0.0
],
[
"[\"Harrods Ground Floor\"]",
0.0,
0.0,
1338502.38,
0.0,
0.0
],
[
"[\"South Molton St\"]",
0.0,
0.0,
1566563.430000002,
0.0,
0.0
],
[
"[\"Trade\"]",
0.0,
0.0,
2528590.596593438,
0.0,
0.0
],
[
"[\"Selfridges London\"]",
0.0,
0.0,
3030125.0000000186,
0.0,
0.0
],
[
"[\"Web\"]",
0.0,
0.0,
6667422.111446918,
0.0,
0.0
]
],
"columns":[
{
"title":"store"
},
{
"virtualId":6
},
{
"virtualId":7
},
{
"virtualId":8
},
{
"virtualId":10
},
{
"virtualId":9
}
],
"total":13
},
"stats":{
},
"metrics":[
{
"id":293,
"statement":"Cast(sum({96}*({5747}/{86})) AS float8)",
"url":null,
"name":"Web - Refunds exc VAT (Pounds)",
"description":"Refunds paid exc VAT",
"type":"Chart",
"subType":"line",
"source":"Web Orders",
"createdBy":null,
"defaultFrequency":"Weekly",
"complexity":"dynamicRelation",
"symbol":null,
"dateColumn":"129",
"dateFieldIndex":0,
"cohort":false,
"multipleDates":false,
"organisation":{
"id":6,
"name":"Monica Vinader",
"location":"London",
"logo":"https://truedash-static.s3.amazonaws.com/images/sandbox/6/logo/organizationLogo",
"fiscalYearStart":7,
"sunWeek":true,
"nullGroupingName":null
},
"columnFormats":null,
"active":true,
"xAxis":{
"label":"time",
"type":"Date",
"symbol":null
},
"yAxis":{
"label":"Amount",
"type":"numeric",
"symbol":"£"
},
"availableTypes":[
"pie",
"line",
"bar"
],
"availableColumns":[
{
"id":16,
"availableColumn":{
"id":2994,
"name":"transaction_qty",
"displayName":null,
"tableId":154,
"type":"integer",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":17,
"availableColumn":{
"id":2993,
"name":"transaction_pool",
"displayName":null,
"tableId":154,
"type":"varchar",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":18,
"availableColumn":{
"id":2997,
"name":"transaction_link_model",
"displayName":null,
"tableId":154,
"type":"varchar",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":20,
"availableColumn":{
"id":169,
"name":"item_id",
"displayName":null,
"tableId":341,
"type":"integer",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":31,
"availableColumn":{
"id":133,
"name":"store",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
"isFiltering":null,
"isGrouping":true
},
{
"id":39,
"availableColumn":{
"id":6663,
"name":"fiscal_ytd",
"displayName":null,
"tableId":81,
"type":"varchar",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":40,
"availableColumn":{
"id":2558,
"name":"product_title",
"displayName":null,
"tableId":67,
"type":"varchar",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":42,
"availableColumn":{
"id":5455,
"name":"mv_region",
"displayName":null,
"tableId":59,
"type":"character varying(256)",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":43,
"availableColumn":{
"id":91,
"name":"country",
"displayName":null,
"tableId":59,
"type":"varchar",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":44,
"availableColumn":{
"id":5457,
"name":"budget_region",
"displayName":null,
"tableId":59,
"type":"character varying(256)",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":45,
"availableColumn":{
"id":5456,
"name":"budget_country",
"displayName":null,
"tableId":59,
"type":"character varying(256)",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":46,
"availableColumn":{
"id":2650,
"name":"product_business_collection",
"displayName":null,
"tableId":67,
"type":"varchar",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":47,
"availableColumn":{
"id":4961,
"name":"business_type_name",
"displayName":null,
"tableId":150,
"type":"character varying(255)",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":48,
"availableColumn":{
"id":5781,
"name":"type_name",
"displayName":null,
"tableId":161,
"type":"character varying(255)",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":49,
"availableColumn":{
"id":2969,
"name":"shipment_item_created",
"displayName":null,
"tableId":83,
"type":"TIMESTAMP",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":50,
"availableColumn":{
"id":2923,
"name":"item_key",
"displayName":null,
"tableId":81,
"type":"varchar",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":51,
"availableColumn":{
"id":119,
"name":"shipment_status",
"displayName":null,
"tableId":49,
"type":"varchar",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":52,
"availableColumn":{
"id":98,
"name":"item_type",
"displayName":null,
"tableId":81,
"type":"varchar",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":524763,
"availableColumn":{
"id":2967,
"name":"shipment_item_id",
"displayName":null,
"tableId":83,
"type":"INTEGER",
"hidden":false
},
"isFiltering":true,
"isGrouping":false
}
],
"frequencies":[
"Hourly",
"Daily",
"Weekly",
"Monthly",
"Yearly"
],
"table":{
"id":44,
"name":"monicavinader.mv_orders",
"position":{
"posX":1621,
"posY":6
},
"dataSource":{
"id":2,
"name":"MonicaVinader Reporting",
"type":"MySql",
"organisation":{
"id":6,
"name":"Monica Vinader",
"location":"London",
"logo":"https://truedash-static.s3.amazonaws.com/images/sandbox/6/logo/organizationLogo",
"fiscalYearStart":7,
"sunWeek":true,
"nullGroupingName":null
}
},
"columns":[
{
"id":73,
"name":"order_customer",
"displayName":null,
"tableId":44,
"type":"integer",
"hidden":false
},
{
"id":74,
"name":"order_processed",
"displayName":null,
"tableId":44,
"type":"timestamp",
"hidden":false
},
{
"id":99,
"name":"order_id",
"displayName":null,
"tableId":44,
"type":"integer",
"hidden":false
},
{
"id":100,
"name":"order_created",
"displayName":null,
"tableId":44,
"type":"timestamp",
"hidden":false
},
{
"id":111,
"name":"order_is_trade",
"displayName":null,
"tableId":44,
"type":"boolean",
"hidden":false
},
{
"id":112,
"name":"order_totalprice",
"displayName":null,
"tableId":44,
"type":"numeric",
"hidden":false
},
{
"id":113,
"name":"order_totalprice_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":122,
"name":"order_reference",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":125,
"name":"order_totalprice_reporting",
"displayName":null,
"tableId":44,
"type":"numeric",
"hidden":false
},
{
"id":126,
"name":"order_totaltax_reporting",
"displayName":null,
"tableId":44,
"type":"numeric",
"hidden":false
},
{
"id":132,
"name":"created_week",
"displayName":null,
"tableId":44,
"type":"int",
"hidden":false
},
{
"id":133,
"name":"store",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":163,
"name":"order_count_number",
"displayName":null,
"tableId":44,
"type":"integer",
"hidden":false
},
{
"id":165,
"name":"lifetime_number_of_orders",
"displayName":null,
"tableId":44,
"type":"integer",
"hidden":false
},
{
"id":2655,
"name":"order_last_modified",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2656,
"name":"order_email",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2657,
"name":"order_description",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2658,
"name":"order_updated",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2659,
"name":"order_tracking",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2660,
"name":"order_referrer",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2661,
"name":"order_keywords",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2662,
"name":"order_status",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2663,
"name":"order_submissions",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2664,
"name":"order_billing_address",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2665,
"name":"order_delivery_address",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2666,
"name":"order_card",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2667,
"name":"order_totaltax_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":2668,
"name":"order_totalexoffers_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":2669,
"name":"order_shipping_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":2670,
"name":"order_totaltax_reporting_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":2671,
"name":"order_totalprice_reporting_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":2672,
"name":"order_comments",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2673,
"name":"order_source",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2674,
"name":"order_third_man_score",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2675,
"name":"order_third_man_action",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2676,
"name":"order_customer_fullname",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2677,
"name":"order_cegid_status",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2678,
"name":"order_tracking_code",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2679,
"name":"order_partial_shipment",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2680,
"name":"order_giftmessage",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2681,
"name":"order_shipping_updated",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2682,
"name":"order_cegid_reference",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2683,
"name":"order_flags",
"displayName":null,
"tableId":44,
"type":"BIGINT",
"hidden":false
},
{
"id":2684,
"name":"order_cegid_invoice_reference",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2685,
"name":"order_include_giftmessage",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2686,
"name":"order_included_giftbags",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2687,
"name":"order_cegid_check_required",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2688,
"name":"order_billing_country",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2689,
"name":"order_delivery_country",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2690,
"name":"order_picklist_printed",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2691,
"name":"order_dispatch_date_current",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2692,
"name":"order_delivery_date_current",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2693,
"name":"order_dispatch_date_original",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2694,
"name":"order_delivery_date_original",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2695,
"name":"order_dispatch_owner",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2696,
"name":"order_late_reason",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2697,
"name":"order_vouchers_sent",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2698,
"name":"order_special",
"displayName":null,
"tableId":44,
"type":"BOOLEAN",
"hidden":false
},
{
"id":2699,
"name":"order_packaging",
"displayName":null,
"tableId":44,
"type":"BOOLEAN",
"hidden":false
},
{
"id":2700,
"name":"order_internal_reference",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2701,
"name":"order_allocation_warehouse",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2702,
"name":"order_cegid_tax_system",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2703,
"name":"order_customer_name",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2704,
"name":"order_required_by",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2705,
"name":"order_external_reference",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2706,
"name":"order_discount",
"displayName":null,
"tableId":44,
"type":"float",
"hidden":false
},
{
"id":2707,
"name":"order_ordered",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2708,
"name":"order_required",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2709,
"name":"order_allocated",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2710,
"name":"order_shipped",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2711,
"name":"order_hash",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2712,
"name":"order_original_totalprice_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":2713,
"name":"order_original_totaltax_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":2714,
"name":"order_original_shipping_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":2715,
"name":"order_from_date",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2716,
"name":"order_to_date",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2717,
"name":"order_payments",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2718,
"name":"order_cegid_amend_required",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2719,
"name":"order_customer_type",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2720,
"name":"order_new_user",
"displayName":null,
"tableId":44,
"type":"BOOLEAN",
"hidden":false
},
{
"id":2721,
"name":"order_checkout_variant",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2722,
"name":"order_totalexcreditsextax_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":2723,
"name":"order_retail_store",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2724,
"name":"order_sales_assistant",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":5478,
"name":"order_totaltax",
"displayName":null,
"tableId":44,
"type":"numeric(24,6)",
"hidden":false
},
{
"id":5479,
"name":"order_totalexoffers",
"displayName":null,
"tableId":44,
"type":"numeric(24,6)",
"hidden":false
},
{
"id":5480,
"name":"order_shipping",
"displayName":null,
"tableId":44,
"type":"numeric(24,6)",
"hidden":false
},
{
"id":5481,
"name":"order_original_totalprice",
"displayName":null,
"tableId":44,
"type":"numeric(24,6)",
"hidden":false
},
{
"id":5482,
"name":"order_original_totaltax",
"displayName":null,
"tableId":44,
"type":"numeric(24,6)",
"hidden":false
},
{
"id":5483,
"name":"order_original_shipping",
"displayName":null,
"tableId":44,
"type":"numeric(24,6)",
"hidden":false
},
{
"id":5484,
"name":"order_totalexcreditsextax",
"displayName":null,
"tableId":44,
"type":"numeric(24,6)",
"hidden":false
},
{
"id":5485,
"name":"order_gateway_flags",
"displayName":null,
"tableId":44,
"type":"character varying(255)",
"hidden":false
},
{
"id":5486,
"name":"order_line_offer_updated",
"displayName":null,
"tableId":44,
"type":"boolean",
"hidden":false
},
{
"id":15650,
"name":"order_issues",
"displayName":null,
"tableId":44,
"type":"bigint",
"hidden":false
}
]
},
"columns":null,
"drillMap":null,
"addressColumn":null,
"owner":null,
"rule":null,
"formulas":[
],
"relationId":null,
"complex":false,
"comparable":false,
"columnGroupings":[
"store"
],
"hidden":true,
"toDate":1438387199000,
"fromDate":1406851200000,
"rangeName":"prevFiscalYear",
"virtualId":3,
"color":null
},
{
"id":290,
"statement":"Cast(-sum({96}*({5737}/{86})) AS float8)",
"url":null,
"name":"Trade - Refunds exc VAT (Pounds)",
"description":"Trade paid exc VAT",
"type":"Chart",
"subType":"line",
"source":"Trade Orders",
"createdBy":null,
"defaultFrequency":"Weekly",
"complexity":"dynamicRelation",
"symbol":null,
"dateColumn":"129",
"dateFieldIndex":0,
"cohort":false,
"multipleDates":false,
"organisation":{
"id":6,
"name":"Monica Vinader",
"location":"London",
"logo":"https://truedash-static.s3.amazonaws.com/images/sandbox/6/logo/organizationLogo",
"fiscalYearStart":7,
"sunWeek":true,
"nullGroupingName":null
},
"columnFormats":null,
"active":true,
"xAxis":{
"label":"time",
"type":"Date",
"symbol":null
},
"yAxis":{
"label":"Amount",
"type":"numeric",
"symbol":"£"
},
"availableTypes":[
"pie",
"line",
"bar"
],
"availableColumns":[
{
"id":16,
"availableColumn":{
"id":2994,
"name":"transaction_qty",
"displayName":null,
"tableId":154,
"type":"integer",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":17,
"availableColumn":{
"id":2993,
"name":"transaction_pool",
"displayName":null,
"tableId":154,
"type":"varchar",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":18,
"availableColumn":{
"id":2997,
"name":"transaction_link_model",
"displayName":null,
"tableId":154,
"type":"varchar",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":20,
"availableColumn":{
"id":169,
"name":"item_id",
"displayName":null,
"tableId":341,
"type":"integer",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":31,
"availableColumn":{
"id":133,
"name":"store",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
"isFiltering":null,
"isGrouping":true
},
{
"id":39,
"availableColumn":{
"id":6663,
"name":"fiscal_ytd",
"displayName":null,
"tableId":81,
"type":"varchar",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":40,
"availableColumn":{
"id":2558,
"name":"product_title",
"displayName":null,
"tableId":67,
"type":"varchar",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":42,
"availableColumn":{
"id":5455,
"name":"mv_region",
"displayName":null,
"tableId":59,
"type":"character varying(256)",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":43,
"availableColumn":{
"id":91,
"name":"country",
"displayName":null,
"tableId":59,
"type":"varchar",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":44,
"availableColumn":{
"id":5457,
"name":"budget_region",
"displayName":null,
"tableId":59,
"type":"character varying(256)",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":45,
"availableColumn":{
"id":5456,
"name":"budget_country",
"displayName":null,
"tableId":59,
"type":"character varying(256)",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":46,
"availableColumn":{
"id":2650,
"name":"product_business_collection",
"displayName":null,
"tableId":67,
"type":"varchar",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":47,
"availableColumn":{
"id":4961,
"name":"business_type_name",
"displayName":null,
"tableId":150,
"type":"character varying(255)",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":48,
"availableColumn":{
"id":5781,
"name":"type_name",
"displayName":null,
"tableId":161,
"type":"character varying(255)",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":49,
"availableColumn":{
"id":2969,
"name":"shipment_item_created",
"displayName":null,
"tableId":83,
"type":"TIMESTAMP",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":50,
"availableColumn":{
"id":2923,
"name":"item_key",
"displayName":null,
"tableId":81,
"type":"varchar",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":51,
"availableColumn":{
"id":119,
"name":"shipment_status",
"displayName":null,
"tableId":49,
"type":"varchar",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":52,
"availableColumn":{
"id":98,
"name":"item_type",
"displayName":null,
"tableId":81,
"type":"varchar",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
}
],
"frequencies":[
"Hourly",
"Daily",
"Weekly",
"Monthly",
"Yearly"
],
"table":{
"id":44,
"name":"monicavinader.mv_orders",
"position":{
"posX":1621,
"posY":6
},
"dataSource":{
"id":2,
"name":"MonicaVinader Reporting",
"type":"MySql",
"organisation":{
"id":6,
"name":"Monica Vinader",
"location":"London",
"logo":"https://truedash-static.s3.amazonaws.com/images/sandbox/6/logo/organizationLogo",
"fiscalYearStart":7,
"sunWeek":true,
"nullGroupingName":null
}
},
"columns":[
{
"id":73,
"name":"order_customer",
"displayName":null,
"tableId":44,
"type":"integer",
"hidden":false
},
{
"id":74,
"name":"order_processed",
"displayName":null,
"tableId":44,
"type":"timestamp",
"hidden":false
},
{
"id":99,
"name":"order_id",
"displayName":null,
"tableId":44,
"type":"integer",
"hidden":false
},
{
"id":100,
"name":"order_created",
"displayName":null,
"tableId":44,
"type":"timestamp",
"hidden":false
},
{
"id":111,
"name":"order_is_trade",
"displayName":null,
"tableId":44,
"type":"boolean",
"hidden":false
},
{
"id":112,
"name":"order_totalprice",
"displayName":null,
"tableId":44,
"type":"numeric",
"hidden":false
},
{
"id":113,
"name":"order_totalprice_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":122,
"name":"order_reference",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":125,
"name":"order_totalprice_reporting",
"displayName":null,
"tableId":44,
"type":"numeric",
"hidden":false
},
{
"id":126,
"name":"order_totaltax_reporting",
"displayName":null,
"tableId":44,
"type":"numeric",
"hidden":false
},
{
"id":132,
"name":"created_week",
"displayName":null,
"tableId":44,
"type":"int",
"hidden":false
},
{
"id":133,
"name":"store",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":163,
"name":"order_count_number",
"displayName":null,
"tableId":44,
"type":"integer",
"hidden":false
},
{
"id":165,
"name":"lifetime_number_of_orders",
"displayName":null,
"tableId":44,
"type":"integer",
"hidden":false
},
{
"id":2655,
"name":"order_last_modified",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2656,
"name":"order_email",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2657,
"name":"order_description",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2658,
"name":"order_updated",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2659,
"name":"order_tracking",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2660,
"name":"order_referrer",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2661,
"name":"order_keywords",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2662,
"name":"order_status",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2663,
"name":"order_submissions",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2664,
"name":"order_billing_address",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2665,
"name":"order_delivery_address",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2666,
"name":"order_card",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2667,
"name":"order_totaltax_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":2668,
"name":"order_totalexoffers_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":2669,
"name":"order_shipping_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":2670,
"name":"order_totaltax_reporting_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":2671,
"name":"order_totalprice_reporting_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":2672,
"name":"order_comments",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2673,
"name":"order_source",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2674,
"name":"order_third_man_score",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2675,
"name":"order_third_man_action",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2676,
"name":"order_customer_fullname",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2677,
"name":"order_cegid_status",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2678,
"name":"order_tracking_code",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2679,
"name":"order_partial_shipment",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2680,
"name":"order_giftmessage",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2681,
"name":"order_shipping_updated",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2682,
"name":"order_cegid_reference",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2683,
"name":"order_flags",
"displayName":null,
"tableId":44,
"type":"BIGINT",
"hidden":false
},
{
"id":2684,
"name":"order_cegid_invoice_reference",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2685,
"name":"order_include_giftmessage",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2686,
"name":"order_included_giftbags",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2687,
"name":"order_cegid_check_required",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2688,
"name":"order_billing_country",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2689,
"name":"order_delivery_country",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2690,
"name":"order_picklist_printed",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2691,
"name":"order_dispatch_date_current",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2692,
"name":"order_delivery_date_current",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2693,
"name":"order_dispatch_date_original",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2694,
"name":"order_delivery_date_original",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2695,
"name":"order_dispatch_owner",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2696,
"name":"order_late_reason",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2697,
"name":"order_vouchers_sent",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2698,
"name":"order_special",
"displayName":null,
"tableId":44,
"type":"BOOLEAN",
"hidden":false
},
{
"id":2699,
"name":"order_packaging",
"displayName":null,
"tableId":44,
"type":"BOOLEAN",
"hidden":false
},
{
"id":2700,
"name":"order_internal_reference",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2701,
"name":"order_allocation_warehouse",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2702,
"name":"order_cegid_tax_system",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2703,
"name":"order_customer_name",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2704,
"name":"order_required_by",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2705,
"name":"order_external_reference",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2706,
"name":"order_discount",
"displayName":null,
"tableId":44,
"type":"float",
"hidden":false
},
{
"id":2707,
"name":"order_ordered",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2708,
"name":"order_required",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2709,
"name":"order_allocated",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2710,
"name":"order_shipped",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2711,
"name":"order_hash",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2712,
"name":"order_original_totalprice_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":2713,
"name":"order_original_totaltax_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":2714,
"name":"order_original_shipping_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":2715,
"name":"order_from_date",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2716,
"name":"order_to_date",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2717,
"name":"order_payments",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2718,
"name":"order_cegid_amend_required",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2719,
"name":"order_customer_type",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2720,
"name":"order_new_user",
"displayName":null,
"tableId":44,
"type":"BOOLEAN",
"hidden":false
},
{
"id":2721,
"name":"order_checkout_variant",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2722,
"name":"order_totalexcreditsextax_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":2723,
"name":"order_retail_store",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2724,
"name":"order_sales_assistant",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":5478,
"name":"order_totaltax",
"displayName":null,
"tableId":44,
"type":"numeric(24,6)",
"hidden":false
},
{
"id":5479,
"name":"order_totalexoffers",
"displayName":null,
"tableId":44,
"type":"numeric(24,6)",
"hidden":false
},
{
"id":5480,
"name":"order_shipping",
"displayName":null,
"tableId":44,
"type":"numeric(24,6)",
"hidden":false
},
{
"id":5481,
"name":"order_original_totalprice",
"displayName":null,
"tableId":44,
"type":"numeric(24,6)",
"hidden":false
},
{
"id":5482,
"name":"order_original_totaltax",
"displayName":null,
"tableId":44,
"type":"numeric(24,6)",
"hidden":false
},
{
"id":5483,
"name":"order_original_shipping",
"displayName":null,
"tableId":44,
"type":"numeric(24,6)",
"hidden":false
},
{
"id":5484,
"name":"order_totalexcreditsextax",
"displayName":null,
"tableId":44,
"type":"numeric(24,6)",
"hidden":false
},
{
"id":5485,
"name":"order_gateway_flags",
"displayName":null,
"tableId":44,
"type":"character varying(255)",
"hidden":false
},
{
"id":5486,
"name":"order_line_offer_updated",
"displayName":null,
"tableId":44,
"type":"boolean",
"hidden":false
},
{
"id":15650,
"name":"order_issues",
"displayName":null,
"tableId":44,
"type":"bigint",
"hidden":false
}
]
},
"columns":null,
"drillMap":null,
"addressColumn":null,
"owner":null,
"rule":null,
"formulas":[
],
"relationId":null,
"complex":false,
"comparable":false,
"columnGroupings":[
"store"
],
"hidden":true,
"toDate":1438387199000,
"fromDate":1406851200000,
"rangeName":"prevFiscalYear",
"virtualId":5,
"color":null
},
{
"id":241,
"statement":"Cast(sum ({92}) AS float8)",
"url":null,
"name":"All - Budget exc VAT",
"description":"Weekly budget exc. VAT metric",
"type":"Chart",
"subType":"line",
"source":"Finance",
"createdBy":null,
"defaultFrequency":"Weekly",
"complexity":"dynamicRelation",
"symbol":null,
"dateColumn":"94",
"dateFieldIndex":0,
"cohort":false,
"multipleDates":false,
"organisation":{
"id":6,
"name":"Monica Vinader",
"location":"London",
"logo":"https://truedash-static.s3.amazonaws.com/images/sandbox/6/logo/organizationLogo",
"fiscalYearStart":7,
"sunWeek":true,
"nullGroupingName":null
},
"columnFormats":null,
"active":true,
"xAxis":{
"label":"time",
"type":"Date",
"symbol":null
},
"yAxis":{
"label":"Amount",
"type":"numeric",
"symbol":"£"
},
"availableTypes":[
"pie",
"line",
"bar"
],
"availableColumns":[
],
"frequencies":[
"Hourly",
"Daily",
"Weekly",
"Monthly",
"Yearly"
],
"table":{
"id":51,
"name":"monicavinader.mv_finance_budget",
"position":{
"posX":512,
"posY":1586
},
"dataSource":{
"id":2,
"name":"MonicaVinader Reporting",
"type":"MySql",
"organisation":{
"id":6,
"name":"Monica Vinader",
"location":"London",
"logo":"https://truedash-static.s3.amazonaws.com/images/sandbox/6/logo/organizationLogo",
"fiscalYearStart":7,
"sunWeek":true,
"nullGroupingName":null
}
},
"columns":[
{
"id":92,
"name":"exc_vat",
"displayName":null,
"tableId":51,
"type":"double precision",
"hidden":false
},
{
"id":94,
"name":"week",
"displayName":null,
"tableId":51,
"type":"timestamp without time zone",
"hidden":false
},
{
"id":3734,
"name":"store",
"displayName":null,
"tableId":51,
"type":"character varying(256)",
"hidden":false
},
{
"id":5384,
"name":"fiscal_ytd",
"displayName":null,
"tableId":51,
"type":"character varying(256)",
"hidden":false
},
{
"id":5385,
"name":"budget_region",
"displayName":null,
"tableId":51,
"type":"character varying(256)",
"hidden":false
},
{
"id":11511,
"name":"week",
"displayName":null,
"tableId":51,
"type":"timestamp without time zone",
"hidden":false
},
{
"id":11512,
"name":"budget",
"displayName":null,
"tableId":51,
"type":"double precision",
"hidden":false
},
{
"id":11513,
"name":"store",
"displayName":null,
"tableId":51,
"type":"character varying(256)",
"hidden":false
},
{
"id":11514,
"name":"budget_country",
"displayName":null,
"tableId":51,
"type":"character varying(256)",
"hidden":false
},
{
"id":11515,
"name":"budget_region",
"displayName":null,
"tableId":51,
"type":"character varying(256)",
"hidden":false
},
{
"id":11516,
"name":"line_id",
"displayName":null,
"tableId":51,
"type":"integer",
"hidden":false
},
{
"id":11517,
"name":"exc_vat",
"displayName":null,
"tableId":51,
"type":"double precision",
"hidden":false
},
{
"id":11518,
"name":"fiscal_ytd",
"displayName":null,
"tableId":51,
"type":"character varying(256)",
"hidden":false
}
]
},
"columns":null,
"drillMap":null,
"addressColumn":null,
"owner":null,
"rule":null,
"formulas":[
],
"relationId":null,
"complex":false,
"comparable":false,
"columnGroupings":[
"store"
],
"hidden":false,
"toDate":1438387199000,
"fromDate":1406851200000,
"rangeName":"prevFiscalYear",
"virtualId":6,
"color":null
},
{
"id":289,
"statement":"Cast(sum(({5737}/{86})*{2994}) AS float8)",
"url":null,
"name":"Trade - Ship Revenue exc VAT (Pounds)",
"description":"Trade - Ship Revenue exc VAT (Pounds)",
"type":"Chart",
"subType":"line",
"source":"Trade Orders",
"createdBy":null,
"defaultFrequency":"Weekly",
"complexity":"dynamicRelation",
"symbol":null,
"dateColumn":"2969",
"dateFieldIndex":0,
"cohort":false,
"multipleDates":false,
"organisation":{
"id":6,
"name":"Monica Vinader",
"location":"London",
"logo":"https://truedash-static.s3.amazonaws.com/images/sandbox/6/logo/organizationLogo",
"fiscalYearStart":7,
"sunWeek":true,
"nullGroupingName":null
},
"columnFormats":null,
"active":true,
"xAxis":{
"label":"time",
"type":"Date",
"symbol":null
},
"yAxis":{
"label":"Amount",
"type":"numeric",
"symbol":"£"
},
"availableTypes":[
"pie",
"line",
"bar"
],
"availableColumns":[
{
"id":16,
"availableColumn":{
"id":2994,
"name":"transaction_qty",
"displayName":null,
"tableId":154,
"type":"integer",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":17,
"availableColumn":{
"id":2993,
"name":"transaction_pool",
"displayName":null,
"tableId":154,
"type":"varchar",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":18,
"availableColumn":{
"id":2997,
"name":"transaction_link_model",
"displayName":null,
"tableId":154,
"type":"varchar",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":19,
"availableColumn":{
"id":170,
"name":"max_transaction_id",
"displayName":null,
"tableId":154,
"type":"boolean",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":31,
"availableColumn":{
"id":133,
"name":"store",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
"isFiltering":null,
"isGrouping":true
},
{
"id":40,
"availableColumn":{
"id":2558,
"name":"product_title",
"displayName":null,
"tableId":67,
"type":"varchar",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":42,
"availableColumn":{
"id":5455,
"name":"mv_region",
"displayName":null,
"tableId":59,
"type":"character varying(256)",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":43,
"availableColumn":{
"id":91,
"name":"country",
"displayName":null,
"tableId":59,
"type":"varchar",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":44,
"availableColumn":{
"id":5457,
"name":"budget_region",
"displayName":null,
"tableId":59,
"type":"character varying(256)",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":45,
"availableColumn":{
"id":5456,
"name":"budget_country",
"displayName":null,
"tableId":59,
"type":"character varying(256)",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":46,
"availableColumn":{
"id":2650,
"name":"product_business_collection",
"displayName":null,
"tableId":67,
"type":"varchar",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":47,
"availableColumn":{
"id":4961,
"name":"business_type_name",
"displayName":null,
"tableId":150,
"type":"character varying(255)",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":48,
"availableColumn":{
"id":5781,
"name":"type_name",
"displayName":null,
"tableId":161,
"type":"character varying(255)",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":49,
"availableColumn":{
"id":2969,
"name":"shipment_item_created",
"displayName":null,
"tableId":83,
"type":"TIMESTAMP",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":50,
"availableColumn":{
"id":2923,
"name":"item_key",
"displayName":null,
"tableId":81,
"type":"varchar",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":51,
"availableColumn":{
"id":119,
"name":"shipment_status",
"displayName":null,
"tableId":49,
"type":"varchar",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":58,
"availableColumn":{
"id":148,
"name":"fiscal_ytd",
"displayName":null,
"tableId":83,
"type":"varchar",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
}
],
"frequencies":[
"Hourly",
"Daily",
"Weekly",
"Monthly",
"Yearly"
],
"table":{
"id":44,
"name":"monicavinader.mv_orders",
"position":{
"posX":1621,
"posY":6
},
"dataSource":{
"id":2,
"name":"MonicaVinader Reporting",
"type":"MySql",
"organisation":{
"id":6,
"name":"Monica Vinader",
"location":"London",
"logo":"https://truedash-static.s3.amazonaws.com/images/sandbox/6/logo/organizationLogo",
"fiscalYearStart":7,
"sunWeek":true,
"nullGroupingName":null
}
},
"columns":[
{
"id":73,
"name":"order_customer",
"displayName":null,
"tableId":44,
"type":"integer",
"hidden":false
},
{
"id":74,
"name":"order_processed",
"displayName":null,
"tableId":44,
"type":"timestamp",
"hidden":false
},
{
"id":99,
"name":"order_id",
"displayName":null,
"tableId":44,
"type":"integer",
"hidden":false
},
{
"id":100,
"name":"order_created",
"displayName":null,
"tableId":44,
"type":"timestamp",
"hidden":false
},
{
"id":111,
"name":"order_is_trade",
"displayName":null,
"tableId":44,
"type":"boolean",
"hidden":false
},
{
"id":112,
"name":"order_totalprice",
"displayName":null,
"tableId":44,
"type":"numeric",
"hidden":false
},
{
"id":113,
"name":"order_totalprice_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":122,
"name":"order_reference",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":125,
"name":"order_totalprice_reporting",
"displayName":null,
"tableId":44,
"type":"numeric",
"hidden":false
},
{
"id":126,
"name":"order_totaltax_reporting",
"displayName":null,
"tableId":44,
"type":"numeric",
"hidden":false
},
{
"id":132,
"name":"created_week",
"displayName":null,
"tableId":44,
"type":"int",
"hidden":false
},
{
"id":133,
"name":"store",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":163,
"name":"order_count_number",
"displayName":null,
"tableId":44,
"type":"integer",
"hidden":false
},
{
"id":165,
"name":"lifetime_number_of_orders",
"displayName":null,
"tableId":44,
"type":"integer",
"hidden":false
},
{
"id":2655,
"name":"order_last_modified",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2656,
"name":"order_email",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2657,
"name":"order_description",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2658,
"name":"order_updated",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2659,
"name":"order_tracking",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2660,
"name":"order_referrer",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2661,
"name":"order_keywords",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2662,
"name":"order_status",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2663,
"name":"order_submissions",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2664,
"name":"order_billing_address",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2665,
"name":"order_delivery_address",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2666,
"name":"order_card",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2667,
"name":"order_totaltax_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":2668,
"name":"order_totalexoffers_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":2669,
"name":"order_shipping_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":2670,
"name":"order_totaltax_reporting_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":2671,
"name":"order_totalprice_reporting_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":2672,
"name":"order_comments",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2673,
"name":"order_source",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2674,
"name":"order_third_man_score",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2675,
"name":"order_third_man_action",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2676,
"name":"order_customer_fullname",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2677,
"name":"order_cegid_status",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2678,
"name":"order_tracking_code",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2679,
"name":"order_partial_shipment",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2680,
"name":"order_giftmessage",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2681,
"name":"order_shipping_updated",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2682,
"name":"order_cegid_reference",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2683,
"name":"order_flags",
"displayName":null,
"tableId":44,
"type":"BIGINT",
"hidden":false
},
{
"id":2684,
"name":"order_cegid_invoice_reference",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2685,
"name":"order_include_giftmessage",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2686,
"name":"order_included_giftbags",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2687,
"name":"order_cegid_check_required",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2688,
"name":"order_billing_country",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2689,
"name":"order_delivery_country",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2690,
"name":"order_picklist_printed",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2691,
"name":"order_dispatch_date_current",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2692,
"name":"order_delivery_date_current",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2693,
"name":"order_dispatch_date_original",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2694,
"name":"order_delivery_date_original",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2695,
"name":"order_dispatch_owner",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2696,
"name":"order_late_reason",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2697,
"name":"order_vouchers_sent",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2698,
"name":"order_special",
"displayName":null,
"tableId":44,
"type":"BOOLEAN",
"hidden":false
},
{
"id":2699,
"name":"order_packaging",
"displayName":null,
"tableId":44,
"type":"BOOLEAN",
"hidden":false
},
{
"id":2700,
"name":"order_internal_reference",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2701,
"name":"order_allocation_warehouse",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2702,
"name":"order_cegid_tax_system",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2703,
"name":"order_customer_name",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2704,
"name":"order_required_by",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2705,
"name":"order_external_reference",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2706,
"name":"order_discount",
"displayName":null,
"tableId":44,
"type":"float",
"hidden":false
},
{
"id":2707,
"name":"order_ordered",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2708,
"name":"order_required",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2709,
"name":"order_allocated",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2710,
"name":"order_shipped",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2711,
"name":"order_hash",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2712,
"name":"order_original_totalprice_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":2713,
"name":"order_original_totaltax_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":2714,
"name":"order_original_shipping_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":2715,
"name":"order_from_date",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2716,
"name":"order_to_date",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2717,
"name":"order_payments",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2718,
"name":"order_cegid_amend_required",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2719,
"name":"order_customer_type",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2720,
"name":"order_new_user",
"displayName":null,
"tableId":44,
"type":"BOOLEAN",
"hidden":false
},
{
"id":2721,
"name":"order_checkout_variant",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2722,
"name":"order_totalexcreditsextax_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":2723,
"name":"order_retail_store",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2724,
"name":"order_sales_assistant",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":5478,
"name":"order_totaltax",
"displayName":null,
"tableId":44,
"type":"numeric(24,6)",
"hidden":false
},
{
"id":5479,
"name":"order_totalexoffers",
"displayName":null,
"tableId":44,
"type":"numeric(24,6)",
"hidden":false
},
{
"id":5480,
"name":"order_shipping",
"displayName":null,
"tableId":44,
"type":"numeric(24,6)",
"hidden":false
},
{
"id":5481,
"name":"order_original_totalprice",
"displayName":null,
"tableId":44,
"type":"numeric(24,6)",
"hidden":false
},
{
"id":5482,
"name":"order_original_totaltax",
"displayName":null,
"tableId":44,
"type":"numeric(24,6)",
"hidden":false
},
{
"id":5483,
"name":"order_original_shipping",
"displayName":null,
"tableId":44,
"type":"numeric(24,6)",
"hidden":false
},
{
"id":5484,
"name":"order_totalexcreditsextax",
"displayName":null,
"tableId":44,
"type":"numeric(24,6)",
"hidden":false
},
{
"id":5485,
"name":"order_gateway_flags",
"displayName":null,
"tableId":44,
"type":"character varying(255)",
"hidden":false
},
{
"id":5486,
"name":"order_line_offer_updated",
"displayName":null,
"tableId":44,
"type":"boolean",
"hidden":false
},
{
"id":15650,
"name":"order_issues",
"displayName":null,
"tableId":44,
"type":"bigint",
"hidden":false
}
]
},
"columns":null,
"drillMap":null,
"addressColumn":null,
"owner":null,
"rule":null,
"formulas":[
],
"relationId":null,
"complex":false,
"comparable":false,
"columnGroupings":[
"store"
],
"hidden":true,
"toDate":1438387199000,
"fromDate":1406851200000,
"rangeName":"prevFiscalYear",
"virtualId":4,
"color":null
},
{
"id":10075,
"statement":"Cast(sum(case when ({2923} ilike 'Store_Retail_Return%') then (-{5747}/{86}) else ({5747}/{86})end) As float8)",
"url":null,
"name":"Store Revenue exc VAT (Pounds)",
"description":"Store Revenue exc VAT (Pounds)",
"type":"Chart",
"subType":"line",
"source":"Orders",
"createdBy":null,
"defaultFrequency":"Weekly",
"complexity":"dynamicRelation",
"symbol":null,
"dateColumn":"74",
"dateFieldIndex":0,
"cohort":false,
"multipleDates":false,
"organisation":{
"id":6,
"name":"Monica Vinader",
"location":"London",
"logo":"https://truedash-static.s3.amazonaws.com/images/sandbox/6/logo/organizationLogo",
"fiscalYearStart":7,
"sunWeek":true,
"nullGroupingName":null
},
"columnFormats":null,
"active":true,
"xAxis":{
"label":"time",
"type":"Date",
"symbol":null
},
"yAxis":{
"label":"Amount",
"type":"numeric",
"symbol":"£"
},
"availableTypes":[
"pie",
"line",
"bar"
],
"availableColumns":[
{
"id":38,
"availableColumn":{
"id":133,
"name":"store",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":39,
"availableColumn":{
"id":6663,
"name":"fiscal_ytd",
"displayName":null,
"tableId":81,
"type":"varchar",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":40,
"availableColumn":{
"id":2558,
"name":"product_title",
"displayName":null,
"tableId":67,
"type":"varchar",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":46,
"availableColumn":{
"id":2650,
"name":"product_business_collection",
"displayName":null,
"tableId":67,
"type":"varchar",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":47,
"availableColumn":{
"id":4961,
"name":"business_type_name",
"displayName":null,
"tableId":150,
"type":"character varying(255)",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
}
],
"frequencies":[
"Hourly",
"Daily",
"Weekly",
"Monthly",
"Yearly"
],
"table":{
"id":44,
"name":"monicavinader.mv_orders",
"position":{
"posX":1621,
"posY":6
},
"dataSource":{
"id":2,
"name":"MonicaVinader Reporting",
"type":"MySql",
"organisation":{
"id":6,
"name":"Monica Vinader",
"location":"London",
"logo":"https://truedash-static.s3.amazonaws.com/images/sandbox/6/logo/organizationLogo",
"fiscalYearStart":7,
"sunWeek":true,
"nullGroupingName":null
}
},
"columns":[
{
"id":73,
"name":"order_customer",
"displayName":null,
"tableId":44,
"type":"integer",
"hidden":false
},
{
"id":74,
"name":"order_processed",
"displayName":null,
"tableId":44,
"type":"timestamp",
"hidden":false
},
{
"id":99,
"name":"order_id",
"displayName":null,
"tableId":44,
"type":"integer",
"hidden":false
},
{
"id":100,
"name":"order_created",
"displayName":null,
"tableId":44,
"type":"timestamp",
"hidden":false
},
{
"id":111,
"name":"order_is_trade",
"displayName":null,
"tableId":44,
"type":"boolean",
"hidden":false
},
{
"id":112,
"name":"order_totalprice",
"displayName":null,
"tableId":44,
"type":"numeric",
"hidden":false
},
{
"id":113,
"name":"order_totalprice_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":122,
"name":"order_reference",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":125,
"name":"order_totalprice_reporting",
"displayName":null,
"tableId":44,
"type":"numeric",
"hidden":false
},
{
"id":126,
"name":"order_totaltax_reporting",
"displayName":null,
"tableId":44,
"type":"numeric",
"hidden":false
},
{
"id":132,
"name":"created_week",
"displayName":null,
"tableId":44,
"type":"int",
"hidden":false
},
{
"id":133,
"name":"store",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":163,
"name":"order_count_number",
"displayName":null,
"tableId":44,
"type":"integer",
"hidden":false
},
{
"id":165,
"name":"lifetime_number_of_orders",
"displayName":null,
"tableId":44,
"type":"integer",
"hidden":false
},
{
"id":2655,
"name":"order_last_modified",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2656,
"name":"order_email",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2657,
"name":"order_description",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2658,
"name":"order_updated",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2659,
"name":"order_tracking",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2660,
"name":"order_referrer",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2661,
"name":"order_keywords",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2662,
"name":"order_status",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2663,
"name":"order_submissions",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2664,
"name":"order_billing_address",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2665,
"name":"order_delivery_address",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2666,
"name":"order_card",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2667,
"name":"order_totaltax_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":2668,
"name":"order_totalexoffers_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":2669,
"name":"order_shipping_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":2670,
"name":"order_totaltax_reporting_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":2671,
"name":"order_totalprice_reporting_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":2672,
"name":"order_comments",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2673,
"name":"order_source",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2674,
"name":"order_third_man_score",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2675,
"name":"order_third_man_action",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2676,
"name":"order_customer_fullname",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2677,
"name":"order_cegid_status",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2678,
"name":"order_tracking_code",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2679,
"name":"order_partial_shipment",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2680,
"name":"order_giftmessage",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2681,
"name":"order_shipping_updated",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2682,
"name":"order_cegid_reference",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2683,
"name":"order_flags",
"displayName":null,
"tableId":44,
"type":"BIGINT",
"hidden":false
},
{
"id":2684,
"name":"order_cegid_invoice_reference",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2685,
"name":"order_include_giftmessage",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2686,
"name":"order_included_giftbags",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2687,
"name":"order_cegid_check_required",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2688,
"name":"order_billing_country",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2689,
"name":"order_delivery_country",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2690,
"name":"order_picklist_printed",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2691,
"name":"order_dispatch_date_current",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2692,
"name":"order_delivery_date_current",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2693,
"name":"order_dispatch_date_original",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2694,
"name":"order_delivery_date_original",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2695,
"name":"order_dispatch_owner",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2696,
"name":"order_late_reason",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2697,
"name":"order_vouchers_sent",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2698,
"name":"order_special",
"displayName":null,
"tableId":44,
"type":"BOOLEAN",
"hidden":false
},
{
"id":2699,
"name":"order_packaging",
"displayName":null,
"tableId":44,
"type":"BOOLEAN",
"hidden":false
},
{
"id":2700,
"name":"order_internal_reference",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2701,
"name":"order_allocation_warehouse",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2702,
"name":"order_cegid_tax_system",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2703,
"name":"order_customer_name",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2704,
"name":"order_required_by",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2705,
"name":"order_external_reference",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2706,
"name":"order_discount",
"displayName":null,
"tableId":44,
"type":"float",
"hidden":false
},
{
"id":2707,
"name":"order_ordered",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2708,
"name":"order_required",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2709,
"name":"order_allocated",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2710,
"name":"order_shipped",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2711,
"name":"order_hash",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2712,
"name":"order_original_totalprice_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":2713,
"name":"order_original_totaltax_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":2714,
"name":"order_original_shipping_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":2715,
"name":"order_from_date",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2716,
"name":"order_to_date",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2717,
"name":"order_payments",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2718,
"name":"order_cegid_amend_required",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2719,
"name":"order_customer_type",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2720,
"name":"order_new_user",
"displayName":null,
"tableId":44,
"type":"BOOLEAN",
"hidden":false
},
{
"id":2721,
"name":"order_checkout_variant",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2722,
"name":"order_totalexcreditsextax_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":2723,
"name":"order_retail_store",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2724,
"name":"order_sales_assistant",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":5478,
"name":"order_totaltax",
"displayName":null,
"tableId":44,
"type":"numeric(24,6)",
"hidden":false
},
{
"id":5479,
"name":"order_totalexoffers",
"displayName":null,
"tableId":44,
"type":"numeric(24,6)",
"hidden":false
},
{
"id":5480,
"name":"order_shipping",
"displayName":null,
"tableId":44,
"type":"numeric(24,6)",
"hidden":false
},
{
"id":5481,
"name":"order_original_totalprice",
"displayName":null,
"tableId":44,
"type":"numeric(24,6)",
"hidden":false
},
{
"id":5482,
"name":"order_original_totaltax",
"displayName":null,
"tableId":44,
"type":"numeric(24,6)",
"hidden":false
},
{
"id":5483,
"name":"order_original_shipping",
"displayName":null,
"tableId":44,
"type":"numeric(24,6)",
"hidden":false
},
{
"id":5484,
"name":"order_totalexcreditsextax",
"displayName":null,
"tableId":44,
"type":"numeric(24,6)",
"hidden":false
},
{
"id":5485,
"name":"order_gateway_flags",
"displayName":null,
"tableId":44,
"type":"character varying(255)",
"hidden":false
},
{
"id":5486,
"name":"order_line_offer_updated",
"displayName":null,
"tableId":44,
"type":"boolean",
"hidden":false
},
{
"id":15650,
"name":"order_issues",
"displayName":null,
"tableId":44,
"type":"bigint",
"hidden":false
}
]
},
"columns":null,
"drillMap":null,
"addressColumn":null,
"owner":null,
"rule":null,
"formulas":[
],
"relationId":null,
"complex":false,
"comparable":false,
"columnGroupings":[
"store"
],
"hidden":true,
"toDate":1438387199000,
"fromDate":1406851200000,
"rangeName":"prevFiscalYear",
"virtualId":1,
"color":null
},
{
"id":242,
"statement":"Cast(sum({93}) AS float8)",
"url":null,
"name":"All - Forecast exc VAT",
"description":"Weekly forecast exc VAT metric",
"type":"Chart",
"subType":"line",
"source":"Finance",
"createdBy":null,
"defaultFrequency":"Weekly",
"complexity":"dynamicRelation",
"symbol":null,
"dateColumn":"95",
"dateFieldIndex":0,
"cohort":false,
"multipleDates":false,
"organisation":{
"id":6,
"name":"Monica Vinader",
"location":"London",
"logo":"https://truedash-static.s3.amazonaws.com/images/sandbox/6/logo/organizationLogo",
"fiscalYearStart":7,
"sunWeek":true,
"nullGroupingName":null
},
"columnFormats":null,
"active":true,
"xAxis":{
"label":"time",
"type":"Date",
"symbol":null
},
"yAxis":{
"label":"Amount",
"type":"numeric",
"symbol":"£"
},
"availableTypes":[
"pie",
"line",
"bar"
],
"availableColumns":[
],
"frequencies":[
"Hourly",
"Daily",
"Weekly",
"Monthly",
"Yearly"
],
"table":{
"id":52,
"name":"monicavinader.mv_finance_forecast",
"position":{
"posX":135,
"posY":1640
},
"dataSource":{
"id":2,
"name":"MonicaVinader Reporting",
"type":"MySql",
"organisation":{
"id":6,
"name":"Monica Vinader",
"location":"London",
"logo":"https://truedash-static.s3.amazonaws.com/images/sandbox/6/logo/organizationLogo",
"fiscalYearStart":7,
"sunWeek":true,
"nullGroupingName":null
}
},
"columns":[
{
"id":90,
"name":"budget_country",
"displayName":null,
"tableId":52,
"type":"character varying(256)",
"hidden":false
},
{
"id":93,
"name":"exc_vat",
"displayName":null,
"tableId":52,
"type":"integer",
"hidden":false
},
{
"id":95,
"name":"week_date",
"displayName":null,
"tableId":52,
"type":"timestamp",
"hidden":false
},
{
"id":5388,
"name":"forecast",
"displayName":null,
"tableId":52,
"type":"integer",
"hidden":false
},
{
"id":5389,
"name":"store",
"displayName":null,
"tableId":52,
"type":"character varying(256)",
"hidden":false
},
{
"id":5390,
"name":"week_timestamp",
"displayName":null,
"tableId":52,
"type":"timestamp without time zone",
"hidden":false
},
{
"id":5391,
"name":"week_in_this_week",
"displayName":null,
"tableId":52,
"type":"character varying(3)",
"hidden":false
},
{
"id":5392,
"name":"fiscal_ytd",
"displayName":null,
"tableId":52,
"type":"character varying(256)",
"hidden":false
},
{
"id":5393,
"name":"budget_region",
"displayName":null,
"tableId":52,
"type":"character varying(256)",
"hidden":false
},
{
"id":5394,
"name":"line_id",
"displayName":null,
"tableId":52,
"type":"integer",
"hidden":false
},
{
"id":5395,
"name":"type",
"displayName":null,
"tableId":52,
"type":"character varying(256)",
"hidden":false
},
{
"id":5396,
"name":"seconds_since_week",
"displayName":null,
"tableId":52,
"type":"bigint",
"hidden":false
}
]
},
"columns":null,
"drillMap":null,
"addressColumn":null,
"owner":null,
"rule":null,
"formulas":[
],
"relationId":null,
"complex":false,
"comparable":false,
"columnGroupings":[
"store"
],
"hidden":false,
"toDate":1438387199000,
"fromDate":1406851200000,
"rangeName":"prevFiscalYear",
"virtualId":7,
"color":null
},
{
"id":295,
"statement":"Cast(sum({5747}/{86}) AS float8)",
"url":null,
"name":"Web - Ship Revenue exc VAT (Pounds)",
"description":"Web - Ship Revenue exc VAT (Pounds)",
"type":"Chart",
"subType":"line",
"source":"Web Orders",
"createdBy":null,
"defaultFrequency":"Weekly",
"complexity":"dynamicRelation",
"symbol":null,
"dateColumn":"2969",
"dateFieldIndex":0,
"cohort":false,
"multipleDates":false,
"organisation":{
"id":6,
"name":"Monica Vinader",
"location":"London",
"logo":"https://truedash-static.s3.amazonaws.com/images/sandbox/6/logo/organizationLogo",
"fiscalYearStart":7,
"sunWeek":true,
"nullGroupingName":null
},
"columnFormats":null,
"active":true,
"xAxis":{
"label":"time",
"type":"Date",
"symbol":null
},
"yAxis":{
"label":"Amount",
"type":"numeric",
"symbol":"£"
},
"availableTypes":[
"pie",
"line",
"bar"
],
"availableColumns":[
{
"id":17,
"availableColumn":{
"id":2993,
"name":"transaction_pool",
"displayName":null,
"tableId":154,
"type":"varchar",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":18,
"availableColumn":{
"id":2997,
"name":"transaction_link_model",
"displayName":null,
"tableId":154,
"type":"varchar",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":19,
"availableColumn":{
"id":170,
"name":"max_transaction_id",
"displayName":null,
"tableId":154,
"type":"boolean",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":31,
"availableColumn":{
"id":133,
"name":"store",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
"isFiltering":null,
"isGrouping":true
},
{
"id":40,
"availableColumn":{
"id":2558,
"name":"product_title",
"displayName":null,
"tableId":67,
"type":"varchar",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":42,
"availableColumn":{
"id":5455,
"name":"mv_region",
"displayName":null,
"tableId":59,
"type":"character varying(256)",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":43,
"availableColumn":{
"id":91,
"name":"country",
"displayName":null,
"tableId":59,
"type":"varchar",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":44,
"availableColumn":{
"id":5457,
"name":"budget_region",
"displayName":null,
"tableId":59,
"type":"character varying(256)",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":45,
"availableColumn":{
"id":5456,
"name":"budget_country",
"displayName":null,
"tableId":59,
"type":"character varying(256)",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":46,
"availableColumn":{
"id":2650,
"name":"product_business_collection",
"displayName":null,
"tableId":67,
"type":"varchar",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":47,
"availableColumn":{
"id":4961,
"name":"business_type_name",
"displayName":null,
"tableId":150,
"type":"character varying(255)",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":48,
"availableColumn":{
"id":5781,
"name":"type_name",
"displayName":null,
"tableId":161,
"type":"character varying(255)",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":49,
"availableColumn":{
"id":2969,
"name":"shipment_item_created",
"displayName":null,
"tableId":83,
"type":"TIMESTAMP",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":50,
"availableColumn":{
"id":2923,
"name":"item_key",
"displayName":null,
"tableId":81,
"type":"varchar",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":51,
"availableColumn":{
"id":119,
"name":"shipment_status",
"displayName":null,
"tableId":49,
"type":"varchar",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":58,
"availableColumn":{
"id":148,
"name":"fiscal_ytd",
"displayName":null,
"tableId":83,
"type":"varchar",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
}
],
"frequencies":[
"Hourly",
"Daily",
"Weekly",
"Monthly",
"Yearly"
],
"table":{
"id":44,
"name":"monicavinader.mv_orders",
"position":{
"posX":1621,
"posY":6
},
"dataSource":{
"id":2,
"name":"MonicaVinader Reporting",
"type":"MySql",
"organisation":{
"id":6,
"name":"Monica Vinader",
"location":"London",
"logo":"https://truedash-static.s3.amazonaws.com/images/sandbox/6/logo/organizationLogo",
"fiscalYearStart":7,
"sunWeek":true,
"nullGroupingName":null
}
},
"columns":[
{
"id":73,
"name":"order_customer",
"displayName":null,
"tableId":44,
"type":"integer",
"hidden":false
},
{
"id":74,
"name":"order_processed",
"displayName":null,
"tableId":44,
"type":"timestamp",
"hidden":false
},
{
"id":99,
"name":"order_id",
"displayName":null,
"tableId":44,
"type":"integer",
"hidden":false
},
{
"id":100,
"name":"order_created",
"displayName":null,
"tableId":44,
"type":"timestamp",
"hidden":false
},
{
"id":111,
"name":"order_is_trade",
"displayName":null,
"tableId":44,
"type":"boolean",
"hidden":false
},
{
"id":112,
"name":"order_totalprice",
"displayName":null,
"tableId":44,
"type":"numeric",
"hidden":false
},
{
"id":113,
"name":"order_totalprice_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":122,
"name":"order_reference",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":125,
"name":"order_totalprice_reporting",
"displayName":null,
"tableId":44,
"type":"numeric",
"hidden":false
},
{
"id":126,
"name":"order_totaltax_reporting",
"displayName":null,
"tableId":44,
"type":"numeric",
"hidden":false
},
{
"id":132,
"name":"created_week",
"displayName":null,
"tableId":44,
"type":"int",
"hidden":false
},
{
"id":133,
"name":"store",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":163,
"name":"order_count_number",
"displayName":null,
"tableId":44,
"type":"integer",
"hidden":false
},
{
"id":165,
"name":"lifetime_number_of_orders",
"displayName":null,
"tableId":44,
"type":"integer",
"hidden":false
},
{
"id":2655,
"name":"order_last_modified",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2656,
"name":"order_email",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2657,
"name":"order_description",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2658,
"name":"order_updated",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2659,
"name":"order_tracking",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2660,
"name":"order_referrer",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2661,
"name":"order_keywords",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2662,
"name":"order_status",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2663,
"name":"order_submissions",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2664,
"name":"order_billing_address",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2665,
"name":"order_delivery_address",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2666,
"name":"order_card",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2667,
"name":"order_totaltax_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":2668,
"name":"order_totalexoffers_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":2669,
"name":"order_shipping_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":2670,
"name":"order_totaltax_reporting_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":2671,
"name":"order_totalprice_reporting_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":2672,
"name":"order_comments",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2673,
"name":"order_source",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2674,
"name":"order_third_man_score",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2675,
"name":"order_third_man_action",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2676,
"name":"order_customer_fullname",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2677,
"name":"order_cegid_status",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2678,
"name":"order_tracking_code",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2679,
"name":"order_partial_shipment",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2680,
"name":"order_giftmessage",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2681,
"name":"order_shipping_updated",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2682,
"name":"order_cegid_reference",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2683,
"name":"order_flags",
"displayName":null,
"tableId":44,
"type":"BIGINT",
"hidden":false
},
{
"id":2684,
"name":"order_cegid_invoice_reference",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2685,
"name":"order_include_giftmessage",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2686,
"name":"order_included_giftbags",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2687,
"name":"order_cegid_check_required",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2688,
"name":"order_billing_country",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2689,
"name":"order_delivery_country",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2690,
"name":"order_picklist_printed",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2691,
"name":"order_dispatch_date_current",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2692,
"name":"order_delivery_date_current",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2693,
"name":"order_dispatch_date_original",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2694,
"name":"order_delivery_date_original",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2695,
"name":"order_dispatch_owner",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2696,
"name":"order_late_reason",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2697,
"name":"order_vouchers_sent",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2698,
"name":"order_special",
"displayName":null,
"tableId":44,
"type":"BOOLEAN",
"hidden":false
},
{
"id":2699,
"name":"order_packaging",
"displayName":null,
"tableId":44,
"type":"BOOLEAN",
"hidden":false
},
{
"id":2700,
"name":"order_internal_reference",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2701,
"name":"order_allocation_warehouse",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2702,
"name":"order_cegid_tax_system",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2703,
"name":"order_customer_name",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2704,
"name":"order_required_by",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2705,
"name":"order_external_reference",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2706,
"name":"order_discount",
"displayName":null,
"tableId":44,
"type":"float",
"hidden":false
},
{
"id":2707,
"name":"order_ordered",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2708,
"name":"order_required",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2709,
"name":"order_allocated",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2710,
"name":"order_shipped",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2711,
"name":"order_hash",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2712,
"name":"order_original_totalprice_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":2713,
"name":"order_original_totaltax_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":2714,
"name":"order_original_shipping_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":2715,
"name":"order_from_date",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2716,
"name":"order_to_date",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2717,
"name":"order_payments",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2718,
"name":"order_cegid_amend_required",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2719,
"name":"order_customer_type",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2720,
"name":"order_new_user",
"displayName":null,
"tableId":44,
"type":"BOOLEAN",
"hidden":false
},
{
"id":2721,
"name":"order_checkout_variant",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2722,
"name":"order_totalexcreditsextax_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":2723,
"name":"order_retail_store",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2724,
"name":"order_sales_assistant",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":5478,
"name":"order_totaltax",
"displayName":null,
"tableId":44,
"type":"numeric(24,6)",
"hidden":false
},
{
"id":5479,
"name":"order_totalexoffers",
"displayName":null,
"tableId":44,
"type":"numeric(24,6)",
"hidden":false
},
{
"id":5480,
"name":"order_shipping",
"displayName":null,
"tableId":44,
"type":"numeric(24,6)",
"hidden":false
},
{
"id":5481,
"name":"order_original_totalprice",
"displayName":null,
"tableId":44,
"type":"numeric(24,6)",
"hidden":false
},
{
"id":5482,
"name":"order_original_totaltax",
"displayName":null,
"tableId":44,
"type":"numeric(24,6)",
"hidden":false
},
{
"id":5483,
"name":"order_original_shipping",
"displayName":null,
"tableId":44,
"type":"numeric(24,6)",
"hidden":false
},
{
"id":5484,
"name":"order_totalexcreditsextax",
"displayName":null,
"tableId":44,
"type":"numeric(24,6)",
"hidden":false
},
{
"id":5485,
"name":"order_gateway_flags",
"displayName":null,
"tableId":44,
"type":"character varying(255)",
"hidden":false
},
{
"id":5486,
"name":"order_line_offer_updated",
"displayName":null,
"tableId":44,
"type":"boolean",
"hidden":false
},
{
"id":15650,
"name":"order_issues",
"displayName":null,
"tableId":44,
"type":"bigint",
"hidden":false
}
]
},
"columns":null,
"drillMap":null,
"addressColumn":null,
"owner":null,
"rule":null,
"formulas":[
],
"relationId":null,
"complex":false,
"comparable":false,
"columnGroupings":[
"store"
],
"hidden":true,
"toDate":1438387199000,
"fromDate":1406851200000,
"rangeName":"prevFiscalYear",
"virtualId":2,
"color":null
},
{
"cohort":false,
"complex":false,
"formulaName":"Revenue",
"complexity":"dynamicRelation",
"columns":null,
"formulaId":11,
"columnGroupings":[
"store"
],
"type":"Chart",
"id":null,
"drillMap":null,
"title":"A+B-C+D-E",
"yAxis":{
"label":"Amount",
"type":"numeric",
"symbol":"£"
},
"rangeName":"prevFiscalYear",
"addressColumn":null,
"frequencies":[
"Hourly",
"Daily",
"Weekly",
"Monthly",
"Yearly"
],
"description":"formula generated data",
"rule":null,
"name":"Web - Refunds exc VAT (Pounds)",
"xAxis":{
"label":"time",
"type":"Date",
"symbol":null
},
"relationId":null,
"symbol":null,
"dateColumn":"129",
"organisation":{
"id":6,
"name":"Monica Vinader",
"location":"London",
"logo":"https://truedash-static.s3.amazonaws.com/images/sandbox/6/logo/organizationLogo",
"fiscalYearStart":7,
"sunWeek":true,
"nullGroupingName":null
},
"columnFormats":null,
"defaultFrequency":"Weekly",
"availableTypes":[
"pie",
"line",
"bar"
],
"toDate":1438387199000,
"comparable":false,
"table":{
"id":44,
"name":"monicavinader.mv_orders",
"position":{
"posX":1621,
"posY":6
},
"dataSource":{
"id":2,
"name":"MonicaVinader Reporting",
"type":"MySql",
"organisation":{
"id":6,
"name":"Monica Vinader",
"location":"London",
"logo":"https://truedash-static.s3.amazonaws.com/images/sandbox/6/logo/organizationLogo",
"fiscalYearStart":7,
"sunWeek":true,
"nullGroupingName":null
}
},
"columns":[
{
"id":73,
"name":"order_customer",
"displayName":null,
"tableId":44,
"type":"integer",
"hidden":false
},
{
"id":74,
"name":"order_processed",
"displayName":null,
"tableId":44,
"type":"timestamp",
"hidden":false
},
{
"id":99,
"name":"order_id",
"displayName":null,
"tableId":44,
"type":"integer",
"hidden":false
},
{
"id":100,
"name":"order_created",
"displayName":null,
"tableId":44,
"type":"timestamp",
"hidden":false
},
{
"id":111,
"name":"order_is_trade",
"displayName":null,
"tableId":44,
"type":"boolean",
"hidden":false
},
{
"id":112,
"name":"order_totalprice",
"displayName":null,
"tableId":44,
"type":"numeric",
"hidden":false
},
{
"id":113,
"name":"order_totalprice_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":122,
"name":"order_reference",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":125,
"name":"order_totalprice_reporting",
"displayName":null,
"tableId":44,
"type":"numeric",
"hidden":false
},
{
"id":126,
"name":"order_totaltax_reporting",
"displayName":null,
"tableId":44,
"type":"numeric",
"hidden":false
},
{
"id":132,
"name":"created_week",
"displayName":null,
"tableId":44,
"type":"int",
"hidden":false
},
{
"id":133,
"name":"store",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":163,
"name":"order_count_number",
"displayName":null,
"tableId":44,
"type":"integer",
"hidden":false
},
{
"id":165,
"name":"lifetime_number_of_orders",
"displayName":null,
"tableId":44,
"type":"integer",
"hidden":false
},
{
"id":2655,
"name":"order_last_modified",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2656,
"name":"order_email",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2657,
"name":"order_description",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2658,
"name":"order_updated",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2659,
"name":"order_tracking",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2660,
"name":"order_referrer",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2661,
"name":"order_keywords",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2662,
"name":"order_status",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2663,
"name":"order_submissions",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2664,
"name":"order_billing_address",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2665,
"name":"order_delivery_address",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2666,
"name":"order_card",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2667,
"name":"order_totaltax_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":2668,
"name":"order_totalexoffers_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":2669,
"name":"order_shipping_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":2670,
"name":"order_totaltax_reporting_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":2671,
"name":"order_totalprice_reporting_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":2672,
"name":"order_comments",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2673,
"name":"order_source",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2674,
"name":"order_third_man_score",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2675,
"name":"order_third_man_action",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2676,
"name":"order_customer_fullname",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2677,
"name":"order_cegid_status",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2678,
"name":"order_tracking_code",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2679,
"name":"order_partial_shipment",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2680,
"name":"order_giftmessage",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2681,
"name":"order_shipping_updated",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2682,
"name":"order_cegid_reference",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2683,
"name":"order_flags",
"displayName":null,
"tableId":44,
"type":"BIGINT",
"hidden":false
},
{
"id":2684,
"name":"order_cegid_invoice_reference",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2685,
"name":"order_include_giftmessage",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2686,
"name":"order_included_giftbags",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2687,
"name":"order_cegid_check_required",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2688,
"name":"order_billing_country",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2689,
"name":"order_delivery_country",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2690,
"name":"order_picklist_printed",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2691,
"name":"order_dispatch_date_current",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2692,
"name":"order_delivery_date_current",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2693,
"name":"order_dispatch_date_original",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2694,
"name":"order_delivery_date_original",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2695,
"name":"order_dispatch_owner",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2696,
"name":"order_late_reason",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2697,
"name":"order_vouchers_sent",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2698,
"name":"order_special",
"displayName":null,
"tableId":44,
"type":"BOOLEAN",
"hidden":false
},
{
"id":2699,
"name":"order_packaging",
"displayName":null,
"tableId":44,
"type":"BOOLEAN",
"hidden":false
},
{
"id":2700,
"name":"order_internal_reference",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2701,
"name":"order_allocation_warehouse",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2702,
"name":"order_cegid_tax_system",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2703,
"name":"order_customer_name",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2704,
"name":"order_required_by",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2705,
"name":"order_external_reference",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2706,
"name":"order_discount",
"displayName":null,
"tableId":44,
"type":"float",
"hidden":false
},
{
"id":2707,
"name":"order_ordered",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2708,
"name":"order_required",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2709,
"name":"order_allocated",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2710,
"name":"order_shipped",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2711,
"name":"order_hash",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2712,
"name":"order_original_totalprice_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":2713,
"name":"order_original_totaltax_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":2714,
"name":"order_original_shipping_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":2715,
"name":"order_from_date",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2716,
"name":"order_to_date",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2717,
"name":"order_payments",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2718,
"name":"order_cegid_amend_required",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2719,
"name":"order_customer_type",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2720,
"name":"order_new_user",
"displayName":null,
"tableId":44,
"type":"BOOLEAN",
"hidden":false
},
{
"id":2721,
"name":"order_checkout_variant",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2722,
"name":"order_totalexcreditsextax_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":2723,
"name":"order_retail_store",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2724,
"name":"order_sales_assistant",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":5478,
"name":"order_totaltax",
"displayName":null,
"tableId":44,
"type":"numeric(24,6)",
"hidden":false
},
{
"id":5479,
"name":"order_totalexoffers",
"displayName":null,
"tableId":44,
"type":"numeric(24,6)",
"hidden":false
},
{
"id":5480,
"name":"order_shipping",
"displayName":null,
"tableId":44,
"type":"numeric(24,6)",
"hidden":false
},
{
"id":5481,
"name":"order_original_totalprice",
"displayName":null,
"tableId":44,
"type":"numeric(24,6)",
"hidden":false
},
{
"id":5482,
"name":"order_original_totaltax",
"displayName":null,
"tableId":44,
"type":"numeric(24,6)",
"hidden":false
},
{
"id":5483,
"name":"order_original_shipping",
"displayName":null,
"tableId":44,
"type":"numeric(24,6)",
"hidden":false
},
{
"id":5484,
"name":"order_totalexcreditsextax",
"displayName":null,
"tableId":44,
"type":"numeric(24,6)",
"hidden":false
},
{
"id":5485,
"name":"order_gateway_flags",
"displayName":null,
"tableId":44,
"type":"character varying(255)",
"hidden":false
},
{
"id":5486,
"name":"order_line_offer_updated",
"displayName":null,
"tableId":44,
"type":"boolean",
"hidden":false
},
{
"id":15650,
"name":"order_issues",
"displayName":null,
"tableId":44,
"type":"bigint",
"hidden":false
}
]
},
"availableColumns":[
{
"id":16,
"availableColumn":{
"id":2994,
"name":"transaction_qty",
"displayName":null,
"tableId":154,
"type":"integer",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":17,
"availableColumn":{
"id":2993,
"name":"transaction_pool",
"displayName":null,
"tableId":154,
"type":"varchar",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":18,
"availableColumn":{
"id":2997,
"name":"transaction_link_model",
"displayName":null,
"tableId":154,
"type":"varchar",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":20,
"availableColumn":{
"id":169,
"name":"item_id",
"displayName":null,
"tableId":341,
"type":"integer",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":31,
"availableColumn":{
"id":133,
"name":"store",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
"isFiltering":null,
"isGrouping":true
},
{
"id":39,
"availableColumn":{
"id":6663,
"name":"fiscal_ytd",
"displayName":null,
"tableId":81,
"type":"varchar",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":40,
"availableColumn":{
"id":2558,
"name":"product_title",
"displayName":null,
"tableId":67,
"type":"varchar",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":42,
"availableColumn":{
"id":5455,
"name":"mv_region",
"displayName":null,
"tableId":59,
"type":"character varying(256)",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":43,
"availableColumn":{
"id":91,
"name":"country",
"displayName":null,
"tableId":59,
"type":"varchar",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":44,
"availableColumn":{
"id":5457,
"name":"budget_region",
"displayName":null,
"tableId":59,
"type":"character varying(256)",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":45,
"availableColumn":{
"id":5456,
"name":"budget_country",
"displayName":null,
"tableId":59,
"type":"character varying(256)",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":46,
"availableColumn":{
"id":2650,
"name":"product_business_collection",
"displayName":null,
"tableId":67,
"type":"varchar",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":47,
"availableColumn":{
"id":4961,
"name":"business_type_name",
"displayName":null,
"tableId":150,
"type":"character varying(255)",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":48,
"availableColumn":{
"id":5781,
"name":"type_name",
"displayName":null,
"tableId":161,
"type":"character varying(255)",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":49,
"availableColumn":{
"id":2969,
"name":"shipment_item_created",
"displayName":null,
"tableId":83,
"type":"TIMESTAMP",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":50,
"availableColumn":{
"id":2923,
"name":"item_key",
"displayName":null,
"tableId":81,
"type":"varchar",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":51,
"availableColumn":{
"id":119,
"name":"shipment_status",
"displayName":null,
"tableId":49,
"type":"varchar",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":52,
"availableColumn":{
"id":98,
"name":"item_type",
"displayName":null,
"tableId":81,
"type":"varchar",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":524763,
"availableColumn":{
"id":2967,
"name":"shipment_item_id",
"displayName":null,
"tableId":83,
"type":"INTEGER",
"hidden":false
},
"isFiltering":true,
"isGrouping":false
}
],
"url":null,
"statement":"Cast(sum({96}*({5747}/{86})) AS float8)",
"fromDate":1406851200000,
"createdBy":null,
"source":"Web Orders",
"color":null,
"hidden":false,
"multipleDates":false,
"subType":"line",
"owner":null,
"active":true,
"dateFieldIndex":0,
"virtualId":8,
"formula":true
},
{
"cohort":false,
"complex":false,
"formulaName":"Vs Forecast",
"complexity":"dynamicRelation",
"columns":null,
"formulaId":13,
"columnGroupings":[
"store"
],
"type":"Chart",
"id":null,
"drillMap":null,
"title":"((A+B-C+D-E)/G)-1",
"yAxis":{
"label":"Amount",
"type":"numeric",
"symbol":"%"
},
"rangeName":"prevFiscalYear",
"addressColumn":null,
"frequencies":[
"Hourly",
"Daily",
"Weekly",
"Monthly",
"Yearly"
],
"description":"formula generated data",
"rule":null,
"name":"Web - Refunds exc VAT (Pounds)",
"xAxis":{
"label":"time",
"type":"Date",
"symbol":null
},
"relationId":null,
"symbol":null,
"dateColumn":"129",
"organisation":{
"id":6,
"name":"Monica Vinader",
"location":"London",
"logo":"https://truedash-static.s3.amazonaws.com/images/sandbox/6/logo/organizationLogo",
"fiscalYearStart":7,
"sunWeek":true,
"nullGroupingName":null
},
"columnFormats":null,
"defaultFrequency":"Weekly",
"availableTypes":[
"pie",
"line",
"bar"
],
"toDate":1438387199000,
"comparable":false,
"table":{
"id":44,
"name":"monicavinader.mv_orders",
"position":{
"posX":1621,
"posY":6
},
"dataSource":{
"id":2,
"name":"MonicaVinader Reporting",
"type":"MySql",
"organisation":{
"id":6,
"name":"Monica Vinader",
"location":"London",
"logo":"https://truedash-static.s3.amazonaws.com/images/sandbox/6/logo/organizationLogo",
"fiscalYearStart":7,
"sunWeek":true,
"nullGroupingName":null
}
},
"columns":[
{
"id":73,
"name":"order_customer",
"displayName":null,
"tableId":44,
"type":"integer",
"hidden":false
},
{
"id":74,
"name":"order_processed",
"displayName":null,
"tableId":44,
"type":"timestamp",
"hidden":false
},
{
"id":99,
"name":"order_id",
"displayName":null,
"tableId":44,
"type":"integer",
"hidden":false
},
{
"id":100,
"name":"order_created",
"displayName":null,
"tableId":44,
"type":"timestamp",
"hidden":false
},
{
"id":111,
"name":"order_is_trade",
"displayName":null,
"tableId":44,
"type":"boolean",
"hidden":false
},
{
"id":112,
"name":"order_totalprice",
"displayName":null,
"tableId":44,
"type":"numeric",
"hidden":false
},
{
"id":113,
"name":"order_totalprice_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":122,
"name":"order_reference",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":125,
"name":"order_totalprice_reporting",
"displayName":null,
"tableId":44,
"type":"numeric",
"hidden":false
},
{
"id":126,
"name":"order_totaltax_reporting",
"displayName":null,
"tableId":44,
"type":"numeric",
"hidden":false
},
{
"id":132,
"name":"created_week",
"displayName":null,
"tableId":44,
"type":"int",
"hidden":false
},
{
"id":133,
"name":"store",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":163,
"name":"order_count_number",
"displayName":null,
"tableId":44,
"type":"integer",
"hidden":false
},
{
"id":165,
"name":"lifetime_number_of_orders",
"displayName":null,
"tableId":44,
"type":"integer",
"hidden":false
},
{
"id":2655,
"name":"order_last_modified",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2656,
"name":"order_email",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2657,
"name":"order_description",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2658,
"name":"order_updated",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2659,
"name":"order_tracking",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2660,
"name":"order_referrer",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2661,
"name":"order_keywords",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2662,
"name":"order_status",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2663,
"name":"order_submissions",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2664,
"name":"order_billing_address",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2665,
"name":"order_delivery_address",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2666,
"name":"order_card",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2667,
"name":"order_totaltax_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":2668,
"name":"order_totalexoffers_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":2669,
"name":"order_shipping_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":2670,
"name":"order_totaltax_reporting_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":2671,
"name":"order_totalprice_reporting_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":2672,
"name":"order_comments",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2673,
"name":"order_source",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2674,
"name":"order_third_man_score",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2675,
"name":"order_third_man_action",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2676,
"name":"order_customer_fullname",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2677,
"name":"order_cegid_status",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2678,
"name":"order_tracking_code",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2679,
"name":"order_partial_shipment",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2680,
"name":"order_giftmessage",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2681,
"name":"order_shipping_updated",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2682,
"name":"order_cegid_reference",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2683,
"name":"order_flags",
"displayName":null,
"tableId":44,
"type":"BIGINT",
"hidden":false
},
{
"id":2684,
"name":"order_cegid_invoice_reference",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2685,
"name":"order_include_giftmessage",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2686,
"name":"order_included_giftbags",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2687,
"name":"order_cegid_check_required",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2688,
"name":"order_billing_country",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2689,
"name":"order_delivery_country",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2690,
"name":"order_picklist_printed",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2691,
"name":"order_dispatch_date_current",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2692,
"name":"order_delivery_date_current",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2693,
"name":"order_dispatch_date_original",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2694,
"name":"order_delivery_date_original",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2695,
"name":"order_dispatch_owner",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2696,
"name":"order_late_reason",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2697,
"name":"order_vouchers_sent",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2698,
"name":"order_special",
"displayName":null,
"tableId":44,
"type":"BOOLEAN",
"hidden":false
},
{
"id":2699,
"name":"order_packaging",
"displayName":null,
"tableId":44,
"type":"BOOLEAN",
"hidden":false
},
{
"id":2700,
"name":"order_internal_reference",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2701,
"name":"order_allocation_warehouse",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2702,
"name":"order_cegid_tax_system",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2703,
"name":"order_customer_name",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2704,
"name":"order_required_by",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2705,
"name":"order_external_reference",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2706,
"name":"order_discount",
"displayName":null,
"tableId":44,
"type":"float",
"hidden":false
},
{
"id":2707,
"name":"order_ordered",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2708,
"name":"order_required",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2709,
"name":"order_allocated",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2710,
"name":"order_shipped",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2711,
"name":"order_hash",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2712,
"name":"order_original_totalprice_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":2713,
"name":"order_original_totaltax_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":2714,
"name":"order_original_shipping_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":2715,
"name":"order_from_date",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2716,
"name":"order_to_date",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2717,
"name":"order_payments",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2718,
"name":"order_cegid_amend_required",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2719,
"name":"order_customer_type",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2720,
"name":"order_new_user",
"displayName":null,
"tableId":44,
"type":"BOOLEAN",
"hidden":false
},
{
"id":2721,
"name":"order_checkout_variant",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2722,
"name":"order_totalexcreditsextax_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":2723,
"name":"order_retail_store",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2724,
"name":"order_sales_assistant",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":5478,
"name":"order_totaltax",
"displayName":null,
"tableId":44,
"type":"numeric(24,6)",
"hidden":false
},
{
"id":5479,
"name":"order_totalexoffers",
"displayName":null,
"tableId":44,
"type":"numeric(24,6)",
"hidden":false
},
{
"id":5480,
"name":"order_shipping",
"displayName":null,
"tableId":44,
"type":"numeric(24,6)",
"hidden":false
},
{
"id":5481,
"name":"order_original_totalprice",
"displayName":null,
"tableId":44,
"type":"numeric(24,6)",
"hidden":false
},
{
"id":5482,
"name":"order_original_totaltax",
"displayName":null,
"tableId":44,
"type":"numeric(24,6)",
"hidden":false
},
{
"id":5483,
"name":"order_original_shipping",
"displayName":null,
"tableId":44,
"type":"numeric(24,6)",
"hidden":false
},
{
"id":5484,
"name":"order_totalexcreditsextax",
"displayName":null,
"tableId":44,
"type":"numeric(24,6)",
"hidden":false
},
{
"id":5485,
"name":"order_gateway_flags",
"displayName":null,
"tableId":44,
"type":"character varying(255)",
"hidden":false
},
{
"id":5486,
"name":"order_line_offer_updated",
"displayName":null,
"tableId":44,
"type":"boolean",
"hidden":false
},
{
"id":15650,
"name":"order_issues",
"displayName":null,
"tableId":44,
"type":"bigint",
"hidden":false
}
]
},
"availableColumns":[
{
"id":16,
"availableColumn":{
"id":2994,
"name":"transaction_qty",
"displayName":null,
"tableId":154,
"type":"integer",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":17,
"availableColumn":{
"id":2993,
"name":"transaction_pool",
"displayName":null,
"tableId":154,
"type":"varchar",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":18,
"availableColumn":{
"id":2997,
"name":"transaction_link_model",
"displayName":null,
"tableId":154,
"type":"varchar",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":20,
"availableColumn":{
"id":169,
"name":"item_id",
"displayName":null,
"tableId":341,
"type":"integer",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":31,
"availableColumn":{
"id":133,
"name":"store",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
"isFiltering":null,
"isGrouping":true
},
{
"id":39,
"availableColumn":{
"id":6663,
"name":"fiscal_ytd",
"displayName":null,
"tableId":81,
"type":"varchar",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":40,
"availableColumn":{
"id":2558,
"name":"product_title",
"displayName":null,
"tableId":67,
"type":"varchar",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":42,
"availableColumn":{
"id":5455,
"name":"mv_region",
"displayName":null,
"tableId":59,
"type":"character varying(256)",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":43,
"availableColumn":{
"id":91,
"name":"country",
"displayName":null,
"tableId":59,
"type":"varchar",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":44,
"availableColumn":{
"id":5457,
"name":"budget_region",
"displayName":null,
"tableId":59,
"type":"character varying(256)",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":45,
"availableColumn":{
"id":5456,
"name":"budget_country",
"displayName":null,
"tableId":59,
"type":"character varying(256)",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":46,
"availableColumn":{
"id":2650,
"name":"product_business_collection",
"displayName":null,
"tableId":67,
"type":"varchar",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":47,
"availableColumn":{
"id":4961,
"name":"business_type_name",
"displayName":null,
"tableId":150,
"type":"character varying(255)",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":48,
"availableColumn":{
"id":5781,
"name":"type_name",
"displayName":null,
"tableId":161,
"type":"character varying(255)",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":49,
"availableColumn":{
"id":2969,
"name":"shipment_item_created",
"displayName":null,
"tableId":83,
"type":"TIMESTAMP",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":50,
"availableColumn":{
"id":2923,
"name":"item_key",
"displayName":null,
"tableId":81,
"type":"varchar",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":51,
"availableColumn":{
"id":119,
"name":"shipment_status",
"displayName":null,
"tableId":49,
"type":"varchar",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":52,
"availableColumn":{
"id":98,
"name":"item_type",
"displayName":null,
"tableId":81,
"type":"varchar",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":524763,
"availableColumn":{
"id":2967,
"name":"shipment_item_id",
"displayName":null,
"tableId":83,
"type":"INTEGER",
"hidden":false
},
"isFiltering":true,
"isGrouping":false
}
],
"url":null,
"statement":"Cast(sum({96}*({5747}/{86})) AS float8)",
"fromDate":1406851200000,
"createdBy":null,
"source":"Web Orders",
"color":null,
"hidden":false,
"multipleDates":false,
"subType":"line",
"owner":null,
"active":true,
"dateFieldIndex":0,
"virtualId":10,
"formula":true
},
{
"cohort":false,
"complex":false,
"formulaName":"Vs Budget",
"complexity":"dynamicRelation",
"columns":null,
"formulaId":12,
"columnGroupings":[
"store"
],
"type":"Chart",
"id":null,
"drillMap":null,
"title":"((A+B-C+D-E)/F)-1",
"yAxis":{
"label":"Amount",
"type":"numeric",
"symbol":"%"
},
"rangeName":"prevFiscalYear",
"addressColumn":null,
"frequencies":[
"Hourly",
"Daily",
"Weekly",
"Monthly",
"Yearly"
],
"description":"formula generated data",
"rule":null,
"name":"Web - Refunds exc VAT (Pounds)",
"xAxis":{
"label":"time",
"type":"Date",
"symbol":null
},
"relationId":null,
"symbol":null,
"dateColumn":"129",
"organisation":{
"id":6,
"name":"Monica Vinader",
"location":"London",
"logo":"https://truedash-static.s3.amazonaws.com/images/sandbox/6/logo/organizationLogo",
"fiscalYearStart":7,
"sunWeek":true,
"nullGroupingName":null
},
"columnFormats":null,
"defaultFrequency":"Weekly",
"availableTypes":[
"pie",
"line",
"bar"
],
"toDate":1438387199000,
"comparable":false,
"table":{
"id":44,
"name":"monicavinader.mv_orders",
"position":{
"posX":1621,
"posY":6
},
"dataSource":{
"id":2,
"name":"MonicaVinader Reporting",
"type":"MySql",
"organisation":{
"id":6,
"name":"Monica Vinader",
"location":"London",
"logo":"https://truedash-static.s3.amazonaws.com/images/sandbox/6/logo/organizationLogo",
"fiscalYearStart":7,
"sunWeek":true,
"nullGroupingName":null
}
},
"columns":[
{
"id":73,
"name":"order_customer",
"displayName":null,
"tableId":44,
"type":"integer",
"hidden":false
},
{
"id":74,
"name":"order_processed",
"displayName":null,
"tableId":44,
"type":"timestamp",
"hidden":false
},
{
"id":99,
"name":"order_id",
"displayName":null,
"tableId":44,
"type":"integer",
"hidden":false
},
{
"id":100,
"name":"order_created",
"displayName":null,
"tableId":44,
"type":"timestamp",
"hidden":false
},
{
"id":111,
"name":"order_is_trade",
"displayName":null,
"tableId":44,
"type":"boolean",
"hidden":false
},
{
"id":112,
"name":"order_totalprice",
"displayName":null,
"tableId":44,
"type":"numeric",
"hidden":false
},
{
"id":113,
"name":"order_totalprice_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":122,
"name":"order_reference",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":125,
"name":"order_totalprice_reporting",
"displayName":null,
"tableId":44,
"type":"numeric",
"hidden":false
},
{
"id":126,
"name":"order_totaltax_reporting",
"displayName":null,
"tableId":44,
"type":"numeric",
"hidden":false
},
{
"id":132,
"name":"created_week",
"displayName":null,
"tableId":44,
"type":"int",
"hidden":false
},
{
"id":133,
"name":"store",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":163,
"name":"order_count_number",
"displayName":null,
"tableId":44,
"type":"integer",
"hidden":false
},
{
"id":165,
"name":"lifetime_number_of_orders",
"displayName":null,
"tableId":44,
"type":"integer",
"hidden":false
},
{
"id":2655,
"name":"order_last_modified",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2656,
"name":"order_email",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2657,
"name":"order_description",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2658,
"name":"order_updated",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2659,
"name":"order_tracking",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2660,
"name":"order_referrer",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2661,
"name":"order_keywords",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2662,
"name":"order_status",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2663,
"name":"order_submissions",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2664,
"name":"order_billing_address",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2665,
"name":"order_delivery_address",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2666,
"name":"order_card",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2667,
"name":"order_totaltax_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":2668,
"name":"order_totalexoffers_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":2669,
"name":"order_shipping_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":2670,
"name":"order_totaltax_reporting_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":2671,
"name":"order_totalprice_reporting_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":2672,
"name":"order_comments",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2673,
"name":"order_source",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2674,
"name":"order_third_man_score",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2675,
"name":"order_third_man_action",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2676,
"name":"order_customer_fullname",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2677,
"name":"order_cegid_status",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2678,
"name":"order_tracking_code",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2679,
"name":"order_partial_shipment",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2680,
"name":"order_giftmessage",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2681,
"name":"order_shipping_updated",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2682,
"name":"order_cegid_reference",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2683,
"name":"order_flags",
"displayName":null,
"tableId":44,
"type":"BIGINT",
"hidden":false
},
{
"id":2684,
"name":"order_cegid_invoice_reference",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2685,
"name":"order_include_giftmessage",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2686,
"name":"order_included_giftbags",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2687,
"name":"order_cegid_check_required",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2688,
"name":"order_billing_country",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2689,
"name":"order_delivery_country",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2690,
"name":"order_picklist_printed",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2691,
"name":"order_dispatch_date_current",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2692,
"name":"order_delivery_date_current",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2693,
"name":"order_dispatch_date_original",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2694,
"name":"order_delivery_date_original",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2695,
"name":"order_dispatch_owner",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2696,
"name":"order_late_reason",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2697,
"name":"order_vouchers_sent",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2698,
"name":"order_special",
"displayName":null,
"tableId":44,
"type":"BOOLEAN",
"hidden":false
},
{
"id":2699,
"name":"order_packaging",
"displayName":null,
"tableId":44,
"type":"BOOLEAN",
"hidden":false
},
{
"id":2700,
"name":"order_internal_reference",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2701,
"name":"order_allocation_warehouse",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2702,
"name":"order_cegid_tax_system",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2703,
"name":"order_customer_name",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2704,
"name":"order_required_by",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2705,
"name":"order_external_reference",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2706,
"name":"order_discount",
"displayName":null,
"tableId":44,
"type":"float",
"hidden":false
},
{
"id":2707,
"name":"order_ordered",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2708,
"name":"order_required",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2709,
"name":"order_allocated",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2710,
"name":"order_shipped",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2711,
"name":"order_hash",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2712,
"name":"order_original_totalprice_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":2713,
"name":"order_original_totaltax_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":2714,
"name":"order_original_shipping_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":2715,
"name":"order_from_date",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2716,
"name":"order_to_date",
"displayName":null,
"tableId":44,
"type":"TIMESTAMP",
"hidden":false
},
{
"id":2717,
"name":"order_payments",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2718,
"name":"order_cegid_amend_required",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2719,
"name":"order_customer_type",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2720,
"name":"order_new_user",
"displayName":null,
"tableId":44,
"type":"BOOLEAN",
"hidden":false
},
{
"id":2721,
"name":"order_checkout_variant",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":2722,
"name":"order_totalexcreditsextax_currency",
"displayName":null,
"tableId":44,
"type":"char",
"hidden":false
},
{
"id":2723,
"name":"order_retail_store",
"displayName":null,
"tableId":44,
"type":"INTEGER",
"hidden":false
},
{
"id":2724,
"name":"order_sales_assistant",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
{
"id":5478,
"name":"order_totaltax",
"displayName":null,
"tableId":44,
"type":"numeric(24,6)",
"hidden":false
},
{
"id":5479,
"name":"order_totalexoffers",
"displayName":null,
"tableId":44,
"type":"numeric(24,6)",
"hidden":false
},
{
"id":5480,
"name":"order_shipping",
"displayName":null,
"tableId":44,
"type":"numeric(24,6)",
"hidden":false
},
{
"id":5481,
"name":"order_original_totalprice",
"displayName":null,
"tableId":44,
"type":"numeric(24,6)",
"hidden":false
},
{
"id":5482,
"name":"order_original_totaltax",
"displayName":null,
"tableId":44,
"type":"numeric(24,6)",
"hidden":false
},
{
"id":5483,
"name":"order_original_shipping",
"displayName":null,
"tableId":44,
"type":"numeric(24,6)",
"hidden":false
},
{
"id":5484,
"name":"order_totalexcreditsextax",
"displayName":null,
"tableId":44,
"type":"numeric(24,6)",
"hidden":false
},
{
"id":5485,
"name":"order_gateway_flags",
"displayName":null,
"tableId":44,
"type":"character varying(255)",
"hidden":false
},
{
"id":5486,
"name":"order_line_offer_updated",
"displayName":null,
"tableId":44,
"type":"boolean",
"hidden":false
},
{
"id":15650,
"name":"order_issues",
"displayName":null,
"tableId":44,
"type":"bigint",
"hidden":false
}
]
},
"availableColumns":[
{
"id":16,
"availableColumn":{
"id":2994,
"name":"transaction_qty",
"displayName":null,
"tableId":154,
"type":"integer",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":17,
"availableColumn":{
"id":2993,
"name":"transaction_pool",
"displayName":null,
"tableId":154,
"type":"varchar",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":18,
"availableColumn":{
"id":2997,
"name":"transaction_link_model",
"displayName":null,
"tableId":154,
"type":"varchar",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":20,
"availableColumn":{
"id":169,
"name":"item_id",
"displayName":null,
"tableId":341,
"type":"integer",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":31,
"availableColumn":{
"id":133,
"name":"store",
"displayName":null,
"tableId":44,
"type":"varchar",
"hidden":false
},
"isFiltering":null,
"isGrouping":true
},
{
"id":39,
"availableColumn":{
"id":6663,
"name":"fiscal_ytd",
"displayName":null,
"tableId":81,
"type":"varchar",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":40,
"availableColumn":{
"id":2558,
"name":"product_title",
"displayName":null,
"tableId":67,
"type":"varchar",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":42,
"availableColumn":{
"id":5455,
"name":"mv_region",
"displayName":null,
"tableId":59,
"type":"character varying(256)",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":43,
"availableColumn":{
"id":91,
"name":"country",
"displayName":null,
"tableId":59,
"type":"varchar",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":44,
"availableColumn":{
"id":5457,
"name":"budget_region",
"displayName":null,
"tableId":59,
"type":"character varying(256)",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":45,
"availableColumn":{
"id":5456,
"name":"budget_country",
"displayName":null,
"tableId":59,
"type":"character varying(256)",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":46,
"availableColumn":{
"id":2650,
"name":"product_business_collection",
"displayName":null,
"tableId":67,
"type":"varchar",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":47,
"availableColumn":{
"id":4961,
"name":"business_type_name",
"displayName":null,
"tableId":150,
"type":"character varying(255)",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":48,
"availableColumn":{
"id":5781,
"name":"type_name",
"displayName":null,
"tableId":161,
"type":"character varying(255)",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":49,
"availableColumn":{
"id":2969,
"name":"shipment_item_created",
"displayName":null,
"tableId":83,
"type":"TIMESTAMP",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":50,
"availableColumn":{
"id":2923,
"name":"item_key",
"displayName":null,
"tableId":81,
"type":"varchar",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":51,
"availableColumn":{
"id":119,
"name":"shipment_status",
"displayName":null,
"tableId":49,
"type":"varchar",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":52,
"availableColumn":{
"id":98,
"name":"item_type",
"displayName":null,
"tableId":81,
"type":"varchar",
"hidden":false
},
"isFiltering":true,
"isGrouping":true
},
{
"id":524763,
"availableColumn":{
"id":2967,
"name":"shipment_item_id",
"displayName":null,
"tableId":83,
"type":"INTEGER",
"hidden":false
},
"isFiltering":true,
"isGrouping":false
}
],
"url":null,
"statement":"Cast(sum({96}*({5747}/{86})) AS float8)",
"fromDate":1406851200000,
"createdBy":null,
"source":"Web Orders",
"color":null,
"hidden":false,
"multipleDates":false,
"subType":"line",
"owner":null,
"active":true,
"dateFieldIndex":0,
"virtualId":9,
"formula":true
}
],
"tableTotals":[
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment