Custom drill down involving table calculations

Hi

I am attempting to create a custom view when drilling into a value in my dashboard, however, despite defining a table calculation, and in theory passing it into the url, only the variables specified in the "drill_fields" argument appear. Any ideas what I could be missing? Any help would be much appreciated!

measure: bias_2_5_pct {
type: percentile
percentile: 2.5
sql: ${bias} ;;
value_format_name: percent_1
drill_fields: [name, bias]
link: {
label: "Custom drill down"
url: "
{% assign table_calc = '
{
\"table_calculation\": \"25pct\",
\"label\": \"25pct\",
\"expression\": \"percentile(${view.bias}, 0.025)\",
\"value_format\": null,
\"value_format_name\": \null,
\"_kind_hint\": \"dimension\",
\"_type_hint\": \"number\"
}' %}
{% assign vis_config = '{
\"type\": \"table\",
\"show_view_names\": false,
\"show_row_numbers\": false,
\"truncate_column_names\": false,
\"table_theme\": \"gray\",
\"enable_conditional_formatting\": false}' %}
{{ link }}&dynamic_fields={{ table_calc | encode_uri }}&vis_config={{ vis_config | encode_uri }}&toggle=dat,pik,vis&limit=5000"
}
}
0 0 754
0 REPLIES 0
Top Labels in this Space
Top Solution Authors