We’re seeing “undefined” for row and column totals of eventDataItems Data Elements in Pivot Table visualizations within Data Visualizer. The same vizzes operated fine in 2.37, and now are being given this. I can replicate this in play across several, but not all eventDataItem examples, screenshot below
Link to saved visualization here: Data Visualizer | DHIS2
I can’t seem to find a meaningful pattern that explains the inability to sum these numbers; there are sums, counts; some store 0 values, some do not, some of them have values for each period, others have some/most omitted.
Wondering if this is something people have triangulated so that I can better avoid it and describe it in a jira ticket.
Thanks for sharing this and for making it easier by sharing the favorite. I noticed a couple of things: Blood transfusion within 3 months before onset of symptoms is a Yes/No WHOMCH Contraceptive counselling provided is a Yes/No
The Voucher Pills one is a number but when the table crashed, I ran analytics then I checked it again and it appears that it’s no longer ‘undefined’:
There are important notes about aggregating event data items, so I think if any one is undefined, it could be because of these limitations: Tracker Analytics - DHIS2 Documentation
Or if it’s a number, maybe analytics tables export and clearing cache needs to be ran.
Let me know if these points help resolve any table where there’s still an issue, if not we can continue our investigation
Thanks!
