Hello, I use my formula
(CASE
WHEN "/RWEE/PMCP_TAUFK"."ARBPL_AN" LIKE 'S-%-S%'
THEN 'South Saxony'
WHEN "/RWEE/PMCP_TAUFK"."ARBPL_AN" LIKE 'S-%-A%'
THEN 'Saxony-Anhalt'
WHEN "/RWEE/PMCP_TAUFK"."ARBPL_AN" LIKE 'S-%-W%'
THEN 'West Saxony'
WHEN "/RWEE/PMCP_TAUFK"."ARBPL_AN" LIKE 'S-%-B%'
THEN 'Brandenburg'
ELSE ' ' END)
to cluster values.
Works great, except that it always gives me the ELSE values as 0 in my graph.
0 means that there is actually no ELSE, or in other words, everything is clustered.
How can I hide the 0 in the formula or in the component filter?
thx :-)