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