Change data source for a chart in a Dashboard

harshadevireddy
harshadevireddy Registered Posts: 3 ✭✭✭✭
in Using Dataiku

I'm trying to duplicate the existing charts in a dashboard. I would like the data for the new charts to come from a different table with the same column names in my project. How can I achieve this? Is it possible to edit the datasource that the chart is built on?

Tagged:
· Share on FacebookShare on Twitter

Answers

  • Sergey
    Sergey Dataiker, Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS Core Concepts, Registered Posts: 365 Dataiker

    Hi @harshadevireddy

    As far as know, this is not possible from UI. When the chart is created -> it's tied to the dataset. When you copy the chart, the corresponding config file just has the same link to this dataset.

    The only possible (not recommended/supported) way that I can think of is to find insight ID inside

    DATA_DIR/config/projects/<PROJECT_KEY>/insights/ directory and manually change

    "datasetSmartName" to the one you need.

    · Share on FacebookShare on Twitter
  • harshadevireddy
    harshadevireddy Registered Posts: 3 ✭✭✭✭

    Hi @sergeyd
    ,

    Thanks for the response. I'm working on my company's shared environment which is maintained by the IT team. Is this something that I can do as a user? If so where should I look for the folder path you mentioned?

    · Share on FacebookShare on Twitter
  • Sergey
    Sergey Dataiker, Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS Core Concepts, Registered Posts: 365 Dataiker

    The only thing that I can think of is to write a python program (within Jupyter notebook) that reads the file from OS filesystem, parses and updates JSON but that's something that I wouldn't recommend doing as incorrectly updated JSON might break corresponding chart on the dashboard.

    · Share on FacebookShare on Twitter
  • Tanguy
    Tanguy Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Neuron, Dataiku DSS Adv Designer, Registered, Dataiku DSS Developer, Neuron 2023, Circle Member Posts: 142 Neuron

    this have also been an issue in our company: we needed to copy/paste dashboards by pointing them on new datasets, but as of today this is not possible...

    · Share on FacebookShare on Twitter
  • CoreyS
    CoreyS Dataiker Alumni, Dataiku DSS Core Designer, Dataiku DSS Core Concepts, Registered Posts: 1,149 ✭✭✭✭✭✭✭✭✭

    Hi @tanguy
    the Product Ideas board is here to let you share and exchange your ideas on how to improve Dataiku so please feel free to utilize it! Here are some resources to help get you started: Suggest an idea

    I hope this helps!

    · Share on FacebookShare on Twitter
  • Tanguy
    Tanguy Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Neuron, Dataiku DSS Adv Designer, Registered, Dataiku DSS Developer, Neuron 2023, Circle Member Posts: 142 Neuron

    Thank you for your reply. I have posted the idea then: https://community.dataiku.com/t5/Product-Ideas/Change-data-source-for-a-chart-in-a-Dashboard/idi-p/29784

    · Share on FacebookShare on Twitter
  • Sarina
    Sarina Dataiker, Dataiku DSS Core Designer, Dataiku DSS Adv Designer, Registered, Moderator Posts: 320 Dataiker

    Hi @tanguy
    ,

    I wanted to update you that the ability to copy charts from one dataset to another has been added in DSS 12.2: https://doc.dataiku.com/dss/latest/release_notes/12.html#charts.

    Thanks,
    Sarina

    · Share on FacebookShare on Twitter
Bookmark this topic

Categories

Setup Info
    Tags
      Help me…