sql - 试图在 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,

标签： sqlmicrostrategy

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)

您可以尝试以下方法：

1. 根据查询的 WHERE 子句创建 3 个过滤器。
2. 创建 1 个指标 COUNT(CUSTOMER_ID)。
3. 在指标内添加过滤器。