How can I have Domostats include historical data as well

Nick_Commisso_X
Nick_Commisso_X Member
in Archive

Currently my Domostats only imports data from the date I downloaded it. How can I change that so it includes data from the past as well?

Tagged:

Comments

  • Basketballfan1
    Basketballfan1 Contributor

    My service rep was able to give me a one time download of the historical data that I could combine with the Domostats with a magic ETL.

  • Nick_Commisso_X
    Nick_Commisso_X Member

    I tried pulling the historical data. I'm still have quite some trouble with the ETL/format. Would you mind posting what your ETL consisted of? 

  • Basketballfan1
    Basketballfan1 Contributor

    Here you go.  In the historical dataset, I changed the name of the column 'userType' to 'Type' to match the activity log.

     

     

     

    DomoStats.PNG

Categories