Text in Pivot Tables

Hi All,

We’re relatively new users of DHIS2 and are trying to see written text in our pivot tables - with no success so far.

2 questions for this group:

  1. Do Pivot Tables provide the ability to see written text entered into the system (the text is connected to a data element) ?
  2. If Yes, is there a particular/different way to query the system to see it?
    Thanks all!

Kate

···

Kate Hesel, MPH
Program Officer - Monitoring, Evaluation and Learning

Planned Parenthood Global

(w) 212.261.4508

(m) 617.902.8511
Skype: katehesel

Web / Twitter

This e-mail is for the sole use of the intended recipient(s) and contains
information which is confidential and/or legally privileged. If you are not
the intended recipient, you are hereby notified that any disclosure,
copying, distribution or taking of any action in reliance on the contents
of this e-mail information is strictly prohibited. If you have received
this e-mail in error, please immediately notify the sender by reply e-mail
and destroy all copies of the original message.

Hi Kate,

Unsure if anyone else has replied but we tested a Data Element to capture ‘Comments’ in Data Sets & found out it is displayed only when exported to an Excel file in the Pivot Table app/section - an extract is attached.

If anyone knows of an update/fix/better alternative please share.

Thanks,

Damien

DHIS23 - Comments testing.csv (381 Bytes)

···

Hi All,

We’re relatively new users of DHIS2 and are trying to see written text in our pivot tables - with no success so far.

2 questions for this group:

  1. Do Pivot Tables provide the ability to see written text entered into the system (the text is connected to a data element) ?

  2. If Yes, is there a particular/different way to query the system to see it?

Thanks all!

Kate

Kate Hesel, MPH

Program Officer - Monitoring, Evaluation and Learning

Planned Parenthood Global

(w) 212.261.4508

(m) 617.902.8511

Skype: katehesel

Web / Twitter

*This e-mail is for the sole use of the intended recipient(s) and contains

information which is confidential and/or legally privileged. If you are not

the intended recipient, you are hereby notified that any disclosure,

copying, distribution or taking of any action in reliance on the contents

of this e-mail information is strictly prohibited. If you have received

this e-mail in error, please immediately notify the sender by reply e-mail

and destroy all copies of the original message.*

Hi Damien,

Thanks for sharing. We recently experienced the same behavior. It seems the text values are present in the datavaluesets and the analytics tables, they just don’t show up in the Pivot App itself. A bit frustrating for the end user because this worked up until quite recently. I need to get around to adding a Jira ticket for this. If you create one, let us know so we can keep an eye on it!

Best,
Sarah

···

Sarah Searle
Project Implementation Manager, BAO Systems

+1 202-536-1541 | ssearle@baosystems.com | http://www.baosystems.comSkype: searle.sarah | 2900 K Street, Suite 507, Washington D.C. 20007

Hi there,

can confirm that this is a regression issue in pivots.

Thanks for writing up the bug issue. We will look into it.

regards,

Lars

···

Lars Helge Øverland

Technical lead, DHIS 2

University of Oslo

lars@dhis2.org

https://www.dhis2.org

Hi Sarah, Damien,

I added a ticket to JIRA for this issue a few weeks back:

https://jira.dhis2.org/browse/DHIS2-5032

···

On Tue, Oct 30, 2018 at 5:09 PM Sarah Searle ssearle@baosystems.com wrote:

Hi Damien,

Thanks for sharing. We recently experienced the same behavior. It seems the text values are present in the datavaluesets and the analytics tables, they just don’t show up in the Pivot App itself. A bit frustrating for the end user because this worked up until quite recently. I need to get around to adding a Jira ticket for this. If you create one, let us know so we can keep an eye on it!

Best,
Sarah

On Tue, Oct 30, 2018 at 5:03 PM Damien Scarlett Damien.Scarlett@brussels.msf.org wrote:

Hi Kate,

Unsure if anyone else has replied but we tested a Data Element to capture ‘Comments’ in Data Sets & found out it is displayed only when exported to an Excel file in the Pivot Table app/section - an extract is attached.

If anyone knows of an update/fix/better alternative please share.

Thanks,

Damien

From: Dhis2-users dhis2-users-bounces+damien.scarlett=brussels.msf.org@lists.launchpad.net On Behalf Of Hesel, Kate

Sent: Tuesday, 23 October 2018 4:25 PM

To: dhis2-users@lists.launchpad.net

Subject: [Dhis2-users] Text in Pivot Tables

Hi All,

We’re relatively new users of DHIS2 and are trying to see written text in our pivot tables - with no success so far.

2 questions for this group:

  1. Do Pivot Tables provide the ability to see written text entered into the system (the text is connected to a data element) ?
  2. If Yes, is there a particular/different way to query the system to see it?
    Thanks all!

Kate

Kate Hesel, MPH

Program Officer - Monitoring, Evaluation and Learning

Planned Parenthood Global

(w) 212.261.4508

(m) 617.902.8511

Skype: katehesel

Web / Twitter

*This e-mail is for the sole use of the intended recipient(s) and contains

information which is confidential and/or legally privileged. If you are not

the intended recipient, you are hereby notified that any disclosure,

copying, distribution or taking of any action in reliance on the contents

of this e-mail information is strictly prohibited. If you have received

this e-mail in error, please immediately notify the sender by reply e-mail

and destroy all copies of the original message.*


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp


Sarah Searle
Project Implementation Manager, BAO Systems

+1 202-536-1541 | ssearle@baosystems.com | http://www.baosystems.comSkype: searle.sarah | 2900 K Street, Suite 507, Washington D.C. 20007

2 posts were split to a new topic: Values in API but they don’t seem to appear in pivot tables at all