dimension condition by filters

Well, I have the next problem.

I have this variable dimension but the problem is that when the first three conditions are not met, the third one does not act as it should. 

${columns_v2_statistics.Variable} and ${columns_v2_statistics.Sub_Variable} are filters of the dashboard.

dimension: dimension_count_lvl3_3 {
type: string
sql:
CASE
WHEN ${columns_v2_statistics.Variable} = 'GEO_AREA_ID' THEN ${geo_area.municipio}
WHEN ${columns_v2_statistics.Sub_Variable} = 'COMUNIDAD' THEN ${geo_area.comunidad}
WHEN ${columns_v2_statistics.Sub_Variable} = 'PROVINCIA' THEN ${geo_area.provincia}
WHEN ${columns_v2_statistics.Sub_Variable} = 'MUNICIPIO' THEN ${geo_area.municipio}
ELSE ${value}
END ;;
}
0 0 339
0 REPLIES 0
Top Labels in this Space
Top Solution Authors