← Back to team overview

dhis2-devs team mailing list archive

Re: Web API Pivot Table Layout

 

So that means I can't pass dynamic uid parameters then? Such a facility
would have greatly assisted me to quickly create my html report leveraging
off the charts already created and saved as favourites in the Data
Visualizer. I would only need to dynamically pass the uid to it and get the
relevant result. Now looks like I will have to reconstruct the charts from
scratch?


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

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



-- 
Farai Mutero

PNG image

PNG image


Follow ups

References