Hello everyone,
I have a dataset program that includes a category combination containing a date data type. I’m trying to pull this date information into a data visualization pivot table, but I’m unable to do so. Below is the error message I’m receiving.
Please can any one advise me on how to extract this data.
Could you please check which data element is showing the error and if possible share a screenshot of the configuration used? Thanks!
Hello
Arithmetic operation such is sum or average can not be applied on Date type to aggregate the result.
@Gassim Hopefully, the DHIS2 team will be able to resolve this issue. However, because the data urgently needed to be cleaned and analyzed, I had to use an alternative approach.
I used the import/export app to export the cleaned data and then extracted the date information. This process was somewhat technical since the import/export app exports data using UIDs instead of names.
The bulk load app can also be used, and it is much easier to navigate.
Hi @Mr_jorge
As @LutfullahShifaa mentioned, the date DE type can’t be aggregated into pivot table unless you might want to use indicators or consider another data element with a type that can be aggregated while using the period to get the date.
What is the pivot table that you are trying to see? What is it supposed to show? This might help us consider if there’s a different way than trying to aggregate dates.
You could mentioned the ID that you’d like to be used during the export:
It’d be very helpful to know what’s the final output that you need because it’s not clear why you exported the data when you’d planned to create a pivot table. Could you share an example?
Thanks!
