Looker Connect Training
Help Center
Documentation
Community
Cloud Certifications
Hi, I have a hack that might help here. But please note the code is a bit ugly… Here is what I think you are trying to get to, measure by measure pivoted on a dimension. Basically the problem is that you need to plot a measure on a dimension in a scatter graph if you are pivoting. So this dataset I am using here has a grouping, distance and a duration for each id. I want to plot distance by duration pivoted on grouping. The solution requires me simply to plot distance (as a dimension) by duration (as a measure, sum is fine). However when doing this, we run into the problem that the distance could have duplications. To get around this, I have a new dimension called distance_for_scatter, where I simply add 0.0000001*row_number which will guarantee that the distances will ALWAYS be unique. (obviously add enough zeros!). Then you can change the value_format_name to something less horrific like decimal_2, and it plots nicely! dimension: distance_for_scatter { type: number sql: ${distance}
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.
