Creating a full range to be used as X-axis

Question & Answer
1

I have am using line chart for which I would like to have the complete range specified by the user on X-axis.
This is how I am implementing my solution. I have two controls which let the user pick two relative number of weeks/months (e.g, user chooses to see 5 months back and 5 months in the future). However, in my dataset, for these relative weeks/months, I don’t have the date values. Therefore, currently on my X-axis I have some gaps (e.g, -5, -4, -1, 0, 2, 4 instead of -5, -4, -3, -2, -1, 0, 1, 2, 3, 4, 5).
Is there a way to create this full range based on user selection of controls in QuickSight ?!

Thanks.

2

Are you saying that you don’t have data but you want to show it still on the x-axis?

If you don’t have data then you won’t be able to see in the visual.

I can mark this as a feature request.

1 Like
3

Hi @Max,

Yes that is exactly the feature I am looking for. I would like the X-axis to behave like a range (e.g., in Python) so that when the user for example enters -5 and 5 in the controls, on the X-axis I could visualize the full range from -5 to 5 even if there are some gaps in my field. For those gaps, instead of just having holes in the range, I would like to have the full range on X-axis and zeros on the Y-axis (showing zeroes on the Y-axis is already possible in QuickSight and its just the incomplete X-axis that I am trying to avoid).

Thanks for marking this as a feature request.