Drill Down not working

[rohit_shoppertr]

Hi team,

I have created a drill dimension as:

  dimension: Drill_Dimensions {
    sql: ${TABLE}.id ;;
    drill_fields: [site_id,zone_id]
  }

 measure: total_sales {
    type: sum
    sql: ${TABLE}.total_sales ;;
    drill_fields: [Drill_Dimensions]
  }

I create a chart and put it on dashboard and clicked on total sales number and this is what I am getting:

Can you please help me to know what exactly I am missing. I just want a simple chart with “id” as dimension and total sales as measure and when I click on “id”, site_id dimension open and then zone_id values