Looker Connect Training
Help Center
Documentation
Community
Cloud Certifications
New user? Click here to get started in the Community.
Learn about our awesome events
Level up your knowledge with Looker's training hub
Find others interested in the same topics as you.
Get the latest news about Looker & the Community
A collection of Looker knowledge for you to explore
I’m trying to replicate a COUNTIFS function in Looker, and cannot figure it out for the life of me. The COUNTIFS works in Sheets but I’m not familiar enough with Looker functions to translate it so hoping someone can help. The COUNTIFS is simply =COUNTIFS(criteria_range-1,criterion-1,criteria-range-2,criterion-2). The criterion themselves are cell references in this instance, as the result I am looking for is a count of how many lines of data match these two criterion within the data set. The actual formula is =COUNTIFS($A$1:$A,A1,$B$1:$B,B1), and the criterion obviously changes to A2, A3 etc depending on the row number. Can this be done in custom calculations in Looker? Thanks in advance for any help!
Howdy,Bit of an odd one. I run a bunch of dashboards in Looker and I’ve never seen this problem before. Can’t find anything that looks like it on the forums either, so apologies if this has already been covered.So say I have a standard dashboard that populates as normal - once the data and visualizations have finished loaded, the “Stop” button cannot be clicked. It just remains as a red “Stop” the whole time.If I change the filters, I can’t click “Run” on the dashboard, I have to reload the page before the filters take effect. Once I refresh, the filters will have started working and the dashboard will load normally, but the “Stop” button remains.I know the issue is specific to this dashboard. My dashboards and models are discrete, so I can plug any data source into any dashboard and it operates as expected. All models interfacing with all other dashboards work as expected.I’m a bit stumped. If anyone knows a potential solution to this issue or where I should look, it would be greatly
I would like to change the naming of labels for bin intervals for readability:I can’t figure out any way to do it, not in the visualisation section either. Would appreciate any tips :)
Hi,I’d like to draw two series of sells over time :sales of group of customer (a WHERE) a specific customer sales (another WHERE)So far the best solution I found is to create a view with a derived_table :view: union_customer_sales_a_b { derived_table: { sql: SELECT "A" AS selection, sales_a.date, sales_a.sell_price FROM `customer_sales` AS sales WHERE {% condition customer_a %} sales_a.customer_id {% endcondition %} UNION ALL SELECT "B" AS selection, sales_b.date, sales_b.sell_price FROM `customer_sales` AS sales WHERE {% condition customer_b %} sales_b.customer_id {% endcondition %};; } parameter: customer_a { type: unquoted } parameter: customer_b { type: unquoted } dimension_group: date { type: time timeframes: [ date, week, month, quarter, year ] datatype: datetime sql: ${TABLE}.date ;; }
if(is_null(${orders.need_by_date}),diff_days(${orders.created_date},${receipts.receipt_created_date}),diff_days(${orders.need_by_date},${receipts.receipt_created_date}))
I have a column that shows sales and I have a column that shows sales date. I am trying to create a filter that allows me to filter the sales column for two weeks ago. I was trying to create a custom filter on the field using syntax like DATE_SUB(DATE_TRUNC(CURRENT_DATE(),week), INTERVAL 1 Week) > ${Transaction_date}and DATE_SUB(DATE_TRUNC(CURRENT_DATE(),week), INTERVAL 2 Week) <= ${Transaction_date}Every time I try this I get an expression incomplete error. Any suggestions would be greatly appreciated!
Attempting to create an average of a MONDAY over 4 weeks So AMOUNT 1, AMOUNT 2, AMOUNT 3, AMOUNT 4, FOR DAY / 4 But It seems to just average everything -This is the measuer - mean(${payments.amount})
Hi All, Is it possible to toggle two different Looks on a Looker Dashboard. Scenario - I have two parameters called Closed and Resolved as a dropdownWhen i Select Closed value - corresponding Visual with Closed should come and in the same way with Resolved data visual should come on same place on the dashboard.
Pivot by Top 10 You’ve got a high cardinality dimension and you’d love to just see the Top 10 based on some measure. In our sample data, that’s the Product’s Item Name; and you’d love to see the Top 10 of your best performing items. Now that Top 10 list frequently changes, plus it would be nice to filter it down by other fields in my explore. If you’re familiar with templated filters in a derived table or with bind_filters in a native derived table, you might have done a version of this, but upkeep of those bind_filters and templated filters are burdensome every time your model changes. But in Looker 6.20, you can use bind_filters_all: yes to make sure you’re ALWAYS filtering down to the exact right top 10 based on what question is being asked. Here’s a quick example: Introducing bind_all_filters for native derived tables. bind_all_filters: yes will listen to every filter in the explore and apply it into your native derived table. Want to see the Top 10 items in the Accessories Catego
I have a row of data with some null values, I just want to count the times that the value is not null. Is there a way to do that easily without writing out a large string?
I have two tables : `groups` and `messages`. To keep it simple let’s consider this :I am able to create two series showing : the number of total groups over time (thanks to a running_total measure) and the number of messages created (with a simple count). What I’d like is to have those two series on the same plot. I created an explore joining the two views. I’m confused because I don’t know if this is possible on the first place. While it visually looks similar, values are not the same. Should it be possible to make it work ? Is there a looker feature I’m missing here ?
Already have an account? Login
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.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
