Got a question?
Ask your big data questions here.
- 83 Topics
- 195 Replies
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!
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
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.
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.