Exploring & curating data
Dashboards, Looks, Visualizations— it all happens here
I'm trying to create a filter for my dashboard. I need the filter to be able to evaluate to more than one condition.For example, my logic can look like the following: casewhen account_age < 1 then 'populate new accounts'when account_health = 'red' then 'populate unhealthy accounts' ...end So in the case where an account is new and unhealthy...I'm running into problems. The filter will only evaluate to the first match.Meaning if the account is new, it will just populate when someone selects populate new account and will not appear when someone selects populate unhealthy accounts. How can I create a filter that can evaluate to more than one criterion when selected? So in this case, I want the account to appear when populate new accountis selected but also populate when you select: populate unhealthy account
In my dashboard which contains metrics using multiple explores. It is having two date filters. I have made these filter parameters as liquid parameter. When I apply these filters on single tile it works fine and I get exact number of records that are expected. But In dashboard it works differently and now my number of records are less than expected.Is it happening because of using multiple explores?I’m a bit confused here.
name ID MBS Count of MBS smith 123 60504 1 smith 123 60505 2 Jones 124 60504 1 moving reports from Oracle Bi to looker and a bit stuck as to how to achieve a table with the count dimension as above - each ID can have many MBS and need a running total or count by ID only. In oracle Bi i can just create a dimension to count MBS by ID - is there a way to achieve this in looker? thanks
Hey everyone,I’m experiencing the same issue reported in this thread, but I see the thread was close, without any further feedback from Looker.Can someone tell us if this is a bug, will it be solved? Because the thread is from 8 months ago, and today I’m having this issue, so no clue on what it’s next.
Ladies and Gentlemen, does it happen to you that the data from system__activity explore seem quite inconsistent?Well, in my company’s case, we are tracking the weekly embedded users that are querying Looker dashboards, and then, the strangest thing happens. When we took the history data using “completed date” and “user count”, we found on day 1 that, on week 40, we had 50 active users. Then, we checked this data again on day 2, it says we had 57 active users on week 40. This is quite weird since we didn’t make changes to the users. The historical data seemed to be overwritten. Then, on day 3, we saw that the number of active users we had on week 40 was “actually” 35. Ok, we screenshot that number and wait for day 4 to come. On day 4, as expected, the number change to something else again.We are quite surprised to see that the history data keeps changing everyday. It becomes impossible to understand how many users are using our embedded dashboards. We lost track of our business and cann
Hi guys, I’ve got this issue with dashboard drill throughs which I’m not sure how to solve. On a large screen the bar chart appears fine with an icon to drill through to another dashboard. However once you squish bar chart (i.e on a smaller screen) then the X axis is displayed on a 45 degree angle and the icon disappears. Is there a known way around this? Thanks in advance
Hello, I’ve to show data on a map with a 96 hour history shown by an interactive slider. When you scroll the slider from left to right the data on the map changes. Is there functionality in looker to do this? I’m new to this so seeking some help advice from the community.see picture below
We’ve got our data lake stored in S3 and we query it via Looker connected to Athena. Due to the runtime of queries, we have an issue where filter suggestions don’t populate. I’m curious how people get a nice filtered list of filter suggestions in situations like this. Do you use PDTs? Something else? We can’t just make a list as we need users to only see suggestions available to them.
If I add a measure filter that can be NULL then the HAVING clause that contains it is not wrapper in COALESCE(<measure>, 0) > 5 and NULL > 5 will return false of course. Technically, it should be up to me to make it numerical though in this case I would prefer to leave NULL (it has a different meaning than 0). Not necessarily a bug but I wonder what patterns people use in this case. As a workaround I will use table calculation with sum(pivot_row())
Hi,I was wondering if it is possible to utilize templated filters by creating a parameter at the explore level. For my use case, a value needs to be set by the user, and that value will affect derived sql across all views being joined in the explore. Currently, if I want to achieve this, it seems like I would have to create a parameter in each individual view and set its value repeatedly despite the value being the same across all views. My thought process is that if the parameter could be created in the explore instead, then each view could pull its value down, and the parameter would only have to be set once.If this is not an option, are there any workarounds for this use case? Thanks!
I have a project I am working on where I need to be able to use a custom field as the series, or the dimension that we care about, versus the date and we want to see the total revenue. The custom field is a concatenation of dimensions that are in separate dimensional tables in our snowflake schema database, so the SQL would look something like SELECT m.date , concat(a.first,b.second) as cust_dim , sum(revenue) from main_table m left join dimension_table_1 a on <key> left join dimension_table_2 b on <key>This obviously isnt the SQL looker generates. For a line graph to work, I have to pivot on the cust_dim. This cannot happen because looker writes a query that fails if I only have the cust_dim in the look. If I include the first and second parts in the look, it works to pull the data, but it fails to be functional as I cannot hide dimensions that are in a pivoted position and if they aren’t in a pivoted position I end up with the least useful result,
I want to use a pivot and add some measures ignoring the pivot column. I have data something similar to below. Department OrderID OrderTotal ItemsSold Quantity Cost Dept1 Order1 600 Item1 6 100 Dept1 Order2 400 Item2 8 50 Dept2 Order3 1200 item2 4 300 Dept2 Order4 300 item3 5 60 In the above example i have three metrics. I need to create a data report similar to below. Item1 Item2 Item3 Department SalesPerDepartment Cost Quantity Cost Quantity Cost Quantity Dept1 1000 100 6 50 8 Dept2 1500 300 4 60 5 Sales need to be aggregated per department and cost and quantity need to be shown at item level in a same view. If i take all there three metrics and pivot on Itemsold, I can see the three metrics at item and department level, but i want to bypass item level aggregation for sales and show only at Department level. To achieve this i might have to create a custom dimensi
Hi, Could someone help me to list out a specific data source (like Denodo) objects from Looker? Suppose I have a Denodo DataSource and I want to find out all the views or derived views that are based on Denodo Objects. Is there an automated way to get it done? Thanks, Abbas
ContextI am interested in installing the radial gauge visualization (link) from the marketplace. QuestionHow can I be sure whether this new application is transferring my data to third parties in order to generate the result? Thank you
Hi all!I am a real newbie when it comes to Looker, so I’m hoping someone can point me in the right direction.I noticed that one of my Facebook campaigns has lower cost data in the FB ads platform than it does in Looker. Only this one campaign is affected, out of hundreds. How can I go about trying to work out why this is? Looker seems to have added an extra 40% to the cost, in the same timeframe. I’m really scratching my head over this one!
I am building a Custom Vis using the custom_visualizations_v2.I am trying to retrieve a list of current filters applied to my query.The queryResponse Param is where I thought this should be. There was some filtering Meta-Data but it all said null. also there was array of field objects under fields key in queryResponse. it has an is_filter param but it always says false even when I think it should be trueRecap. If I am running my custom vis, and apply a filter in the Explore UI. How can I identify a filter in my custom vis code?
Hi all, I’m creating different Period-over-Period custom calculations and I was wondering why it doesn’t add and shows a total % of increase/decrease. Might it be because some values are null? If this is the case, any suggestions that could allow to show the % total of the specific period? See an image below:At the bottom I’ve highlighted the missing total that I would like to have, in order to have an overall idea if we are growing or not
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.