data for app

I have a dataset with historical production data by month that I am using in an app.  I need to restructure the data so that the monthly values are nested into new objects based on their CISN which is a unique identifier.  I have been able to create the nested production data as hoped but it is still returning every row for each CISN.  I have attached the code that I am using for the data pull.  As a footnote, I am a novice with JavaScript & jQuery so I am not sure if I am on the right track or way off base with the code I have used.

 

Any suggestions/help would be greatly appreciated!!

 

Sample of the data in tabular format looks like this:

table.png

 

and produces the following json structure when loaded via domo.get:

json.png

Nested json production example:

nestedJson.png

 

Comments