2340patel Posted March 6, 2019 Share Posted March 6, 2019 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.Productquartermarchaprilbags1Q100100 Productquarterapril shoes2Q200 When using group with crosstab the data is not displayed as group instead only the last line is displaying.Productquarteraprilbags1Q200can using jsonql we group the display of data based on quarter. ThanksAnjana Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now