Looker Connect Training
Help Center
Documentation
Community
Cloud Certifications
My use case is to analyze which views/tables are least used. I have made a visual in which I have shown view name and their usage time in descending order but some of the lest used views are already deleted. So I want this analysis to be done which are not deleted.
How can we create a dashboard which can give us insight about looker content used by user/team/depts and what should be the metrices that can give us this insight??
Hi All,Is anyone have idea of how we can consolidate all the alerts of single dashboard into one.
How can I use alert to notify me when there is no data in the table??
WITH last_run AS ( SELECT max(date_run) as last_run_date FROM analytics_s.firm_stats ), Transaction_sum AS ( SELECT sum(Transactions) as TransactionMonthly, month(date_run) as Month, year(date_run) as Year from analytics_s.firm_stats group by 2,3 ) SELECT fs.*,t.TransactionMonthly,t.Month || t.Year as distinct_key FROM analytics_s.firm_stats fs LEFT OUTER JOIN last_run left outer join Transaction_sum t on t.month = month(fs.date_run) and t.year = year(fs.date_run)The dimension and measure in which I am getting error : dimension: TransactionMonthly { type: number sql: ${TABLE}."TransactionMonthly";; } measure: Transactions { type : sum_distinct sql_distinct_key: ${TABLE}."distinct_key" ;; sql: ${TABLE}."TransactionMonthly";; label : "$ Transaction" }
Hi ,I want to create an alert when I notice any NULL value in my look. Can anyone have any idea about this??
Hello,I am trying to create an alert on my tile which contain a single percentage value on the basis of two rows of data (3rd and 4th day before), which contain one table calculation of "% Change from previous value". The tile is only showing the percentage change on which I want to check if that value is >=10 then I want to create an alert But getting error "Error: Your alert could not be saved."
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.
