Hi community,
I have a multiselect fields in my form and I’m saving it’s data in 15 fields in binary format (if selected than 1 else 0). I’m presenting this data in table. Issue is with the uniformity of data.
For the fields used in this visual, I don’t have data for years 2014, 2015, 2016, 2017, 2018, 2020 2021 and 2023 but quicksight is including column of 2014 to 2018 but not 2020, 2021 and 2023.
Can anyone suggest me how to handle this (either include all years or none).
Hello @Raghu, I am curious, is there any chance the values returning for those years are actually NULLs instead of 0s? Is anything returning if you filter for just the years that are missing?
It is an interesting error, so with a little more information, I should be able to guide you further. It may also be beneficial if you could create a demo version in QuickSight Arena where I could test out some possible solutions. Thank you!
Hello @DylanM ,
By default I’m passing 0. If data is satisfying my condition then only it’ll be 1 else 0 for NULL, empty string or any random value.
This is my postgresql query for fields like this and anti_none is one of the value column.
Hello @Raghu, is it possible there are other filters on the visual that would be excluding values from the missing years? Also, have you tried filtering down to just the missing years to see if they display on the visual? It seems like something is causing those values to not be included and I would imagine it has something to do with NULL values. With a little more information, I can help guide you further.
Hello @Raghu, since we have not heard back from you, I wanted to check in and see if you could share more information about the data you are utilizing. It would also be beneficial if you could create an anonymized version of the analysis in QuickSight Arena like I suggested above so I can help debug the issue.
If we do not receive a follow-up response from you in 3 days, I will archive this topic. Thank you!
Hello @Raghu, since we have not heard back from you with any follow-up information, I will archive this topic. If you require further assistance with this issue, please post a new question in the community and link to this topic to provide relevant information. That will ensure you are at the top of the priority list for a response from one of our QuickSight experts. Thank you!
