Pivot and Chart-Please help!!!

MARU Registered Posts: 9 ✭✭✭

I have attached an excel file that I do weekly with an updated refreshed data. I wanted to mimic this in Dataiku for automation. I don't know much coding so using the prepare recipe but its not working. I need help.

In my attached file, I have a raw extract where I want to "transpose" the dates into rows with naming that column "date". Then I wanted the column "P to be the columns with the Metric. Then I wanted to do the basic chart that looks like that with dates on X axis and filter by "P" and use column "Metric". but unable to do it. I need help!!! I would appreciate a step by step approach since I'm new this and trying to learn.


Setup Info
      Help me…