Hi team! I am trying to set up a venn diagram using the highcharts feature, but I keep running into a “No data to display” error, even when I hard code the values following a guide I found. Here is my query:
{
“charts”: [
{
“type”: “venn”,
“data”: {
“name”: [“getColumn”, 0],
“sets”: [“getColumn”, 0],
“value”: [“getColumn”, 1]
},
“size”: {
“width”: 800,
“height”: 600
},
“legend”: {
“show”: true,
“position”: “right”
},
“padding”: {
“top”: 20,
“right”: 20,
“bottom”: 20,
“left”: 20
}
}
]
}
Is there anything that stands out with this query that could be the issue? The data is a simple 2 column data set, where the values in the left column are names of groups which also represent the set mappings like: [“A”, “A, B”, “B”,…] and the right column contains the counts for each row.
Hello @qsuser1,
Welcome to the QuickSight community, it is great having you here.
You will need to use the JSON expression language for Highcharts to get your data to the format that the Venn diagram from Highcharts needs.
I made a simple example of how to build a simple venn diagram and how to use the JSON expression language to get the data from the dataset as a data for HighCharts.
Hope this helps!
Hi, I am having some issues still with the getColumn call. How do we know which column corresponds to which in the get column call? My understanding is that the getColumn call returns each array, so this gets column 0 (section names), 1 (corresponding sets), 2 (value) and then these are mapped to sets, name, and value in the following json block. But, in your table it seems like the first column is Name, which is getting mapped to sets. Also, how do you know when to call “get item” of 0, 1, 2, etc…? TY
