← proof sheet

17 pivot-country-channel-category-metrics

pivot

PR #153 9fdf8d3718

CountryChannelinkpaperstaplestoner
RevenueUnitsRevenueUnitsRevenueUnitsRevenueUnits
BRWeb$7,543.83238$2,466.42193$1,007.87243$12,350.65203
Store$3,382.84105$1,292.42104$491.48121$6,219.16109
Phone$1,831.3361$855.0369$242.6955$3,786.2867
DEWeb$11,544.92372$3,882.28308$1,356.75320$16,159.50282
Store$5,496.45175$2,924.84232$891.40213$11,317.23202
Phone$2,436.3679$1,037.6280$379.0394$4,804.0780
FRWeb$9,294.81292$3,848.40311$1,305.92308$15,884.32277
Store$5,038.20155$2,410.47190$626.74150$9,740.93168
Phone$3,146.65101$1,194.5796$352.6682$4,148.7071
GBWeb$14,546.23452$5,513.41432$1,764.85431$27,111.72459
Store$6,675.54217$2,930.40237$1,075.74254$10,165.66175
Phone$2,748.1588$1,250.3898$436.72103$4,465.2374
JPWeb$11,715.24378$6,074.03483$2,259.62535$26,907.97461
Store$6,836.88221$2,901.72237$1,035.76245$15,476.28270
Phone$2,915.6991$1,800.99148$498.66120$7,988.06137
USWeb$29,850.28958$11,850.74943$3,960.14940$49,076.30847
Store$11,576.35373$5,764.62461$1,860.92441$26,994.58462
Phone$5,441.41174$3,306.23255$942.50227$12,026.60205
Viz
{
  "mark": "text",
  "x": [
    {
      "kind": "dimension",
      "ref": {
        "dimension": "category"
      }
    },
    {
      "kind": "metrics"
    }
  ],
  "y": [
    {
      "kind": "dimension",
      "ref": {
        "dimension": "country"
      }
    },
    {
      "kind": "dimension",
      "ref": {
        "dimension": "channel"
      }
    }
  ],
  "text": {
    "kind": "metrics",
    "of": [
      {
        "kind": "metric",
        "metric": "revenue"
      },
      {
        "kind": "metric",
        "metric": "units"
      }
    ]
  }
}
Query
{
  "steps": [
    {
      "kind": "select",
      "metric": "revenue",
      "transform": null,
      "within": [],
      "along": null,
      "alias": null
    },
    {
      "kind": "select",
      "metric": "units",
      "transform": null,
      "within": [],
      "along": null,
      "alias": null
    }
  ],
  "by": [
    {
      "ref": {
        "dimension": "category",
        "transforms": []
      },
      "alias": null
    },
    {
      "ref": {
        "dimension": "country",
        "transforms": []
      },
      "alias": null
    },
    {
      "ref": {
        "dimension": "channel",
        "transforms": []
      },
      "alias": null
    }
  ],
  "slice": [],
  "order_by": [
    {
      "ref": "category",
      "direction": "asc"
    },
    {
      "ref": "country",
      "direction": "asc"
    },
    {
      "ref": "channel",
      "direction": "asc"
    }
  ],
  "limit": null
}