Question

Change the Model for Existing Looks and Dashboards?

  • 4 August 2015
  • 6 replies
  • 1768 views

I created a bunch of looks and dashboards using a model that is now outdated. I would like to switch all my looks and dashboards to the new model - what is the best way to do this? Is there a way to avoid re-building all my looks/dashboards from scratch?


6 replies

Userlevel 5
Badge

Hey Carla! Fortunately, you don’t have to rebuild all your Looks and Dashboards from scratch. We have something called the Look Validator that will allow you to find and replace the model name in all your saved Looks. You can read more about using the Look Validator here. You will want to use the Find and Replace All Looks button.


Note: this feature may need to be enabled in the Labs section of the Admin panel.

Is there a way to do this for just a few looks/dashboards/tiles?

Example: I have everything in one model but need to move sales related items to a new model that only has access to sales data. (I will probably do this with the other departments later for security purposes)

What is the best way to do this without re-creating the sales dashboards, looks and tiles?

Userlevel 1

Step 4 can get a bit sticky. How do you suggest I change the relevant parts of this URL?


https://company.looker.com/explore/ha_prod/tier3_jbroberg_scorecard_variancetoedap?fields=tier3_jbroberg_scorecard_variancetoedap.metric,tier3_jbroberg_scorecard_variancetoedap.meandailyvariance_gatoedap,tier3_jbroberg_scorecard_variancetoedap.standarderror_gatoedap,tier3_jbroberg_scorecard_variancetoedap.meandailyvariance_edwtoedap,tier3_jbroberg_scorecard_variancetoedap.standarderror_edwtoedap,tier3_jbroberg_scorecard_variancetoedap.meandailyvariance_betoedap,tier3_jbroberg_scorecard_variancetoedap.standarderror_betoedap,tier3_jbroberg_scorecard_variancetoedap.sort_by&f[tier3_jbroberg_scorecard_variancetoedap.metric]=-Booking+Request+Visitors%2C-Inquiry+Visitors%2C-PDP+View+Visitors&sorts=tier3_jbroberg_scorecard_variancetoedap.sort_by&limit=500&query_timezone=America%2FChicago&vis={"show_view_names"%3Atrue%2C"show_row_numbers"%3Afalse%2C"truncate_column_names"%3Afalse%2C"hide_totals"%3Afalse%2C"hide_row_totals"%3Afalse%2C"table_theme"%3A"unstyled"%2C"limit_displayed_rows"%3Afalse%2C"enable_conditional_formatting"%3Atrue%2C"conditional_formatting_include_totals"%3Afalse%2C"conditional_formatting_include_nulls"%3Afalse%2C"type"%3A"table"%2C"stacking"%3A""%2C"show_value_labels"%3Afalse%2C"label_density"%3A25%2C"legend_position"%3A"center"%2C"x_axis_gridlines"%3Afalse%2C"y_axis_gridlines"%3Atrue%2C"y_axis_combined"%3Atrue%2C"show_y_axis_labels"%3Atrue%2C"show_y_axis_ticks"%3Atrue%2C"y_axis_tick_density"%3A"default"%2C"y_axis_tick_density_custom"%3A5%2C"show_x_axis_label"%3Atrue%2C"show_x_axis_ticks"%3Atrue%2C"x_axis_scale"%3A"auto"%2C"y_axis_scale_mode"%3A"linear"%2C"x_axis_reversed"%3Afalse%2C"y_axis_reversed"%3Afalse%2C"ordering"%3A"none"%2C"show_null_labels"%3Afalse%2C"show_totals_labels"%3Afalse%2C"show_silhouette"%3Afalse%2C"totals_color"%3A"%23808080"%2C"series_types"%3A{}%2C"conditional_formatting"%3A[{"type"%3A"equal+to"%2C"value"%3A0%2C"background_color"%3Anull%2C"font_color"%3A"%23FFFFFF"%2C"palette"%3A{"name"%3A"Red+to+Yellow+to+Green"%2C"colors"%3A["%23F36254"%2C"%23FCF758"%2C"%234FBC89"]}%2C"bold"%3Afalse%2C"italic"%3Afalse%2C"strikethrough"%3Afalse%2C"fields"%3Anull}%2C{"type"%3A"between"%2C"value"%3A[-0.05%2C0.05]%2C"background_color"%3Anull%2C"font_color"%3A"%23008000"%2C"palette"%3A{"name"%3A"Red+to+Yellow+to+Green"%2C"colors"%3A["%23F36254"%2C"%23FCF758"%2C"%234FBC89"]}%2C"bold"%3Afalse%2C"italic"%3Afalse%2C"strikethrough"%3Afalse%2C"fields"%3A["tier3_jbroberg_scorecard_variancetoedap.meandailyvariance_gatoedap"%2C"tier3_jbroberg_scorecard_variancetoedap.meandailyvariance_edwtoedap"]}%2C{"type"%3A"not+between"%2C"value"%3A[-0.05%2C0.05]%2C"background_color"%3Anull%2C"font_color"%3A"%23FF0000"%2C"palette"%3A{"name"%3A"Red+to+Yellow+to+Green"%2C"colors"%3A["%23F36254"%2C"%23FCF758"%2C"%234FBC89"]}%2C"bold"%3Afalse%2C"italic"%3Afalse%2C"strikethrough"%3Afalse%2C"fields"%3A["tier3_jbroberg_scorecard_variancetoedap.meandailyvariance_gatoedap"%2C"tier3_jbroberg_scorecard_variancetoedap.meandailyvariance_edwtoedap"]}%2C{"type"%3A"not+between"%2C"value"%3A[-0.01%2C0.01]%2C"background_color"%3Anull%2C"font_color"%3A"%23FF0000"%2C"palette"%3A{"name"%3A"Red+to+Yellow+to+Green"%2C"colors"%3A["%23F36254"%2C"%23FCF758"%2C"%234FBC89"]}%2C"bold"%3Afalse%2C"italic"%3Afalse%2C"strikethrough"%3Afalse%2C"fields"%3A["tier3_jbroberg_scorecard_variancetoedap.standarderror_gatoedap"%2C"tier3_jbroberg_scorecard_variancetoedap.standarderror_edwtoedap"]}%2C{"type"%3A"between"%2C"value"%3A[-0.01%2C0.01]%2C"background_color"%3Anull%2C"font_color"%3A"%23008000"%2C"palette"%3A{"name"%3A"Red+to+Yellow+to+Green"%2C"colors"%3A["%23F36254"%2C"%23FCF758"%2C"%234FBC89"]}%2C"bold"%3Afalse%2C"italic"%3Afalse%2C"strikethrough"%3Afalse%2C"fields"%3A["tier3_jbroberg_scorecard_variancetoedap.standarderror_gatoedap"%2C"tier3_jbroberg_scorecard_variancetoedap.standarderror_edwtoedap"]}]%2C"series_labels"%3A{"tier3_jbroberg_scorecard_variancetoedap.meandailyvariance_gatoedap"%3A"Variance+against+GA"%2C"tier3_jbroberg_scorecard_variancetoedap.standarderror_gatoedap"%3A"Standard+Error+against+GA"%2C"tier3_jbroberg_scorecard_variancetoedap.meandailyvariance_edwtoedap"%3A"Variance+against+EDW+(Cloud)"%2C"tier3_jbroberg_scorecard_variancetoedap.standarderror_edwtoedap"%3A"Standard+Error+against+EDW+(Cloud)"%2C"tier3_jbroberg_scorecard_variancetoedap.metric"%3A"Metric+%2F+Dimension"%2C"tier3_jbroberg_scorecard_variancetoedap.standarderror_betoedap"%3A"Standard+Error+against+Business+Events"%2C"tier3_jbroberg_scorecard_variancetoedap.meandailyvariance_betoedap"%3A"Variance+against+Business+Events"%2C"tier3_jbroberg_scorecard_variancetoedap.validation_complete"%3A"Validation+Complete%3F"}%2C"hidden_fields"%3A["tier3_jbroberg_scorecard_variancetoedap.sort_by"]}&filter_config={"tier3_jbroberg_scorecard_variancetoedap.metric"%3A[{"type"%3A"!%3D"%2C"values"%3A[{"constant"%3A"Booking+Request+Visitors%2CInquiry+Visitors%2CPDP+View+Visitors"}%2C{}]%2C"id"%3A0%2C"error"%3Afalse}]}&dynamic_fields=[]&origin=share-expanded

Userlevel 4

I’ve got the same issue here… and tried pasting the URL into notepad, and replacing all instances of the one explore with the new one - but I get a “Looker Unavailable” error when I try to go to that.

Userlevel 4

Do you want to replace the explore or the model? The original question was about replacing the model, but you seem to be asking about the explore. I would suggest the technique for either might be the same, but I’ve not had occasion to try it.


This aside, from my brief testing, the error “Looker Unavailable”, seems to indicate company in: https://company.looker.com/explore … is incorrect.

Userlevel 4

Hi


I want to re-map a single look or dashboard to a new explore, but not change all the other dashboards I have in my company.

Reply