← Back to team overview

dhis2-devs team mailing list archive

Re: Web API Pivot Table Layout

 

Does it have to be a parameter? If I understand you correctly, you can get
your stored charts by passing the chart uid as part of the url:
http://apps.dhis2.org/dev/api/charts/UlfTKWZWV4u/data


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

> 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