Hello, new to Quicksight but have got everything else in order except this nut, which is more difficult to crack.
I have a database with row that for simplicities sake have the following values: startDate, endDate, value. Here the value is one that actually takes place every day between startDate and endDate.
What I would like to achieve is have a line chart or bar chart that shows the sum of the values per month. My problem is that I can get the values for the exact startDate but how can I populate this value to the dates in between startDate and endDate?
Image for reference of how this data is populated in another system. The data is evenly distributed even though most of the rows reflecting this year start at Jan 1st -25.
Hi @jhznyman and welcome to the QuickSight community!
You mention that your value is one that takes place every day between start and end date; so does that mean a given row can be longer than one day? Are they all this way or do they vary in lengths?
Additionally, a couple questions regarding your value:
If a row lasts longer than one day, is the value essentially a combination of ‘each day’?
In the same case, would the value for each day be the same (For example, if a row stretches from 2/1/25-2/4/25 and your value was ‘16’, would that imply that the value for each day is 4?)
If you could share a screenshot of what you currently have setup in QuickSight, we can share notes on how to obtain your desired outcome!
