7 Replies Latest reply on Oct 4, 2018 8:27 AM by Joe Oppelt

    Assigning a month to 12 columns to plot against time

    shan chandi

      I'm importing 1 row per id 12 columns each representing the same variable at different months using SQL and I'm having trouble trying to figure out how to assign a month to each column.. Is there any way to do this?

       

      My data before was 12 rows per id and this allowed me to track the variable across time very easily but made it difficult to show percentages and changes on the id level. Or was my dataset the way it was before the only way to do this?