# viewing statistics of dataset assignments

Hi
Is there a way of treating the assignment of a dataset to an org unit as an indicator?

Thinking of datasets assignments as indications that some class of services is given in a specific org-unit, It would be useful to visualize them so as to better understand the availability of those services.

If there isn’t a built-in way, a possible workaround would be to generate one boolean data element per dataset and set it’s datavalue to true for those org-units that are assigned the corosponding dataset at a specific period. This would also serve as a way of tracking the history of dataset assignments.

Lavi

Hi Lavi,

In DHIS2, indicator is always treated as formula or we can say like mathematical expression.

If you treat Indicator as a mathematical formula that obvious implies that it should have some denominator & nominator. If you treat Indicator as a mathematical expression, than that implies

it should have some mathematical operands & mathematical operators. However Data Element
plays role of mathematical operands that are variable in nature in Indicator, since their values are measured with multiple time frame for multiple org unit, means it depends upon two other dimensions of frame of reference.

···

It is certain and fissionable to make Indicator expressions, where we can keep data element
that should measure number of multiple datasets assigned to an org unit and number of multiple

org units assigned to a dataset, for that we would centrally have to create data element that should keep total number of data sets available in application in present time frame & total number of available org units assigned with the specific data set, both these data elements can be used in calculating value of indicator that could measured periodically.

Brajesh

On Sun, Aug 3, 2014 at 6:38 PM, Lavi Shpigelman shpigi@gmail.com wrote:

Hi
Is there a way of treating the assignment of a dataset to an org unit as an indicator?

Thinking of datasets assignments as indications that some class of services is given in a specific org-unit, It would be useful to visualize them so as to better understand the availability of those services.

If there isn’t a built-in way, a possible workaround would be to generate one boolean data element per dataset and set it’s datavalue to true for those org-units that are assigned the corosponding dataset at a specific period. This would also serve as a way of tracking the history of dataset assignments.

Lavi

(+91)-99-53-787977(P)

P please consider the environment before printing this email

Regards

Brajesh Murari

Phone: (+91)-96-43-208375(O)

Hi Barajesh,

I guess I just wanted to verify that there isn’t such a feature already built in to DHIS2 that I may have missed.

Regarding implementing something like this using data-elements, my suggestion is to assign one boolean data element per data set and use aggregation to figure out how many facilities report the dataset in higher levels of the org-unit hierarchy.

.

Counting the total number of datasets that a facility provides is probably less useful but you could do that either by making a specific data element for that (as you have suggested) or by making an indicator that sums the boolean data elements that represent single datasets.

Regards,

Lavi

···

On Sun, Aug 3, 2014 at 8:31 PM, Brajesh Murari brijeshmurari@gmail.com wrote:

Hi Lavi,

In DHIS2, indicator is always treated as formula or we can say like mathematical expression.

If you treat Indicator as a mathematical formula that obvious implies that it should have some denominator & nominator. If you treat Indicator as a mathematical expression, than that implies

it should have some mathematical operands & mathematical operators. However Data Element
plays role of mathematical operands that are variable in nature in Indicator, since their values are measured with multiple time frame for multiple org unit, means it depends upon two other dimensions of frame of reference.

It is certain and fissionable to make Indicator expressions, where we can keep data element
that should measure number of multiple datasets assigned to an org unit and number of multiple

org units assigned to a dataset, for that we would centrally have to create data element that should keep total number of data sets available in application in present time frame & total number of available org units assigned with the specific data set, both these data elements can be used in calculating value of indicator that could measured periodically.

Brajesh

On Sun, Aug 3, 2014 at 6:38 PM, Lavi Shpigelman shpigi@gmail.com wrote:

Hi
Is there a way of treating the assignment of a dataset to an org unit as an indicator?

Thinking of datasets assignments as indications that some class of services is given in a specific org-unit, It would be useful to visualize them so as to better understand the availability of those services.

If there isn’t a built-in way, a possible workaround would be to generate one boolean data element per dataset and set it’s datavalue to true for those org-units that are assigned the corosponding dataset at a specific period. This would also serve as a way of tracking the history of dataset assignments.

Lavi

``````   (+91)-99-53-787977(P)
``````

P please consider the environment before printing this email

Regards

Brajesh Murari

Phone: (+91)-96-43-208375(O)

Yes Livi, as you suggested should require addition of one new Boolean data element in all available dataset, but i think you are missing one very useful reporting functionality available in DHIS2, ie. Dataset Completeness Report, that gives us an idea about reporting of specific dataset to assigned org unit and parent org unit with necessary data elements.

For example, if a dataset consists of 25 data elements, and out of 25, necessary 4 data elements must be reported for certain time period depends upon dataset reporting period type in order to consider completeness of data entry for that period, can be analyzed in DC Report (ie. Dataset Completeness Report) without defining any specific indicator.

However, for those who are not aware about DC Report functionality, as you suggested, they can assign one boolean data element in each dataset for this measurement.

Brajesh

···

On Mon, Aug 4, 2014 at 1:28 AM, Lavi Shpigelman shpigi@gmail.com wrote:

Hi Barajesh,

I guess I just wanted to verify that there isn’t such a feature already built in to DHIS2 that I may have missed.

Regarding implementing something like this using data-elements, my suggestion is to assign one boolean data element per data set and use aggregation to figure out how many facilities report the dataset in higher levels of the org-unit hierarchy.

.

Counting the total number of datasets that a facility provides is probably less useful but you could do that either by making a specific data element for that (as you have suggested) or by making an indicator that sums the boolean data elements that represent single datasets.

Regards,

Lavi

(+91)-99-53-787977(P)

P please consider the environment before printing this email

Regards

Brajesh Murari

Phone: (+91)-96-43-208375(O)

On Sun, Aug 3, 2014 at 8:31 PM, Brajesh Murari brijeshmurari@gmail.com wrote:

Hi Lavi,

In DHIS2, indicator is always treated as formula or we can say like mathematical expression.

If you treat Indicator as a mathematical formula that obvious implies that it should have some denominator & nominator. If you treat Indicator as a mathematical expression, than that implies

it should have some mathematical operands & mathematical operators. However Data Element
plays role of mathematical operands that are variable in nature in Indicator, since their values are measured with multiple time frame for multiple org unit, means it depends upon two other dimensions of frame of reference.

It is certain and fissionable to make Indicator expressions, where we can keep data element
that should measure number of multiple datasets assigned to an org unit and number of multiple

org units assigned to a dataset, for that we would centrally have to create data element that should keep total number of data sets available in application in present time frame & total number of available org units assigned with the specific data set, both these data elements can be used in calculating value of indicator that could measured periodically.

Brajesh

On Sun, Aug 3, 2014 at 6:38 PM, Lavi Shpigelman shpigi@gmail.com wrote:

Hi
Is there a way of treating the assignment of a dataset to an org unit as an indicator?

Thinking of datasets assignments as indications that some class of services is given in a specific org-unit, It would be useful to visualize them so as to better understand the availability of those services.

If there isn’t a built-in way, a possible workaround would be to generate one boolean data element per dataset and set it’s datavalue to true for those org-units that are assigned the corosponding dataset at a specific period. This would also serve as a way of tracking the history of dataset assignments.

Lavi

``````   (+91)-99-53-787977(P)
``````

P please consider the environment before printing this email

Regards

Brajesh Murari

Phone: (+91)-96-43-208375(O)

Hi Lavi,

we don't have the feature you suggest but we do have one that resembles it:
You can use the count of organisation units in org unit groups inside
indicator formulas. If you look in the indicator expression dialog there is
a list in the top right corner which you can click in.

For your specific use-case this of course means you have to maintain the
data set assignments two places. As a quick start you could easily do a sql
"insert into - select from" statement from datasetsource to
orgunitgroupmembers table.

Another aspect is that there is often not a one-to-one mapping between data
sets and services. By using org unit groups for services you can define the
services freely.

regards,

Lars

···

On Sun, Aug 3, 2014 at 3:08 PM, Lavi Shpigelman <shpigi@gmail.com> wrote:

Hi
Is there a way of treating the assignment of a dataset to an org unit as
an indicator?
Thinking of datasets assignments as indications that some class of
services is given in a specific org-unit, It would be useful to visualize
them so as to better understand the availability of those services.

If there isn't a built-in way, a possible workaround would be to generate
one boolean data element per dataset and set it's datavalue to true for
those org-units that are assigned the corosponding dataset at a specific
period. This would also serve as a way of tracking the history of dataset
assignments.