Error when I put two measures in an explore

Hello! I recently have had problems when I tried to put two measures in an explore and the result is the following:

Here is the LookML of the two measures that I used:

dimension: is_paid {
hidden: yes
type: string
case: {
when: {
label: “Yes”
sql: case when ${doc_type} = ‘0001’ then ${bus_status_nbr} = 1
else null end;;
}
else: “No”
}
measure: paid_orders {
label: “Paid Orders”
type: count_distinct
sql: case when ${is_paid} = ‘Yes’ then ${order_no}
else null end;;
}

dimension: paid_orders_gross_amount_raw {
hidden: yes
type: number
value_format_name: usd
sql: case when ${is_paid} = ‘Yes’ then ${gross_sales_amt_raw}
else 0 end;;
}
measure: paid_orders_gross_amount {
label: “Paid Orders Gross Amount”
type: sum
value_format_name: usd
sql: ${paid_orders_gross_amount_raw} ;;
}

The explore:

Could anyone help me or guide me to the solution, please?
If it can help in something my source database is Druid

Thanks in advance!

0 5 359
5 REPLIES 5
Top Labels in this Space