how to plot a chart by row

Chen
Chen Registered Posts: 1

I have a sample dataset with 5 columns shown below:

sample0.png

In dataiku how can I plot by each row, to get result like below chart in excel?

sample.png

Right now I can only plot something like below chart, which is NOT what I want ( I need 1M, 3M, 6M and 1Y to appear on x-axis):

sample2.png

Could someone help? Many thanks!

Best Answer

  • Turribeach
    Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 2,438 Neuron
    Answer ✓

    I start with your data:

    image.png

    I use a Prepare recipe to transpose the date column:

    image.png

    Then I can chart it as required:

    image.png
Setup Info
    Tags
      Help me…