I was trying to check the data value for a DE with TEXT valueType in the Data Visualizer app. I noticed that the values have space added to the value as shown in the attached image. I have selected the Details only DISAGGREGATION when selecting the data.
When I checked the original value selected in the form, there is no space i.e Residing, Not Residing, CO instead of C O.
This is totally strange! Could you share the steps to reproduce in any of the play.dhis2.org instances? Maybe there are options to change that will display the text differently (and if not then maybe we can create a bug issue)?
Unfortunately, I created the form with a custom app. So I don’t know how to reproduce the data in dhis2. However, when I use the search feature of the Data Visualizer app to search the DE name and select one DE, the value return without space as expected like the image below for comm1.
As I said the data is stored properly in the database and it appears without space individually.
But when I use the search feature of the Data Visualizer app to search data elements and select more than one DE in a pivot table, the value return with spaces. But if I select one data element, it returns without space.
That is the million question. The only difference I have noticed is that if I select more than one DE in a pivot table for details, the value return with spaces. But if I select one data element, it returns without space.