Exploring & curating data
Dashboards, Looks, Visualizations— it all happens here
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?
Note: for Looker-hosted instances, this option will only work if the table takes less than 1 hour to rebuild (due to browser timeouts). When you query data from a persistent derived table in Explore, there will be an option in the gear dropdown in the upper right to Rebuild Derived Tables. Clicking this will cause all the persistent derived table(s) referenced in the query to immediately rebuild, as well as all PDTs that those PDTs depend on to rebuild. Another way to look at it is that clicking Rebuild Derived Tables ensures that this query will be run with all the freshest possible data. Note: Clicking Rebuild Derived Tables will cause the PDTs referenced in the Look to be inaccessible for only the user who clicked the button while they rebuild. While they are building, all other users will be able to query the already-built tables. Once the tables finish rebuilding, all users will be querying these new tables
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.
Is there a way to do in a Look what the following does in SQL? select if( c in ('Anchorage','Fairbanks','Juneau'),-- that is, the c column has one of those values -- then c, -- else 'Other' ) as city, count(*) -- or another aggregate function from t group by city; This groups not by the column in the table itself but by that same column with some values combined into one.
If you have just had an account set up on your Looker, you will receive a setup email with a link to finish setting up your account. When you click this link, it may take you to a login page (rather than a page prompting you to finish setting up your account). This is happening because LDAP or SAML is enabled on your Looker instance. These services allow users to log in using a common username and password across multiple sites. If you know what your common username/password are, log in with those credentials! If you are unsure what those credentials are, talk to an administrator for your Looker. They will be able to point you in the right direction.
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.
I am trying to add a statistical significance calculation to my table using table calculations in looker. I have got to a z-score using the standard functions available but cannot find a way to turn this into a p-value. Is there something like the normdist function found in excel and R that I can use in looker, or is this something that may be coming in the future?
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", "
Do you have a version of AdBlock installed on your browser? We have come across some versions of AdBlock occasionally not allowing users to access certain models or explores that have “ad” in the name. You can test whether this might be the problem by running the query in Incognito mode, or in a different browser. If you whitelist looker.com in your AdBlock extension, this should prevent this from happening again. For more information on how to whitelist domains in AdBlocker, checkout this YouTube how-to video.
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.