Skip to content

Instantly share code, notes, and snippets.

@rozanovz

rozanovz/gist:4dcd53d2eb89ccb8f5f2c8736ab4e1f9

Created April 21, 2016 07:18
Show Gist options

  • Select an option

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

Select an option

Learn more about clone URLs
Save rozanovz/4dcd53d2eb89ccb8f5f2c8736ab4e1f9 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
{
"id":11579,
"createdBy":"AdminTD@monicavinader.com",
"name":"Web USA (Inc VAT)",
"description":null,
"fromDate":1443657600000,
"toDate":1459468799000,
"multipleAxis":true,
"showGroupingAsPercentage":false,
"showTableTotals":true,
"selectedFrequency":"Monthly",
"type":"table",
"selectedTotals":[],
"subType":"table",
"xAxis": {
"label": "Date", "type": "Date", "symbol": null
}
,
"yAxis": {
"label": "Label", "type": "Label", "symbol": null
}
,
"active":true,
"size":null,
"rangeName":"prev6Months",
"metrics":[ {
"id":10084,
"statement":"Cast(sum({5747}/{86}) AS float8)",
"url":null,
"name":"Web - Shipping Charges exc VAT (Pounds)",
"description":"Web - Shipping Charges exc VAT (Pounds)",
"type":"Chart",
"subType":"line",
"source":"Web Orders",
"createdBy":null,
"defaultFrequency":"Weekly",
"complexity":"dynamicRelation",
"symbol":null,
"dateColumn":"121",
"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":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":52,
"availableColumn": {
"id": 98, "name": "item_type", "displayName": null, "tableId": 81, "type": "varchar", "hidden": false
}
,
"isFiltering":true,
"isGrouping":true
}
,
{
"id":59,
"availableColumn": {
"id": 149, "name": "fiscal_ytd", "displayName": null, "tableId": 49, "type": "varchar", "hidden": false
}
,
"isFiltering":true,
"isGrouping":true
}
,
{
"id":62,
"availableColumn": {
"id": 3, "name": "order_sub_category", "displayName": null, "tableId": 88, "type": "varchar", "hidden": false
}
,
"isFiltering":true,
"isGrouping":true
}
,
{
"id":63,
"availableColumn": {
"id": 4, "name": "shipment_first", "displayName": null, "tableId": 49, "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,
"relationId":19074,
"relationPosition":0
}
,
{
"id":239,
"statement":"Cast(sum(forecast) AS float8)",
"url":null,
"name":"Forecast",
"description":"Weekly forecast 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": 1906, "posY": 951
}
,
"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": "date", "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,
"relationId":19075,
"relationPosition":0
}
,
{
"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,
"relationId":19076,
"relationPosition":0
}
,
{
"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,
"relationId":19077,
"relationPosition":0
}
,
{
"id":238,
"statement":"Cast(sum(budget) AS float8)",
"url":null,
"name":"Budget",
"description":"Weekly budget metric",
"type":"Chart",
"subType":"line",
"source":"Finance",
"createdBy":null,
"defaultFrequency":"Weekly",
"complexity":"dynamicRelation",
"symbol":null,
"dateColumn":"11511",
"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":null,
"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,
"relationId":19078,
"relationPosition":0
}
,
{
"id":296,
"statement":"Cast(sum({5745}/{86}) AS float8)",
"url":null,
"name":"Web - Ship Revenue inc VAT (Pounds)",
"description":"Web - Ship Revenue inc 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":53,
"availableColumn": {
"id": 6641, "name": "department_name", "displayName": null, "tableId": 340, "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": {
"id":17,
"levels":[ {
"id":4,
"column": {
"id": 91, "name": "country", "displayName": null, "tableId": 59, "type": "varchar", "hidden": false
}
,
"operation":"groupby",
"chartType":"line"
}
],
"metricId":296
}
,
"addressColumn":null,
"owner":null,
"rule":null,
"relationId":19079,
"relationPosition":0
}
,
{
"id":294,
"statement":"Cast(sum({5745}/{86}) AS float8)",
"url":null,
"name":"Web - Refunds inc VAT (Pounds)",
"description":"Refunds paid inc 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":524982,
"availableColumn": {
"id": 119, "name": "shipment_status", "displayName": null, "tableId": 49, "type": "varchar", "hidden": false
}
,
"isFiltering":true,
"isGrouping":true
}
,
{
"id":524983,
"availableColumn": {
"id": 5457, "name": "budget_region", "displayName": null, "tableId": 59, "type": "character varying(256)", "hidden": false
}
,
"isFiltering":true,
"isGrouping":true
}
,
{
"id":524984,
"availableColumn": {
"id": 169, "name": "item_id", "displayName": null, "tableId": 341, "type": "integer", "hidden": false
}
,
"isFiltering":true,
"isGrouping":true
}
,
{
"id":524985,
"availableColumn": {
"id": 2993, "name": "transaction_pool", "displayName": null, "tableId": 154, "type": "varchar", "hidden": false
}
,
"isFiltering":true,
"isGrouping":true
}
,
{
"id":524986,
"availableColumn": {
"id": 5456, "name": "budget_country", "displayName": null, "tableId": 59, "type": "character varying(256)", "hidden": false
}
,
"isFiltering":true,
"isGrouping":true
}
,
{
"id":524987,
"availableColumn": {
"id": 2997, "name": "transaction_link_model", "displayName": null, "tableId": 154, "type": "varchar", "hidden": false
}
,
"isFiltering":true,
"isGrouping":true
}
,
{
"id":524988,
"availableColumn": {
"id": 2969, "name": "shipment_item_created", "displayName": null, "tableId": 83, "type": "TIMESTAMP", "hidden": false
}
,
"isFiltering":true,
"isGrouping":true
}
,
{
"id":524989,
"availableColumn": {
"id": 2558, "name": "product_title", "displayName": null, "tableId": 67, "type": "varchar", "hidden": false
}
,
"isFiltering":true,
"isGrouping":true
}
,
{
"id":524990,
"availableColumn": {
"id": 5455, "name": "mv_region", "displayName": null, "tableId": 59, "type": "character varying(256)", "hidden": false
}
,
"isFiltering":true,
"isGrouping":true
}
,
{
"id":524991,
"availableColumn": {
"id": 133, "name": "store", "displayName": null, "tableId": 44, "type": "varchar", "hidden": false
}
,
"isFiltering":false,
"isGrouping":true
}
,
{
"id":524992,
"availableColumn": {
"id": 2650, "name": "product_business_collection", "displayName": null, "tableId": 67, "type": "varchar", "hidden": false
}
,
"isFiltering":true,
"isGrouping":true
}
,
{
"id":524993,
"availableColumn": {
"id": 91, "name": "country", "displayName": null, "tableId": 59, "type": "varchar", "hidden": false
}
,
"isFiltering":true,
"isGrouping":true
}
,
{
"id":524994,
"availableColumn": {
"id": 2994, "name": "transaction_qty", "displayName": null, "tableId": 154, "type": "integer", "hidden": false
}
,
"isFiltering":true,
"isGrouping":true
}
,
{
"id":524995,
"availableColumn": {
"id": 98, "name": "item_type", "displayName": null, "tableId": 81, "type": "varchar", "hidden": false
}
,
"isFiltering":true,
"isGrouping":true
}
,
{
"id":524996,
"availableColumn": {
"id": 6648, "name": "story_label", "displayName": null, "tableId": 342, "type": "varchar", "hidden": false
}
,
"isFiltering":true,
"isGrouping":true
}
,
{
"id":524997,
"availableColumn": {
"id": 2578, "name": "product_code", "displayName": null, "tableId": 67, "type": "varchar", "hidden": false
}
,
"isFiltering":true,
"isGrouping":true
}
,
{
"id":524998,
"availableColumn": {
"id": 2923, "name": "item_key", "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,
"relationId":19080,
"relationPosition":0
}
,
{
"id":10083,
"statement":"Cast(sum({5745}/{86}) AS float8)",
"url":null,
"name":"Web - Shipping Charges inc VAT (Pounds)",
"description":"Web - Shipping Charges inc VAT (Pounds)",
"type":"Chart",
"subType":"line",
"source":"Web Orders",
"createdBy":null,
"defaultFrequency":"Weekly",
"complexity":"dynamicRelation",
"symbol":null,
"dateColumn":"121",
"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":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":52,
"availableColumn": {
"id": 98, "name": "item_type", "displayName": null, "tableId": 81, "type": "varchar", "hidden": false
}
,
"isFiltering":true,
"isGrouping":true
}
,
{
"id":53,
"availableColumn": {
"id": 6641, "name": "department_name", "displayName": null, "tableId": 340, "type": "varchar", "hidden": false
}
,
"isFiltering":true,
"isGrouping":true
}
,
{
"id":59,
"availableColumn": {
"id": 149, "name": "fiscal_ytd", "displayName": null, "tableId": 49, "type": "varchar", "hidden": false
}
,
"isFiltering":true,
"isGrouping":true
}
,
{
"id":63,
"availableColumn": {
"id": 4, "name": "shipment_first", "displayName": null, "tableId": 49, "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,
"relationId":19081,
"relationPosition":0
}
],
"metricInfoMap": {
"relation-19075": {
"subType": "table", "columnsMap": [0, 1]
}
,
"relation-19078": {
"subType": "table", "columnsMap": [0, 1]
}
,
"relation-19079": {
"subType": "table", "columnsMap": [0, 1]
}
,
"relation-19080": {
"subType": "table", "columnsMap": [0, 1]
}
,
"relation-19081": {
"subType": "table", "columnsMap": [0, 1]
}
,
"formula-5280": {
"subType": "table", "columnsMap": [0, 1]
}
,
"formula-5281": {
"subType": "table", "columnsMap": [0, 1]
}
,
"formula-5282": {
"subType": "table", "columnsMap": [0, 1]
}
}
,
"cohortFromDate":null,
"cohortToDate":null,
"cohortRangeName":null,
"availableFrequencies":["Yearly",
"Weekly",
"Monthly",
"Daily",
"Hourly"],
"availableTypes":["table",
"line",
"spline",
"symbol",
"mixed",
"bar",
"stacked",
"pie",
"donut"],
"alerts":[],
"formulas":[ {
"id":5282,
"type":"%",
"expression":"((E+F-G)/I)-1",
"name":"vs Forecast",
"metrics": {
"19081": "E", "19075": "I", "19079": "F", "19080": "G"
}
,
"color":null
}
,
{
"id":5281,
"type":"£",
"expression":"E+F-G",
"name":"Revenue",
"metrics": {
"19081": "E", "19079": "F", "19080": "G"
}
,
"color":null
}
,
{
"id":5280,
"type":"%",
"expression":"((E+F-G)/H)-1",
"name":"vs Budget",
"metrics": {
"19081": "E", "19078": "H", "19079": "F", "19080": "G"
}
,
"color":null
}
],
"filters":[ {
"id":37862,
"operator":"eq",
"value":"Web",
"isRange":false,
"isMetricFilter":null,
"card": {
"class":"org.truedash.Card",
"id":11579,
"active":true,
"availableTypes":["line",
"bar"],
"cohortFromDate":null,
"cohortRangeName":null,
"cohortToDate":null,
"columnsSort":[],
"complete":true,
"createdBy":"AdminTD@monicavinader.com",
"dataGenerationDate":null,
"description":null,
"formulas":[ {
"class": "org.truedash.Formula", "id": 5282
}
,
{
"class": "org.truedash.Formula", "id": 5281
}
,
{
"class": "org.truedash.Formula", "id": 5280
}
],
"frequencies":null,
"fromDate":1443657600000,
"groupBys":[],
"hiddenMetrics":null,
"letters": {
"19076": "A", "19077": "B", "19074": "C", "5458": "D", "19081": "E", "19079": "F", "19080": "G", "19078": "H", "19075": "I"
}
,
"messages":[],
"metricInfoMap": {
"relation-19075": {
"subType": "table", "columnsMap": [0, 1]
}
,
"relation-19078": {
"subType": "table", "columnsMap": [0, 1]
}
,
"relation-19079": {
"subType": "table", "columnsMap": [0, 1]
}
,
"relation-19080": {
"subType": "table", "columnsMap": [0, 1]
}
,
"relation-19081": {
"subType": "table", "columnsMap": [0, 1]
}
,
"formula-5280": {
"subType": "table", "columnsMap": [0, 1]
}
,
"formula-5281": {
"subType": "table", "columnsMap": [0, 1]
}
,
"formula-5282": {
"subType": "table", "columnsMap": [0, 1]
}
}
,
"metrics":[],
"moving": {
"from": [true, 186], "to": [true, 4]
}
,
"multipleAxis":true,
"name":"Web USA (Inc VAT)",
"owner": {
"class": "org.truedash.User", "id": 215
}
,
"rangeName":"prev6Months",
"segments":[],
"selectedFrequency":"Monthly",
"selectedTotals":[],
"showGroupingAsPercentage":false,
"showTableTotals":true,
"size":null,
"subType":"table",
"toDate":1459468799999,
"type":"table",
"url":null,
"userInfoMap": {
"215": {
"fromDate": 1412121600000, "toDate": 1414799999999, "frequency": "Monthly", "rangeName": "custom"
}
}
,
"virtual":false,
"xAxis": {
"class": "org.truedash.Axis", "id": null, "label": "Date", "symbol": null, "type": "Date"
}
,
"yAxis": {
"class": "org.truedash.Axis", "id": null, "label": "Label", "symbol": null, "type": "Label"
}
}
,
"metric":null,
"column": {
"id": 3734, "name": "store", "displayName": null, "tableId": 51, "type": "character varying(256)", "hidden": false
}
,
"chain":"AND",
"chainLetter":"A",
"cardMetricRelationId": {
"class": "org.truedash.CardMetricRelation", "id": 19078, "cardId": 11579, "color": null, "formula": "A AND B", "generatedFilters": null, "hidden": false, "metricId": 238, "metricName": "Budget", "position": 0
}
,
"parenthesisConfig":null
}
,
{
"id":37863,
"operator":"eq",
"value":"Web",
"isRange":false,
"isMetricFilter":null,
"card": {
"class":"org.truedash.Card",
"id":11579,
"active":true,
"availableTypes":["line",
"bar"],
"cohortFromDate":null,
"cohortRangeName":null,
"cohortToDate":null,
"columnsSort":[],
"complete":true,
"createdBy":"AdminTD@monicavinader.com",
"dataGenerationDate":null,
"description":null,
"formulas":[ {
"class": "org.truedash.Formula", "id": 5282
}
,
{
"class": "org.truedash.Formula", "id": 5281
}
,
{
"class": "org.truedash.Formula", "id": 5280
}
],
"frequencies":null,
"fromDate":1443657600000,
"groupBys":[],
"hiddenMetrics":null,
"letters": {
"19076": "A", "19077": "B", "19074": "C", "5458": "D", "19081": "E", "19079": "F", "19080": "G", "19078": "H", "19075": "I"
}
,
"messages":[],
"metricInfoMap": {
"relation-19075": {
"subType": "table", "columnsMap": [0, 1]
}
,
"relation-19078": {
"subType": "table", "columnsMap": [0, 1]
}
,
"relation-19079": {
"subType": "table", "columnsMap": [0, 1]
}
,
"relation-19080": {
"subType": "table", "columnsMap": [0, 1]
}
,
"relation-19081": {
"subType": "table", "columnsMap": [0, 1]
}
,
"formula-5280": {
"subType": "table", "columnsMap": [0, 1]
}
,
"formula-5281": {
"subType": "table", "columnsMap": [0, 1]
}
,
"formula-5282": {
"subType": "table", "columnsMap": [0, 1]
}
}
,
"metrics":[],
"moving": {
"from": [true, 186], "to": [true, 4]
}
,
"multipleAxis":true,
"name":"Web USA (Inc VAT)",
"owner": {
"class": "org.truedash.User", "id": 215
}
,
"rangeName":"prev6Months",
"segments":[],
"selectedFrequency":"Monthly",
"selectedTotals":[],
"showGroupingAsPercentage":false,
"showTableTotals":true,
"size":null,
"subType":"table",
"toDate":1459468799999,
"type":"table",
"url":null,
"userInfoMap": {
"215": {
"fromDate": 1412121600000, "toDate": 1414799999999, "frequency": "Monthly", "rangeName": "custom"
}
}
,
"virtual":false,
"xAxis": {
"class": "org.truedash.Axis", "id": null, "label": "Date", "symbol": null, "type": "Date"
}
,
"yAxis": {
"class": "org.truedash.Axis", "id": null, "label": "Label", "symbol": null, "type": "Label"
}
}
,
"metric":null,
"column": {
"id": 5389, "name": "store", "displayName": null, "tableId": 52, "type": "character varying(256)", "hidden": false
}
,
"chain":"AND",
"chainLetter":"A",
"cardMetricRelationId": {
"class": "org.truedash.CardMetricRelation", "id": 19075, "cardId": 11579, "color": null, "formula": "A AND B", "generatedFilters": null, "hidden": false, "metricId": 239, "metricName": "Forecast", "position": 0
}
,
"parenthesisConfig":null
}
,
{
"id":37864,
"operator":"eq",
"value":"United States",
"isRange":false,
"isMetricFilter":null,
"card": {
"class":"org.truedash.Card",
"id":11579,
"active":true,
"availableTypes":["line",
"bar"],
"cohortFromDate":null,
"cohortRangeName":null,
"cohortToDate":null,
"columnsSort":[],
"complete":true,
"createdBy":"AdminTD@monicavinader.com",
"dataGenerationDate":null,
"description":null,
"formulas":[ {
"class": "org.truedash.Formula", "id": 5282
}
,
{
"class": "org.truedash.Formula", "id": 5281
}
,
{
"class": "org.truedash.Formula", "id": 5280
}
],
"frequencies":null,
"fromDate":1443657600000,
"groupBys":[],
"hiddenMetrics":null,
"letters": {
"19076": "A", "19077": "B", "19074": "C", "5458": "D", "19081": "E", "19079": "F", "19080": "G", "19078": "H", "19075": "I"
}
,
"messages":[],
"metricInfoMap": {
"relation-19075": {
"subType": "table", "columnsMap": [0, 1]
}
,
"relation-19078": {
"subType": "table", "columnsMap": [0, 1]
}
,
"relation-19079": {
"subType": "table", "columnsMap": [0, 1]
}
,
"relation-19080": {
"subType": "table", "columnsMap": [0, 1]
}
,
"relation-19081": {
"subType": "table", "columnsMap": [0, 1]
}
,
"formula-5280": {
"subType": "table", "columnsMap": [0, 1]
}
,
"formula-5281": {
"subType": "table", "columnsMap": [0, 1]
}
,
"formula-5282": {
"subType": "table", "columnsMap": [0, 1]
}
}
,
"metrics":[],
"moving": {
"from": [true, 186], "to": [true, 4]
}
,
"multipleAxis":true,
"name":"Web USA (Inc VAT)",
"owner": {
"class": "org.truedash.User", "id": 215
}
,
"rangeName":"prev6Months",
"segments":[],
"selectedFrequency":"Monthly",
"selectedTotals":[],
"showGroupingAsPercentage":false,
"showTableTotals":true,
"size":null,
"subType":"table",
"toDate":1459468799999,
"type":"table",
"url":null,
"userInfoMap": {
"215": {
"fromDate": 1412121600000, "toDate": 1414799999999, "frequency": "Monthly", "rangeName": "custom"
}
}
,
"virtual":false,
"xAxis": {
"class": "org.truedash.Axis", "id": null, "label": "Date", "symbol": null, "type": "Date"
}
,
"yAxis": {
"class": "org.truedash.Axis", "id": null, "label": "Label", "symbol": null, "type": "Label"
}
}
,
"metric":null,
"column": {
"id": 5393, "name": "budget_region", "displayName": null, "tableId": 52, "type": "character varying(256)", "hidden": false
}
,
"chain":"AND",
"chainLetter":"B",
"cardMetricRelationId": {
"class": "org.truedash.CardMetricRelation", "id": 19075, "cardId": 11579, "color": null, "formula": "A AND B", "generatedFilters": null, "hidden": false, "metricId": 239, "metricName": "Forecast", "position": 0
}
,
"parenthesisConfig":null
}
,
{
"id":37865,
"operator":"eq",
"value":"United States",
"isRange":false,
"isMetricFilter":null,
"card": {
"class":"org.truedash.Card",
"id":11579,
"active":true,
"availableTypes":["line",
"bar"],
"cohortFromDate":null,
"cohortRangeName":null,
"cohortToDate":null,
"columnsSort":[],
"complete":true,
"createdBy":"AdminTD@monicavinader.com",
"dataGenerationDate":null,
"description":null,
"formulas":[ {
"class": "org.truedash.Formula", "id": 5282
}
,
{
"class": "org.truedash.Formula", "id": 5281
}
,
{
"class": "org.truedash.Formula", "id": 5280
}
],
"frequencies":null,
"fromDate":1443657600000,
"groupBys":[],
"hiddenMetrics":null,
"letters": {
"19076": "A", "19077": "B", "19074": "C", "5458": "D", "19081": "E", "19079": "F", "19080": "G", "19078": "H", "19075": "I"
}
,
"messages":[],
"metricInfoMap": {
"relation-19075": {
"subType": "table", "columnsMap": [0, 1]
}
,
"relation-19078": {
"subType": "table", "columnsMap": [0, 1]
}
,
"relation-19079": {
"subType": "table", "columnsMap": [0, 1]
}
,
"relation-19080": {
"subType": "table", "columnsMap": [0, 1]
}
,
"relation-19081": {
"subType": "table", "columnsMap": [0, 1]
}
,
"formula-5280": {
"subType": "table", "columnsMap": [0, 1]
}
,
"formula-5281": {
"subType": "table", "columnsMap": [0, 1]
}
,
"formula-5282": {
"subType": "table", "columnsMap": [0, 1]
}
}
,
"metrics":[],
"moving": {
"from": [true, 186], "to": [true, 4]
}
,
"multipleAxis":true,
"name":"Web USA (Inc VAT)",
"owner": {
"class": "org.truedash.User", "id": 215
}
,
"rangeName":"prev6Months",
"segments":[],
"selectedFrequency":"Monthly",
"selectedTotals":[],
"showGroupingAsPercentage":false,
"showTableTotals":true,
"size":null,
"subType":"table",
"toDate":1459468799999,
"type":"table",
"url":null,
"userInfoMap": {
"215": {
"fromDate": 1412121600000, "toDate": 1414799999999, "frequency": "Monthly", "rangeName": "custom"
}
}
,
"virtual":false,
"xAxis": {
"class": "org.truedash.Axis", "id": null, "label": "Date", "symbol": null, "type": "Date"
}
,
"yAxis": {
"class": "org.truedash.Axis", "id": null, "label": "Label", "symbol": null, "type": "Label"
}
}
,
"metric":null,
"column": {
"id": 5457, "name": "budget_region", "displayName": null, "tableId": 59, "type": "character varying(256)", "hidden": false
}
,
"chain":"AND",
"chainLetter":"A",
"cardMetricRelationId": {
"class": "org.truedash.CardMetricRelation", "id": 19081, "cardId": 11579, "color": null, "formula": "A", "generatedFilters": [13122, 13118, 13120, 12, 101], "hidden": true, "metricId": 10083, "metricName": "Web - Shipping Charges inc VAT (Pounds)", "position": 0
}
,
"parenthesisConfig":null
}
,
{
"id":37866,
"operator":"eq",
"value":"United States",
"isRange":false,
"isMetricFilter":null,
"card": {
"class":"org.truedash.Card",
"id":11579,
"active":true,
"availableTypes":["line",
"bar"],
"cohortFromDate":null,
"cohortRangeName":null,
"cohortToDate":null,
"columnsSort":[],
"complete":true,
"createdBy":"AdminTD@monicavinader.com",
"dataGenerationDate":null,
"description":null,
"formulas":[ {
"class": "org.truedash.Formula", "id": 5282
}
,
{
"class": "org.truedash.Formula", "id": 5281
}
,
{
"class": "org.truedash.Formula", "id": 5280
}
],
"frequencies":null,
"fromDate":1443657600000,
"groupBys":[],
"hiddenMetrics":null,
"letters": {
"19076": "A", "19077": "B", "19074": "C", "5458": "D", "19081": "E", "19079": "F", "19080": "G", "19078": "H", "19075": "I"
}
,
"messages":[],
"metricInfoMap": {
"relation-19075": {
"subType": "table", "columnsMap": [0, 1]
}
,
"relation-19078": {
"subType": "table", "columnsMap": [0, 1]
}
,
"relation-19079": {
"subType": "table", "columnsMap": [0, 1]
}
,
"relation-19080": {
"subType": "table", "columnsMap": [0, 1]
}
,
"relation-19081": {
"subType": "table", "columnsMap": [0, 1]
}
,
"formula-5280": {
"subType": "table", "columnsMap": [0, 1]
}
,
"formula-5281": {
"subType": "table", "columnsMap": [0, 1]
}
,
"formula-5282": {
"subType": "table", "columnsMap": [0, 1]
}
}
,
"metrics":[],
"moving": {
"from": [true, 186], "to": [true, 4]
}
,
"multipleAxis":true,
"name":"Web USA (Inc VAT)",
"owner": {
"class": "org.truedash.User", "id": 215
}
,
"rangeName":"prev6Months",
"segments":[],
"selectedFrequency":"Monthly",
"selectedTotals":[],
"showGroupingAsPercentage":false,
"showTableTotals":true,
"size":null,
"subType":"table",
"toDate":1459468799999,
"type":"table",
"url":null,
"userInfoMap": {
"215": {
"fromDate": 1412121600000, "toDate": 1414799999999, "frequency": "Monthly", "rangeName": "custom"
}
}
,
"virtual":false,
"xAxis": {
"class": "org.truedash.Axis", "id": null, "label": "Date", "symbol": null, "type": "Date"
}
,
"yAxis": {
"class": "org.truedash.Axis", "id": null, "label": "Label", "symbol": null, "type": "Label"
}
}
,
"metric":null,
"column": {
"id": 5385, "name": "budget_region", "displayName": null, "tableId": 51, "type": "character varying(256)", "hidden": false
}
,
"chain":"AND",
"chainLetter":"B",
"cardMetricRelationId": {
"class": "org.truedash.CardMetricRelation", "id": 19078, "cardId": 11579, "color": null, "formula": "A AND B", "generatedFilters": null, "hidden": false, "metricId": 238, "metricName": "Budget", "position": 0
}
,
"parenthesisConfig":null
}
,
{
"id":37867,
"operator":"eq",
"value":"United States",
"isRange":false,
"isMetricFilter":null,
"card": {
"class":"org.truedash.Card",
"id":11579,
"active":true,
"availableTypes":["line",
"bar"],
"cohortFromDate":null,
"cohortRangeName":null,
"cohortToDate":null,
"columnsSort":[],
"complete":true,
"createdBy":"AdminTD@monicavinader.com",
"dataGenerationDate":null,
"description":null,
"formulas":[ {
"class": "org.truedash.Formula", "id": 5282
}
,
{
"class": "org.truedash.Formula", "id": 5281
}
,
{
"class": "org.truedash.Formula", "id": 5280
}
],
"frequencies":null,
"fromDate":1443657600000,
"groupBys":[],
"hiddenMetrics":null,
"letters": {
"19076": "A", "19077": "B", "19074": "C", "5458": "D", "19081": "E", "19079": "F", "19080": "G", "19078": "H", "19075": "I"
}
,
"messages":[],
"metricInfoMap": {
"relation-19075": {
"subType": "table", "columnsMap": [0, 1]
}
,
"relation-19078": {
"subType": "table", "columnsMap": [0, 1]
}
,
"relation-19079": {
"subType": "table", "columnsMap": [0, 1]
}
,
"relation-19080": {
"subType": "table", "columnsMap": [0, 1]
}
,
"relation-19081": {
"subType": "table", "columnsMap": [0, 1]
}
,
"formula-5280": {
"subType": "table", "columnsMap": [0, 1]
}
,
"formula-5281": {
"subType": "table", "columnsMap": [0, 1]
}
,
"formula-5282": {
"subType": "table", "columnsMap": [0, 1]
}
}
,
"metrics":[],
"moving": {
"from": [true, 186], "to": [true, 4]
}
,
"multipleAxis":true,
"name":"Web USA (Inc VAT)",
"owner": {
"class": "org.truedash.User", "id": 215
}
,
"rangeName":"prev6Months",
"segments":[],
"selectedFrequency":"Monthly",
"selectedTotals":[],
"showGroupingAsPercentage":false,
"showTableTotals":true,
"size":null,
"subType":"table",
"toDate":1459468799999,
"type":"table",
"url":null,
"userInfoMap": {
"215": {
"fromDate": 1412121600000, "toDate": 1414799999999, "frequency": "Monthly", "rangeName": "custom"
}
}
,
"virtual":false,
"xAxis": {
"class": "org.truedash.Axis", "id": null, "label": "Date", "symbol": null, "type": "Date"
}
,
"yAxis": {
"class": "org.truedash.Axis", "id": null, "label": "Label", "symbol": null, "type": "Label"
}
}
,
"metric":null,
"column": {
"id": 5457, "name": "budget_region", "displayName": null, "tableId": 59, "type": "character varying(256)", "hidden": false
}
,
"chain":"AND",
"chainLetter":"A",
"cardMetricRelationId": {
"class": "org.truedash.CardMetricRelation", "id": 19079, "cardId": 11579, "color": null, "formula": "A", "generatedFilters": [11133, 11135, 12162, 105, 106, 99, 107], "hidden": true, "metricId": 296, "metricName": "Web - Ship Revenue inc VAT (Pounds)", "position": 0
}
,
"parenthesisConfig":null
}
,
{
"id":37868,
"operator":"eq",
"value":"United States",
"isRange":false,
"isMetricFilter":null,
"card": {
"class":"org.truedash.Card",
"id":11579,
"active":true,
"availableTypes":["line",
"bar"],
"cohortFromDate":null,
"cohortRangeName":null,
"cohortToDate":null,
"columnsSort":[],
"complete":true,
"createdBy":"AdminTD@monicavinader.com",
"dataGenerationDate":null,
"description":null,
"formulas":[ {
"class": "org.truedash.Formula", "id": 5282
}
,
{
"class": "org.truedash.Formula", "id": 5281
}
,
{
"class": "org.truedash.Formula", "id": 5280
}
],
"frequencies":null,
"fromDate":1443657600000,
"groupBys":[],
"hiddenMetrics":null,
"letters": {
"19076": "A", "19077": "B", "19074": "C", "5458": "D", "19081": "E", "19079": "F", "19080": "G", "19078": "H", "19075": "I"
}
,
"messages":[],
"metricInfoMap": {
"relation-19075": {
"subType": "table", "columnsMap": [0, 1]
}
,
"relation-19078": {
"subType": "table", "columnsMap": [0, 1]
}
,
"relation-19079": {
"subType": "table", "columnsMap": [0, 1]
}
,
"relation-19080": {
"subType": "table", "columnsMap": [0, 1]
}
,
"relation-19081": {
"subType": "table", "columnsMap": [0, 1]
}
,
"formula-5280": {
"subType": "table", "columnsMap": [0, 1]
}
,
"formula-5281": {
"subType": "table", "columnsMap": [0, 1]
}
,
"formula-5282": {
"subType": "table", "columnsMap": [0, 1]
}
}
,
"metrics":[],
"moving": {
"from": [true, 186], "to": [true, 4]
}
,
"multipleAxis":true,
"name":"Web USA (Inc VAT)",
"owner": {
"class": "org.truedash.User", "id": 215
}
,
"rangeName":"prev6Months",
"segments":[],
"selectedFrequency":"Monthly",
"selectedTotals":[],
"showGroupingAsPercentage":false,
"showTableTotals":true,
"size":null,
"subType":"table",
"toDate":1459468799999,
"type":"table",
"url":null,
"userInfoMap": {
"215": {
"fromDate": 1412121600000, "toDate": 1414799999999, "frequency": "Monthly", "rangeName": "custom"
}
}
,
"virtual":false,
"xAxis": {
"class": "org.truedash.Axis", "id": null, "label": "Date", "symbol": null, "type": "Date"
}
,
"yAxis": {
"class": "org.truedash.Axis", "id": null, "label": "Label", "symbol": null, "type": "Label"
}
}
,
"metric":null,
"column": {
"id": 5457, "name": "budget_region", "displayName": null, "tableId": 59, "type": "character varying(256)", "hidden": false
}
,
"chain":"AND",
"chainLetter":"A",
"cardMetricRelationId": {
"class": "org.truedash.CardMetricRelation", "id": 19080, "cardId": 11579, "color": null, "formula": "A", "generatedFilters": [12979, 11479, 11480, 11481, 11482, 11483, 44, 96, 111, 112, 113, 115], "hidden": true, "metricId": 294, "metricName": "Web - Refunds inc VAT (Pounds)", "position": 0
}
,
"parenthesisConfig":null
}
],
"segments":[],
"groupings":[],
"columnsSort":[],
"moving": {
"from": true, "to": true
}
,
"drillMaps": {
"card":null,
"relations":[ {
"id":17,
"levels":[ {
"id":4,
"column": {
"id": 91, "name": "country", "displayName": null, "tableId": 59, "type": "varchar", "hidden": false
}
,
"operation":"groupby",
"chartType":"line"
}
],
"metricId":296,
"relationId":19079
}
]
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment