← Back to team overview

dhis2-users team mailing list archive

Re: Data set report not showing Text-type data

 

This was the original question from Owen:

---

How do I make the data set report show text-type data? I encountered this
while hoping to export a data set report made from parameters that should
match a single submission into Excel/CSV format. There doesn't seem to be a
way to turn off aggregation on the data element definition (only choices
are either Sum or Average). What we're actually trying to accomplish is
export all submissions into a file with a layout that's close to the
original entry form. Aggregation really isnt as important which is why
every submission has a lot more text data than number data.

---

Answer is that the analytics api is designed for retrieving aggregated
data, and we have because of that disabled support for text-type data
elements, since free-text cannot be reliably aggregated in any dimension.

We have however heard the request for making free-text values available in
the output and I think we can make an effort for supporting this. Note that
the best we can do is to return the text values if the request is an exact
match on data element, period and organisation unit (and potential category
option combo).

regards,

Lars



On Sat, Aug 17, 2013 at 8:47 PM, Knut Staring <knutst@xxxxxxxxx> wrote:

> Hello Owen, pls send such queries to this mailing list:
> https://answers.launchpad.net/dhis2/+question/234181
>
> --
> Knut Staring
> Dept. of Informatics, University of Oslo
> +4791880522
> http://dhis2.org
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>

References