data for app

tmullins Houston, TX 🟠

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:




  • Great question.


    This will require working with your CSM in this particular case.


    @SpencerWilcox please touch base with @tmullins on this question.



    Dani aka "Mr.Dojo"

    Dojo Admin
    **Say "Thanks" by clicking the "heart" in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
    **You can update your Dojo Community name and avatar by clicking on your avatar then the "My Profile" button.