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:
and produces the following json structure when loaded via domo.get:
Nested json production example:
