← Back to team overview

dhis2-devs team mailing list archive

Re: [Bug 1320460] [NEW] Pivot table not showing data element desagregation values

 

Hi Romain,

I just tried this on the online demo site and in works fine following these
steps:
1) Open Pivot Table App
2) In data elements, select group Immunization and select the data element
"BCG doses given"
3) Click Update to see the table with data, these are totals for "BCG doses
given", by month
4) Click on the "EPI/nutrition age" dimension in the left side menu. Select
both options ("<1", ">1").
5) Click on Layout and move "EPI/nutrition age" to columns.
6) Clik on Update and you will see "BCG doses given" data disaggregated by
age <1, and age >1
7) Click on the "Location Fixed/Outreach" dimension in the left side menu
and select all options
8) In Layout put "Location Fixed/Outreach" on Rows
9) Click on Update and you will see the data further disaggregated by
location

Maybe you forgot to actually select the options in the dimension menu on
the left side?  It is not enough to move the dimension into the table
layout, if no options are selected then the table will not show the
disaggregations.

In the demo database the data element "BCG doses given" is assigned to a
category combination which is combining the two categories "EPI/nutrition
age" and "Location Fixed/Outreach".

Ola
-------


----------------------------------
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps
link<https://maps.google.com/maps?q=Eftas%C3%A5sen+68,+0687+Oslo,+Norge&hl=en&ie=UTF8&sll=59.893855,10.785116&sspn=0.222842,0.585709&oq=eftas%C3%A5sen+68,+0687+Oslo,+&t=h&hnear=Eftas%C3%A5sen+68,+%C3%98stensj%C3%B8,+0687+Oslo,+Norway&z=16>


On 17 May 2014 12:17, Romain-Rolland Tohouri <romain@xxxxxxxxxxx> wrote:

> Public bug reported:
>
> Using pivot table app, when selecting data element "BCG doses given" you
> see the values in the generated table, but when editing the layout and
> adding "categories" dimension to the column or row where data is
> located, the table generated became empty with no values. I tried it
> with my local database but also on DHIS2 demo site and same problem.
>
> Thanks!
>
> ** Affects: dhis2
>      Importance: Undecided
>          Status: New
>
> --
> You received this bug notification because you are a member of DHIS 2
> developers, which is subscribed to DHIS.
> https://bugs.launchpad.net/bugs/1320460
>
> Title:
>   Pivot table not showing data element desagregation values
>
> Status in DHIS 2:
>   New
>
> Bug description:
>   Using pivot table app, when selecting data element "BCG doses given"
>   you see the values in the generated table, but when editing the layout
>   and adding "categories" dimension to the column or row where data is
>   located, the table generated became empty with no values. I tried it
>   with my local database but also on DHIS2 demo site and same problem.
>
>   Thanks!
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/dhis2/+bug/1320460/+subscriptions
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>

Follow ups

References