calculated-field - 在 Tableau Desktop 中，创建计算字段以在标记卡中使用度量值时有条件地格式化值

Question

我需要使用计算字段根据度量值的聚合（9 个单独的变量）设置三个标准级别，然后使用这些标准级别有条件地为表中 9 个变量中的每个变量的度量值的聚合着色，每个都是一行。首选此选项，而不是通过旋转来实现目标，因为我需要将已经很大的数据表保持尽可能小，以缩短用户在仪表板上查询的加载时间。

下面提供了我当前的公式。问题是标准级别仅针对第一个度量值“平均 QI1 访问分数”设置和/或应用于所有 9 个度量值，这是不正确的。我还尝试了 9 个测量值中的每一个的公式，我可以确认它可以单独工作，但不能一起工作。

{ FIXED [School - School Level],[Age - School]: IF AVG([QI1 Access Score]) >= 3.00 THEN "Sufficient Access"
    ELSEIF AVG([QI1 Access Score]) >= 2.00 THEN "Partial Access"
    ELSEIF AVG([QI1 Access Score]) < 2.00 THEN "Limited Access"
ELSEIF AVG([QI2 Access Score]) >= 3.00 THEN "Sufficient Access"
    ELSEIF AVG([QI2 Access Score]) >= 2.00 THEN "Partial Access"
    ELSEIF AVG([QI2 Access Score]) < 2.00 THEN "Limited Access"
ELSEIF AVG([QI3 Access Score]) >= 3.00 THEN "Sufficient Access"
    ELSEIF AVG([QI3 Access Score]) >= 2.00 THEN "Partial Access"
    ELSEIF AVG([QI3 Access Score]) < 2.00 THEN "Limited Access"
ELSEIF AVG([QI4 Access Score]) >= 3.00 THEN "Sufficient Access"
    ELSEIF AVG([QI4 Access Score]) >= 2.00 THEN "Partial Access"
    ELSEIF AVG([QI4 Access Score]) < 2.00 THEN "Limited Access"
ELSEIF AVG([QI5 Access Score]) >= 3.00 THEN "Sufficient Access"
    ELSEIF AVG([QI5 Access Score]) >= 2.00 THEN "Partial Access"
    ELSEIF AVG([QI5 Access Score]) < 2.00 THEN "Limited Access"
ELSEIF AVG([QI6 Access Score]) >= 3.00 THEN "Sufficient Access"
    ELSEIF AVG([QI6 Access Score]) >= 2.00 THEN "Partial Access"
    ELSEIF AVG([QI6 Access Score]) < 2.00 THEN "Limited Access"
ELSEIF AVG([QI7 Access Score]) >= 3.00 THEN "Sufficient Access"
    ELSEIF AVG([QI7 Access Score]) >= 2.00 THEN "Partial Access"
    ELSEIF AVG([QI7 Access Score]) < 2.00 THEN "Limited Access"
ELSEIF AVG([QI8 Access Score]) >= 3.00 THEN "Sufficient Access"
    ELSEIF AVG([QI8 Access Score]) >= 2.00 THEN "Partial Access"
    ELSEIF AVG([QI8 Access Score]) < 2.00 THEN "Limited Access"
ELSEIF AVG([QI9 Access Score]) >= 3.00 THEN "Sufficient Access"
    ELSEIF AVG([QI9 Access Score]) >= 2.00 THEN "Partial Access"
    ELSEIF AVG([QI9 Access Score]) < 2.00 THEN "Limited Access"
END}

我无权共享工作簿，我深表歉意

标签： calculated-fieldtableau-desktop