- Newest
- Most votes
- Most comments
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 content
- asked a month ago
AWS OFFICIALUpdated 17 days ago- AWS OFFICIALUpdated 20 days ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated 24 days 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.