Option set and legend in DE not working in Data visualizer

In version 40.2, I assigned the option set and legend to DE. However, when I tried to generate a report using the data visualizer app, I encountered the following error: “Query item cannot specify both legend set and option set.”

Furthermore, when I attempted to remove the option set from DE and only keep the legend, the report was generated successfully but the legend colors were not functioning properly.

I need assistance in resolving this issue or finding an alternative solution.

Hi @sami.oracle10g

Could you take a screenshot explaining how the legend colors were not functioning properly?

Thanks!