Applying Legends to Option Sets with Text Values

Hi

I would like to know if its possible to apply legends to option set values that are of type text.

As an example, I have use-case in which we are conducting a survey. Using program rules, various scores are calculated based on the criteria that is entered during the survey. Here is an example of the output in event reports

Like pivot table, I would like to apply a colour scheme to the background cells. I could push the data to aggregate data elements, but I think I would have the same problem as I do not think I can create a legend for text values. Is there any way around this or do I need to create a standard report of some kind?

Thanks

1 Like

Hi @Shurajit_Dutta,

I hope you are well. Sorry for the late response; did you get a fix for this? Kindly et us know.

Best regards,
James.

No. I don’t think this is supported. As a a work around, we had to take the text values, assign to a numerical data element and then we could apply the legend.

2 Likes

Hi @Shurajit_Dutta,

What steps did you take to assign text values to numeric data elements?

Thanks