Skip to content

Instantly share code, notes, and snippets.

@davebshow
Created August 20, 2014 15:08
Show Gist options
  • Save davebshow/3b8ab15b48a24f31630a to your computer and use it in GitHub Desktop.
Save davebshow/3b8ab15b48a24f31630a to your computer and use it in GitHub Desktop.
Dummy JSON for reports models
// ReportTemplate JSON
[
[
{
"rowspan":"1",
"colspan":"1",
"id":"cell1",
"chartType":"line",
"displayQuery":"Query1",
"col":0,
"row":0
},
{
"rowspan":"1",
"colspan":"2",
"id":"cell2",
"chartType":"scatter",
"displayQuery":"Query1",
"col":1,
"row":0
}
],
[
{
"rowspan":"1",
"colspan":"1",
"id":"cell3",
"chartType":"pie",
"displayQuery":"Query1",
"col":0,
"row":1
},
{
"rowspan":"1",
"colspan":"1",
"id":"cell4",
"chartType":"column",
"displayQuery":"Query1",
"col":1,
"row":1
},
{
"rowspan":"1",
"colspan":"1",
"id":"cell5",
"chartType":"column",
"displayQuery":"Query1",
"col":2,
"row":1
}
]
]
// Report 1 JSON
[
[
{
"rowspan":"1",
"colspan":"1",
"col":0,
"series":[
[
"5",
0.279767
],
[
"2",
0.15
],
[
"6",
0.484065
],
[
"8",
0.1925
],
[
"7",
0.918638
],
[
"1",
0.1925
],
[
"4",
0.394192
],
[
"3",
0.182725
]
],
"chartType":"bar",
"displayQuery":"Query1",
"id":"cell1",
"row":0
},
{
"rowspan":"1",
"colspan":"2",
"col":1,
"series":[
[
"5",
0.279767
],
[
"2",
0.15
],
[
"6",
0.484065
],
[
"8",
0.1925
],
[
"7",
0.918638
],
[
"1",
0.1925
],
[
"4",
0.394192
],
[
"3",
0.182725
]
],
"chartType":"bar",
"displayQuery":"Query1",
"id":"cell2",
"row":0
}
],
[
{
"rowspan":"1",
"colspan":"1",
"col":0,
"series":[
[
"5",
0.279767
],
[
"2",
0.15
],
[
"6",
0.484065
],
[
"8",
0.1925
],
[
"7",
0.918638
],
[
"1",
0.1925
],
[
"4",
0.394192
],
[
"3",
0.182725
]
],
"chartType":"bar",
"displayQuery":"Query1",
"id":"cell3",
"row":1
},
{
"rowspan":"1",
"colspan":"1",
"col":1,
"series":[
[
"5",
0.279767
],
[
"2",
0.15
],
[
"6",
0.484065
],
[
"8",
0.1925
],
[
"7",
0.918638
],
[
"1",
0.1925
],
[
"4",
0.394192
],
[
"3",
0.182725
]
],
"chartType":"bar",
"displayQuery":"Query1",
"id":"cell4",
"row":1
},
{
"rowspan":"1",
"colspan":"1",
"col":2,
"series":[
[
"5",
0.279767
],
[
"2",
0.15
],
[
"6",
0.484065
],
[
"8",
0.1925
],
[
"7",
0.918638
],
[
"1",
0.1925
],
[
"4",
0.394192
],
[
"3",
0.182725
]
],
"chartType":"bar",
"displayQuery":"Query1",
"id":"cell5",
"row":1
}
]
]
// Report 2 JSON
[
[
{
"rowspan":"1",
"colspan":"1",
"col":0,
"series":[
[
"5",
0.279767
],
[
"2",
0.15
],
[
"6",
0.484065
],
[
"8",
0.1925
],
[
"7",
0.918638
],
[
"1",
0.1925
],
[
"4",
0.394192
],
[
"3",
0.182725
]
],
"chartType":"pie",
"displayQuery":"Query1",
"id":"cell1",
"row":0
},
{
"rowspan":"1",
"colspan":"2",
"col":1,
"series":[
[
"5",
0.279767
],
[
"2",
0.15
],
[
"6",
0.484065
],
[
"8",
0.1925
],
[
"7",
0.918638
],
[
"1",
0.1925
],
[
"4",
0.394192
],
[
"3",
0.182725
]
],
"chartType":"pie",
"displayQuery":"Query1",
"id":"cell2",
"row":0
}
],
[
{
"rowspan":"1",
"colspan":"1",
"col":0,
"series":[
[
"5",
0.279767
],
[
"2",
0.15
],
[
"6",
0.484065
],
[
"8",
0.1925
],
[
"7",
0.918638
],
[
"1",
0.1925
],
[
"4",
0.394192
],
[
"3",
0.182725
]
],
"chartType":"pie",
"displayQuery":"Query1",
"id":"cell3",
"row":1
},
{
"rowspan":"1",
"colspan":"1",
"col":1,
"series":[
[
"5",
0.279767
],
[
"2",
0.15
],
[
"6",
0.484065
],
[
"8",
0.1925
],
[
"7",
0.918638
],
[
"1",
0.1925
],
[
"4",
0.394192
],
[
"3",
0.182725
]
],
"chartType":"pie",
"displayQuery":"Query1",
"id":"cell4",
"row":1
},
{
"rowspan":"1",
"colspan":"1",
"col":2,
"series":[
[
"5",
0.279767
],
[
"2",
0.15
],
[
"6",
0.484065
],
[
"8",
0.1925
],
[
"7",
0.918638
],
[
"1",
0.1925
],
[
"4",
0.394192
],
[
"3",
0.182725
]
],
"chartType":"pie",
"displayQuery":"Query1",
"id":"cell5",
"row":1
}
]
]
// Query JSON ***NAME MUST BE Query1***
{
"series":[
[
"5",
0.279767
],
[
"2",
0.15
],
[
"6",
0.484065
],
[
"8",
0.1925
],
[
"7",
0.918638
],
[
"1",
0.1925
],
[
"4",
0.394192
],
[
"3",
0.182725
]
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment