DHIS Pivot table export with with friendly data

Implementation - Implémentation
1

Hallo

We have implemented HTS line listing for users to generate pivot tables and do analysis. When viewed in DHIS it looks great

hts_line_list
hts_line_list1845×486 79.1 KB

but when when we export to excel we get the data as codes as show below e.g. HIV result or HTS model

hts_line_list_csv
hts_line_list_csv1850×381 128 KB

We would like the user to select if they want the codes or friendly data. Is this possible? We using 2.30

Regards

1 Like
2

@tonysox
Would you confirm whether some of the attributes in your table are confidential?

Emma

1 Like
3

apologies for late response. The data contains de-identifiable information. The challenge is for example we have an optionset Functional Status

code name
B Bedridden
A Ambulatory
W Work/School going

When one views in dhis they see Ambulatory or bedridden but when they export to excel so they may use a more comfortable package they get B or A and we need them to be able to select whether to export friendly name (Ambulatory or bedridden) versus exporting B or A.

This data is already approved for public consumption for those with dhis credential and they are no identifying variables.

Regards

1 Like