Dashboards & looks
Building reports & visualizations in Looker
- 1,689 Topics
- 4,117 Replies
Hello everybody, I was wondering if it’s possible to add html links to a dashboard, for example, to have shortcats to certain dashboard filters so the users don’t have to set the filters themselves. I’ve looked at the documentation but have not found anything about it Thanks in advance for the help!
Hi good lookers, I’m wondering if it’s possible to have a visualisation which aggregates the results of a query? My table is deliberately quite granular as I then filter results at a granular level, but then I would like to present the overall no. of these results by day. More specifically, if I have a table like: Date, domain, domain type, domain seller, impressions, conversions (& for this table I am filtering to impressions>100,000, conversions=0 in order to flag badly performing domains) Can I then ‘aggregate’ this table’s results using a visualisation, just showing ‘date’ on the x-axis and ‘impressions’ on the y-axis? (To present ‘no. of impressions from badly performing domains by day’) Thanks in advance to anyone who can help!
Hi there. Who is using custom visualizations? I have enhanced the bubble chart and have that to trade… our version doesn’t require that columns are metrics and also allows for a 4th column to be displayed in the tool tip as “meta data” I’m looking for others who might have done some additional footwork on the “options” in the visualization pane of explore. Also @natenate I don’t see any docs yet on custom visualizations. I would love to see things like: How to create toggle buttons for a value on an off options as well as radio buttons, and perhaps even a reference line example? A knerd can dream…
We came up with an interesting trick that I thought I would share with the community. We recently updated some of our underlying model and rebuilt a dashboard based on the newer model, in order to allow for people who may have bookmarked the old version of the dashboard, we created a new field in the underlying Look. - dimension: dashboard_redirect sql: getDate() html: <a href="/dashboards/26">Go Here Instead</a> (Note: We used getDate() because true didn’t work) Then we created a Look that had that one field displayed, set it as “Single Value” visualization, and replaced the content of old dashboard with this Look. The new dashboard is pretty simple, but informative 😄
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
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?
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?
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.
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.
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", "
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?
Already have an account? Login
Login to the community
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.