Measuring % of loans on which we are lead investors


#1
  measure: count_funded_this_year_deals {
    type: count

    filters: {
      field: is_funded_this_year
      value: "yes"
    }
  }

measure: funded_lead_percent {
    type: number
    sql: 100.0 * ${count_funded_this_year_deals} / ${lead_count} ;;
    html: {{ rendered_value }}%
      ;;
  }

  measure: lead_count {
    type: count
    filters: {
      field: is_lead_this_year
      value: "yes"
    }
  }

  measure: lead_percent {
    type: number
    sql: 100.0 * ${lead_count}/ ${count} ;;
    html: {{ rendered_value }}%
      ;;
  }