Drill Down not working

  • 2 September 2021
  • 0 replies

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

This topic has been closed for comments