Donut Chart Legend Labels

I created a donut chart modeling the percentage of EDI Orders in VBAK (Dimension is “VBAK”.“ZZEDI_FLAG”)

Currently it looks as such:
image

Instead of the X featured at the bottom and to the left of 26%, would it be possible to have the label appear as ‘EDI Orders’. I tried "VBAK"."ZZEDI_FLAG" AS 'EDI', but that did not work. Any other options available?

Thanks

Hi,

If I understand your case correctly, "VBAK"."ZZEDI_FLAG" column contains either ‘X’ or ‘NULL’, right?
Then you could use a CASE WHEN in your Dimension to map those values to more meaningful ones, for example like this:

CASE WHEN "VBAK"."ZZEDI_FLAG"='X' THEN 'EDI' ELSE 'Non EDI' END

Best,

David

1 Like