I want to create a line chart that shows the actual number, instead of the aggerated number on the Y axis, this is something easy to create in excel (see screeshot below). I couldn’t figure out how to replicate the same line chart in QuickSight. Any advice are greatly appreciated.
Hi @ll5 -
Welcome to the QuickSight Community! If I understand correctly (based upon my working with this small sample), it was the X-axis sort order that was not giving you the desired output. I changed the sort options on the X-axis of the line chart to sort by Customer with aggregation Count and sort order ascending and could replicate your output. See screenshot.
Thanks @Kellie_Burton for the response. I need to show the actual value not the aggerated value (neither count nor sum but just actual non aggerated value) on Y axis and customer name on the x axis, like exactly what is shown in my screen shot. In my real working situation, the data structure is more complex than what I showed, there are over 20K customers (broken down into more glandular level) with same or different data value, so I can’t use any aggerated function. Is this even doable in AWS QuickSight?
you said the actual data is more granular than just customer. So, the customers will be repetitive.
So any analytic tool will provide an aggregate value.
Can you elaborate your requirement??
Does your dataset result produce unique customers?? If yes then there is a way to represent this in graph. If not then what is the significance of other dimensions??
@mhmd, Thanks for the response and feedback. The customers will be repetitive, but filters will be place on top of the graph to distinguish the records (like local area where each customer shops, product being purchased, period of time etc), so the result will always produce unique record, which is customer name on the x axis. As a second thought, while I am typing to answer your question, I think the question is being answered - I can use the max(data value) or min(data value) on the Y axis since the record per customer will be unique. Thanks for asking question in detail and help me think through the solution.
as per you reply. if you are adding other fields in the filter section, then the aggregation doesn’t matter.
you can go with min,max or avg or even sum. But, beware this will fail your requirement the moment you choose all values in the filter selection.
@mhmd -Yes, as now I am trying to find out how to set the filter dropdown value to be single selection only.