Drawing Constant line showing "Average of one Column of a Table"

Question & Answer
,
1

I have Table tbl_sales. It contains column “Sales”. I want to draw a line chart which should show “Average value of Sales Column”. So this line is a constant line.

Lets say, value_avg_sales = average(Sales column of table tbl_sales)

Dont want any measurement on X-axis. Only Y-axis showing showing constat line with Y=value_avg_sales.

2

Hey @shalakam, Could you clarify your question? Thanks!

3

Shalakam,
I’m not certain exactly what you are describing. QS has a concept of reference lines, which can be dashed line running across a bar chart (in our case). It’s available from the “format visual” command.

image

In the visual above the 321 is the value of the reference line. This value varies depending on the how the filters are set (such as the property control).

Here’s the documentation on reference lines:
Displaying, customizing, and removing reference lines - Amazon QuickSight

Does this help?

1 Like
4

Hi, @shalakam. Did @cgreenacre’s solution work for you? I am marking their reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community Q&A Forum!