Org Units in Pivot Tables with Tracker Program Indicator data

Support - Assistance technique
1

|Version|2.39.2.1|
|Build revision|99a70d2|
|Build date|June 30, 2023 at 12:54|

We are using the Data Visualization app to create a simple pivot table. The data in the table are all Program Indicators (i.e., Tracker data).

The Program Indicators count values filtering on variables that span 3 program stages (we have just one program with multi-stages.)

The OU of each of the 3 stages can vary from one another so one enrollment can consist of 3 events and have data spanning 3 stages and each stage can be associated with a different OU.

When creating the pivot table, OU dimension is the row, Data dimension is the column, Period is the filter. The OUs to be included in the pivot table were individually selected.

It appears that the data in the pivot table is assigned to the OU from the first of the 3 stages. Is there a way to force a different stage’s assigned OU to be the one assigned the data in the pivot table? Stage-specific OUs display in Line List Event Reports but we need it to display in a pivot table that can incorporate Program Indicators.

TIA.

2

Hi @LauraLincks

So the way I understood your question is that in the pivot table you want to display the result of program indicators for each stage but the issue you are facing is that the different stages in the program can be in different OUs?

Is it possible to create a program indicator for each stage and then display these program indicators in the pivot table? Even if each stage is in a different OU it should only show the result for the indicator of that specific stage.

I hope this helps!