# Chart where data has different dates

**URL:** <https://community.amazonquick.com/t/chart-where-data-has-different-dates/17972>\
**Category:** Q&A\
**Tags:** charts, error, quick-sight\
**Created:** [September 13, 2023, 6:43am UTC](https://community.amazonquick.com/t/chart-where-data-has-different-dates/17972 "2023-09-13T06:43:31Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![anandds](https://avatars.discourse-cdn.com/v4/letter/a/58956e/32.png) [@anandds](https://community.amazonquick.com/u/anandds)\
**Post date:** [September 13, 2023, 6:43am UTC](https://community.amazonquick.com/t/chart-where-data-has-different-dates/17972/1 "2023-09-13T06:43:32Z")

</div>

Hello,  
I have a data set that has the following columns: item\_id, created\_at and deleted\_at.  
I am trying to create a quicksight chart that has three lines:  
Number of items created by month  
Number of items deleted by month  
Cumulative total of items that are active (meaning not deleted once created)

X-axis is the calendar months starting Jan 2012

How do I do this?

---

<div class="post-metadata">

**Author:** ![purpledonkey17](https://avatars.discourse-cdn.com/v4/letter/p/f08c70/32.png) [@purpledonkey17](https://community.amazonquick.com/u/purpledonkey17)\
**Post date:** [September 13, 2023, 10:55am UTC](https://community.amazonquick.com/t/chart-where-data-has-different-dates/17972/2 "2023-09-13T10:55:35Z")

</div>

Hello, you can create a line chart with multiple fields. You will need to reshape your dataset, summing items created and deleted by month. Once you have this, you can do a cumulative sum of the difference between these to get items active. Then you can plot these three series on a line chart, with your months along the x axis.

---

<div class="post-metadata">

**Author:** ![anandds](https://avatars.discourse-cdn.com/v4/letter/a/58956e/32.png) [@anandds](https://community.amazonquick.com/u/anandds)\
**Post date:** [September 13, 2023, 4:14pm UTC](https://community.amazonquick.com/t/chart-where-data-has-different-dates/17972/3 "2023-09-13T16:14:55Z")

</div>

Hello, do I reshape the data outside quicksight or can I do it within? If within, how do I do that?

---

<div class="post-metadata">

**Author:** ![neelay](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/neelay/32/12168_2.png) [@neelay](https://community.amazonquick.com/u/neelay)\
**Post date:** [September 13, 2023, 5:00pm UTC](https://community.amazonquick.com/t/chart-where-data-has-different-dates/17972/4 "2023-09-13T17:00:16Z")

</div>

@anandds you can’t reshape the data in QS. QS is mostly for post-processed data.

---

<div class="post-metadata">

**Author:** ![abacon](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/abacon/32/2291_2.png) [@abacon](https://community.amazonquick.com/u/abacon)\
**Post date:** [September 18, 2023, 4:23pm UTC](https://community.amazonquick.com/t/chart-where-data-has-different-dates/17972/5 "2023-09-18T16:23:58Z")

</div>

Hi @anandds ,  
We hope the replies from @purpledonkey17 and @neelay worked for you.  
Let us know if this is resolved. And if it is, please help the community by marking the reply as a “Solution.”  
Many Thanks,  
Andrew