Looker Connect Training
Help Center
Documentation
Community
Cloud Certifications
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!
Hello all, I was wondering how can I have a % difference between a metric shown on data range Y vs the prior data range. Ex. Spend of the last 7 days vs Spend of previous 7 daysDate Filter: Last 7 DaysName: ABC ; Spend Last 7 Days: 100$ ; Spend prior 7 days (8 - 14 days): 120$ ; % Diff: -16% Thanks
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.