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:
<a href="#drillmenu" target="_self">
<div title={{loss._value}}>
<font color="#ef7d81">{{ rendered_value }}</font>
</div>
</a>;;
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.
Is there a reason why you wouldn’t be able to just remove it from the drill details?
User | Count |
---|---|
4 | |
1 | |
1 | |
1 | |
1 |