Hi All,
I have to plot a line graph where the Y -axis is text values and X - Axis. I am trying to achive a plot like this . Can this be done in QS. I have exhasuted options any inputs/direction would be ideal.
Thanks!
Hi @abhinav_gundlapalli and welcome back to the Quick Community!
So the difficult part with this, as I’m sure you’re aware, is that line charts in QuickSight require a numeric ‘value’ on the y-axis. This means that even if you place a string data type in the ‘values’ section, QuickSight will aggregate it (counting occurrences) rather than displaying each unique string value as a separate category or line.
It might not be an ideal solution, but my initial idea was to utilize a gantt chart to try to closely achieve what you want to create. My thought process is that you can have a date, or in your case a time field, in your x-axis and then in your y-axis you can have your text values. Now to create a gantt chart you are going to do that through a highchart. Refer to this resource on highcharts (DemoCentral) and then go to the ‘samples’ tab at the top of the screen. From there, the gantt chart example is the second visual shown. I should also state that utilizing highcharts require creating visualizations through JSON expression language which can be difficult to understand at first. The resource I sent is great in terms of explaining the basics but I have noticed that sometimes the Quick’s chat agent can be useful in answering questions about highcharts.
Additionally, if you would like to see this specific visual within an analysis, I would click on this icon shown below that will take you to an arena sandbox page:
I will keep thinking on other ideas but I think for now you can look into this to see if this can be a potential idea.
Let me look into this and try to test if we are able to get it. But shouldn’t this be more like a feature request that QS should be bringing in?