← Back to team overview

dhis2-devs team mailing list archive

Re: Web API Pivot Table Layout

 

Hi Farai,

If you look in the second table on this page, you will see that there is a
dynamic parameter called ou:
http://apps.dhis2.org/demo/api/charts/UlfTKWZWV4u


On Wed, Jul 24, 2013 at 8:07 PM, Farai Mutero <fmutero@xxxxxxxxx> wrote:

> Thanks Jan for the feedback. Noted.
>
> The following querystring parameters *"
> tableLayout=true&columns=dx;ou&rows=pe"* found in the Web API
> documentation just provided what I was looking for :
>
> api/analytics.html?dimension=dx:fbfJHSPpUQD;cYeuwXTCPkU&dimension=pe:2012Q1;2012Q2&dimension=ou:O6uvpzGd5pu*&tableLayout=true&columns=dx;ou&rows=pe*
>
> One more question : If I setup a chart using the Data Visualizer and I
> have saved it as "favourite", how do I call that chart favourite from my
> html report passing a dynamic org unit parameter to it?
>
> Regards
>
> Farai
>
> On Wed, Jul 24, 2013 at 7:38 PM, Jan Henrik Øverland <
> janhenrik.overland@xxxxxxxxx> wrote:
>
>> Hi Farai, such layout is produced by the pivot tables client, so you
>> cannot get it directly from the server.
>>
>>
>> On Wed, Jul 24, 2013 at 6:44 PM, Farai Mutero <fmutero@xxxxxxxxx> wrote:
>>
>>> Hi Guys
>>>
>>> I'm using the Web API to design an html report displaying pivot tables.
>>> How do I adjust my url call so that the pivot table rendered can display in
>>> the same way it was designed.
>>>
>>> Using the DHIS2 demo for example, if I use the url
>>> http://apps.dhis2.org/demo/api/analytics.html?dimension=dx:Jtf34kNZhzP;cYeuwXTCPkU;fbfJHSPpUQD;hfdmMSPBgLG&dimension=ou:USER_ORGUNIT_CHILDREN&dimension=pe:THIS_YEAR I
>>> get this view :
>>>
>>> [image: Inline image 1]
>>>
>>> Yet I would like the Pivot Table to have a layout like this :
>>>
>>> [image: Inline image 2]
>>>
>>> Regards
>>>
>>>
>>> --
>>> Farai Mutero
>>>
>>>
>>>
>>>
>>> --
>>> Farai Mutero
>>>
>>>
>>> _______________________________________________
>>> 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
>>>
>>>
>>
>
>
> --
> Farai Mutero
>
>
> _______________________________________________
> 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
>
>


-- 
Knut Staring
Dept. of Informatics, University of Oslo
+4791880522
http://dhis2.org

PNG image

PNG image


Follow ups

References