I have a dimension like as follows
dimension: col1 {
type: string
hidden: yes
sql: ${TABLE}.col1 ;;
}
measure: loss_percent {
type: number
sql:
case
when ${loss} > 0 and ${total} > 0 then
ceiling((${loss} / ${total}) * 100)
else 0
end ;;
html:
{{ rendered_value }}
;;
drill_fields: [drill_details*]
}
set: drill_details {
fields: [event_time,rollup_a, rollup_b,
rollup_c, rollup_d, rollup_e,
col1]
}
in dashboard, I’m displaying loss_percent measure and if I click on drilldown col1 is getting displayed in drilldown as it’s passed in URL although it’s set to hidden:yes. Anyway to hide this col1 in drilldown? I need this data to generate a link in one of this drilldown dimension but not to be shown in drilldown table.