← Back to team overview

dhis2-devs team mailing list archive

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

 

Hi Ola,
When you clic on layout in the demo, in the "Dimensions" column you have at
the top of the list "Categories", how do you use that since it is generic
and now you have to specify actual disagregations in the left panel before
seeing the result on the table.
Hope my question is more clear now...
Thank you for your help,


Romain


2014-05-19 19:57 GMT+00:00 Ola Hodne Titlestad <olati@xxxxxxxxxx>:

> Good.
>
> Not sure what you mean Romain. Can you use an example from the demo?
> What kind out table layout do you want?
>
> 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 19 May 2014 16:56, Romain-Rolland TOHOURI <romain@xxxxxxxxxxx> wrote:
>
>> Yes Ola, you're right!!
>> I didn't select the option in the left side menu. Now its works! but now,
>> how do you use the "category" option in the layout dimension column?
>>
>> Thanks for your help,
>>
>> Romain
>>
>>
>> 2014-05-19 12:24 GMT+00:00 Ola Hodne Titlestad <olati@xxxxxxxxxx>:
>>
>> 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
>>>>
>>>
>>>
>>> _______________________________________________
>>> 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
>>>
>>>
>>
>>
>> --
>> Dr Tohouri Romain-Rolland
>> www.tohouri.
>> Tel: +225 03 44 49 44
>>
>
>


-- 
Dr Tohouri Romain-Rolland
www.tohouri.
Tel: +225 03 44 49 44

References