← Back to team overview

dhis2-users team mailing list archive

Re: Datamart

 

Noted.
Sent from my BlackBerry® smartphone

-----Original Message-----
From: Bob Jolliffe <bobjolliffe@xxxxxxxxx>
Date: Fri, 20 Jul 2012 18:43:13 
To: Ola Hodne Titlestad<olati@xxxxxxxxxx>
Cc: Kabango Malewezi<kmalewezi@xxxxxxxxxxx>; <dhis2-users@xxxxxxxxxxxxxxxxxxx>
Subject: Re: [Dhis2-users] Datamart

I guess another workaround might be to create simple naive indicators
(ie denominator=1) but this could easily lead to indicator
proliferation.

On 20 July 2012 18:39, Ola Hodne Titlestad <olati@xxxxxxxxxx> wrote:
> Jason,
> How do you handle the values in this view? Indicator values should be set up
> as a calculated field to let excel aggregate numerators and denominators
> separately for percentage values. If not the values for higher levels will
> be wrong.
>
> Or are you using only one orgunit level in this view?
>
> I guess it is possible to use two separate value fields for data elements
> and indicators in the same pivot table?
> Sounds confusing, but for a very specific/static table maybe.... but then I
> would recommend standard reports.
>
> Ola
> -------
>
> On Jul 20, 2012 7:24 PM, "Kabango Malewezi" <kmalewezi@xxxxxxxxxxx> wrote:
>>
>> Hi Kabango,
>>
>> That is not possible.
>>
>> You can do it with report tables and standard reports.
>>
>> Ola
>> -------
>>
>> On Jul 20, 2012 10:49 AM, "Kabango Malewezi" <kmalewezi@xxxxxxxxxxx>
>> wrote:
>>>
>>> Gentle People,
>>>
>>>
>>>
>>> I'd like to have Elements and indicators in one excel pivot table. How do
>>> I do that? The available views I have have either Pivot_Indicator or
>>> Pivot_Routinedata.
>>>
>>>
>>>
>>> Kabango Malewezi
>>>
>>> SSDI Services
>>>
>>> 2nd Floor, Pamodzi House, City Center, P.O Box 1091, Lilongwe, Malawi
>>> Tel: +265 (01) 776 412/3/4 | fax: +265 (01) 776 410 | Mobile: +265 (0) 88
>>> 4 245 431
>>>
>>> kmalewezi@xxxxxxxxxxx <mailto:kmalewezi@xxxxxxxxxxx > |
>>> www.jhpiego.org<http://www.jhpiego.org/>
>>>
>>> Skype: kabango.malewezi | Twitter: kabangoM
>>>
>>> _______________________________________________
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>


References