Hey there everyone,
I am tryin got be able to drill down from a KPI percentage that uses two measures. As far as I understand, you can only add drill downs in a measure. The two measures look something like below:
measure: reporting_count {
type: count
filters: [report_date: "90 days",
status: "Active, Hibernate, Deactivation Pending"]
}
measure: subscribed_count {
type: count
filters: [status: "Active, Hibernate, Deactivation Pending"]
}
What I would like to do is have a percentage (reporting_count / subscribed count) able to drill down to a set. But I know you cannot create a measure based on another measure. So my question is, how can I create a calculated field that allows for drilldown?