I have field in my application which receives multiselect data and stores it in various columns in boolean format. Now I want to visualize this data. Is there any kind of visual present in quicksight which can help me do this.
I have a field named “da” in my form which is multiselect and its data is stored in 14 different columns.
I tried vertical stack bar chart but it is restricting me to 10 value fields only. Can you suggest me something to represent my data other than a simple table.
Hello @Raghu, is this something you are continuing to have issues visualizing? Setting up a visual that needs 14 different fields for values is going to be a bit difficult. You have 2 options I think to manage this. The one that will require the least amount of effort would be to use a table or pivot table like you mentioned. Luckily with tools like conditional formatting and maybe adding some over time aggregations you could make it into a more interesting or useful visual. Otherwise, I suppose you could use a visual like a stacked bar chart but maybe show all 14 fields over 2 visuals side by side. You could even set your sheet view to free form, stack the 2 visuals on top of each other, then use the rules on the edit visual customization to set them to show and hide based on a parameter. That way a user could choose “first half” or “second half” in a dropdown and it would swap the displays.
The other option is reformatting your dataset to have a da_type field, and each of the 14 columns would be displayed on individual rows and the da_type would be the identifier for each. That way you could use the group/color portion of visuals to better highlight the 14 different categories and no longer worry about field limits.
I will mark this as a solution for now, but if you have any further questions on implementing one of these ideas, please let me know!