Got a question?
Ask your big data questions here.
- 82 Topics
- 195 Replies
Hello Community! I am currently trying to compare launch periods of products and campaigns, however these are not launched within the same time frame each year. Instead, each campaign/product is launched at a different date, but I need to compare the first days, weeks, months, etc. after launch for each product with each other. As an example:Product A: launch in December 2020Product B: launch in May 2022 I need to compare those 2 launches, even with them having different launch dates, but need to measure and compare the first days, weeks, months, etc. after launch for each product with each other. How do I make sure that if we launch Product A in December 2020 and we relaunch a similar product of nature in May 2022 as Product B, that Looker will take the initial weeks and days of launch? Any help on what needs to be setup to make sure this is reflected would be greatly appreciated. Thanks!
Is it possible to specify the default delimiter in a CSV export, or are we restricted to using a comma?This is causing issues for us when sending files to clients in countries that use the comma as a decimal point as well as those who would prefer a pipe delimited file.
Hi,I have 2 numerical dimensions which I want to plot as x and y, and a categorical dimension as pivot and count as dot-size. I have converted one dimension to a table calculation to make them as X and Y and it works. I’m also able to use grid layout to make multiple smaller plots for each category.However when I try to make the same plot without any grid layout, I get an incompatible data error:“Unable to chart pivoted data when dimension has repeated values. This commonly happens when you create a query with a second dimension and hide that dimension from the chart.”What is the suggested solution here?I have seen this plot in looker documentation which is exactly what I need. What should be the data format to make such plot work?
Need to send a report to targeted people within the scheduled report email list WHERE the data has changed since the last scheduleFOR that specific person. SO using user attribute to filter through the list of emails, and if the report is different for that specific user, then send the report, If not don't send the report. Similar to an if else but for scheduled reports. Iterate through the list of recipients and send to the ones where the data has changed
I am trying to display a fixed value table calculation to an existing combination chart (column and line). I have created a fixed value table calculation (e.g. 0.005) and I get this error: “Unable to chart more than one dimension with one or more pivots.”The display variables are also table calculations so I thought adding a third table calculation would not be an issue.
Hi all,The main goal of my dashboard is to display how many accounts add an additional product by the end of a given year. For example, in 2021, let’s say there are 100 accounts that start the year with 1 product (and were still active at the end of the year), and by the end of the year, x accounts added 1 other product, or 2 products (and what are these products). Product 1: 10 districtsProduct 2: 5 districtsOther products etcI helped run salesforce reporting to put the data in google sheets and then created formulas with vlookups and countuniqueifs to see if by the end of the year, if that account has added any other products. I’m looking for advice on how to proceed with building this out in Looker. I played around with an existing explore but the thing that trips me up is how to define what is active by the end of a year and summing up the accounts, then making it dynamic so I could choose which year. Hope that makes sense and thank you in advance for the advice!
Hi everyone, I was creating a custom measure on Looker analytics.It was to be filtered based upon another custom dimension “Touchless”, which I had created:image919×421 21.1 KBAfter running it, the error message came up:“The Snowflake database encountered an error while running this query”.Believe the analytics have difficulty when I create a new custom field, that is filtered based on another custom field.Appreciate if anyone has a workaround around it.Thank you!
Hello, I’m trying to add a calculation to multiply values in 2 columns but the calculation is showing this error. I’m using the “Table Calculation” field under the “Custom Fields” section. I’m trying to add a 3rd column that multiples values in the “Bill Code Code” field and “Visit Unit Qty Sum” field. Is this possible?
Hello, The way we are currently using this integration, if an alert is made through Looker to push to Slack, Looker makes the alert as if the user is creating the message. As a result, the user does not get a notification that the system thinks the user made.Does anyone have any workarounds for this? Many thanks,
Hi Everyone, I would like to filter an existing dashboard for the previous date, and the filter should show the exact date. We send out a daily email report at the beginning of the day, and users would like to have the date for which the report is generated(Typically yesterday). Is this possible in looker? Thanks,-Ran
Hello, My case is very simple. How do I count the amount of times that X has Y without having it on my table?Example:My database is: Client Item Price X A 10 X B 5 X C 1 Y A 10 Y D 3 I want my final outcome to be:Client # Items above $4 X 2 Y 1 Thank you very much!
Hi, I built a visualization about "Top 5 countries with positive and negative change in road traffic death (rate per 100,000) between 2000 & 2019 based on data from WHO. I am polishing my skills by creating simple and advance visualizations like this one in short time and without any programming skill using visualization tool.My question is there a way to create like this or more advance visualization in Looker.Thanks.
I will preface this with I am new to Looker. I created a tile for my call center that shows the count of calls that come in, in 15 minute increments throughout the course of the day. However, this is only useful for a single day. What I want is to be able to set a range of days and see the amount of calls that come in, on average, in 15 minute increments throughout that period. Essentially, i’m looking to see what time of the day are our highest and lowest call volumes. If I select multiple days now, it gives me each day separately on the line graph, not an average of those days.
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.