Hey all,
we are currently trying to show relative numbers (i.e. where something is set in relation to the total number). The total number is not of any interest to us in this case. Here's how the example looks, so you can understand it better. We just want the relative percentage of Measure1 from Measure2.
measure: example1 {
type: number
value_format_name: percent_1
sql: 1.0*(${measure1}}) / NULLIF(${measure2},0);;
}
How can we make sure that the drill-down overlay of a measure always shows only the data that is relevant? We just get all records unfiltered that exist in the table when we drill down.
Of course, in this example, only the data from Measure1 would be interesting. How can we display only these or use the filtering of Measure1?
Thank you
Nick