← Back to team overview

dhis2-devs team mailing list archive

Re: Web API Pivot Table Layout

 

Sorry, I misread your question a bit. In your case, you can only pass width
and height if you wish to work with stored charts, like this:
http://apps.dhis2.org/demo/api/charts/UlfTKWZWV4u/data?width=300&height=400


On Wed, Jul 24, 2013 at 8:35 PM, Knut Staring <knutst@xxxxxxxxx> wrote:

> 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
>



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

PNG image

PNG image


Follow ups

References