looker / custom_visualizations_v2

THIS REPOSITORY HAS MOVED, PLEASE FIND THE NEW REPOSITORY HERE

---

A Note on Support

The visualizations provided in this repository are intended to serve as examples. Looker's support team does not troubleshoot issues relating to these example visualizations or your custom visualization code. Supported visualizations are downloadable through the Looker Marketplace.

---

Looker Visualization API Examples

Looker's Visualization API provides a simple JavaScript interface to creating powerful, customizable visualizations that seamlessly integrate into your data applications. 📊 📉 📈

Getting Started Guide →

Visualization API Reference →

View Examples Library →

Getting Started

1. Ensure you have Yarn installed.
2. Run yarn
3. 💥 start creating!

Commands

• yarn build - Compiles the code in /src to /dist via webpack
• yarn lint - Runs TSLint across the codebase.
• yarn lint-fix - Runs TSLint and attempts to fix any linter errors automatically.

---

custom_visualizations_v2's Issues

Liquid fill is blanked when it prints out in PDF

Creating the dashboard with Liquid fill, liquid fill which is placed in the bottom gets blanked when printing out in PDF.

In Dashboard -

In PDF -

Sankey vis example image may be misleading?

Hi there,

Just a quick note that the example image provided in this repo for the Sankey diagram may be misleading as it appears to show part of the flow terminating on certain nodes.

I have tried to recreate this effect with this visualisation without success. Is it possible?

If not, perhaps it would be a good idea to change this example image so that users would not expect this behaviour.

Thanks!

Highcharts boxplot viz only works when switching to another viz, than back to the boxplot viz

Tested on a Looker-hosted client instance with a custom viz license.

https://cdn.rawgit.com/llooker/agfaantwerp/6e412e27/highcharts_boxplot.js

Dependencies:
https://cdn.rawgit.com/llooker/agfaantwerp/2ce38438/highcharts.js
https://cdn.rawgit.com/llooker/agfaantwerp/2ce38438/utils.js

Subtotal viz does not bold the subtotals

link to the explore page

Percentages are summed when folded

The table calculations in the foldable tables always sum, but when using percentages - this doesn't make sense when some rows are folded. I'd rather be able skip the table calculation, to make sure the viz is correct.
Keep up the good work! Love these viz

Sort Sankey column order based on a dimension sort order

Customer wants to be able to sort any columns order based on the dimension's sort order. In the below screenshot, the first dimension order is 2018-11-26 > 2018-11-12 > 2018-10-19, however in the visualization, the order becomes 2018-11-26 > 2018-08-27 > 2018-11-12.

Can the custom visualization listen in on parent dashboard filters?

I have a case wherein i am fetching the data for rendering from a custom backend api. I need to update the custom visualization everytime the filters in the dashboard change.

Sunburst displaying NULL values

Sunburst visualization displays null values in the visualization, and includes "lay - null - null" etc. in the description of the layer sections, resulting in each layer always being a full 360º

Remove horizontal and vertical scroll bars

Hi!

Would be great to fit the viz to the entire frame, without having horizontal and vertical scroll bars.

Thanks!

Subtotal Viz Shows incorrect cached values from old filter

I can only reproduce this on a dashboard, so far.
Steps:

1. Filter on value "foo" in the dashboard, which correctly updates the subtotal tile.
2. Filter on value "bar" in the dashboard, which correctly updates the subtotal tile.
3. Filter on value "foo" in the dashboard. Notice that every other tile updates correctly, but the subtotal tile still shows "bar".

Apply LookML formulas to subtotals custom vis aggregation

Toast would like for formulas written in a measure's sql parameter to apply to the subtotals custom visualization aggregation, similar to how the vis determines aggregation type (average, sum, etc.) based on the measure type.

For example, say we have a measure that's a calculation of two other measures:

measure: per_user_sale_price {
    type: number
    sql: ${average_sale_price}/${count} ;;
  }

When this field is aggregated in the subtotals table the formula should be applied to the total, as opposed to making this a sum of the rows.

Also on Analytics.

Collapsible Tree Custom Viz JS Errors

Testing out the new custom viz, I have them all loading except for the Collapsible Tree, which shows this error. @nickfogler can you guys take a look at this please when you have a chance? Thanks!

https://saleseng.dev.looker.com/explore/thelook/order_items?qid=fGRWq6oUdXf7mltLvg2gRi&origin_space=1&toggle=vis

Uncaught TypeError: Cannot read property 'color_empty' of undefined
at Object.create (looker-custom-viz-a.lookercdn.com/master/collapsible_tree.js:1)
at t. (collapsible_tree_block:12)
at collapsible_tree_block:18
3looker-custom-viz-a.lookercdn.com/master/collapsible_tree.js:1 Uncaught TypeError: Cannot read property 'html' of undefined
at Object.update (looker-custom-viz-a.lookercdn.com/master/collapsible_tree.js:1)
at t. (collapsible_tree_block:12)
at collapsible_tree_block:18
2looker-custom-viz-a.lookercdn.com/master/collapsible_tree.js:1 Uncaught TypeError: Cannot read property 'html' of undefined
at Object.update (looker-custom-viz-a.lookercdn.com/master/collapsible_tree.js:1)
at t. (collapsible_tree_block:12)
at collapsible_tree_block:18
update @ looker-custom-viz-a.lookercdn.com/master/collapsible_tree.js:1
(anonymous) @ collapsible_tree_block:12
(anonymous) @ collapsible_tree_block:18
2looker-custom-viz-a.lookercdn.com/master/collapsible_tree.js:1 Uncaught TypeError: Cannot read property 'html' of undefined
at Object.update (looker-custom-viz-a.lookercdn.com/master/collapsible_tree.js:1)
at t. (collapsible_tree_block:12)
at collapsible_tree_block:18
collapsible_tree.js:1 Uncaught TypeError: Cannot read property 'html' of undefined
at Object.update (collapsible_tree.js:1)
at t. (collapsible_tree_block:12)
at collapsible_tree_block:18
update @ collapsible_tree.js:1
(anonymous) @ collapsible_tree_block:12
(anonymous) @ collapsible_tree_block:18
collapsible_tree.js:1 Uncaught TypeError: Cannot read property 'html' of undefined
at Object.update (collapsible_tree.js:1)
at t. (collapsible_tree_block:12)
at collapsible_tree_block:18

https://user-images.githubusercontent.com/8075115/41066664-83af05da-69da-11e8-8078-a2957852dbaf.png

Printing causes errors

Having just installed this great visualization, I tried to send a PDF report to the intended end-user.

Instead, it crashed on me:
`Error occurred while generating this dashboard - contact administrator (error: Render job 47f40e35a8d5a5cc1571fd54d4d09005[909] failed ["Target page generated a JavaScript error: Error: undefined is not a function (evaluating 't.iframe.sandbox.add(e)')\nhttps://static-a.lookercdn.com/5.20.11/webpack/main-8c449660a747626c2315.chunk.js:1:738982\nforEach@[native code]\ne@https://static-a.lookercdn.com/5.20.11/webpack/main-8c449660a747626c2315.chunk.js:1:738942\nbuild@https://static-a.lookercdn.com/5.20.11/webpack/main-8c449660a747626c2315.chunk.js:14:205019\ncreate@https://static-a.lookercdn.com/5.20.11/webpack/main-8c449660a747626c2315.chunk.js:50:746287\n_internalCreate@https://static-a.lookercdn.com/5.20.11/webpack/main-8c449660a747626c2315.chunk.js:1:1145944\nvalue@https://static-a.lookercdn.com/5.20.11/webpack/main-8c449660a747626c2315.chunk.js:50:1128302\nvalue@https://static-a.lookercdn.com/5.20.11/webpack/main-8c449660a747626c2315 .chunk.js:50:1127591\nhttps://static-b.lookercdn.com/5.20.11/webpack/vendor-chunk-293c95e502b06f3adf81.chunk.js:55:144751\ni@https://static-b.lookercdn.com/5.20.11/webpack/vendor-chunk-293c95e502b06f3adf81.chunk.js:55:933\nh@https://static-b.lookercdn.com/5.20.11/webpack/vendor-chunk-293c95e502b06f3adf81.chunk.js:55:113499\ns@https://static-b.lookercdn.com/5.20.11/webpack/vendor-chunk-293c95e502b06f3adf81.chunk.js:55:78840\nhttps://static-b.lookercdn.com/5.20.11/webpack/vendor-chunk-293c95e502b06f3adf81.chunk.js:55:78371\nhttps://static-b.lookercdn.com/5.20.11/webpack/vendor-chunk-293c95e502b06f3adf81.chunk.js:55:81144\ni@https://static-b.lookercdn.com/5.20.11/webpack/vendor-chunk-293c95e502b06f3adf81.chunk.js:55:79335\nf@https://static-b.lookercdn.com/5.20.11/webpack/vendor-chunk-293c95e502b06f3adf81.chunk.js:55:112478\nhttps://static-b.lookercdn.com/5.20.11/webpack/vendor-chunk-293c95e502b06f3adf81.chunk.js:55:146400\n$digest@https://static-b.lookercdn.com/5.20.11/webpack/ vendor-chunk-293c95e502b06f3adf81.chunk.js:55:213606\n$apply@https://static-b.lookercdn.com/5.20.11/webpack/vendor-chunk-293c95e502b06f3adf81.chunk.js:55:215116\nhttps://static-b.lookercdn.com/5.20.11/webpack/vendor-chunk-293c95e502b06f3adf81.chunk.js:55:82492\no@https://static-b.lookercdn.com/5.20.11/webpack/vendor-chunk-293c95e502b06f3adf81.chunk.js:55:20707\nhttps://static-b.lookercdn.com/5.20.11/webpack/vendor-chunk-293c95e502b06f3adf81.chunk.js:55:42829\nr@https://static-a.lookercdn.com/5.20.11/webpack/main-8c449660a747626c2315.chunk.js:14:297213 undefined"])

`

Euro signs disappear in foldable tables

Howdy!
When using monetary values in foldable tables, the formatting is lost. (prepended euro signs are lost).
keep up the good work, I love this viz

Sort order is lost in foldable tables for 3rd column with months

When using a foldable table with columns [category, year, month] I have my sorting done in the 'data' section. Unfortunately foldable tables loses my sort order, which is why I am getting strange month sorting in the 3rd column.
Keep up the good work on this viz, love it!

Examples page lacks links to all but Sankey chart

https://github.com/looker/custom_visualizations_v2/tree/master/src/examples

Unexpected effects from Gauge Viz in Marketplace

The Gauge visualization in the Marketplace have the following unexpected results:

1. It doesn't allow me to customize the format of the Measure at the Visualization level. The option to change the format exists, it should work like the rest of the Viz in Looker. When I change the default of "#,##0.00", to "0.0,,"M"", I get exponential notation as the value.
   (This effect is the same for other Marketplace viz as well - like Multiple Value)
2. When selected 10 segments in the Gauge, the division of the segments did not label correctly (duplicates of 100M and 200M) - see image below. This labeling is confusing and incorrect.
3. Changing out the Measures in the Gauge doesn't remove the Visualization options for the measure. I had measure A in the Gauge, then removed it and put in measure B. But when I opened up the Edit pane in the Visualization, both the options for measures A and B exists in the Values section.

Subtotals Visualization causes error in Looker when downloading to PDF or scheduling

Attempts to download dashboard containing subtotal viz type results in the following error:

Uh oh. "Target page generated a JavaScript error: Error: undefined is not a function (evaluating 't.iframe.sandbox.add(e)')\nhttps://static-a.lookercdn.com/5.18.13/webpack/main-f576b9502b01d6937166.chunk.js:1:1186790\nforEach@[native code]\ne@https://static-a.lookercdn.com/5.18.13/webpack/main-f576b9502b01d6937166.chunk.js:1:1186750\nbuild@https://static-a.lookercdn.com/5.18.13/webpack/main-f576b9502b01d6937166.chunk.js:14:212393\ncreate@https://static-a.lookercdn.com/5.18.13/webpack/main-f576b9502b01d6937166.chunk.js:50:766242\n_internalCreate@https://static-a.lookercdn.com/5.18.13/webpack/main-f576b9502b01d6937166.chunk.js:1:1814980\nvalue@https://static-a.lookercdn.com/5.18.13/webpack/main-f576b9502b01d6937166.chunk.js:50:1156818\nvalue@https://static-a.lookercdn.com/5.18.13/webpack/main-f576b9502b01d6937166.chunk.js:50:1155945\nhttps://static-a.lookercdn.com/5.18.13/webpack/vendor-chunk-84fab9765bb851a3b164.chunk.js:55:144751\ni@https://static-a.lookercdn.com/5.18.13/webpack/vendor-chunk-84fab9765bb851a3b164.chunk.js:55:933\nh@https://static-a.lookercdn.com/5.18.13/webpack/vendor-chunk-84fab9765bb851a3b164.chunk.js:55:113499\ns@https://static-a.lookercdn.com/5.18.13/webpack/vendor-chunk-84fab9765bb851a3b164.chunk.js:55:78840\nhttps://static-a.lookercdn.com/5.18.13/webpack/vendor-chunk-84fab9765bb851a3b164.chunk.js:55:78371\nhttps://static-a.lookercdn.com/5.18.13/webpack/vendor-chunk-84fab9765bb851a3b164.chunk.js:55:81144\ni@https://static-a.lookercdn.com/5.18.13/webpack/vendor-chunk-84fab9765bb851a3b164.chunk.js:55:79335\nf@https://static-a.lookercdn.com/5.18.13/webpack/vendor-chunk-84fab9765bb851a3b164.chunk.js:55:112478\nhttps://static-a.lookercdn.com/5.18.13/webpack/vendor-chunk-84fab9765bb851a3b164.chunk.js:55:146400\n$digest@https://static-a.lookercdn.com/5.18.13/webpack/vendor-chunk-84fab9765bb851a3b164.chunk.js:55:213606\n$apply@https://static-a.lookercdn.com/5.18.13/webpack/vendor-chunk-84fab9765bb851a3b164.chunk.js:55:215116\nhttps://static-a.lookercdn.com/5.18.13/webpack/vendor-chunk-84fab9765bb851a3b164.chunk.js:55:211336\no@https://static-a.lookercdn.com/5.18.13/webpack/vendor-chunk-84fab9765bb851a3b164.chunk.js:55:20707\nhttps://static-a.lookercdn.com/5.18.13/webpack/vendor-chunk-84fab9765bb851a3b164.chunk.js:55:42829\nr@https://static-a.lookercdn.com/5.18.13/webpack/main-f576b9502b01d6937166.chunk.js:14:301831 undefined"

To replicate:

1. Build Look using Subtotals visualization
2. Add to new dashboard
3. Click gear and download as PDF

Subtotal viz does not allow drill-downs

Drill-down links break/don't work in the subtotal visualization.

Sankey blank in IE11

Sankey won't render in IE11 - error in console is
SCRIPT1010: Expected identifier
sankey.js (1,292072)

Subtotal viz does not display HTML of a LookML field

If a LookML field has an HTML attribute defined, the HTML version doesn't show in the subtotal custom viz. The unformatted result displays instead.

In this example, Entry Week is formatted with HTML to display the last day of the week, rather than the first day of the week. This is lost in the custom viz.

Here is the LookML for Entry Week, showing the HTML attribute definition.

Tests failing due to incorrect jsdom config

Tests incorrectly utilize jsdom. Document, navigator, etc. not on global object.
I think we should migrate over to jest and bring in https://www.npmjs.com/package/jest-environment-jsdom-global

iFrame sandbox options

With custom visualizations being sandboxed via the sandbox iframe attribute, is there any hope of letting this be configurable? Adding allow-same-origin and/or allow-top-navigation would make interactions with the vizs much more powerful. AFAIK The way it currently is we can't even make use of Links on dimensions like the out of the box visualizations can.

subtotals custom viz renders weirdly

When using the subtotals custom viz, it downloads OK but it renders:

In the picture I see multiple rows and they add another per dimension, being this confusing for the business user.

`Plot Null values` toggle for Sankey

Hotelchamp wish to have the ability to toggle null values to OFF in the Sankey vis.

Could you please expand the #organizing-options in the API reference doc?

In particular, I can't find the documentation to:

1. Organize options in "sub-section" (e.g. Hide Legend and Legend Align, in native Line chart Looker visualization, have a nice "LEGEND---------" above them, making the options inside the Plot section tidier.
2. Make an option appear / disappear depending on a boolean option (e.g., once again the native Line chart, where if Hide Legend is toggled, then the Align Legend disappear).

Sankey will unexpectedly show a "1" next to the label names starting at the 11th dimension

Starting at the 11th dimension added to a sankey visualization, the vis will then add a "1" next to the label name of the dimension values (e.g. will show a label of 'Sweaters1' in the visualization but it appears as 'Sweaters' in the data panel for that dimension value).

The visualization is displayed as expected in terms of the dimensions added, flow, and the sizing based on the measure, but the labels are appearing with a "1" when we'd expect them not to starting at the 11th dimension.

Subtotal vis does not show calculated fields

Calculated fields do not show in custom visualizations. The visualization doesn't "break" - the calculation just doesn't appear.

When Liquid Fill Gauge has no data, it never stops running

When Liquid Fill Gauge on the dashboard has no data, it seems to be breaking. The dashboard keeps on running and Run button stuck as Stop.
The tile will be just blank.
Repro: https://master.dev.looker.com/dashboards/3516

If we convert to dashboard-next, the tile brings "No Result" and new Run button is not stuck: https://master.dev.looker.com/dashboards-next/3516

Expected behaviour: Liquid Fill Gauge query to be finished even when No Results and dashboard button to be back to Run.

subtotal viz breaks with "% of total" measure

If I include a "percent of total" measure, the subtotal visualization doesn't render:

in this case, the field that breaks it is:

Matrix visualization

Hi,

Is there the possibility to get back the matrix/heatmap visualozation back?
https://github.com/looker/visualization-api-examples/tree/master/examples/matrix

Subtotal CDN Link is inaccessible

It looks like the file is not publicly accessible. Link for reference:

https://looker-custom-viz-a.lookercdn.com/master/subtotal.js

Also, how in-sync are these files with what's currently within master? Is it based off of what is in the /dist folder or are they rebuilt based on the source each time there is a commit to master?

JS error for boxplot

When using the boxplot we get the following error

Uncaught ReferenceError: handleErrors is not defined 
at Object.update (highcharts_boxplot.js:52) 
at t.<anonymous> (highcharts_boxplot:12) 
at highcharts_boxplot:18 

and the visualization panel is empty.

Any ideas how we can fix this?

Color Palette isses (Sunburst, Sankey, Chord)

Link to the explore page

Link to the explore page

1. Create an explore with Sunburst, Sankey
2. Change the color palette and everything will go black
3. Choose a different color on one of the swatches and it will then display the correct colors

Chord acts a little differently - it doesn't go to black and will only display the correct colors upon switching color palette after you edit one of the swatches

Sankey Options change and then cause problems

Using the dist/sankey.js, works when I select the visualization. If I click on visualization options: at first I see that there are no options. If I re-run the query and check the options, I see that I can change color, but if I change color, the URL starts flipping through qid's and the browser window stops functioning.

Updating visualization options

Is there a way to update the options in a visualization after the query has been executed? Specifically I would like to create a select box of measures that are available to the visualization so the user can select one. I can get the values from queryResponse.fields.measures but not sure what to do with them. I am able to use the updateConfig trigger to change the value of the options, but not any of the other properties. What I am looking to create is very similar to the conditional formatting options in a table viz:

Table with subtotals: Header Row scrolls... freeze it to the page

When the table is expanded to where it is scrollable, scrolling down moves the header row off the page. Typical table/grid behavior is for this row to be frozen. any way to get that to work that way?

The Number type option cause error

When use option which type is number in vis and its display in 1st panel of edit window, the error message below is displayed. How can we get fixed?

Error: [ngModel:numfmt] Expected {"type":"number","label":"label","default":10,"min":5,"max":50,"display":"range"} to be a number

Bug in subtotals with Row Total

Hi there,

just reporting a bug I just found with subtotal:

• add a dimension
• pivot over some other dimension
• tick the Row Totals option

this leads to 2 columns being added to the visualization beyond the 'Total' column (see attached screenshot)

Thanks

Adam

Display: color

Is there a way to create a single color picker in the config UI? According to the docs, the display property can be color or colors, but only for array types. Taking the singular color display option seems odd for a type of array when we only want one. Seems like it should work for type string as well, and it almost does. With this config:

options: {
    color_range: {
        type: 'string',
         label: 'Start Color',
        display: 'color'
      }
}

The UI is rendered appropriately:

But clicking on the swatch to change it leads to an error in the console:

main-05bd04281f6c9f2ff1fe.chunk.js:14 Uncaught TypeError: e.toLowerCase is not a function
    at Object.setColor (vendor-chunk-01162e2105a91c8777b4.chunk.js:106)
    at O (vendor-chunk-01162e2105a91c8777b4.chunk.js:106)
    at HTMLDivElement.A (vendor-chunk-01162e2105a91c8777b4.chunk.js:106)
    at HTMLDivElement.dispatch (vendor-chunk-01162e2105a91c8777b4.chunk.js:37)
    at HTMLDivElement.v.handle (vendor-chunk-01162e2105a91c8777b4.chunk.js:37)
    at HTMLDivElement.r (main-05bd04281f6c9f2ff1fe.chunk.js:14)

Changing the type to array, gets this in the UI:

But the same error message in the console.

Add labels to Sankey

Hi,

Adding labels to the pre-aggregated values in a Sankey chart would be very useful.

For example:

In the attached snapshot - I wish to know what is the value for Illinois, for May.

Also - would be great to display these labels on the actual dashboard, not only in the tooltip.
Thanks a lot!

[Marketplace] Feedback for Gauge Visualization - Ability to specify a range/size for each segment

As Rashimi Ullikashi at Equiptmentshare, I would like to be able to specify a range for each segment in Gauge visualization so that, in the example below, I can make the green segment 0 - 18%, the yellow segment 18 - 20%, and the red segment everything above 20%.

Would it be possible to set the default behaviour of collapsing columns in subtotals

Hi there,

I was wondering whether it would be possible to allow users to change the default behaviour when it comes to collapsing columns?

My use case:
I have the following columns
category, continent, country, city

I would like to show the results aggregated at the category level when the dashboard loads. Then if a user wants to see the details for a country, they'd unfold that specific country.

I hope this is clear 😄

Thanks

Value Formats not being applied as expected in the Multiple Value Viz

Value Format : 0.000,," M"
Applied to Multiple Value Viz

.... and applied to a Single Value Viz

Treemap issue

Treemap does not seem to work. Not sure if the drill down functionality works?

I got the following error in the console.

Uncaught RangeError: toPrecision() argument must be between 1 and 100
at Number.toPrecision ()
at n.a (looker-custom-viz-a.lookercdn.com/master/treemap.js:1)
at x (looker-custom-viz-a.lookercdn.com/master/treemap.js:1)
at SVGGElement. (looker-custom-viz-a.lookercdn.com/master/treemap.js:1)
at SVGGElement. (looker-custom-viz-a.lookercdn.com/master/treemap.js:1)

Subtotal Visualization Feedback

Issue Summary

Options to edit visualization are occasionally missing (not on every explore load). Re-running query causes edit options to appear. Reloading the page causes the edit options to disappear again.

Link/Screenshots Of Issue:

Features Affected:
Visualizations

Issue Info

Steps:

1. Go to any explore in Meta
2. Create a Subtotal visualization
3. Check the visualization edit options
   a. If there are options, refresh the page until they disappear
   b. If the options are missing, re-run the query and they will disappear

Error Message:
No errors in the JS console

Customer Info

Client: metanew
Version: 5.17.00000628-231040
URL: https://meta.looker.com/explore/bq_salesforce/zendesk_tickets?qid=7e36dgnbE9JKaAaLCc1DW3&toggle=dat,fil,vis,vse
Development Mode: No
User: Emma Ware

Getting error 414 (Request-URI Too Large) when trying to save serialised data as config value

Hey,

I'm building a Kepler.gl custom visualization (see here: https://github.com/team-blaze/custom_visualizations_v2/tree/kepler/src/examples/kepler) and it's almost there, except for an issue with trying to save its config.

Kepler has a bunch of customisations you can do in its own UI and an API to save the config to then later re-apply on top of the data. Which is very neat as it would be possible to have Looker send it data and then people can tweak how it looks which would then be persisted in the Look using the config.

However the serialised config seems to be too large to be saved as a URL query parameter so I'm getting a 414 (Request-URI Too Large) error.

Do you happen to have a POST endpoint to send this to as request body rather than the GET one using query parameters implemented by the library (ie trigger("updateConfig", [xxx])? Or is there a workaround? The best one I could think of would be to decompose the object and serialise parts of it into different config parameters and then recompose it or maybe to compress the serialised string, but these aren't great.

To get an idea about the size, here's the offending URL below (with some potentially sensitive info scrubbed):

https://ping.looker.com/6.22.18/xxx/xxx/17/2388/custom_vis?uri=%2Fexplore%xxx%2Fjourney%3FFILTERED&ms_epoch=1575037228070&current_user_id=17&license_slug=xxx&browser_id=2388&looker_version=6.22.18&instance_slug=xxx&is_dev_mode=true&is_sudo=false&session_type=email&is_mobile=false&is_admin=true&query.fields.length=5&query.fill_fields.length=0&query.filters.length=3&query.filter_expression.exists=false&query.limit=100&query.pivots.length=0&query.query_timezone=Europe%2FLondon&query.sorts.length=1&query.subtotals.length=0&query.custom_dimensions.length=0&query.custom_measures.length=0&query.table_calculations.length=0&query.vis_config.latitude_column_strings.0=latitude&query.vis_config.latitude_column_strings.1=lat&query.vis_config.longitude_column_strings.0=longitude&query.vis_config.longitude_column_strings.1=lon&query.vis_config.longitude_column_strings.2=lng&query.vis_config.position_column_strings.0=pos&query.vis_config.position_column_strings.1=loc&query.vis_config.geojson_column_strings.0=geom&query.vis_config.geojson_column_strings.1=route&query.vis_config.gbfs_feeds.0=https%3A%2F%2Fxxx%2FBCP%2Fsystem_regions.json&query.vis_config.gbfs_feeds.1=https%3A%2F%2Fxxx%2FBCP%2Fstation_information.json&query.vis_config.gbfs_feeds.2=https%3A%2F%2Fxxx%2FHereford%2Fsystem_regions.json&query.vis_config.gbfs_feeds.3=https%3A%2F%2Fxxx%2FHereford%2Fstation_information.json&query.vis_config.gbfs_feeds.4=https%3A%2F%2Fxxx%2FLondon%2Fsystem_regions.json&query.vis_config.gbfs_feeds.5=https%3A%2F%2Fxxx%2FLondon%2Fstation_information.json&query.vis_config.type=Kepler_test&&query.vis_config.serialised_kepler_map_config=%7B%22version%22%3A%22v1%22%2C%22config%22%3A%7B%22visState%22%3A%7B%22filters%22%3A%5B%5D%2C%22layers%22%3A%5B%7B%22id%22%3A%22l8y239%22%2C%22type%22%3A%22geojson%22%2C%22config%22%3A%7B%22dataId%22%3A%22GBFS_Stations_5%22%2C%22label%22%3A%22Stations%20https%3A%2F%2Fxxx%2FLondon%2Fstation_information%22%2C%22color%22%3A%5B18%2C147%2C154%5D%2C%22columns%22%3A%7B%22geojson%22%3A%22_geojson%22%7D%2C%22isVisible%22%3Atrue%2C%22visConfig%22%3A%7B%22opacity%22%3A0.8%2C%22thickness%22%3A0.5%2C%22strokeColor%22%3Anull%2C%22colorRange%22%3A%7B%22name%22%3A%22Global%20Warming%22%2C%22type%22%3A%22sequential%22%2C%22category%22%3A%22Uber%22%2C%22colors%22%3A%5B%22%235A1846%22%2C%22%23900C3F%22%2C%22%23C70039%22%2C%22%23E3611C%22%2C%22%23F1920E%22%2C%22%23FFC300%22%5D%7D%2C%22strokeColorRange%22%3A%7B%22name%22%3A%22Global%20Warming%22%2C%22type%22%3A%22sequential%22%2C%22category%22%3A%22Uber%22%2C%22colors%22%3A%5B%22%235A1846%22%2C%22%23900C3F%22%2C%22%23C70039%22%2C%22%23E3611C%22%2C%22%23F1920E%22%2C%22%23FFC300%22%5D%7D%2C%22radius%22%3A10%2C%22sizeRange%22%3A%5B0%2C10%5D%2C%22radiusRange%22%3A%5B0%2C50%5D%2C%22heightRange%22%3A%5B0%2C500%5D%2C%22elevationScale%22%3A5%2C%22stroked%22%3Atrue%2C%22filled%22%3Atrue%2C%22enable3d%22%3Afalse%2C%22wireframe%22%3Afalse%7D%2C%22textLabel%22%3A%5B%7B%22field%22%3Anull%2C%22color%22%3A%5B255%2C255%2C255%5D%2C%22size%22%3A18%2C%22offset%22%3A%5B0%2C0%5D%2C%22anchor%22%3A%22start%22%2C%22alignment%22%3A%22center%22%7D%5D%7D%2C%22visualChannels%22%3A%7B%22colorField%22%3Anull%2C%22colorScale%22%3A%22quantile%22%2C%22sizeField%22%3Anull%2C%22sizeScale%22%3A%22linear%22%2C%22strokeColorField%22%3Anull%2C%22strokeColorScale%22%3A%22quantile%22%2C%22heightField%22%3Anull%2C%22heightScale%22%3A%22linear%22%2C%22radiusField%22%3Anull%2C%22radiusScale%22%3A%22linear%22%7D%7D%2C%7B%22id%22%3A%2281wgogq%22%2C%22type%22%3A%22geojson%22%2C%22config%22%3A%7B%22dataId%22%3A%22GBFS_Stations_5%22%2C%22label%22%3A%22Stations%20https%3A%2F%2Fxxx%2FLondon%2Fstation_information%22%2C%22color%22%3A%5B221%2C178%2C124%5D%2C%22columns%22%3A%7B%22geojson%22%3A%22lineColor%22%7D%2C%22isVisible%22%3Atrue%2C%22visConfig%22%3A%7B%22opacity%22%3A0.8%2C%22thickness%22%3A0.5%2C%22strokeColor%22%3Anull%2C%22colorRange%22%3A%7B%22name%22%3A%22Global%20Warming%22%2C%22type%22%3A%22sequential%22%2C%22category%22%3A%22Uber%22%2C%22colors%22%3A%5B%22%235A1846%22%2C%22%23900C3F%22%2C%22%23C70039%22%2C%22%23E3611C%22%2C%22%23F1920E%22%2C%22%23FFC300%22%5D%7D%2C%22strokeColorRange%22%3A%7B%22name%22%3A%22Global%20Warming%22%2C%22type%22%3A%22sequential%22%2C%22category%22%3A%22Uber%22%2C%22colors%22%3A%5B%22%235A1846%22%2C%22%23900C3F%22%2C%22%23C70039%22%2C%22%23E3611C%22%2C%22%23F1920E%22%2C%22%23FFC300%22%5D%7D%2C%22radius%22%3A10%2C%22sizeRange%22%3A%5B0%2C10%5D%2C%22radiusRange%22%3A%5B0%2C50%5D%2C%22heightRange%22%3A%5B0%2C500%5D%2C%22elevationScale%22%3A5%2C%22stroked%22%3Atrue%2C%22filled%22%3Afalse%2C%22enable3d%22%3Afalse%2C%22wireframe%22%3Afalse%7D%2C%22textLabel%22%3A%5B%7B%22field%22%3Anull%2C%22color%22%3A%5B255%2C255%2C255%5D%2C%22size%22%3A18%2C%22offset%22%3A%5B0%2C0%5D%2C%22anchor%22%3A%22start%22%2C%22alignment%22%3A%22center%22%7D%5D%7D%2C%22visualChannels%22%3A%7B%22colorField%22%3Anull%2C%22colorScale%22%3A%22quantile%22%2C%22sizeField%22%3Anull%2C%22sizeScale%22%3A%22linear%22%2C%22strokeColorField%22%3Anull%2C%22strokeColorScale%22%3A%22quantile%22%2C%22heightField%22%3Anull%2C%22heightScale%22%3A%22linear%22%2C%22radiusField%22%3Anull%2C%22radiusScale%22%3A%22linear%22%7D%7D%2C%7B%22id%22%3A%22tvuwpfn%22%2C%22type%22%3A%22geojson%22%2C%22config%22%3A%7B%22dataId%22%3A%22GBFS_Stations_5%22%2C%22label%22%3A%22Stations%20https%3A%2F%2Fxxx%2FLondon%2Fstation_information%22%2C%22color%22%3A%5B136%2C87%2C44%5D%2C%22columns%22%3A%7B%22geojson%22%3A%22fillColor%22%7D%2C%22isVisible%22%3Atrue%2C%22visConfig%22%3A%7B%22opacity%22%3A0.8%2C%22thickness%22%3A0.5%2C%22strokeColor%22%3Anull%2C%22colorRange%22%3A%7B%22name%22%3A%22Global%20Warming%22%2C%22type%22%3A%22sequential%22%2C%22category%22%3A%22Uber%22%2C%22colors%22%3A%5B%22%235A1846%22%2C%22%23900C3F%22%2C%22%23C70039%22%2C%22%23E3611C%22%2C%22%23F1920E%22%2C%22%23FFC300%22%5D%7D%2C%22strokeColorRange%22%3A%7B%22name%22%3A%22Global%20Warming%22%2C%22type%22%3A%22sequential%22%2C%22category%22%3A%22Uber%22%2C%22colors%22%3A%5B%22%235A1846%22%2C%22%23900C3F%22%2C%22%23C70039%22%2C%22%23E3611C%22%2C%22%23F1920E%22%2C%22%23FFC300%22%5D%7D%2C%22radius%22%3A10%2C%22sizeRange%22%3A%5B0%2C10%5D%2C%22radiusRange%22%3A%5B0%2C50%5D%2C%22heightRange%22%3A%5B0%2C500%5D%2C%22elevationScale%22%3A5%2C%22stroked%22%3Atrue%2C%22filled%22%3Afalse%2C%22enable3d%22%3Afalse%2C%22wireframe%22%3Afalse%7D%2C%22textLabel%22%3A%5B%7B%22field%22%3Anull%2C%22color%22%3A%5B255%2C255%2C255%5D%2C%22size%22%3A18%2C%22offset%22%3A%5B0%2C0%5D%2C%22anchor%22%3A%22start%22%2C%22alignment%22%3A%22center%22%7D%5D%7D%2C%22visualChannels%22%3A%7B%22colorField%22%3Anull%2C%22colorScale%22%3A%22quantile%22%2C%22sizeField%22%3Anull%2C%22sizeScale%22%3A%22linear%22%2C%22strokeColorField%22%3Anull%2C%22strokeColorScale%22%3A%22quantile%22%2C%22heightField%22%3Anull%2C%22heightScale%22%3A%22linear%22%2C%22radiusField%22%3Anull%2C%22radiusScale%22%3A%22linear%22%7D%7D%2C%7B%22id%22%3A%22bm6cx0h%22%2C%22type%22%3A%22geojson%22%2C%22config%22%3A%7B%22dataId%22%3A%22GBFS_Stations_3%22%2C%22label%22%3A%22Stations%20https%3A%2F%2Fxxx%2FHereford%2Fstation_information%22%2C%22color%22%3A%5B255%2C153%2C31%5D%2C%22columns%22%3A%7B%22geojson%22%3A%22_geojson%22%7D%2C%22isVisible%22%3Atrue%2C%22visConfig%22%3A%7B%22opacity%22%3A0.8%2C%22thickness%22%3A0.5%2C%22strokeColor%22%3Anull%2C%22colorRange%22%3A%7B%22name%22%3A%22Global%20Warming%22%2C%22type%22%3A%22sequential%22%2C%22category%22%3A%22Uber%22%2C%22colors%22%3A%5B%22%235A1846%22%2C%22%23900C3F%22%2C%22%23C70039%22%2C%22%23E3611C%22%2C%22%23F1920E%22%2C%22%23FFC300%22%5D%7D%2C%22strokeColorRange%22%3A%7B%22name%22%3A%22Global%20Warming%22%2C%22type%22%3A%22sequential%22%2C%22category%22%3A%22Uber%22%2C%22colors%22%3A%5B%22%235A1846%22%2C%22%23900C3F%22%2C%22%23C70039%22%2C%22%23E3611C%22%2C%22%23F1920E%22%2C%22%23FFC300%22%5D%7D%2C%22radius%22%3A10%2C%22sizeRange%22%3A%5B0%2C10%5D%2C%22radiusRange%22%3A%5B0%2C50%5D%2C%22heightRange%22%3A%5B0%2C500%5D%2C%22elevationScale%22%3A5%2C%22stroked%22%3Atrue%2C%22filled%22%3Atrue%2C%22enable3d%22%3Afalse%2C%22wireframe%22%3Afalse%7D%2C%22textLabel%22%3A%5B%7B%22field%22%3Anull%2C%22color%22%3A%5B255%2C255%2C255%5D%2C%22size%22%3A18%2C%22offset%22%3A%5B0%2C0%5D%2C%22anchor%22%3A%22start%22%2C%22alignment%22%3A%22center%22%7D%5D%7D%2C%22visualChannels%22%3A%7B%22colorField%22%3Anull%2C%22colorScale%22%3A%22quantile%22%2C%22sizeField%22%3Anull%2C%22sizeScale%22%3A%22linear%22%2C%22strokeColorField%22%3Anull%2C%22strokeColorScale%22%3A%22quantile%22%2C%22heightField%22%3Anull%2C%22heightScale%22%3A%22linear%22%2C%22radiusField%22%3Anull%2C%22radiusScale%22%3A%22linear%22%7D%7D%2C%7B%22id%22%3A%22u419d0e%22%2C%22type%22%3A%22geojson%22%2C%22config%22%3A%7B%22dataId%22%3A%22GBFS_Stations_3%22%2C%22label%22%3A%22Stations%20https%3A%2F%2Fxxx%2FHereford%2Fstation_information%22%2C%22color%22%3A%5B241%2C92%2C23%5D%2C%22columns%22%3A%7B%22geojson%22%3A%22lineColor%22%7D%2C%22isVisible%22%3Atrue%2C%22visConfig%22%3A%7B%22opacity%22%3A0.8%2C%22thickness%22%3A0.5%2C%22strokeColor%22%3Anull%2C%22colorRange%22%3A%7B%22name%22%3A%22Global%20Warming%22%2C%22type%22%3A%22sequential%22%2C%22category%22%3A%22Uber%22%2C%22colors%22%3A%5B%22%235A1846%22%2C%22%23900C3F%22%2C%22%23C70039%22%2C%22%23E3611C%22%2C%22%23F1920E%22%2C%22%23FFC300%22%5D%7D%2C%22strokeColorRange%22%3A%7B%22name%22%3A%22Global%20Warming%22%2C%22type%22%3A%22sequential%22%2C%22category%22%3A%22Uber%22%2C%22colors%22%3A%5B%22%235A1846%22%2C%22%23900C3F%22%2C%22%23C70039%22%2C%22%23E3611C%22%2C%22%23F1920E%22%2C%22%23FFC300%22%5D%7D%2C%22radius%22%3A10%2C%22sizeRange%22%3A%5B0%2C10%5D%2C%22radiusRange%22%3A%5B0%2C50%5D%2C%22heightRange%22%3A%5B0%2C500%5D%2C%22elevationScale%22%3A5%2C%22stroked%22%3Atrue%2C%22filled%22%3Afalse%2C%22enable3d%22%3Afalse%2C%22wireframe%22%3Afalse%7D%2C%22textLabel%22%3A%5B%7B%22field%22%3Anull%2C%22color%22%3A%5B255%2C255%2C255%5D%2C%22size%22%3A18%2C%22offset%22%3A%5B0%2C0%5D%2C%22anchor%22%3A%22start%22%2C%22alignment%22%3A%22center%22%7D%5D%7D%2C%22visualChannels%22%3A%7B%22colorField%22%3Anull%2C%22colorScale%22%3A%22quantile%22%2C%22sizeField%22%3Anull%2C%22sizeScale%22%3A%22linear%22%2C%22strokeColorField%22%3Anull%2C%22strokeColorScale%22%3A%22quantile%22%2C%22heightField%22%3Anull%2C%22heightScale%22%3A%22linear%22%2C%22radiusField%22%3Anull%2C%22radiusScale%22%3A%22linear%22%7D%7D%2C%7B%22id%22%3A%22hr61yo%22%2C%22type%22%3A%22geojson%22%2C%22config%22%3A%7B%22dataId%22%3A%22GBFS_Stations_3%22%2C%22label%22%3A%22Stations%20https%3A%2F%2Fxxx%2FHereford%2Fstation_information%22%2C%22color%22%3A%5B34%2C63%2C154%5D%2C%22columns%22%3A%7B%22geojson%22%3A%22fillColor%22%7D%2C%22isVisible%22%3Atrue%2C%22visConfig%22%3A%7B%22opacity%22%3A0.8%2C%22thickness%22%3A0.5%2C%22strokeColor%22%3Anull%2C%22colorRange%22%3A%7B%22name%22%3A%22Global%20Warming%22%2C%22type%22%3A%22sequential%22%2C%22category%22%3A%22Uber%22%2C%22colors%22%3A%5B%22%235A1846%22%2C%22%23900C3F%22%2C%22%23C70039%22%2C%22%23E3611C%22%2C%22%23F1920E%22%2C%22%23FFC300%22%5D%7D%2C%22strokeColorRange%22%3A%7B%22name%22%3A%22Global%20Warming%22%2C%22type%22%3A%22sequential%22%2C%22category%22%3A%22Uber%22%2C%22colors%22%3A%5B%22%235A1846%22%2C%22%23900C3F%22%2C%22%23C70039%22%2C%22%23E3611C%22%2C%22%23F1920E%22%2C%22%23FFC300%22%5D%7D%2C%22radius%22%3A10%2C%22sizeRange%22%3A%5B0%2C10%5D%2C%22radiusRange%22%3A%5B0%2C50%5D%2C%22heightRange%22%3A%5B0%2C500%5D%2C%22elevationScale%22%3A5%2C%22stroked%22%3Atrue%2C%22filled%22%3Afalse%2C%22enable3d%22%3Afalse%2C%22wireframe%22%3Afalse%7D%2C%22textLabel%22%3A%5B%7B%22field%22%3Anull%2C%22color%22%3A%5B255%2C255%2C255%5D%2C%22size%22%3A18%2C%22offset%22%3A%5B0%2C0%5D%2C%22anchor%22%3A%22start%22%2C%22alignment%22%3A%22center%22%7D%5D%7D%2C%22visualChannels%22%3A%7B%22colorField%22%3Anull%2C%22colorScale%22%3A%22quantile%22%2C%22sizeField%22%3Anull%2C%22sizeScale%22%3A%22linear%22%2C%22strokeColorField%22%3Anull%2C%22strokeColorScale%22%3A%22quantile%22%2C%22heightField%22%3Anull%2C%22heightScale%22%3A%22linear%22%2C%22radiusField%22%3Anull%2C%22radiusScale%22%3A%22linear%22%7D%7D%2C%7B%22id%22%3A%221cbsb4%22%2C%22type%22%3A%22geojson%22%2C%22config%22%3A%7B%22dataId%22%3A%22GBFS_Service_areas_4%22%2C%22label%22%3A%22Service%20areas%20london%22%2C%22color%22%3A%5B218%2C112%2C191%5D%2C%22columns%22%3A%7B%22geojson%22%3A%22_geojson%22%7D%2C%22isVisible%22%3Atrue%2C%22visConfig%22%3A%7B%22opacity%22%3A0.8%2C%22thickness%22%3A0.5%2C%22strokeColor%22%3A%5B18%2C92%2C119%5D%2C%22colorRange%22%3A%7B%22name%22%3A%22Global%20Warming%22%2C%22type%22%3A%22sequential%22%2C%22category%22%3A%22Uber%22%2C%22colors%22%3A%5B%22%235A1846%22%2C%22%23900C3F%22%2C%22%23C70039%22%2C%22%23E3611C%22%2C%22%23F1920E%22%2C%22%23FFC300%22%5D%7D%2C%22strokeColorRange%22%3A%7B%22name%22%3A%22Global%20Warming%22%2C%22type%22%3A%22sequential%22%2C%22category%22%3A%22Uber%22%2C%22colors%22%3A%5B%22%235A1846%22%2C%22%23900C3F%22%2C%22%23C70039%22%2C%22%23E3611C%22%2C%22%23F1920E%22%2C%22%23FFC300%22%5D%7D%2C%22radius%22%3A10%2C%22sizeRange%22%3A%5B0%2C10%5D%2C%22radiusRange%22%3A%5B0%2C50%5D%2C%22heightRange%22%3A%5B0%2C500%5D%2C%22elevationScale%22%3A5%2C%22stroked%22%3Atrue%2C%22filled%22%3Afalse%2C%22enable3d%22%3Afalse%2C%22wireframe%22%3Afalse%7D%2C%22textLabel%22%3A%5B%7B%22field%22%3Anull%2C%22color%22%3A%5B255%2C255%2C255%5D%2C%22size%22%3A18%2C%22offset%22%3A%5B0%2C0%5D%2C%22anchor%22%3A%22start%22%2C%22alignment%22%3A%22center%22%7D%5D%7D%2C%22visualChannels%22%3A%7B%22colorField%22%3Anull%2C%22colorScale%22%3A%22quantile%22%2C%22sizeField%22%3Anull%2C%22sizeScale%22%3A%22linear%22%2C%22strokeColorField%22%3Anull%2C%22strokeColorScale%22%3A%22quantile%22%2C%22heightField%22%3Anull%2C%22heightScale%22%3A%22linear%22%2C%22radiusField%22%3Anull%2C%22radiusScale%22%3A%22linear%22%7D%7D%2C%7B%22id%22%3A%2201wiixa%22%2C%22type%22%3A%22geojson%22%2C%22config%22%3A%7B%22dataId%22%3A%22GBFS_Service_areas_4%22%2C%22label%22%3A%22Service%20areas%20london%22%2C%22color%22%3A%5B77%2C193%2C156%5D%2C%22columns%22%3A%7B%22geojson%22%3A%22lineColor%22%7D%2C%22isVisible%22%3Atrue%2C%22visConfig%22%3A%7B%22opacity%22%3A0.8%2C%22thickness%22%3A0.5%2C%22strokeColor%22%3Anull%2C%22colorRange%22%3A%7B%22name%22%3A%22Global%20Warming%22%2C%22type%22%3A%22sequential%22%2C%22category%22%3A%22Uber%22%2C%22colors%22%3A%5B%22%235A1846%22%2C%22%23900C3F%22%2C%22%23C70039%22%2C%22%23E3611C%22%2C%22%23F1920E%22%2C%22%23FFC300%22%5D%7D%2C%22strokeColorRange%22%3A%7B%22name%22%3A%22Global%20Warming%22%2C%22type%22%3A%22sequential%22%2C%22category%22%3A%22Uber%22%2C%22colors%22%3A%5B%22%235A1846%22%2C%22%23900C3F%22%2C%22%23C70039%22%2C%22%23E3611C%22%2C%22%23F1920E%22%2C%22%23FFC300%22%5D%7D%2C%22radius%22%3A10%2C%22sizeRange%22%3A%5B0%2C10%5D%2C%22radiusRange%22%3A%5B0%2C50%5D%2C%22heightRange%22%3A%5B0%2C500%5D%2C%22elevationScale%22%3A5%2C%22stroked%22%3Atrue%2C%22filled%22%3Afalse%2C%22enable3d%22%3Afalse%2C%22wireframe%22%3Afalse%7D%2C%22textLabel%22%3A%5B%7B%22field%22%3Anull%2C%22color%22%3A%5B255%2C255%2C255%5D%2C%22size%22%3A18%2C%22offset%22%3A%5B0%2C0%5D%2C%22anchor%22%3A%22start%22%2C%22alignment%22%3A%22center%22%7D%5D%7D%2C%22visualChannels%22%3A%7B%22colorField%22%3Anull%2C%22colorScale%22%3A%22quantile%22%2C%22sizeField%22%3Anull%2C%22sizeScale%22%3A%22linear%22%2C%22strokeColorField%22%3Anull%2C%22strokeColorScale%22%3A%22quantile%22%2C%22heightField%22%3Anull%2C%22heightScale%22%3A%22linear%22%2C%22radiusField%22%3Anull%2C%22radiusScale%22%3A%22linear%22%7D%7D%2C%7B%22id%22%3A%22m4l5lz%22%2C%22type%22%3A%22geojson%22%2C%22config%22%3A%7B%22dataId%22%3A%22GBFS_Service_areas_0%22%2C%22label%22%3A%22Service%20areas%20bcp%22%2C%22color%22%3A%5B119%2C110%2C87%5D%2C%22columns%22%3A%7B%22geojson%22%3A%22_geojson%22%7D%2C%22isVisible%22%3Atrue%2C%22visConfig%22%3A%7B%22opacity%22%3A0.8%2C%22thickness%22%3A0.5%2C%22strokeColor%22%3A%5B23%2C184%2C190%5D%2C%22colorRange%22%3A%7B%22name%22%3A%22Global%20Warming%22%2C%22type%22%3A%22sequential%22%2C%22category%22%3A%22Uber%22%2C%22colors%22%3A%5B%22%235A1846%22%2C%22%23900C3F%22%2C%22%23C70039%22%2C%22%23E3611C%22%2C%22%23F1920E%22%2C%22%23FFC300%22%5D%7D%2C%22strokeColorRange%22%3A%7B%22name%22%3A%22Global%20Warming%22%2C%22type%22%3A%22sequential%22%2C%22category%22%3A%22Uber%22%2C%22colors%22%3A%5B%22%235A1846%22%2C%22%23900C3F%22%2C%22%23C70039%22%2C%22%23E3611C%22%2C%22%23F1920E%22%2C%22%23FFC300%22%5D%7D%2C%22radius%22%3A10%2C%22sizeRange%22%3A%5B0%2C10%5D%2C%22radiusRange%22%3A%5B0%2C50%5D%2C%22heightRange%22%3A%5B0%2C500%5D%2C%22elevationScale%22%3A5%2C%22stroked%22%3Atrue%2C%22filled%22%3Afalse%2C%22enable3d%22%3Afalse%2C%22wireframe%22%3Afalse%7D%2C%22textLabel%22%3A%5B%7B%22field%22%3Anull%2C%22color%22%3A%5B255%2C255%2C255%5D%2C%22size%22%3A18%2C%22offset%22%3A%5B0%2C0%5D%2C%22anchor%22%3A%22start%22%2C%22alignment%22%3A%22center%22%7D%5D%7D%2C%22visualChannels%22%3A%7B%22colorField%22%3Anull%2C%22colorScale%22%3A%22quantile%22%2C%22sizeField%22%3Anull%2C%22sizeScale%22%3A%22linear%22%2C%22strokeColorField%22%3Anull%2C%22strokeColorScale%22%3A%22quantile%22%2C%22heightField%22%3Anull%2C%22heightScale%22%3A%22linear%22%2C%22radiusField%22%3Anull%2C%22radiusScale%22%3A%22linear%22%7D%7D%2C%7B%22id%22%3A%2263zcgq6%22%2C%22type%22%3A%22geojson%22%2C%22config%22%3A%7B%22dataId%22%3A%22GBFS_Service_areas_0%22%2C%22label%22%3A%22Service%20areas%20bcp%22%2C%22color%22%3A%5B246%2C209%2C138%5D%2C%22columns%22%3A%7B%22geojson%22%3A%22lineColor%22%7D%2C%22isVisible%22%3Atrue%2C%22visConfig%22%3A%7B%22opacity%22%3A0.8%2C%22thickness%22%3A0.5%2C%22strokeColor%22%3Anull%2C%22colorRange%22%3A%7B%22name%22%3A%22Global%20Warming%22%2C%22type%22%3A%22sequential%22%2C%22category%22%3A%22Uber%22%2C%22colors%22%3A%5B%22%235A1846%22%2C%22%23900C3F%22%2C%22%23C70039%22%2C%22%23E3611C%22%2C%22%23F1920E%22%2C%22%23FFC300%22%5D%7D%2C%22strokeColorRange%22%3A%7B%22name%22%3A%22Global%20Warming%22%2C%22type%22%3A%22sequential%22%2C%22category%22%3A%22Uber%22%2C%22colors%22%3A%5B%22%235A1846%22%2C%22%23900C3F%22%2C%22%23C70039%22%2C%22%23E3611C%22%2C%22%23F1920E%22%2C%22%23FFC300%22%5D%7D%2C%22radius%22%3A10%2C%22sizeRange%22%3A%5B0%2C10%5D%2C%22radiusRange%22%3A%5B0%2C50%5D%2C%22heightRange%22%3A%5B0%2C500%5D%2C%22elevationScale%22%3A5%2C%22stroked%22%3Atrue%2C%22filled%22%3Afalse%2C%22enable3d%22%3Afalse%2C%22wireframe%22%3Afalse%7D%2C%22textLabel%22%3A%5B%7B%22field%22%3Anull%2C%22color%22%3A%5B255%2C255%2C255%5D%2C%22size%22%3A18%2C%22offset%22%3A%5B0%2C0%5D%2C%22anchor%22%3A%22start%22%2C%22alignment%22%3A%22center%22%7D%5D%7D%2C%22visualChannels%22%3A%7B%22colorField%22%3Anull%2C%22colorScale%22%3A%22quantile%22%2C%22sizeField%22%3Anull%2C%22sizeScale%22%3A%22linear%22%2C%22strokeColorField%22%3Anull%2C%22strokeColorScale%22%3A%22quantile%22%2C%22heightField%22%3Anull%2C%22heightScale%22%3A%22linear%22%2C%22radiusField%22%3Anull%2C%22radiusScale%22%3A%22linear%22%7D%7D%2C%7B%22id%22%3A%223myger8%22%2C%22type%22%3A%22geojson%22%2C%22config%22%3A%7B%22dataId%22%3A%22GBFS_Stations_1%22%2C%22label%22%3A%22Stations%20https%3A%2F%2Fxxx%2FBCP%2Fstation_information%22%2C%22color%22%3A%5B183%2C136%2C94%5D%2C%22columns%22%3A%7B%22geojson%22%3A%22_geojson%22%7D%2C%22isVisible%22%3Atrue%2C%22visConfig%22%3A%7B%22opacity%22%3A0.8%2C%22thickness%22%3A0.5%2C%22strokeColor%22%3Anull%2C%22colorRange%22%3A%7B%22name%22%3A%22Global%20Warming%22%2C%22type%22%3A%22sequential%22%2C%22category%22%3A%22Uber%22%2C%22colors%22%3A%5B%22%235A1846%22%2C%22%23900C3F%22%2C%22%23C70039%22%2C%22%23E3611C%22%2C%22%23F1920E%22%2C%22%23FFC300%22%5D%7D%2C%22strokeColorRange%22%3A%7B%22name%22%3A%22Global%20Warming%22%2C%22type%22%3A%22sequential%22%2C%22category%22%3A%22Uber%22%2C%22colors%22%3A%5B%22%235A1846%22%2C%22%23900C3F%22%2C%22%23C70039%22%2C%22%23E3611C%22%2C%22%23F1920E%22%2C%22%23FFC300%22%5D%7D%2C%22radius%22%3A10%2C%22sizeRange%22%3A%5B0%2C10%5D%2C%22radiusRange%22%3A%5B0%2C50%5D%2C%22heightRange%22%3A%5B0%2C500%5D%2C%22elevationScale%22%3A5%2C%22stroked%22%3Atrue%2C%22filled%22%3Atrue%2C%22enable3d%22%3Afalse%2C%22wireframe%22%3Afalse%7D%2C%22textLabel%22%3A%5B%7B%22field%22%3Anull%2C%22color%22%3A%5B255%2C255%2C255%5D%2C%22size%22%3A18%2C%22offset%22%3A%5B0%2C0%5D%2C%22anchor%22%3A%22start%22%2C%22alignment%22%3A%22center%22%7D%5D%7D%2C%22visualChannels%22%3A%7B%22colorField%22%3Anull%2C%22colorScale%22%3A%22quantile%22%2C%22sizeField%22%3Anull%2C%22sizeScale%22%3A%22linear%22%2C%22strokeColorField%22%3Anull%2C%22strokeColorScale%22%3A%22quantile%22%2C%22heightField%22%3Anull%2C%22heightScale%22%3A%22linear%22%2C%22radiusField%22%3Anull%2C%22radiusScale%22%3A%22linear%22%7D%7D%2C%7B%22id%22%3A%22mk89cfj%22%2C%22type%22%3A%22geojson%22%2C%22config%22%3A%7B%22dataId%22%3A%22GBFS_Stations_1%22%2C%22label%22%3A%22Stations%20https%3A%2F%2Fxxx%2FBCP%2Fstation_information%22%2C%22color%22%3A%5B255%2C203%2C153%5D%2C%22columns%22%3A%7B%22geojson%22%3A%22lineColor%22%7D%2C%22isVisible%22%3Atrue%2C%22visConfig%22%3A%7B%22opacity%22%3A0.8%2C%22thickness%22%3A0.5%2C%22strokeColor%22%3Anull%2C%22colorRange%22%3A%7B%22name%22%3A%22Global%20Warming%22%2C%22type%22%3A%22sequential%22%2C%22category%22%3A%22Uber%22%2C%22colors%22%3A%5B%22%235A1846%22%2C%22%23900C3F%22%2C%22%23C70039%22%2C%22%23E3611C%22%2C%22%23F1920E%22%2C%22%23FFC300%22%5D%7D%2C%22strokeColorRange%22%3A%7B%22name%22%3A%22Global%20Warming%22%2C%22type%22%3A%22sequential%22%2C%22category%22%3A%22Uber%22%2C%22colors%22%3A%5B%22%235A1846%22%2C%22%23900C3F%22%2C%22%23C70039%22%2C%22%23E3611C%22%2C%22%23F1920E%22%2C%22%23FFC300%22%5D%7D%2C%22radius%22%3A10%2C%22sizeRange%22%3A%5B0%2C10%5D%2C%22radiusRange%22%3A%5B0%2C50%5D%2C%22heightRange%22%3A%5B0%2C500%5D%2C%22elevationScale%22%3A5%2C%22stroked%22%3Atrue%2C%22filled%22%3Afalse%2C%22enable3d%22%3Afalse%2C%22wireframe%22%3Afalse%7D%2C%22textLabel%22%3A%5B%7B%22field%22%3Anull%2C%22color%22%3A%5B255%2C255%2C255%5D%2C%22size%22%3A18%2C%22offset%22%3A%5B0%2C0%5D%2C%22anchor%22%3A%22start%22%2C%22alignment%22%3A%22center%22%7D%5D%7D%2C%22visualChannels%22%3A%7B%22colorField%22%3Anull%2C%22colorScale%22%3A%22quantile%22%2C%22sizeField%22%3Anull%2C%22sizeScale%22%3A%22linear%22%2C%22strokeColorField%22%3Anull%2C%22strokeColorScale%22%3A%22quantile%22%2C%22heightField%22%3Anull%2C%22heightScale%22%3A%22linear%22%2C%22radiusField%22%3Anull%2C%22radiusScale%22%3A%22linear%22%7D%7D%2C%7B%22id%22%3A%22caxiyl%22%2C%22type%22%3A%22geojson%22%2C%22config%22%3A%7B%22dataId%22%3A%22GBFS_Stations_1%22%2C%22label%22%3A%22Stations%20https%3A%2F%2Fxxx%2FBCP%2Fstation_information%22%2C%22color%22%3A%5B248%2C149%2C112%5D%2C%22columns%22%3A%7B%22geojson%22%3A%22fillColor%22%7D%2C%22isVisible%22%3Atrue%2C%22visConfig%22%3A%7B%22opacity%22%3A0.8%2C%22thickness%22%3A0.5%2C%22strokeColor%22%3Anull%2C%22colorRange%22%3A%7B%22name%22%3A%22Global%20Warming%22%2C%22type%22%3A%22sequential%22%2C%22category%22%3A%22Uber%22%2C%22colors%22%3A%5B%22%235A1846%22%2C%22%23900C3F%22%2C%22%23C70039%22%2C%22%23E3611C%22%2C%22%23F1920E%22%2C%22%23FFC300%22%5D%7D%2C%22strokeColorRange%22%3A%7B%22name%22%3A%22Global%20Warming%22%2C%22type%22%3A%22sequential%22%2C%22category%22%3A%22Uber%22%2C%22colors%22%3A%5B%22%235A1846%22%2C%22%23900C3F%22%2C%22%23C70039%22%2C%22%23E3611C%22%2C%22%23F1920E%22%2C%22%23FFC300%22%5D%7D%2C%22radius%22%3A10%2C%22sizeRange%22%3A%5B0%2C10%5D%2C%22radiusRange%22%3A%5B0%2C50%5D%2C%22heightRange%22%3A%5B0%2C500%5D%2C%22elevationScale%22%3A5%2C%22stroked%22%3Atrue%2C%22filled%22%3Afalse%2C%22enable3d%22%3Afalse%2C%22wireframe%22%3Afalse%7D%2C%22textLabel%22%3A%5B%7B%22field%22%3Anull%2C%22color%22%3A%5B255%2C255%2C255%5D%2C%22size%22%3A18%2C%22offset%22%3A%5B0%2C0%5D%2C%22anchor%22%3A%22start%22%2C%22alignment%22%3A%22center%22%7D%5D%7D%2C%22visualChannels%22%3A%7B%22colorField%22%3Anull%2C%22colorScale%22%3A%22quantile%22%2C%22sizeField%22%3Anull%2C%22sizeScale%22%3A%22linear%22%2C%22strokeColorField%22%3Anull%2C%22strokeColorScale%22%3A%22quantile%22%2C%22heightField%22%3Anull%2C%22heightScale%22%3A%22linear%22%2C%22radiusField%22%3Anull%2C%22radiusScale%22%3A%22linear%22%7D%7D%2C%7B%22id%22%3A%22hpvsyvk%22%2C%22type%22%3A%22geojson%22%2C%22config%22%3A%7B%22dataId%22%3A%22GBFS_Service_areas_2%22%2C%22label%22%3A%22Service%20areas%20hereford%22%2C%22color%22%3A%5B130%2C154%2C227%5D%2C%22columns%22%3A%7B%22geojson%22%3A%22_geojson%22%7D%2C%22isVisible%22%3Atrue%2C%22visConfig%22%3A%7B%22opacity%22%3A0.8%2C%22thickness%22%3A0.5%2C%22strokeColor%22%3A%5B231%2C159%2C213%5D%2C%22colorRange%22%3A%7B%22name%22%3A%22Global%20Warming%22%2C%22type%22%3A%22sequential%22%2C%22category%22%3A%22Uber%22%2C%22colors%22%3A%5B%22%235A1846%22%2C%22%23900C3F%22%2C%22%23C70039%22%2C%22%23E3611C%22%2C%22%23F1920E%22%2C%22%23FFC300%22%5D%7D%2C%22strokeColorRange%22%3A%7B%22name%22%3A%22Global%20Warming%22%2C%22type%22%3A%22sequential%22%2C%22category%22%3A%22Uber%22%2C%22colors%22%3A%5B%22%235A1846%22%2C%22%23900C3F%22%2C%22%23C70039%22%2C%22%23E3611C%22%2C%22%23F1920E%22%2C%22%23FFC300%22%5D%7D%2C%22radius%22%3A10%2C%22sizeRange%22%3A%5B0%2C10%5D%2C%22radiusRange%22%3A%5B0%2C50%5D%2C%22heightRange%22%3A%5B0%2C500%5D%2C%22elevationScale%22%3A5%2C%22stroked%22%3Atrue%2C%22filled%22%3Afalse%2C%22enable3d%22%3Afalse%2C%22wireframe%22%3Afalse%7D%2C%22textLabel%22%3A%5B%7B%22field%22%3Anull%2C%22color%22%3A%5B255%2C255%2C255%5D%2C%22size%22%3A18%2C%22offset%22%3A%5B0%2C0%5D%2C%22anchor%22%3A%22start%22%2C%22alignment%22%3A%22center%22%7D%5D%7D%2C%22visualChannels%22%3A%7B%22colorField%22%3Anull%2C%22colorScale%22%3A%22quantile%22%2C%22sizeField%22%3Anull%2C%22sizeScale%22%3A%22linear%22%2C%22strokeColorField%22%3Anull%2C%22strokeColorScale%22%3A%22quantile%22%2C%22heightField%22%3Anull%2C%22heightScale%22%3A%22linear%22%2C%22radiusField%22%3Anull%2C%22radiusScale%22%3A%22linear%22%7D%7D%2C%7B%22id%22%3A%228w0k6b9%22%2C%22type%22%3A%22geojson%22%2C%22config%22%3A%7B%22dataId%22%3A%22GBFS_Service_areas_2%22%2C%22label%22%3A%22Service%20areas%20hereford%22%2C%22color%22%3A%5B30%2C150%2C190%5D%2C%22columns%22%3A%7B%22geojson%22%3A%22lineColor%22%7D%2C%22isVisible%22%3Atrue%2C%22visConfig%22%3A%7B%22opacity%22%3A0.8%2C%22thickness%22%3A0.5%2C%22strokeColor%22%3Anull%2C%22colorRange%22%3A%7B%22name%22%3A%22Global%20Warming%22%2C%22type%22%3A%22sequential%22%2C%22category%22%3A%22Uber%22%2C%22colors%22%3A%5B%22%235A1846%22%2C%22%23900C3F%22%2C%22%23C70039%22%2C%22%23E3611C%22%2C%22%23F1920E%22%2C%22%23FFC300%22%5D%7D%2C%22strokeColorRange%22%3A%7B%22name%22%3A%22Global%20Warming%22%2C%22type%22%3A%22sequential%22%2C%22category%22%3A%22Uber%22%2C%22colors%22%3A%5B%22%235A1846%22%2C%22%23900C3F%22%2C%22%23C70039%22%2C%22%23E3611C%22%2C%22%23F1920E%22%2C%22%23FFC300%22%5D%7D%2C%22radius%22%3A10%2C%22sizeRange%22%3A%5B0%2C10%5D%2C%22radiusRange%22%3A%5B0%2C50%5D%2C%22heightRange%22%3A%5B0%2C500%5D%2C%22elevationScale%22%3A5%2C%22stroked%22%3Atrue%2C%22filled%22%3Afalse%2C%22enable3d%22%3Afalse%2C%22wireframe%22%3Afalse%7D%2C%22textLabel%22%3A%5B%7B%22field%22%3Anull%2C%22color%22%3A%5B255%2C255%2C255%5D%2C%22size%22%3A18%2C%22offset%22%3A%5B0%2C0%5D%2C%22anchor%22%3A%22start%22%2C%22alignment%22%3A%22center%22%7D%5D%7D%2C%22visualChannels%22%3A%7B%22colorField%22%3Anull%2C%22colorScale%22%3A%22quantile%22%2C%22sizeField%22%3Anull%2C%22sizeScale%22%3A%22linear%22%2C%22strokeColorField%22%3Anull%2C%22strokeColorScale%22%3A%22quantile%22%2C%22heightField%22%3Anull%2C%22heightScale%22%3A%22linear%22%2C%22radiusField%22%3Anull%2C%22radiusScale%22%3A%22linear%22%7D%7D%5D%2C%22interactionConfig%22%3A%7B%22tooltip%22%3A%7B%22fieldsToShow%22%3A%7B%22GBFS_Stations_5%22%3A%5B%22name%22%2C%22capacity%22%2C%22id%22%2C%22lineWidth%22%2C%22radius%22%5D%2C%22GBFS_Stations_3%22%3A%5B%22name%22%2C%22capacity%22%2C%22id%22%2C%22lineWidth%22%2C%22radius%22%5D%2C%22GBFS_Service_areas_4%22%3A%5B%22name%22%2C%22id%22%2C%22fillColor%22%5D%2C%22GBFS_Service_areas_0%22%3A%5B%22name%22%2C%22id%22%2C%22fillColor%22%5D%2C%22GBFS_Stations_1%22%3A%5B%22name%22%2C%22capacity%22%2C%22id%22%2C%22lineWidth%22%2C%22radius%22%5D%2C%22GBFS_Service_areas_2%22%3A%5B%22name%22%2C%22id%22%2C%22fillColor%22%5D%7D%2C%22enabled%22%3Atrue%7D%2C%22brush%22%3A%7B%22size%22%3A0.5%2C%22enabled%22%3Afalse%7D%7D%2C%22layerBlending%22%3A%22normal%22%2C%22splitMaps%22%3A%5B%5D%2C%22animationConfig%22%3A%7B%22currentTime%22%3Anull%2C%22speed%22%3A1%7D%7D%2C%22mapState%22%3A%7B%22bearing%22%3A0%2C%22dragRotate%22%3Afalse%2C%22latitude%22%3A50.77734015993433%2C%22longitude%22%3A-1.9615279473015588%2C%22pitch%22%3A0%2C%22zoom%22%3A10.216142080455525%2C%22isSplit%22%3Afalse%7D%2C%22mapStyle%22%3A%7B%22styleType%22%3A%22light%22%2C%22topLayerGroups%22%3A%7B%7D%2C%22visibleLayerGroups%22%3A%7B%22label%22%3Atrue%2C%22road%22%3Atrue%2C%22border%22%3Afalse%2C%22building%22%3Atrue%2C%22water%22%3Atrue%2C%22land%22%3Atrue%2C%223d%20building%22%3Afalse%7D%2C%22threeDBuildingColor%22%3A%5B218.82023004728686%2C223.47597962276103%2C223.47597962276103%5D%2C%22mapStyles%22%3A%7B%7D%7D%7D%7D&vis_type=Kepler_test&model=xxx&view=journey&result.drill_menu_build_time=0.023203&result.from_cache=true&result.runtime=10.677&result.sql.length=1681&result.supports_pivot_in_db=true&result.truncated=true&router_state=explore&track_name=trigger&track_action=loadingStart&browser_name=Chrome&device=&os_type=OS%20X&os_version=10.14.6&has_touch=false

Subtotal visualization does not label the total row which makes it confusing to understand

Problem:

The subtotal row in the subtotal viz is not labeled, it is not obvious to know tat's the subtotal directly until users have a second check.

What's it like now:

What users want to see:
Users want to have the subtotal row being labeled

[Marketplace] Unexpected behavior in Gauge Visualization - Position of the target needle does not match the specified target value

Customer Equipmentshare has reported that the position of the target needle does not match their specified target values.

You'll see that, in the above, the target value is 72%, but the target needle is close to 0.

In the above, the target value is 90%, but the target needle seems close to 50%.

Repro:
https://dcl.dev.looker.com/explore/won_thesis_movies/movies?qid=9LoKmup5vT2fzchtTqXpMm&toggle=dat,vis,vse
Note thet the target value here is specified as 90%, but the target needle is at 0.

Business impact:
"we are using to showcase the business the unavailability of our current rentable assets. So pretty much all the manager and sales people and the customers use it to track."
"If it can be done this week. Appreciate it!"

Zendesk ticket link:
https://looker.zendesk.com/agent/tickets/283872

Subtotals vis removes field name instead of view name when `Show Full field Name` is OFF

Compass have reported that the subtotals vis is removing the field name and not the view name when Show Full field Name is toggled OFF

Version 5.20.7-11421d

Toggled Off

Toggled On