Forum Discussion

Jin's avatar
Jin
3 years ago

How to merge two dashboards

I created two dashboards, but want to merge them into one. Is there a way to merge, or copy over widgets in bulk from another dashboard? 
Anonymous's avatar
Anonymous
3 years ago

The only way to do this would be to export the two dashboards and combine the JSON files into one. Then, you'd import the file as a new dashboard. Not terribly difficult, but you may run into problems is there are conflicts with the position attribute of each widget. It could probably be scripted since you can download and upload the dashboards via the API.

Within the dashboard JSON, there is a "widgets" object that is a list of the widgets. Each widget has a "position" object containing the row and column (col), plus the height (sizex) and width (sizey) of each widget. I'm not sure what would happen if these row and column conflict. You could probably avoid the conflict if you took the max row value from the target dashboard and added that to each widget's row value of the merging-into dashboard. 

{
  "santabaRelease": 165,
  "widgetTokens": [],
  "name": "ERCOT",
  "description": "",
  "overwriteGroupFields": false,
  "widgetsConfigVersion": 2,
  "type": "dashboard",
  "widgets": [
    {
      "position": {
        "col": 1,
        "sizex": 3,
        "row": 3, <==This is probably the potential collision.
        "sizey": 3
      },
      "config": {
        "displaySettings": {},
        "name": "ERCOT Prices",
        "description": "",
        "theme": "newBorderGray",
        "interval": 3,
        "graphInfo": {
          =============TRUNCATED=============