How to hide certain column on drill down table?

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.

0 1 515
1 REPLY 1

Is there a reason why you wouldn’t be able to just remove it from the drill details?

Top Labels in this Space
Top Solution Authors