I’m encountering an issue with zero data values in my datasets. After enabling the option to include zero values in analytics (under settings) and checking the “Store zero data values” option in the data element settings, I performed maintenance tasks such as clearing analytics tables, analyzing tables, clearing the application cache, reloading apps, and generating tables. When I ran analytics for all periods, I noticed that zero values started appearing for the past week, but older periods (like the past 52 weeks and previous years) still show blanks instead of zeroes.
Could anyone advise on how to ensure zero values are also displayed for those older periods? Thank you!
Anything in the analytics tables export logs that could give a hint? Any errors in the Catalina.out log?
Did you check that these older values are actually stored in the system as zeroes? One question please, if you try to import the values for the week 52 and try again, do you think you’ll find the values for that week (i.e. you’ll have 51 weeks missing the zero value rather than 52.)
Thank you for your response! Just to clarify, zero values have started showing for the most recent week, but for the previous 51 weeks, I still see blanks instead of zeroes.
To answer your question, the older data was stored as blanks when no value was entered during data entry. At the time, we didn’t enable the option to store zero values.
Thanks for the suggestion! Just to clarify, when you say “update those values from ‘blank’ to ‘zeroes,’” do you mean this should be done manually, or is there a specific query or method (like using PostgreSQL) that could automate the process? Any guidance on how best to approach this would be really helpful.