Dashboards & looks
Building reports & visualizations in Looker
- 1,918 Topics
- 4,348 Replies
How to do year-over-year line chart visualizations on a daily grain?
Hi all, We’re transitioning from an analytics platform where people would commonly create line charts to compare year-over-year data on a daily grain for multiple months, or even entire years. (So, for example, one might chart daily activity for the past 3 months, and then compare that to the same 3 months from the prior year.) I’m having a bit of trouble reproducing this elegantly in Looker; it’s simple enough for a single month, but it’s more complicated with 2 or more months. I can pivot on the year to create a year data series for a given measure, but since Looker will only accept one date dimension beyond that, the options for creating a visual that contains both month of year AND day of month on the x-axis seem limited. I’ve got a “Month-Day” dimension that extracts those parts of the date, but because this is a string, the x-axis on my line chart gets rather messy – even when looking at just 3 months and with “Value Density” cranked all the way to the lowest setting (see attache
Show percent_of_total and count in the same chart bar
Hello, i have a chart that displays a count of users grouped by range of ages. The chart is displaying correctly, showing in the chart, one bar for each different age interval and displaying the count measure. Is it possible to show the percent_of_total when the users hovers each bar? Right now is only displaying the count value, but i’d like to add the % of total also without adding a new column. For example, if total is 100, i’m showing 3 bars with the next values “Age < 10” : 25 users “Age 10-20”: 40 users “Age > 30”: 35 users i’d want to show something like this “Age < 10” : 25 users (25% of total) “Age 10-20”: 40 users (40% of total) “Age > 30”: 35 users (35% of total) Is it possible to do something like this? Thanks
Add HTML to dashboards
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!
Aggregate table for visualisation?
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!
Who is using custom visualizations?
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…
Retiring Old Dashboards
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 😄
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
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?
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?
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.
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.
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", "
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?
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.