Forum Discussion

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

gnavia - I downloaded your file and I would highly recommend starting by unpivoting all of your humidity and temperature columns. Beyond that, I am not 100% on what you are trying to achieve. 

  • gnavia's avatar
    gnavia
    Helper I
    6 years ago

    Hello @Greg_Deckler , thank you for your response. I don't know what you mean by despivo, maybe it means depivot?, but if I do that I'll lose the date ratio with the columns. What I'm trying to achieve is to filter the graphs so that it only shows 1 or 2 humidity values to compare and not all, the same with the temperature. Other than that if I convert the columns into rows, as I mentioned earlier the date relationship to the data would be lost.

      • gnavia's avatar
        gnavia
        Helper I
        5 years ago

        Hello

        I try to do what you tell me, however I get the following error:

        gnavia_0-1598267964579.png

        I get an error due to duplication of dates in the data because I have pivoted the columns