[json] response
Viewer
- {
- "ecom": {
- "data": [
- {
- "Category": "Amusement",
- "MALAYSIA - Sum (RM)": 0.0,
- "MALAYSIA - Transaction Count": 0.0,
- "OTHER COUNTRIES - Sum (RM)": 1687.55,
- "OTHER COUNTRIES - Transaction Count": 146.0,
- "Total - Sum (RM)": 1687.55,
- "Total - Transaction Count": 146.0
- },
- {
- "Category": "Commercial",
- "MALAYSIA - Sum (RM)": 0.0,
- "MALAYSIA - Transaction Count": 0.0,
- "OTHER COUNTRIES - Sum (RM)": 13567.23,
- "OTHER COUNTRIES - Transaction Count": 50.0,
- "Total - Sum (RM)": 13567.23,
- "Total - Transaction Count": 50.0
- },
- {
- "Category": "Entertainment",
- "MALAYSIA - Sum (RM)": 1791.0,
- "MALAYSIA - Transaction Count": 40.0,
- "OTHER COUNTRIES - Sum (RM)": 124.59,
- "OTHER COUNTRIES - Transaction Count": 13.0,
- "Total - Sum (RM)": 1915.59,
- "Total - Transaction Count": 53.0
- },
- {
- "Category": "Financial",
- "MALAYSIA - Sum (RM)": 2605098.75,
- "MALAYSIA - Transaction Count": 7035.0,
- "OTHER COUNTRIES - Sum (RM)": 7115.09,
- "OTHER COUNTRIES - Transaction Count": 129.0,
- "Total - Sum (RM)": 2612213.84,
- "Total - Transaction Count": 7164.0
- },
- {
- "Category": "Food",
- "MALAYSIA - Sum (RM)": 799.65,
- "MALAYSIA - Transaction Count": 28.0,
- "OTHER COUNTRIES - Sum (RM)": 2761.32,
- "OTHER COUNTRIES - Transaction Count": 28.0,
- "Total - Sum (RM)": 3560.97,
- "Total - Transaction Count": 56.0
- },
- {
- "Category": "Fuel",
- "MALAYSIA - Sum (RM)": 7.11,
- "MALAYSIA - Transaction Count": 13.0,
- "OTHER COUNTRIES - Sum (RM)": 0.0,
- "OTHER COUNTRIES - Transaction Count": 0.0,
- "Total - Sum (RM)": 7.11,
- "Total - Transaction Count": 13.0
- },
- {
- "Category": "Government",
- "MALAYSIA - Sum (RM)": 16883.97,
- "MALAYSIA - Transaction Count": 123.0,
- "OTHER COUNTRIES - Sum (RM)": 54194267.22,
- "OTHER COUNTRIES - Transaction Count": 752.0,
- "Total - Sum (RM)": 54211151.19,
- "Total - Transaction Count": 875.0
- },
- {
- "Category": "Hotel",
- "MALAYSIA - Sum (RM)": 3161.79,
- "MALAYSIA - Transaction Count": 27.0,
- "OTHER COUNTRIES - Sum (RM)": 30197.68,
- "OTHER COUNTRIES - Transaction Count": 134.0,
- "Total - Sum (RM)": 33359.47,
- "Total - Transaction Count": 161.0
- },
- {
- "Category": "Insurance",
- "MALAYSIA - Sum (RM)": 3121.73,
- "MALAYSIA - Transaction Count": 7.0,
- "OTHER COUNTRIES - Sum (RM)": 10175.0,
- "OTHER COUNTRIES - Transaction Count": 14.0,
- "Total - Sum (RM)": 13296.73,
- "Total - Transaction Count": 21.0
- },
- {
- "Category": "Merchant",
- "MALAYSIA - Sum (RM)": 0.0,
- "MALAYSIA - Transaction Count": 0.0,
- "OTHER COUNTRIES - Sum (RM)": 8666.21,
- "OTHER COUNTRIES - Transaction Count": 887.0,
- "Total - Sum (RM)": 8666.21,
- "Total - Transaction Count": 887.0
- },
- {
- "Category": "Other",
- "MALAYSIA - Sum (RM)": 171356.41,
- "MALAYSIA - Transaction Count": 1235.0,
- "OTHER COUNTRIES - Sum (RM)": 1816233.38,
- "OTHER COUNTRIES - Transaction Count": 10084.0,
- "Total - Sum (RM)": 1987589.7899999998,
- "Total - Transaction Count": 11319.0
- },
- {
- "Category": "Professional",
- "MALAYSIA - Sum (RM)": 14759.32,
- "MALAYSIA - Transaction Count": 14.0,
- "OTHER COUNTRIES - Sum (RM)": 3579.15,
- "OTHER COUNTRIES - Transaction Count": 58.0,
- "Total - Sum (RM)": 18338.47,
- "Total - Transaction Count": 72.0
- },
- {
- "Category": "Restaurant",
- "MALAYSIA - Sum (RM)": 1405.82,
- "MALAYSIA - Transaction Count": 25.0,
- "OTHER COUNTRIES - Sum (RM)": 21.83,
- "OTHER COUNTRIES - Transaction Count": 2.0,
- "Total - Sum (RM)": 1427.65,
- "Total - Transaction Count": 27.0
- },
- {
- "Category": "Retail",
- "MALAYSIA - Sum (RM)": 95644.58,
- "MALAYSIA - Transaction Count": 2596.0,
- "OTHER COUNTRIES - Sum (RM)": 317843.85,
- "OTHER COUNTRIES - Transaction Count": 1005.0,
- "Total - Sum (RM)": 413488.43,
- "Total - Transaction Count": 3601.0
- },
- {
- "Category": "Transportation",
- "MALAYSIA - Sum (RM)": 118903.91,
- "MALAYSIA - Transaction Count": 3080.0,
- "OTHER COUNTRIES - Sum (RM)": 364107.63,
- "OTHER COUNTRIES - Transaction Count": 96.0,
- "Total - Sum (RM)": 483011.54,
- "Total - Transaction Count": 3176.0
- },
- {
- "Category": "Utility",
- "MALAYSIA - Sum (RM)": 21853.87,
- "MALAYSIA - Transaction Count": 128.0,
- "OTHER COUNTRIES - Sum (RM)": 5312.36,
- "OTHER COUNTRIES - Transaction Count": 52.0,
- "Total - Sum (RM)": 27166.23,
- "Total - Transaction Count": 180.0
- },
- {
- "Category": "Total",
- "MALAYSIA - Sum (RM)": 3054787.91,
- "MALAYSIA - Transaction Count": 14351.0,
- "OTHER COUNTRIES - Sum (RM)": 56775660.09,
- "OTHER COUNTRIES - Transaction Count": 13450.0,
- "Total - Sum (RM)": 59830448.0,
- "Total - Transaction Count": 27801.0
- }
- ],
- "schema": {
- "fields": [
- {
- "name": "Category",
- "type": "string"
- },
- {
- "name": "MALAYSIA - Sum (RM)",
- "type": "number"
- },
- {
- "extDtype": "Float64",
- "name": "MALAYSIA - Transaction Count",
- "type": "number"
- },
- {
- "name": "OTHER COUNTRIES - Sum (RM)",
- "type": "number"
- },
- {
- "extDtype": "Float64",
- "name": "OTHER COUNTRIES - Transaction Count",
- "type": "number"
- },
- {
- "name": "Total - Sum (RM)",
- "type": "number"
- },
- {
- "name": "Total - Transaction Count",
- "type": "number"
- }
- ],
- "pandas_version": "1.4.0",
- "primaryKey": [
- "Category"
- ]
- }
- },
- "pos": {
- "data": [
- {
- "Category": "Amusement",
- "MALAYSIA - Sum (RM)": 5672.05,
- "MALAYSIA - Transaction Count": 133.0,
- "OTHER COUNTRIES - Sum (RM)": 20.9,
- "OTHER COUNTRIES - Transaction Count": 2.0,
- "Total - Sum (RM)": 5692.95,
- "Total - Transaction Count": 135.0
- },
- {
- "Category": "Commercial",
- "MALAYSIA - Sum (RM)": 2438.66,
- "MALAYSIA - Transaction Count": 419.0,
- "OTHER COUNTRIES - Sum (RM)": 710.78,
- "OTHER COUNTRIES - Transaction Count": 38.0,
- "Total - Sum (RM)": 3149.44,
- "Total - Transaction Count": 457.0
- },
- {
- "Category": "Entertainment",
- "MALAYSIA - Sum (RM)": 5926.8,
- "MALAYSIA - Transaction Count": 138.0,
- "OTHER COUNTRIES - Sum (RM)": 2051.29,
- "OTHER COUNTRIES - Transaction Count": 118.0,
- "Total - Sum (RM)": 7978.09,
- "Total - Transaction Count": 256.0
- },
- {
- "Category": "Financial",
- "MALAYSIA - Sum (RM)": 1690475.38,
- "MALAYSIA - Transaction Count": 21992.0,
- "OTHER COUNTRIES - Sum (RM)": -3736389.32,
- "OTHER COUNTRIES - Transaction Count": 219.0,
- "Total - Sum (RM)": -2045913.94,
- "Total - Transaction Count": 22211.0
- },
- {
- "Category": "Food",
- "MALAYSIA - Sum (RM)": 93919.46,
- "MALAYSIA - Transaction Count": 3769.0,
- "OTHER COUNTRIES - Sum (RM)": 3485332.22,
- "OTHER COUNTRIES - Transaction Count": 313.0,
- "Total - Sum (RM)": 3579251.68,
- "Total - Transaction Count": 4082.0
- },
- {
- "Category": "Fuel",
- "MALAYSIA - Sum (RM)": 125054.03,
- "MALAYSIA - Transaction Count": 5671.0,
- "OTHER COUNTRIES - Sum (RM)": 45947.39,
- "OTHER COUNTRIES - Transaction Count": 46.0,
- "Total - Sum (RM)": 171001.42,
- "Total - Transaction Count": 5717.0
- },
- {
- "Category": "Government",
- "MALAYSIA - Sum (RM)": 39947.01,
- "MALAYSIA - Transaction Count": 256.0,
- "OTHER COUNTRIES - Sum (RM)": 191.81,
- "OTHER COUNTRIES - Transaction Count": 4.0,
- "Total - Sum (RM)": 40138.82,
- "Total - Transaction Count": 260.0
- },
- {
- "Category": "Hotel",
- "MALAYSIA - Sum (RM)": 25978.93,
- "MALAYSIA - Transaction Count": 223.0,
- "OTHER COUNTRIES - Sum (RM)": 743328.98,
- "OTHER COUNTRIES - Transaction Count": 68.0,
- "Total - Sum (RM)": 769307.91,
- "Total - Transaction Count": 291.0
- },
- {
- "Category": "Insurance",
- "MALAYSIA - Sum (RM)": 1614.28,
- "MALAYSIA - Transaction Count": 8.0,
- "OTHER COUNTRIES - Sum (RM)": 0.0,
- "OTHER COUNTRIES - Transaction Count": 0.0,
- "Total - Sum (RM)": 1614.28,
- "Total - Transaction Count": 8.0
- },
- {
- "Category": "Merchant",
- "MALAYSIA - Sum (RM)": 7824.7,
- "MALAYSIA - Transaction Count": 48.0,
- "OTHER COUNTRIES - Sum (RM)": 44546.25,
- "OTHER COUNTRIES - Transaction Count": 3253.0,
- "Total - Sum (RM)": 52370.95,
- "Total - Transaction Count": 3301.0
- },
- {
- "Category": "Other",
- "MALAYSIA - Sum (RM)": 521384.08,
- "MALAYSIA - Transaction Count": 11806.0,
- "OTHER COUNTRIES - Sum (RM)": 1054670.99,
- "OTHER COUNTRIES - Transaction Count": 38643.0,
- "Total - Sum (RM)": 1576055.07,
- "Total - Transaction Count": 50449.0
- },
- {
- "Category": "Professional",
- "MALAYSIA - Sum (RM)": 45160.53,
- "MALAYSIA - Transaction Count": 312.0,
- "OTHER COUNTRIES - Sum (RM)": 2163.66,
- "OTHER COUNTRIES - Transaction Count": 64.0,
- "Total - Sum (RM)": 47324.19,
- "Total - Transaction Count": 376.0
- },
- {
- "Category": "Restaurant",
- "MALAYSIA - Sum (RM)": 279508.9,
- "MALAYSIA - Transaction Count": 12358.0,
- "OTHER COUNTRIES - Sum (RM)": 3267684.76,
- "OTHER COUNTRIES - Transaction Count": 171.0,
- "Total - Sum (RM)": 3547193.6599999997,
- "Total - Transaction Count": 12529.0
- },
- {
- "Category": "Retail",
- "MALAYSIA - Sum (RM)": 3290890.67,
- "MALAYSIA - Transaction Count": 101780.0,
- "OTHER COUNTRIES - Sum (RM)": 8959419.43,
- "OTHER COUNTRIES - Transaction Count": 1993.0,
- "Total - Sum (RM)": 12250310.1,
- "Total - Transaction Count": 103773.0
- },
- {
- "Category": "Transportation",
- "MALAYSIA - Sum (RM)": 343734.93,
- "MALAYSIA - Transaction Count": 36417.0,
- "OTHER COUNTRIES - Sum (RM)": 4851541.44,
- "OTHER COUNTRIES - Transaction Count": 344.0,
- "Total - Sum (RM)": 5195276.37,
- "Total - Transaction Count": 36761.0
- },
- {
- "Category": "Utility",
- "MALAYSIA - Sum (RM)": 3007.61,
- "MALAYSIA - Transaction Count": 24.0,
- "OTHER COUNTRIES - Sum (RM)": 72093.96,
- "OTHER COUNTRIES - Transaction Count": 12.0,
- "Total - Sum (RM)": 75101.57,
- "Total - Transaction Count": 36.0
- },
- {
- "Category": "Total",
- "MALAYSIA - Sum (RM)": 6482538.02,
- "MALAYSIA - Transaction Count": 195354.0,
- "OTHER COUNTRIES - Sum (RM)": 18793314.540000003,
- "OTHER COUNTRIES - Transaction Count": 45288.0,
- "Total - Sum (RM)": 25275852.560000002,
- "Total - Transaction Count": 240642.0
- }
- ],
- "schema": {
- "fields": [
- {
- "name": "Category",
- "type": "string"
- },
- {
- "name": "MALAYSIA - Sum (RM)",
- "type": "number"
- },
- {
- "extDtype": "Float64",
- "name": "MALAYSIA - Transaction Count",
- "type": "number"
- },
- {
- "name": "OTHER COUNTRIES - Sum (RM)",
- "type": "number"
- },
- {
- "extDtype": "Float64",
- "name": "OTHER COUNTRIES - Transaction Count",
- "type": "number"
- },
- {
- "name": "Total - Sum (RM)",
- "type": "number"
- },
- {
- "name": "Total - Transaction Count",
- "type": "number"
- }
- ],
- "pandas_version": "1.4.0",
- "primaryKey": [
- "Category"
- ]
- }
- },
- "total": {
- "data": [
- {
- "Category": "Grand Total",
- "MALAYSIA - Sum (RM)": 9537325.93,
- "MALAYSIA - Transaction Count": 209705.0,
- "OTHER COUNTRIES - Sum (RM)": 75568974.63000001,
- "OTHER COUNTRIES - Transaction Count": 58738.0,
- "Total - Sum (RM)": 85106300.56,
- "Total - Transaction Count": 268443.0
- }
- ],
- "schema": {
- "fields": [
- {
- "name": "Category",
- "type": "string"
- },
- {
- "name": "MALAYSIA - Sum (RM)",
- "type": "number"
- },
- {
- "extDtype": "Float64",
- "name": "MALAYSIA - Transaction Count",
- "type": "number"
- },
- {
- "name": "OTHER COUNTRIES - Sum (RM)",
- "type": "number"
- },
- {
- "extDtype": "Float64",
- "name": "OTHER COUNTRIES - Transaction Count",
- "type": "number"
- },
- {
- "name": "Total - Sum (RM)",
- "type": "number"
- },
- {
- "name": "Total - Transaction Count",
- "type": "number"
- }
- ],
- "pandas_version": "1.4.0",
- "primaryKey": [
- "Category"
- ]
- }
- }
- }
Editor
You can edit this paste and save as new: