Hi,
I have a dataset where I want to extract multiple series for a line chart following the templates in the Demo central - https://democentral.learnquicksight.online/#Dashboard-FeatureDemo-Highcharts-Visual.
I have a dataset with 9 columns, where 4 of them are included in my visual.
If I hard code the value for the filter, I get the “correct” data for one of the series (but this value for all series as expected for this hardcoding).
I cannot find a way to access the value for the name of “outer” series to get the correct data for each series.
The example online suggests using the [“item”, 1], but that gives me no data.
A snippet of my code is:
“series”:
[“map”,
[“unique”, [“getColumn”, 3]], // One series per order
{
“name”: [“item”],
“data”: [“map”,
[“filter”, [“getColumn”, 0, 1, 2, 3], [“==”, [“get”,[“item”], 3],
[“item”, 1] // This does not work for me to get the name of the series
//“136737320” - this “works” to get the data for a single series shown in attached image
//[“name”] - Also tried to get the series name to find the matching data
//“NRD B 342195 712” - this “works” for another column
] ],
[[“get”,[“item”],1], [“get”,[“item”],2]]
],
I am trying to achieve a “Scatter chart” kind of visual where each data series is a short line between two pairs of xy coordinates.
Bonus question:
Is there any other way to achieve this with QuickSight visuals?