dhis2-users team mailing list archive
-
dhis2-users team
-
Mailing list archive
-
Message #01254
Re: 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
>
Follow ups
References