Highcharts include parameter value in text

Question & Answer
,
1

Hi! I am new to whole highchart concept in QS. Is it possible to include parameter value in Highcharts y-axis label? Like it’s possible with other visuals. Sth like that:

image
image402×596 33.7 KB

2

Hi @JRoz,
The highchart options within QuickSight do still have some limitations and the documentation is still a bit light as it’s a newer feature.
Could you share your chart code, more specifically the portion that you’ve setup for the y-axis, so that we can try and assist further?

Thank you

3

Hi! No problem, here:

{...
  "yAxis": {
    "title": {
      "text": "Buying rate <<${param}>>", 
      "style": { "fontSize": "10" }
      
    },
    "labels": {
      "style": { "fontSize": "8" }
    },
    "endOnTick": false,
    "tickInterval": 1,
    "min":0
  },
...}
4

Hi @JRoz, if you use DIRECT QUERY, you could probably put your parameter (it can be a text that is used an the axis title) into a calculated field and send it to the Highcharts visual as a column. Then use, for example, operations “get” and “unique” to convert the column back into a single value. In plain words, instead of hardcoding yAxis.title.text you can take it from the dataset. Unfortunately, this staff will likely fail if you switch to using SPICE, at least with this release. Anyway, it’s a tricky workaround and it makes sense if you do need it very much. It’s much easier to put this data to the title or to the subtitle.
P.S. This approach works much better with numbers then with strings, but I am not sure that it will be easy to build the axis name from parts.

2 Likes
5

Hi! You gave me an idea of using ‘getColumn’ and ‘unique’ - I created a calculated field that uses my parameter sth like this:

concat("X ", "[", ${currencyParameter}, "]" )

and used it in xAxis title:

"yAxis": {
    "title": {
      "text":  ["unique", ["getColumn", 3]],
      "style": { "fontSize": "10" }
      
    },

works like a charm, even with SPICE :slight_smile:

2 Likes