By using AWS re:Post, you agree to the Terms of Use
/How can I display data with start and end date in QuickSight?/

How can I display data with start and end date in QuickSight?

0

Hello,

I am wondering what the best visual in QuickSight would be to display a record of data that has a start and end date. I am imagining a visual with time along the x-axis and a bar with its endpoints at the start and end dates for each record.

Is there a visual that would meet my needs? Or is this just wishful thinking?

asked 5 months ago124 views
3 Answers
0

Thank you for posting your question, can you please elaborate the details of the visual you are looking for and also provide a few lines of sample data so we can have a more clear understanding of the requirement.

SUPPORT ENGINEER
answered 5 months ago
  • Sure, I will do my best to describe. I am dealing with a dataset for equipment rentals and would like to visualize each of these rentals, showing their start and end dates plotted over time. A sample of rental data might look like this:

    rentalIdcheckOutcheckIn
    1'2022-01-02''2022-01-05'
    2'2021-12-13''2022-12-13'
    3'2022-01-12''2022-01-18'
    4'2021-12-30''2022-01-04'

    What I am looking for is a way to represent each of these records as one unit ( a rental) and display the start and end dates for each.

0

Hi,

I have a similar issue (working with start and end dates instead of single date).

My goal is to display the sum of distributed value on a given period (with from and to in declared controls/parameters).

So, on the X axis, I want to use the range define by from and to controls, and use distributed value for each date between start and end crossing control period.

With following data example, if I set from=2022-01-28 and to=2022-02-02, with a day distribution, I want the following result

Dataset :

start_dateend_datebudgetnumber_of_day(easy to compute)daily_budget(easy to compute)
2022-01-162022-02-14300030100
2022-01-012022-01-3116123152

Expected result (here as a table, but I want also use it as chart):

DayBudget
2022-01-28152
2022-01-29152
2022-01-30152
2022-01-31152
2022-02-0152
2022-02-0252

Regards,

answered 5 days ago
  • I know that a naive solution is to have one line per day, but I prefer a mathematical solution to volume one.

0

Hi,

from my understanding you are looking for a Gantt chart. This is not currently available in QuickSight, but it could be implemented following the example available in our QuickSight community you can find it explained in this answer .

hope this heps

EXPERT
answered 2 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions