Hi, there is one problem in 2.40.6 when I download an excel from Data Visualizer pivot table, it reorders my file columns and rows to alphabet, not in the style of my own.
Hi
Could you please explain how the change happens? Is it after you import the file into spreadsheet or before? Are you able to reproduce this issue in any of the play.dhis2.org instances.
Thanks!
Hi
Look at the above snapshot; there I have my own order for the first column. But when I download it to an Excel file, it changes the order to alphabetical. like the below snapshot.
1 Like
Same issue occured … is there any solution?
have you recievied any solution of this error in 2.40.6?
when I download an excel from Data Visualizer pivot table, it reorders my file columns and rows to alphabet, not in the style of my own which is showing on visualizer. is there any solution?
1 Like
Hi @ALI_HASSAN
You’re right. I am able to reproduce this in Data Visualizer app version v.100.9 (currently the latest version). I’ll ask to @dhis2-analytics team to see whether this is a bug or if retaining the column order is a feature request. After that I’ll let you know so we can create a feature request.
For now, the other option is to manually reorder the columns in a spreadsheet software.
I also have a question for you please. When I reproduced this issue, the columns were (ANC 2, ANC 3, ANC 1) so when they were reordered to (ANC1, ANC2, ANC3) it made more sense. Would you kindly share your use case where the alphabetical sorting doesn’t help?
Thank you!
I am currently working on the Tuberculosis indicator, and I’ve encountered an issue with the alphabetical sorting functionality. It is not working as expected, affecting our ability to download the data into Excel, similar to what is shown in the Data Visualizer. Could you please prioritize this issue and provide an update on the Data Visualizer application? Your assistance is greatly appreciated.
1 Like
In latest version of Data Visulaizer 101.0.0 issue not resolved yet…
1 Like
Thanks @ALI_HASSAN !
I’ve created a bug jira issue on your behalf and @Aminulhaq_SADAT, Jira
Please watch the ticket to receive updates about any changes/comments related to the ticket.
Thanks!
I am using DHIS2 version 2.39.8 and noticed that when I arrange the columns with Data Types in a specific order in the Pivot Tables of the Data Visualizer for better analysis, this order is lost when exporting the file to Excel.
Does anyone know if this is the expected system behavior, a possible bug in this DHIS2 version, or if there is a configuration that could fix this issue?
1 Like
Hi @cassamo
Thank you the clearly written post with the screenshots. This had been discussed here (Pivot Table excel downloaded file reordered columns/rows) and reported here (Jira)
Since the topics are the same, I will merge your post with the one that was posted first. Thanks!
Any update regarding this issue?