Exploring & curating data
Dashboards, Looks, Visualizations— it all happens here
Hi there, I have created a custom drop-down list (using CASE WHEN formula) which groups campaigns together based on the country where they are present. However, now I would like to create a custom statement for each selection of such: e.g. IF the selection of drop down = US then take the clicks (only from the US campaigns) and multiply them by static (custom) click to sale ratio (e.g. 1.5%) and further multiply this by constant sales value (e.g. 2000 USD) and subsequently discounting the cost of these campaigns. I would like to do this for each selection of the country drop down list so when I change the selection the new calculation that reflects in the graph uses values related to the group of campaigns (i.e. clicks and cost for US only as well as the constants – i.e. 1.5% & 2000 USD that are defined for the given region). What would be the best way to achieve this? So far I seem to be hitting ‘complexity limits’ and getting the error message which mentions that metrics cannot b
Hello Does anyone know if it’s possible to only show certain tiles in a dashboard based on user attributes? For example, let’s say there are two graphs in a dashboard. User 1 can view both, but it is possible that User 2 can only see one of them, with the other tile being hidden? Thank you
Hi all, does anyone know how can I create table like this in Looker Studio?I can’t see these fields, when I connect Universal Analytics property to Looker Studio. However I saw this kind of table in Looker Studio somewhere online, so it’s possible to create.. I just don’t know how to create it
I’ve been searching around and can’t find an answer. Hoping to get some help here. I am trying to create a dynamic precent total table calculation where the denominator stays the same but the numerator can be changed with filters in a dashboard. For example. I want my stakeholders to be able to understand how much of revenue comes from one customer in a state of all revenue made. lets say we have $100,000 in total revenue and I want to know how much of customer A in Texas. A sample table is below to make more sense.State Customer Revenue TX A $50K CA A $10K TX B $20K NY B $20K With the scenario above I want them to be able to filter a dashboard to see the followingState Customer Customer Revenue Total Revenue % of Total Revenue TX A $50K $100K 50% Basically I’m struggling with the “Total Revenue” being ignored by other filters. Ideally I would like the filter that can effect the “Total Revenue” is a date range. Any help would be greatl
I have a line chart with a count of months on the x-axis and a cumulative count custom measure of some metric on the y-axis. There are a number of lines on the chart as a result of a pivot, each one representing a person. I’d like to add a line representing the average of all the other lines, that is dynamic - i.e. if the chart is filtered, the average will change. Is it possible to do this?
Hi all, I am pretty confident in Looker, but I wanted to see if there is a better way of doing this. When I have a bar chart that is pivoting on another dimension, I almost always need the stacks to be ordered descending, however, the default behaviour in Looker is to sort based on the values within that particular date. This means that the stacked elements jump around a lot and makes it hard to see consistent change. So my only options are either to have default sort and the stacks are not organised by volume at all:Or to have them stacked by volume and then the stacks can look chaotic:I know that there is a “hackaround” using derived ranking tables, but doing this for every chart and every view is a pain in the butt. I really feel like this is relatively simple and should be a chart setting, not something that requires building and joining yet another view (too many solutions to simple problems require a new view, which overcomplicates models, in my humble opinion, so I would like to
I have a requirement where I want to freeze the headers of my table (report) visualization ,as after a certain amount of data scroll I can’t see the headers and just able to see the data . I didn’t found any option to achieve that , Please let me know if there is any way to resolve this.
I have 6 looks in dashbaord and users want it to be delivered as pdf file. Now the height of the looks in dashboard can change based on number of rows/content wrap. Pdf export only displays visible rows not the complete look. Is there anyway to expand the height for the looks as fit to content so it always displays all rows without scroll bar?
I have a table visualization which is connected with different filters. When I apply a certain filter one of the column gives out only Null values in it.So is there a way my table viz could automatically hide that column when a filter is applied.For Example:Consider my table A:ID || Type || Value 1 A 102 B NULL3 B NULL4 A 15 If I filter this on type = “B”I will get this result ID || Type || Value 2 B NULL3 B NULL In this case I want to hide the value column.Is it possible in Looker ?
I created an explore to query system__activity-history to query look’s execution: model: system__activity view: history fields: history.source, look.id, look.title, history.created_time filters: history.created_date: last 30 days, history.source: look The problem is: why is the look data (id and title) returning nulls? The results source is always ‘look’ I’m running active Looks using Looker web interface, no apis, pure simple Look on Looker site I even saved this system__activity explore as a Look, and it will be listed as an execution, but look data is null as well Is the Look data stored in the system__activity unreliable? Even using very basic operations, the Look data is not being stored/shown
I regularly download data from a Look (Excel format, With visualization options applied, Formatted, All Results).In the last few days, rather than the expected data, this message is provided in the spreadsheet: Refusing to run query with no limit that Looker cannot stream incrementally. Please choose a smaller limit or remove table calculations.I’ve decreased the Row Limit from 500 to 250 to 100 to 25 to 24 (the exact number of data rows for a particular download), and still receive this message. Another data set had just one data row, and with a Row Limit of 1, still garnered this message.Is anyone else having this issue? What is occurring, and how do I fix it?Thank you!
Hello. I want to build a dashboard on looker to keep track of my SEO impressions, users, (etc.) by languages. My website is built like this:xxx.com/ => FR urlsxxx.com/en => EN urls (the homepage is .com/en and the other pages are .com/en/...)I would like to know what kind of filters or whatever should I use to create separate dashboards based on the URL structure (.com/ and .com/en), using different types of data (GSC, Analytics). I am sure there are formulas available however I can’t find themFor instance if I want to create a dashboard to keep track of SEO impressions I will select:data source: search console dimension: year month metric: for instance “impressions”And then create separate dashboards:one filtered on URLs starting with “xxx.com/” without the URLs starting with “xxx.com/en” one filtered on URLs starting with “xxx.com/en”Thanks
Hi I am trying to create a single table in looker where some of the measures are adjusted with a page date filter and some measures in same table are not. is that possible?Page date filter would be “Month to day”. example table Area Invoiced Revenue Invoiced revenue last 5 days East 100 30 West 150 70 if i then change date filter on page to “yesterday”Then invoiced revenue changes but invoiced revenue last 5 days is still the same One way i can think of fixing this now is to have this in two tables, where date filter affect on but not the other. I do not find that to give a good user experience from and overview perspective and then you would not be able to sort on column and see effect on the otherOther option is to have a merge query where date filter does not apply to one of the merge, but as i understand i should always try to avoid merge querys Any good ideas ?all help is much appreciated.
Hi,I’m using visualization and I have an issue with some products which are hidden some days because there were no sales.As example, I’m selling 10 products, if one day only 5 of them have been sold, visualization is hidden the 5 remaining products.How can I always display all products in visualization table even if there was no sales?Currently, the only situation when all products are displayed is that when all of them had at least one sale.I’m using sum_price and count products as measures.Many thanks for your help?
Can't fill in missing dates on merged table because: "Missing values can only be added for queries with one dimension"
Is there no way to fill in missing dates on an explore before merging when I want to picot by another dimension after the merge? I am reporting on a metric that can exist on three different tables in looker. I need to sum all three to get the accurate number and pivot by country. The issue I am running into is that when I want to only look at countries with low values in this metric data will be skipped because the individual pre-merge queries cannot fill in missing dates when the country field is present.I have a workaround where I include a country with high amounts of this metric to make sure no dates are missing but I don't like including USA data in a report for Eastern Europe. I can of course have that USA data in another query and hide all results of it but the more queries are merged the slower the dashboard becomes.Is there no way around this? If not I will have to ask for an explore called “Merge Correct” where there is a value of 1 for every date for all of my merges an
How can I get a table where I can see the country code, the count of accounts created and the standard deviation, 75th percentile, 25th percentile by country? I have been trying to do it but I can´t for the life of me get how to do it. I have tried creating measures on LookML but they didn’t work.
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.