Change data source for a chart in a Dashboard
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?
Answers
-
Sergey Dataiker, Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS Core Concepts Posts: 365 Dataiker
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.
-
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?
-
Sergey Dataiker, Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS Core Concepts 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.
-
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 Posts: 118 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...
-
CoreyS Dataiker Alumni, Dataiku DSS Core Designer, Dataiku DSS Core Concepts, Registered Posts: 1,150 ✭✭✭✭✭✭✭✭✭
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!
-
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 Posts: 118 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
-
Sarina Dataiker, Dataiku DSS Core Designer, Dataiku DSS Adv Designer, Registered Posts: 317 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