Dashboards & looks
Building reports & visualizations in Looker
- 1,927 Topics
- 4,361 Replies
Saved report filtering out records
Hi Everyone, I am facing a weired concern, i have using a looker report and the report showing me a correct expected results in Edit mode as i have in my table but when came back in visualization then filtering out records which should not be happen when u didn’t use any filter to filter out any thing… Please help me out to rectify the issues . Regards Harsh
Stuck in Visualization of X Axis
I want X axis to be same like Y axis from 0% to 100%. I know as my X axis is a dimension it will show me the same fields in visualization. Dimension Org Percent showing 25% 5 times due to another dimension Alert Created Date. so if I try to remove that date dimension, it throws an error saying “column should be in group by clause or an aggregate function should be used”. How can I achieve only single count of 25% and 75% on X axis.
One Dimension, One Measure - Changing Colour of one of the Options in the chart
Hi All, I would like to have it so that I am able to change the colour of the middle option (Group Y) to another color, but as it is now it is in one dimension and one measure. I do not have access to lookml and I think there is a hack / work around with formulas… I’m just not sure how to do it! Any help would be much appreciated. Cheers, Janet
Bars overlapping issue in looker 6.6 bar chart
Hello, We recently moved to looker 6.6 from looker 5.14. But after that getting issue with the bar chart, Bars seem to be overlapped but in looker 5.14 we never face this issue. Please see the below image with looker 5.14. And image from looker 6.6. We are looking for a solution to this issue. Maybe we missed something. Any idea to fix this problem? Thank you.
Reference line label position issue in looker 6.6
Hi We are facing an issue in reference line label position after updating looker 5.14 to 6.6. The label is showing in the bottom, not in the top. In Looker 5.14 it was like this:- And in Looker 6.6 it is like this:- Is there any way to fix this issue? Thank you.
How we can show only the required data in visualization?
I created a look % of Alert Created by % of Org and wanted to hide the records with 0% from visualization. There are various Date Measures used in visualization, which when toggle shows the another date wise % of Alert. I don’t want to see 0% in my visualization and I want to have X axis format from 0% to 100%. For Eg:- In given Screenshot, for the highighted date I want to see just 75% org showing 44% of alert. Same with other Date when toggled.
Max columns for Timeline visualization
I’d like to use the Timeline visualization to show how many purchases are made by hour of day per day of week. Was trying to pivot the Day of Week, but apparently you can only have 5 columns in a Timeline visualization. What is the rationale for that? Is there a work around? Perhaps a better way to visualize what the data?
Data points missing
I produced a look that has probably about 2500 data points on a time series. I removed the 500 row limit and when I run the look everything is shown correctly. Then I save it and go to my dashboard and for some reason I can only see 500 data points. Anything I should change to get all the data?
How to assign table calculation column to right axis on graph
Hi All, I am having issue plotting line chart with the x axis and y axis from the columns I want. I am having a explore with two table (A and B) left joint together based on ‘as-of-date’ and ‘CBSA’ columns. I created a few derived columns with the following steps: ‘Median Value’ created based on median of a column in table A group by ‘as-of-date’ ‘Index A’ is created as a table calculation column based on top of ‘Median Value’ ‘Index B’ is created from a table calculation column based on a column ‘Hpi’ from table B the visualization table looks like: Now I want to plot line graph with ‘as-of-date’ as x-axis and compare two lines: Index A vs. Index B. however the line chart looks like this now: I am thinking what should I do to achieve something like: Could you please help me with it? Thank you!
Pressing ESC to hide table calculation window closes look
I have a dashboard that I need to edit. I click pencil icon on a look and make some changes. Then I go to a certain table calculation and the popup opens but I decide to not proceed. I press ESC and instead of the table calculation popup, the whole look is closed, losing all my previous changes
"Expand Tables" print option combined with custom visualizations containing tables
Data Fetch Mechanism on View and Look
Consider, a view has been built and has been scheduled for a one time refresh everyday at 6 am. Also, consider a look A1 (10 Dimensions and 10 Measures) is built on this view and a look A2 (2 Dimensions and a Measure - Kind of aggregated look on A1) is built on A1. When I edit and run the look A2 later for example at 10 am, the looker fetches data from the cached View or from A1.
Conditional Formatted Single Dimension Column Chart
Hi Community, I was wondering if there is a way to take a single dimension in looker and conditionally format to a specific choice or selection in looker. So if I have one dimension named “brand” and my measure is “recommend score” my data is set up like this: BRAND Recommend Score brand A 56% brand B 66% brand C 54% brand D 57% brand E 62% where i want to make the chart highlight brand C in a different color automatically, and if I were to select another brand (i.e. Brand A, B, D, or E) it would highlight in a third color. So eventually I may have a chart that looks like this: If there is a way you think I would need to set this up in the SQL portion / just in the visualization itself that would be much appreciated! Cheers
QoQ Line chart comparisons, stop line at current date
Hey guys, I’m wondering if you could help me out with something. So i have this quarter over quarter line chart comparison, which is great for quarters that have finished. But if I want to bring in current quarter for a live up to date status of current performance, it flat lines after today’s date or today. Ideally I that line would stop, and each day it would tick forward or up as time goes on. I’m pivoting by quarter, days of quarter on the x and I’m plotting a running total calculation of a ‘deal amount’ dimension. Has anyone executed something like this? Or does anyone have any thoughts on the matter? Much appreciated, Stuck
Dashboard filter showing white space where no data available
I have a dashboard set up to show data since the 1st of August. This applies to all of the views in the dashboard. One of the views only has data from the 1st of October, this means there is 2 months of white space in the graph I’d rather not have. Similarly, I’ve been asked to only show data from the 1st of January this year. Is there a way I can keep the dashboard filter applicable to that view, so if a user changes it to “The last 2 weeks” or similar it will affect that view. Or do I need to unlink that filter from the view to make sure the graph only starts on the 1st of October/January?
Reformatting month name for chart axis
Does anyone know a way to reformat a month name time dimension which is used as a chart axis so it’s displayed as Jan, Feb, Mar etc? This would be equivalent of using %b for Time Label Format, which I can’t do because the month name dimension is a string not a date, and I can’t want to use the full date as I’m pivoting on year for YoY comparison. I can add my own short month name dimension but thought I’d throw it out here in case anyone had a better idea.
Columns stacking together in Chart
I found a link to a waterfall report, and thought I’d give it a go. I’ve made a chart that easily shows all the transactions on an account with a clear visualisation of what the balance was after each transaction, with different colours to easily show payments/increases/etc. The trouble I have is occasionally an account will have multiple transactions at the exact same time. I already have the X axis set as “Ordinal”, since it either doesn’t work (Internal Chart Error) when there are duplications, or it looks terrible if the account had say 3 transactions in a week and then another 2 years later. So if the first two transactions in the table have the exact same time, I get a “Increase” column on my chart, which starts not at zero, but at a height of how tall it is. That’s the initial balance being loaded and 2 payments, the green bars are perfect where they are, but the black bar should be from 0 to 1695, and really there should be a second black bar to show another increase. There do
Creating Panel Chart Visualization
Hi All, I am looking to create Panel Charts (similar to Excel) in Looker. The idea is I want to visualize my data with either a vertical or horizontal separation as sometimes it is hard to read/define trends when you have more than 5 in a visualization. I want to end up with something like this or even better have it stacked in the opposite way (i.e. brand on the y axis layered with the score, then quarters on the x axis). If anyone knows of a way I can do this / if there is a better visualization to show multiple fields & how the data needs to be set up in Looker it would be much appreciated! Cheers, Janet
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.