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!