Indicator - Pivot Table in Data Visualizer calculation issue

Support - Assistance technique
,
1

Dear All,

There is one indicator with the KP-1a MSM Reached, We are checking the count in the Data Visualizer with pivot table, the count is differ when we select period as year=2023 the count is 15,746.
And with the same sceanrio with period select monthly wise till july then count is 20705.

Please provide some conculsion why the vary count while selecting the period as year or monthlywise.

Thanks in advance.

image
image920×602 56.7 KB

image
image1145×612 50.4 KB

2

Thank you for your post @Ravikumar!

I think what we are seeing is a bug issue. I’m able to reproduce a similar issue where the numbers are not adding up correctly but I need to double check with the software team @dhis2-analytics, please see screenshot:

/
/1920×587 130 KB

Thanks!

3

Dear Gassim,

Thanks for response,but in Screen shot the period is different one is jan 2023 and other August 2022 and Dhis version is different.

In my scenario,the selection of data,Organisation and dimension are same in both but period is different, one of the period we select Year 2023 and in other part wwe select period monthwise (means from jan 2023 to august 2023).Ideally in both cases count should be same only.

while selecting period as yearly then count is 15,746 and monthlywise count is 20705.

Please provide some feedback on this.

Thanks in advance.

Regards,
Ravikumar

1 Like
4

Thanks @Ravikumar! I have triaged this issue as well. :pray:

5

Hi @Gassim can you share the jira ticket for this? Would be useful to be able to recreate and better understand implications.

6

Hi @Matthew_Boddie

If it turns out we need to create a jira bug issue, I will make a post here. There’s still a discussion about different issues. Thank you!