尝试在Microstrategy中执行此逻辑

Question

count(DISTINCT CASE WHEN enrollment_status = 'ACTIVE' AND enroll_end_date is null and enroll_start_date <= TRUNC(DATE_TRUNC('month', CURRENT_DATE)-1) 
THEN customer_id END) AS ACTIVE_MEMEMERS,

Answer 1

查询与以下内容相同：

select count(distinct customer_id) from table where enrollment_status = 'ACTIVE' AND enroll_end_date is null and enroll_start_date <= TRUNC(DATE_TRUNC('month', CURRENT_DATE)-1)

您可以尝试以下方法：

基于查询的WHERE子句的

1. Create 3筛选器。
2. Create 1 metric COUNT(CUSTOMER_ID).
3. Add指标内部的筛选器。