Skip to main content
Question

Donut Chart Legend Labels

  • July 16, 2019
  • 1 reply
  • 7 views

I created a donut chart modeling the percentage of EDI Orders in VBAK (Dimension is VBAK.ZZEDI_FLAG) Currently it looks as such: 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

1 reply

Forum|alt.badge.img+2
  • Level 1
  • 240 replies
  • July 16, 2019
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