Looker Connect Training

Help Center

Documentation

Community

Cloud Certifications

Dashboards & looks

Building reports & visualizations in Looker

  • 1,560 Topics
  • 3,978 Replies

1560 Topics

A
apd
asked in Dashboards & looks

Remove table name prefix from column names in Dashboard Table

Guess what? It’s easier than π. Just add one line to the relevant dashboard LookML. show_view_names: false A more complete example. # Dashboard LookML - dashboard: some_dashboard title: Some Title layout: grid rows: - elements: [some_name, ...] height: 1500 elements: - name: some_name ... show_view_names: false # This will hide the table name

0
A
6 years ago
C
cobbr2Member
asked in Dashboards & looks

Can we filter the set of visualizations in a dashboard?

In our most common dashboards, we want different users to see different visualizations. In order to do this now (based on the feature set from 3.8), we use external tooling: a script which identifies which combinations of charts make up legitimate dashboards, and then generates the filtered dashboards. We would prefer to actually just filter them from a comprehensive dashboard. Is there anything in the more recent versions that support this?

1
L
Looker Staff
6 years ago
C
cobbr2Member
asked in Dashboards & looks

Can we get the title for a dashboard chart from data instead of hard-coding it?

In some of our dashboards, different users see the same visualization of the same data – but want to call it something else (e.g., “location” vs. “store”). Is there a way to do this without having to generate a new copy of that chart, then add a special dashboard for each set of users?

1
L
Looker Staff
6 years ago
S
Shawn_Peterson
asked in Dashboards & looks

Dashboard Copy - Listeners not being copied

When I use copy a Dashboard, the filters and looks are in the new copy, but listeners have to be set up again. Is this intended and if so why?

3
S
7 years ago
S
staubina
asked in Dashboards & looks

Looker vs SSRS

I am working with a SQL Server Dataset and I am building an Engineering Dashboard on top of this to monitor Product Status based on data in the DB. I am considering using either Looker or SSRS. People in this board have chosen Looker or are considering it of course. For those who have worked with SSRS, but now use Looker, why did you choose to go with Looker? How well does Looker integrate with SQL Server? My main goal is to build an internal net accessible Dashboard with dynamic Tables and Plots embedded in the page. Tables that allow the user to drill down into the data. One feature that has drawn me to Looker is the lack of requirement for every user to have a license to view the data. Is this Assumption correct? Thank you.

0
S
7 years ago
J
joshsiegelMember
asked in Dashboards & looks

About the Dashboards & Visualizations category

Visualizations how-to, dashboarding best practices, and all things viz

1
segahm
7 years ago
W
weitzenfeldMember
asked in Dashboards & looks

Single Value Visualization with percent_of_previous Measure

I’m trying to create a Single Value visualization displaying the ratio of the current month’s revenue to the prior month’s. Is there a trick to making this work? I need multiple months to generate the percent_of_previous measure, but including multiple months makes it impossible to use the Single Value visualization.

3
W
7 years ago
A
andybeech
asked in Dashboards & looks

Is there a standard way to do histograms in Looker?

Wondering what best practices are from others who have built histograms in Looker.

1
R
7 years ago
Xiaolong_Cheng
Xiaolong_Cheng
asked in Dashboards & looks

Escaping commas in string filters for a dashboard

Issue Hi all, I have an issue with escaping commas in string filters. I have this line in my dashboard LookML: default_value: "San Francisco, East Bay, Portland, Washington, D.C.", and Looker treats “Washington” and “D.C.” as 2 separate strings, which is not desired. Notes First thing I tried is to escape the comma with a backslash, like below: default_value: "San Francisco, East Bay, Portland, Washington\, D.C." but this gives me a “parsing error” in Looker. Then I used double backslashes: default_value: "San Francisco, East Bay, Portland, Washington\\, D.C." Now there wasn’t any parsing errors, but this eliminated the space after that comma, which is not desired. According to http://www.looker.com/docs/reference/filter-expressions, I modified my line to default_value: "San Francisco", "East Bay", "Portland", "Washington, D.C.", However this also gives me a “parsing error”. Then I tried using single quote to enclose the whole thing, like below: default_value: '"San Francisco", "

1
colin
Looker Staff
7 years ago
A
andybeech
asked in Dashboards & looks

Embedding without links back to Looker

I want to embed a Looker table into my internal company’s Confluence page, which works fine, but if someone clicks a dimension it tries to filter by that dimension and run another query, which goes back to Looker. Is there a way to turn off the dimension links? What about measure links?

0
A
7 years ago

Badges

  • Friendly Face
    sbrylowskihas earned the badge Friendly Face
  • Helpful
    carriehas earned the badge Helpful
  • Community Star
    carriehas earned the badge Community Star
  • Friendly Face
    carriehas earned the badge Friendly Face
  • Community Star
    Dawidhas earned the badge Community Star
Show all badges
Terms of Service