How can I display data with start and end date in QuickSight?
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?
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.
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_date | end_date | budget | number_of_day(easy to compute) | daily_budget(easy to compute) |
|---|---|---|---|---|
| 2022-01-16 | 2022-02-14 | 3000 | 30 | 100 |
| 2022-01-01 | 2022-01-31 | 1612 | 31 | 52 |
Expected result (here as a table, but I want also use it as chart):
| Day | Budget |
|---|---|
| 2022-01-28 | 152 |
| 2022-01-29 | 152 |
| 2022-01-30 | 152 |
| 2022-01-31 | 152 |
| 2022-02-01 | 52 |
| 2022-02-02 | 52 |
Regards,
I know that a naive solution is to have one line per day, but I prefer a mathematical solution to volume one.
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
Relevant questions
Error bringing in additional datasets/tables to Amazon Quicksight Dataset
asked 4 months agoWeekly Data metrics
asked 3 months agoReplacing quicksight logo - Quicksight
asked 4 months agoChanging the Start of the Fiscal Year on Relative Date Picker in Quicksight
asked 5 months agoHow can I get WorkMail to display a data URL image in an email?
asked 4 months agoQuickSight Freeze First Column in a table view
asked 2 months agoHow to set off automatic filtering in QuickSight?
asked 3 months agoHow to make a Year-Over-Year Line Chart in QuickSight
asked 5 months agoHow can I display data with start and end date in QuickSight?
asked 5 months agoTrying to display Quicksight dashboard on Webpage
asked 2 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:
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.