How can I change the Looker Drill Visualization Y ...

kakurebono · 09-17-2021 06:31 AM

Typo in the title cannot be changed, apologies for it.

I am working on a visual drill for marketing channel hourly breakdown.

My current solution - for some reason - seemingly stacks the Y axis values and therefore they follow the same trend even though some channels have a way lower hourly volume.

Is there a know solution to the problem?

below my current code.

measure: NO_OF_INSTALLS {
    label: "No of Installs"
    type: sum
    sql: ${TABLE}."NO_OF_INSTALLS" ;;
  drill_fields: [TIME_STAMP_hour,CHANNEL,NO_OF_INSTALLS]
  link: {
    label: "Hourly Breakdown"
    url: "
    {% assign vis_config = '{
    \"stacking\" : \"normal\",
    \"legend_position\" : \"center\",
    \"x_axis_gridlines\" : false,
    \"y_axis_gridlines\" : true,
    \"show_view_names\" : false,
    \"y_axis_combined\" : false,
    \"show_y_axis_labels\" : true,
    \"show_y_axis_ticks\" : true,
    \"y_axis_tick_density\" : \"default\",
    \"show_x_axis_label\" : true,
    \"show_x_axis_ticks\" : true,
    \"y_axis_scale_mode\" : \"linear\",
    \"show_null_points\" : false,
    \"interpolation\" : \"monotone\",
    \"series_types\" : {},
    \"type\" : \"looker_line\",
    \"colors\": [
     \"#74A09F\",
     \"#ADAA8D\",
     \"#EBC667\",
     \"#C0D918\",
     \"#85C0DE\",
     \"#49CEC0\",
     \"#AE6262\",
     \"#CE642D\",
     \"#92CF50\",
     \"#F2E271\"
     ],
    \"x_axis_label\" : \"Hour of Day\"
    }' %}
    {{ link }}&vis_config={{ vis_config | encode_uri }}&sorts=daily_installs.TIME_STAMP_hour+asc&pivots=daily_installs.CHANNEL&toggle=dat,pik,vis&limit=500&column_limit=15"
  }
}

example from the current Viz:

How can I change the Looker Drill Visualization Y axes that each value is shown on separate axes?