javascript - DataTable 输出的在线图表？

Question

我有大约 900 个查询将它们的结果输出到 DataTable，然后我使用 NewtonSoft JsonConvert 将它们序列化为 json 字符串。

我希望能够为每个结果集尝试不同的图表类型，看看它是否能最好地显示为饼图、条形图、折线图、堆叠图......

以下是我从查询中获得的一些输出示例：

Count of patients by age:
[      
  {
    "Age": "17",
    "Patients": "11"
  },
  {
    "Age": "18",
    "Patients": "9"
  },
  {
    "Age": "19",
    "Patients": "17"
  },
  {
    "Age": "20",
    "Patients": "23"
  }
]

============

Patients seen per provider
[
  {
    "Provider": "Desi",
    "Patients Seen": "307"
  },
  {
    "Provider": "Dr. Smith",
    "Patients Seen": "1123"
  },
  {
    "Provider": "DRM",
    "Patients Seen": "293"
  },
  {
    "Provider": "HYG ",
    "Patients Seen": "171"
  },
  {
    "Provider": "RG",
    "Patients Seen": "137"
  }
]

Patients by payment type
============   

[
  {
    "InsType": "Cash Patients",
    "PatientCount": "421"
  },
  {
    "InsType": "Category Percentage",
    "PatientCount": "658"
  },
  {
    "InsType": "Medicaid/Flat Copay",
    "PatientCount": "604"
  }
]

Income results
============

[
  {
    "Production_": "1951282.06",
    "Adjust_": "-41892.36",
    "Writeoff_": "-12471.90",
    "NetProd_": "1896917.80"
  }
]

有些查询比其他查询有更多的“列”，例如这个：

[
  {
    "Abbr": "Dr. Smith ",
    "LName": "Smith",
    "FName": "Jerry ",
    "PatCount": "1131",
    " GrossProd": "1658438.70",
    " Writeoffs": "-11649.6",
    " Adjustments": "-38503.81",
    " NetProd": "1608285.29",
    " AveGrossPr": "1466.34",
    " AveNetPr": "1422.00"
  },
  {
    "Abbr": "HYG ",
    "LName": "Hygienist",
    "FName": "Default",
    "PatCount": "173",
    " GrossProd": "60620.5",
    " Writeoffs": "-803.6",
    " Adjustments": "-2629.75",
    " NetProd": "57187.15",
    " AveGrossPr": "350.40",
    " AveNetPr": "330.56"
  }
]

我可以就如何在在线图表软件中使用这些结果提出一些建议？似乎有了这样一个简单的查询系统 -> DataTable -> json，就会有图表将该输出用作其源数据。在尝试使用 ChartsJS 和其他一些工具时，看起来有一些广泛的自定义数据，这必须为 900 个中的每一个完成......

我希望我可以输入所有结果并查看哪些呈现为一条线，然后再次呈现并查看哪些用作饼图，哪些用作堆叠。

标签： javascriptjsonchartsjson.net