Dear Community
I would like to ask, is it possible to visualize aggregate text data in data visualizer module? Please guide me in this regard.
Best
Jan Agha Stanikzai
cc: @Gassim (greetings)
Hi @janagha
Thanks for your question, would you like to share a use case or an example to how aggregating text is necessary? I think to the best of my knowledge that data element of type text and long text can’t be aggregated. I can confirm this because after selecting text for the type the aggregation type field will be locked as below:
So this helps to know after selecting the value type whether it is supported or not.
Thanks!
Dear @Gassim
Thank you so much for your guidance, I thought i would have used text columes for text data entry of logistic management system in order to track numeric and text data easily.
Regards
Jan Agha Stanikzai
Dear @Gassim
Aggregation type of aggregate data element and tracker data element are the same as you mentioned but tracker data element shows data in reports.
Regards
Jan Agha Stanikzai
Hi @janagha
Do you think the issue above could be related to this ticket ([DHIS2-14188] - Jira)? I think we have the same idea here. You are creating data element of type text and unable to preview it in a pivot table, right?
If so then the ticket above is being looked at by the software team at the moment. Thanks!
Thank you @Gassim
It will be great if we could visualize aggregate text in reports.
Regards
Jan Agha Stanikzai
1 Like
Hi @janagha
You’re welcome to have a look at the complete discussion on the jira issue or the final comment by @lina here: [DHIS2-14188] - Jira “The original issue has evolved and been fixed: the long text elements can be visualized in the pivot table option in Data Visualizer [and should work on all latest versions: 2.38.4.3, 2.39.2.1, and 2.40.1]”
Thanks!
Dear @Gassim
Thank you so much for your efforts in this regards, this is a great news you have resolved this proble, we will upgrade our instance version and test this option.
Regards
Jan Agha Stanikzai
1 Like
Dear @Gassim
Are you sure DHIS2 version 2.38.4.3 fixed for text data visualization in data visualizer, still i am facing the same problem of not showing text data after upgradation in data visualizer, if you could guide me right way please.
Regards
Jan Agha Stanikzai