Help with transforming Json data

[Markzolotoy]

I have the following json:

{
  "AgeDistributionWeeks": {
    "Week1": 1,
    "Week2": 0,
    "Week3": 0,
    "Week4": 0,
    "Week5": 0,
    "Week6+": 0
  },
  "CaseCategories": {
    "(Uncategorized)": 1
  },
  "CasePriorities": {
    "CasePriorityNormal": 1
  },
  "OpenCaseCount": 1
}

How would I transform it into something that I can create some charts based on it?

Thanks

[lbendlin · Accepted solution]

This entirely depends on what the data means to you, which part is important, at what granularity level etc.

let
    Source = Json.Document(File.Contents("C:\Users\xxx\Downloads\test.json")),
    #"Converted to Table" = Record.ToTable(Source),
    Value = #"Converted to Table"{0}[Value],
    #"Converted to Table1" = Record.ToTable(Value)
in
    #"Converted to Table1"

This is just one example of how you can parse the content.