I have a input json in this structure
{
"values": [
{
"product": {
"name": "bags",
"location": "MainMarket ",
"id": "1002"
},
"quarters": [{
"quarter": "1Q 2019",
"months": [{
"month": "march",
"purchase": 100
},
{
"month": "april",
"purchase": 100
}
]
},
{
"quarter": "2Q 2019",
"months": [
{
"month": "april",
"purchase": 100
}
]
}
]
},
{
"product": {
"name": "shoes",
"location": "MainMarket ",
"id": "1001"
},
"quarters": [{
"quarter": "1Q 2019",
"months": [{
"month": "march",
"purchase": 200
},
{
"month": "april",
"purchase": 300
}
]
},
{
"quarter": "2Q 2019",
"months": [
{
"month": "april",
"purchase": 500
}
]
}
]
}
]
}
For every product there exist its quarter and its quarter purchase like below.
| Product | quarter | march | april |
| bags | 1Q | 100 | 100 |
| Product | quarter | april | |
| shoes | 2Q | 200 |
|
When using group with crosstab the data is not displayed as group instead only the last line is displaying.
| Product | quarter | april |
| bags | 1Q | 200 |
can using jsonql we group the display of data based on quarter.
Thanks
Anjana
